Cost Management - EBS (MOSC)

MOSC Banner

AP-PO Accrual Report Balance is not Matching with GL

edited Sep 15, 2014 5:00AM in Cost Management - EBS (MOSC) 1 commentAnswered

Dear Experts,

AP-Po Accrual Reconciliation report balance is not matched with GL account Balance.

We identified that few transactions are not transferred to GL by executing the below SQl.

SELECT fa.application_short_name,

l.accounted_dr,

l.accounted_cr,

l.gl_sl_link_id,

l.gl_sl_link_table

FROM apps.xla_ae_headers h,

apps.xla_ae_lines l,

apps.fnd_application fa

WHERE h.ledger_id =:v_ledger_id

AND h.gl_transfer_status_code = 'Y'

AND h.balance_type_code = 'A'

AND h.ae_header_id = l.ae_header_id

AND l.gl_sl_link_table IN ('XLAJEL','RSL','APECL')

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