Person Costing Details Export Using OTBI Subject Area

Question

Hi Experts,

We have a requirement to extract employment and costing details for a person. We have used the following subject areas: Worker Assignment Real Time and Payroll Costing Setup Details Real Time, but they are not returning the correct data.

Are these the correct subject areas to extract costing information for a person's details?

Please share your input if you have encountered a similar requirement.

Thanks in advance!

Riyaz Ali-Oracle · Answer

Hi Ravi,

The subject areas Worker Assignment Real Time and Payroll Costing Setup Details Real Time are commonly used for employment and costing details, but they may not always provide the full picture depending on your specific reporting needs.

Alternative Subject Areas to Consider:

Payroll - Payroll Process Results Real Time – This subject area provides detailed payroll costing information, including earnings, deductions, and employer costs.

Payroll - Payroll Costing Details Real Time – This is more granular and can help track costing details at the element level.

Workforce Management - Worker Assignment Real Time – While useful for employment details, it may not always link correctly with payroll costing.

Payroll - Payroll Run Results Real Time – If you need costing details tied to payroll runs, this subject area can be helpful.

Best Practices for Extracting Costing Information:

Verify Data Joins – Ensure that the subject areas you are using have common keys (such as Person ID or Assignment ID) to correctly link employment and costing details.

Check Security Access – Some costing details may require additional permissions to be visible in OTBI reports.

Use OTBI Usage Tracking – Since you have expertise in OTBI Usage Tracking, you might want to check how these subject areas are being queried and whether any filters are affecting the results.

Check the below as it might be helpful:

Subject Area to capture Employee details — Cloud Customer Connect

Subject Areas

gclampitt · Answer

hi yes "Payroll Costing Setup Details Real Time" is correct subject area - thats what we use.

Can you elaborate why its not returning correct data?

Only issue we have, is the Costing subject area does not have a common "Worker" dimension for some reason, so this makes  joining to other subject areas tricky and therefore involves amending logical SQL  or custom SQL report.

There's an idea raised to fix this:

https://community.oracle.com/products/oracleanalytics/discussion/18633/need-person-level-data-add-worker-dimension-to-payroll-payroll-costing-setup-details-real-time-sa?