HDL · Payroll · Oracle Fusion HCM How to Bulk End-Date Element Entries Using HDL Using the ElementEntry.dat business object and the ReplaceLastEffectiveEndDate attribute to close out or clean up recurring element entries across your employee population — without triggering an unwanted date split. By default, every recurring element entry in Oracle Fusion HCM is…
-
-
HDL – Query to Extract Business Object Attributes List
HDL – Query to Extract Business Object Attributes List If you’ve ever worked with HCM Data Loader (HDL), you’ll know how useful the Business Objects reference page is in the UI — it shows you the Name, METADATA Attribute, Data Type, Key Type, Required, Lookup, and Description for every attribute of a business object (see…
-
BIP – List of departments associated with a specific business unit
In Oracle Fusion HCM, a business unit can be linked to either a common reference data set or a specific one. When associated with a specific reference data set, the business unit gains access to departments defined within that set, as well as those available in the common reference data set. The SQL query provided…
-
BIP – Extract Grade Ladder, Grade and Step details
Below query can be used to extract grade ladder, grades in ladder and step details of a grade.
-
BIP – Report to extract BIP scheduled jobs
I have designed below query to extract the schedule of a BIP submitted jobs which is not available directly. Replace the job name attribute with your job name or run it for all:
-
HDL – Mass DELETE Document Record Attachments
Post refresh, the attachments from source environment gets copied to target environment. For data security, it is highly recommended to purge the attachments in lower environments. Oracle’s standard data masking feature doesn’t remove any attachments from the UCM. In order to overcome this problem, I have created a BIP report which will pull details of…
-
HDL – Loading and Extracting ‘Reporting Information’ calculation card
For US legislation, Reporting Information calculation card is mandatory calculation card. CalculationCard.dat HDL is used to upload the Calculation Component Details: In this example, we will prepare a sample HDL file to upload “Corporate Officer” component value and set it to “Not a Corporate Officer”. To create a calculation component details, below three Metadata’s should…
-
BIP – Deliver an encrypted file on UCM server
There is a common requirement to send encrypted output files to UCM server as part of outbound integrations in Fusion HCM. By default, FA_UCM_PROVISIONED is delivered as ‘Content Server’. But the delivered content server, doesn’t have the encryption enabled and there is no option to enable encryption on the delivered content server. So, the solution…
-
BIP – Query to extract worker manager job name
Below SQL query below shows how a job name can be pulled for a worker’s manager. The SQL can be easily modified to include further employment related attributes for worker’s line manager.
-
BIP – Find list of message sent from Oracle Alert
Alert composer a very powerful and useful tool to configure and sent notifications to the users. However, it is very important for business to know the list of receipients for each message. I have tried to built a query to get these details. From alert history, one can find the emails triggered but it doesn’t…
-
-
BIP – Extract Job details with Job Family and Job Function details
List of all job families not associated with a Job:
-
Security – Deactivating Users in Bulk
With the security concerns regarding access to Oracle HCM applications, I have seen many customers asking for a way to restrict access to a particular DEV/TEST environment having unmasked data. One option in such scenario’s is to keep only the admin user accounts active in the particular environment and deactivate all other user accounts. This…
-
BIP – Query to get Benefits Relationship details
Use below SQL to get benefits relationship name and status for a worker:
-
BIP – Error Exception happened when delivery document to wcc
Many a times when the reports are delivering the content to UCM server, we get below error: In this case look at the password for account used to connect to UCM server. If the password is reset make sure it is updated at the UCM connection as well.
-
HDL – Loading Person Profile Items
In order to load person profile items, a person should have a profile code. There are two ways to create the profile code for a person record. It is advisable to load profile codes in bulk as part of data migration using HDL. But there are cases where a user will click on Talent Profile…
-
BIP – Extract Address Style Format Information
You use “Manage Address Formats” task from Setup and Maintenance to define the address style for a particular country. Oracle provides a lot of address format for various countries out of the box. You have the capaibility to customize the address formats as per customer requirement. For example, you can search for all available address…
-
HDL – Sample file to update Grade name and Grade Step Name
File for Grade Name change: File for Grade Step Name change: Save the files as Grade.dat and upload them.
-
HDL – Sample HDL file to End Date Position Valid Grades
There can multiple grades assigned as Valid grade at Position level or Job level. However, there is no direct way to end date the valid grades in bulk. You can end date a valid grade from responsive UI. But it will be a lot of manual effort. You can search for Position and then navigate…
-
HDL – Sample HDL files load Content Items
To bulk upload items catalogs in HCM profiles, you can use ContentItem.dat. Each of the template have certain mandatory attributes like Context Name, Value Set Name or Value Set Id: S0, before you start preparing the file, you need to have below information handy: The values 3000122xxxxx aren’t valid for ContentItemValueSetId. You can get the…
