-
-
BIP – Query to Extract Learner Completion Details
Use below query to extract the learner completion details. The same query can be used to generate the Learning Record HDL format with small changes.
-
BIP – Query to extract GL Cost Details from Department
GL Cost center Information can be maintained at Department Level. This information can be extracted using below SQL: To bulk upload GL Cost Centers Organization.dat HDL can be used. Please check the below link for more details: https://fusionhcmconsulting.com/2021/01/hdl-sample-hdl-to-load-gl-information-at-department-level/
-
BIP – Extract UDT data
Use below query to extract data related to User Defined Tables in Oracle HCM
-
HDL – Sample HDL to load Performance Rating
Historical performance ratings can be loaded into Worker Talent Profile using TalentProfile.dat business object. Below is the sample HDL (enhanced profiles (v2)), to load performance rating data: In order to make the loaded performance rating visible in UI, Source Type and Qualifier ID should be passed. Values of source type and qualifier Id depend upon…
-
BIP – Query to extract business unit attached to a Job
In multi country HCM Implementations, work structures data can be stored in a COMMON set or a country specific set. In such cases, it becomes important to show the correct business unit name against the jobs in reports. Use the below report to extract the Job and the business unit: To get more details on…
-
BIP – Configure AuditViewDB for BIP Reports Audit
In order to audit the BIP reports, AuditViewDB should be first configured in list of data sources. Follow the below steps to configure it: Login to your Fusion application instance (analytics). Click on Administration -> Manage BI Publisher -> Data Sources -> JNDI Connection 3. Click on Add Data Source and enter below details and…
-
BIP – Query to extract Fast Formulas used in HCM Extracts
Use the below query to extract list of “Extract Rule Type” fast formulas used in Oracle HCM Extracts:
-
HDL – UCM Connection Error (HRC – 1035375)
In rare cases, while uploading the HDL file from Data exchange results in HRC-1035375 – A connection to the WebCenter Content Server Couldn’t be established. Resolution to this error is to raise an SR with Oracle support and ask them for OID services bounce.
-
BIP – SFTP Connection fails with 503 Service Unavailable error
Sometime, while configuring the SFTP server, the user gets below error: The cause of this issue is incorrect SFTP details entered. Make sure all the details are correctly entered. Once the SFTP details are entered correctly, the error will fade away.
-
BIP – Configure SFTP using private key for Authentication
In this article, we will see how to setup an SFTP server which will use private key for authentication. First step is to obtain the private key. Once you have the key, login into Oracle Fusion Application Analytics and click on Administration link on the right top side: Click ‘Manage BI Publisher’ under BI Publisher…
-
BIP – Update Sheet Name in RTF template for Excel output
Excel output in Fusion BIP can be generated using multiple ways i.e. either using excel template or RTF templates. When you use RTF templates to generate excel output, by default the data is generated in sheet with name “Sheet1: If you want to rename Sheet1 to user defined value, then use the below expression in…
-
Configuration – Enable Location Based Access
By default Location Based Access is disabled. Navigate to Tools -> Administration and you will not find Location Based Access Tab: To enable the location based access tab, set the profile option ‘ASE_ADMINISTER_LOCATION_BASED_ACCESS_CONTROL’ to Yes: Once this is set, Location Based Access tab will start appearing in the Tools -> Administration: Click Enable Location Based…
-
Configuration – How to make a role public? (LBAC)
While implementing Location Based Access control for your application, make sure you set the IT Security Manager role as public. This will help you to access the application and the tasks in an event where a wrong list of IP’s has been supplied and no user is able to access the application. Follow the below…
-
BIP – Query to extract Actions.dat data
Many a time there is a requirement to update/change the existing actions and actions reasons usages. Doing this manually in UI will become a cumbersome process for multiple actions and may lead to human errors as well. For this, HCM Data Loader can used to update the changes using Actions.dat file. Use the below SQL…
-
Configuration – Make a document type defaulted in search
When an employee opens document of records, by default it will show all the document types. There are many scenarios where the business wants to set a default filter to see only a particular type of document type. The other document types should be visible only if the default filter is removed. Follow the below…
-
BIP – Report Cannot Be Rendered Error
When designing BIP reports, sometimes the developer is encountered with “Report Cannot Be Rendered Error”. There can be various reasons of this error. The main reason behind this error is incorrect configuration. To resolve this issue for excel templates, make sure that there are no invalid references under Name Manager. Navigate to Formulas -> Name…
-
BIP – Query to extract data from Pay Inbound Records
Third party payslip data can be loaded into Payroll Inbound Records in Fusion HCM. Use below query to extract the data:
-
-