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
15
Views
1
Comments
edited Jul 10, 2021 4:13PM in Payroll and Global Payroll Interface (GPI) 1 comment

Summary

What is DEBIT_OR_CREDIT column's significance in PAY_COSTS Table

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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