After Pay on Receipt Autoinvoice(POXPOIV), Quantity Invoiced Does Not Match Quantity Received if the Transaction UOM/PO UOM Differs From the Primary UOM (Doc ID 2357602.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

ACTUAL BEHAVIOR

After running Pay on Receipt Autoinvoice(POXPOIV),
PO_LINE_LOCATIONS_ALL.QUANTITY_BILLED and AP_INVOICE_DISTRIBUTIONS_ALL.QUANTITY_INVOICED are not matching with PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED and RCV_TRANSACTIONS.QUANTITY by a decimal.

For Example:
PO_LINE_LOCATIONS_ALL.QUANTITY_BILLED = 9.99999999999999999999999999999999999999
AP_INVOICE_DISTRIBUTIONS_ALL.QUANTITY_INVOICED = 9.99999999999999999999999999999999999999
PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED = 10
RCV_TRANSACTIONS.QUANTITY = 10

EXPECTED BEHAVIOR

After Pay on Receipt Autoinvoice(POXPOIV) runs,
it is expected that PO_LINE_LOCATIONS_ALL.QUANTITY_BILLED and AP_INVOICE_DISTRIBUTIONS_ALL.QUANTITY_INVOICED should match with the PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED and RCV_TRANSACTIONS.QUANTITY

STEPS

1. Define UOM conversion from UOM1 to UOM2 on ItemA which primary UOM is UOM1
   Inventory(N) > setup > unit of measure > conversions > Intra-class
   Item : ItemA
   Source Unit : UOM1
   Conversion : 1440
   Destination Unit : UOM2
2. Crete new Standard Purchase Order for ItemA which UOM is UOM2 and quantity is 10 and set the invoice match option to Receipt.
   Purchasing(N) > Purchase Orders > Purchase Orders
3. Approve it
4. Receive this PO
5. Run the 'Pay on receipt autoinvoice'
6. Note that the QUANTITY_BILLED is not matching the QUANTITY_RECEIVED

Changes

 After applying Patch.21213054.

Cause

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