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!

Reconciliation Issue between payroll and General Ledger

edited May 26, 2016 5:02AM in Payroll and OTL - EBS (MOSC) 4 commentsAnswered

Dear All,

We are trying to reconcile the balances between general ledger and payroll for one of the account i.e 22105 using following queries. But unfortunately we are finding some deferences.

Can any one please help us how to identify the deference.

Payroll Querry:

select sum(pcdv.DEBIT_AMOUNT)   "Debit",

        sum(pcdv.CREDIT_AMOUNT)    "Credit"

from pay_costing_details_v pcdv where 1=1

        and pcdv.EFFECTIVE_DATE >= '01-Jan-2013'

        and pcdv.EFFECTIVE_DATE <= '31-DEC-2015'

        and pcdv.segment4 = '22105'

General ledger query:

select  round(SUM(gjl.ENTERED_DR),2) DEBIT,

        round(SUM (gjl.ENTERED_CR ),2) CREDIT,

        round(SUM(gjl.ENTERED_DR),2) - round(SUM (gjl.ENTERED_CR ),2) defference

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