R12: PO Lines & Distributions not Matching in Terms of Billed Quantity and Amount. APP-SQLAP-10706 Error Message
(Doc ID 1237583.1)
Last updated on APRIL 27, 2023
Applies to:
Oracle Payables - Version 12.0.0 to 12.2.8 [Release 12.0 to 12.2] Information in this document applies to any platform.
APXPMTCH - Match to Purchase Orders
APXINWKB - Invoice Workbench
Symptoms
One of more of the following Symptoms/Descriptions may apply:
While doing price/Quantity/Amount corrections system updates only PO_distributions_all properly and PO_line_locations_all not updating accordingly.
Amount Billed is not getting updated in PO_LINE_LOCATIONS_ALL table when invoice price/quantity is corrected.
After invoicing and creating a credit memo for a purchase order, there is a mismatch between the shipment and distribution amount billed. The distributions show the correct quantity, but the shipment shows the value without the credit memo.
Cannot discard a PO matched line due to a error message:
Changes
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!