Lookup Report
As Payroll interface partners, you must be aware of some of the master data configured on the Human Capital Management (HCM) cloud, such as lookup types and codes, or elements.
This is handled by providing an interface called Lookup Report that extracts identified master master data configured on the HCM cloud.
Use the Lookup Report to generate the list of lookup types and codes on the HCM cloud that have been setup by a customer or delivered by Oracle, or both. It also extracts other setup like Elements, Job codes, Position codes, or Legal Employers, that generally require value mapping on the third-party application. As a Payroll partner, you need this information to create the maps for transformation at your end before you can use the payroll interface data.
Generate the Lookup Report
-
Navigate to My Client Groups, Payroll, Submit a Flow.
-
Select the Legislative Data Group.
-
Search for the Run Global Payroll Interface Lookup Report flow.
-
Enter values for these parameters as given in this table.
Field
What It Means
Payroll Flow
Any name that can be used to monitor the progress of the flow.
Delivered By
Select a value from Both, Customer or Oracle. This parameter determines whether the report will contain values delivered by Oracle out of the box, or those that are created by the customer, or both.
Include Work Structures
Select Yes to include work structure information like Job, Cost Center, Location, Grade, and Position. Selecting No excludes this information from the report.
Schedule
Run the flow 'As soon as possible' or use a predefined schedule or frequency to run the report once or on a recurring basis.
-
Click Submit.
-
Monitor the process and view the report output.
Report Output
The Lookup Report generates the list of lookup types and codes on the HCM cloud that have been setup by a customer or delivered by Oracle, or both. The report extracts the following key information.
Configuration |
What It Includes |
---|---|
Lookups |
|
Legislative Data Group (LDG) |
|
Legal Employer and Business Units |
|
Action Code and Action Reason |
|
Assignment Status |
|
Workforce Structures |
|
Cost Center Details |
|
Elements |
|
Payroll Definition |
|