R12: Reversal In Payables Did Not Get Interfaced To PA
(Doc ID 2290298.1)
Last updated on FEBRUARY 21, 2019
Applies to:Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
In the JAN-17 accounting period we discovered a -5876.34 variance between AP/PA. It was found that the receipt was reversed but this change did not interface in PA.
Currently the AP balance is $0.00 and the PA balance is -$5876.34 which is total amount of the variance.
Ran the query in <Bug 24371261>
from ap_invoice_distributions_all DIST
WHERE DIST.project_id > 0
AND DIST.LINE_TYPE_LOOKUP_CODE not in ('REC_TAX', 'ACCRUAL')
ANd NVL(DIST.PA_ADDITION_FLAG,'Y') not in ('N','Z')
AND DIST.posted_flag ||'' = 'Y'
AND DIST.REVERSAL_FLAG = 'Y'
AND dist.parent_reversal_id is not null
AND NVL(dist.historical_flag,'N') = 'N'
AND NOT EXISTS
FROM pa_expenditure_items_all EI
WHERE EI.transaction_source like 'AP%'
AND EI.document_header_id = dist.invoice_id
AND EI.document_distribution_id = dist.invoice_distribution_id
AND NOT EXISTS
FROM po_distributions_all pod
WHERE pod.po_distribution_id = dist.po_distribution_id
AND pod.accrue_on_receipt_flag = 'Y'
AND EXISTS (SELECT 1
FROM ap_invoice_distributions_all dist2
where dist2.invoice_distribution_id = dist.parent_reversal_id
and dist2.pa_addition_flag = 'Y');
The query returned the record that is creating the variance between AP and PA
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