You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Determine Account date for PAY_COSTS entries

in Reporting and Analytics for HCM 3 comments

Summary:

I am trying to figure out how to get back to the accounting date from each entry in the pay_costs table.
We have a need to get this down to the person for some specific state reports. Below is the sql I am using to get to department and person but I am just not able to figure out how to get to any sort of accounting date for the the entries

Content (please ensure you mask any confidential information):
select
pc.cost_id,
pc.costed_value,
pc.debit_or_credit,
pc.transfer_to_gl_flag,
pc.COST_ALLOCATION_KEYFLEX_ID,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!