R12 Payables Posted Invoice and Payment Registers have duplicate/inaccurate data (Doc ID 747181.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.0.3 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
This problem can occur on any platform.
PAYABLES POSTED INVOICE REGISTER (APXPOINV),
Payables Posted Payment Register (APXPOPMT)

Symptoms

In R12, the Payables Posted Invoice Register (APXPOINV) and Payables Posted Payment
Register (APXPOPMT) have duplicate/inaccurate data. 

Symptoms include:  Review the report output and note that the totals do not balance with the GL totals and find that there are duplicate amounts . For example, it show Payment Number = 1854 in one section with all of the payment, supplier and bank account details and the debit and credit amounts included in the total for the account. Then again in another section, just showing the debit and credit amounts, no details for payment, supplier or bank, but same amount so it does appear to be duplicate data.

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