Reversal In Payables Did Not Get Interfaced To PA (Doc ID 2290298.1)

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.

Symptoms

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:

select DIST.*
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
  (SELECT 'X'
  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
  (SELECT 1
  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

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