HCM Extracts – tips & tricks
#1. Fast way to rollback extracts: Navigate to Payroll -> checklist -> click on the extract run -> process details -> View Process results-> rollback#2. Best ways to schedule an…
PGP encryption in Fusion BI Publisher
Are you inclined to use HCM Extracts feature, just because it has features like output file encryption, built in SFTP integration point then think again... if your main goal is…
Pagination in BI reports
Pagination is a technique to limit the no of records shown per page. for example, 100 records are fetched from the database or Oracle HCM Cloud, report output should split…
Sample HDL files for Work schedule Assignments
In this article, we will go through steps to create and manage work schedule assignments using HDL Goal HDL files to create work schedule assignments for employees Solution ScheduleAssignment.dat file…
Fusion BI – Useful queries
I am maintaining a repository of the code snippets/templates/queries, that I feel useful for whoever is working on Fusion BI - Adhoc reporting. Logged in user details The user information…
Fusion HCM BI 101 – Part 1
Technology: Fusion Applications BI - Adhoc Reporting Part 1 in a series on the basics of the Fusion BI reporting I am currently working on a series of articles covering…
SFTP configuration as delivery option in Fusion BI Publisher
Are you inclined to use HCM Extracts feature, just because it has features like output file encryption, built in SFTP integration point then think again... if your main goal is…
PGP encryption in Fusion BI Publisher
Are you inclined to use HCM Extracts feature, just because it has features like output file encryption, built in SFTP integration point then think again... if your main goal is…
Secure PII data in Fusion SAAS – using Data Masking techniques
Using data roles secures PII data such as National Identifiers, Ethnicity, Home Address etc... In Production instance this PII data is secured using VPD policies applied at database level. Where…
Oracle HCM Cloud – BI – Adhoc Reports – Excel templates
In this article, we are going to discuss usage and creation of excel templates for BI - Adhoc reports in Oracle HCM Cloud. we need to have clear understanding of…