We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

What is DEBIT_OR_CREDIT column's significance in PAY_COSTS Table

Received Response
edited Jul 10, 2021 4:13PM in Payroll and Global Payroll Interface (GPI) 1 comment


What is DEBIT_OR_CREDIT column's significance in PAY_COSTS Table


HI All,


I have a requirement of extracting costing details for the run results of a particular pay period.


In EBS, We can directly join HR_ALL_ORGANIZATION_UNITS table with PAY_COST_ALLOC_KEYFLEX table. However in fusion, HR_ALL_ORGANIZATION_UNITS has no data in COST_ALLOCATION_KEYFLEX_ID column.


I tried to derive the costed value from PAY_COSTS table but for every run result value, there are 2 rows once for CREDIT and the other  for DEBIT. and these 2 rows have different cost details.


Howdy, Stranger!

Log In

To view full details, sign in.


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