-
-
-
-
-
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
-
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:
-
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…
-
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…
-
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:
-
-
-
-