Payroll and OTL - EBS (MOSC)

MOSC Banner

Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!

Identifying costed payroll activity that has not been transfered to GL yet

I am trying to identify all costing (versus balance) rows in PAY_COSTS for which the "Costing" concurrent request has been run, creating said rows, and which are to be transferred to the ledger but which have not yet been transferred.

I've looked at several threads in this community, including https://community.oracle.com/thread/3411832 which seems to dance around the subject but never provides a clear answer to the question, not that I can see at least.

It seems the key is that there will exist no rows in PAY_PAYROLL_ACTIONS related to this data with ACTION_TYPE = 'T' and ACTION_STATUS 'C'.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center