Thursday, 17 April 2014

Table involve while Payroll Run...

Payroll Run :
-----------------
Tables populated : 
1. PAY_PAYROLL_ACTIONS (Action_Type = 'R' and 'Q' in case of Quickpay)
2. PAY_ASSIGNMENT_ACTIONS (2 records ,one master and one child. If you have process separate elements it creates more actions).
3. PAY_RUN_RESULTS
4. PAY_RUN_RESULT_VALUES

Prepayments :
--------------------
Tables Populated :
1. PAY_PAYROLL_ACTIONS (Action_Type = 'P' and 'U' in case of Quickpay Prepayments).
2. PAY_ASSIGNMENT_ACTIONS.
3. PAY_ACTION_INTERLOCKS (Locks Payroll Run Assignment actions both master and child).
4. PAY_PRE_PAYMENTS
5. PAY_COIN_ANAL_ELEMENTS (in case of Cash Payment Method.

Cash / Cheque Writer / BACS :
-----------------------------------------
Tables Populated :
1.PAY_PAYROLL_ACTIONS (Action_type = 'A' for Cash, 'H' for Cheque Writer and 'M' for BACS)
2. PAY_ASSIGNMENT_ACTIONS
3. PAY_ACTION_INTERLOCKS (Locks Prepayment Assignment Action).

Costing :
------------
Tables Populated :
1.PAY_PAYROLL_ACTIONS (Action_type = 'C')
2. PAY_ASSIGNMENT_ACTIONS
3. PAY_ACTION_INTERLOCKS (Locks Payroll Run Assignment Actions both master and child).
4. PAY_COSTS
5. PAY_COST_ALLOCATION_KEYFLEX
6. PAY_GL_INTERFACE

Transfer to GL :
---------------------
Tables Populated :
1.PAY_PAYROLL_ACTIONS (Action_type = 'T')
2. PAY_ASSIGNMENT_ACTIONS
3. PAY_ACTION_INTERLOCKS (Locks Payroll Run Assignment Actions both master and child and Costing Assignment Action).
4. GL_INTERFACE

2 comments:

  1. Can't find the PAY_ASSIGNMENT_ACTIONS table in the Oracle Cloud HCM. We are using R11.

    ReplyDelete
  2. Can't find the PAY_ASSIGNMENT_ACTIONS table in the Oracle Cloud HCM. We are using R11.

    ReplyDelete