Determine Account date for PAY_COSTS entries — Cloud Customer Connect
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

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!