Last updated on JULY 25, 2017
Applies to:Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
In our 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.
We have found MOS doc 2227880.1 which stated to open an SR in order to receive a datafix for this issue.
I have also 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms