R12 Payables Posted Invoice and Payment Registers have duplicate/inaccurate data
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)
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.
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