General Ledger - EBS (MOSC)

MOSC Banner

Reconciliation Issue between payroll and General Ledger

edited May 14, 2016 5:02AM in General Ledger - EBS (MOSC) 1 commentAnswered

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

Tagged:

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