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

Last updated on OCTOBER 04, 2022

Applies to:

Symptoms

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>

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

Changes

Cause

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