AP And PO Accrual Reconciliation Report Shows Wrong Balance (Doc ID 1965130.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
-----------------------
AP and PO Accrual Reconciliation Report total is not matching with GL balance of the accrual account

EXPECTED BEHAVIOR
-----------------------
AP and PO Accrual Reconciliation Report total should match with GL balance of the accrual account

STEPS TO REPRODUCE
-------------------------

1. Run the AP and PO Accrual Reconciliation Report and note the total for accrual account
2. Run the below query and get the GL balance

SELECT period_name,
(SUM(NVL(accounted_dr,0))- SUM(NVL(accounted_cr,0)))
FROM gl_je_lines
WHERE code_combination_id IN
(SELECT code_combination_id
FROM gl_code_combinations_kfv
WHERE concatenated_segments = '&accrual_account'
)
AND ledger_id =&ledger_id
AND je_header_id IN
(SELECT je_header_id
FROM gl_je_headers
WHERE je_source IN ('Cost Management','Payables')
AND je_category IN ('Receiving','Inventory','Purchase Invoices')
AND status ='P'
AND actual_flag = 'A'
)
GROUP BY period_name;

3. Note the GL balance for the accrual account .
4. Observe the GL balance and accrual reconciliation report total is not matching.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms