My Oracle Support Banner

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

Last updated on MARCH 02, 2023

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
 R12.1.3
 R12.2.x
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.