Need User entity pull the costing of department and department details.

Summary:

I have a request to develop the report in the extract to pull the cost center, profit center, company code, department name, and department title without touching the person-related joins.

We can achieve this report via BIP but we are looking to achieve the same in extract.

This UE "ORA_PAY_COST_ALLOCATION_ACCOUNT_UE" holds the department of costing fields but we couldn't find the correct join with organization UE's which has department details.

Please assist.

Thank You.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

23D

Code Snippet (add any code snippets that support your topic, if applicable):