My Oracle Support Banner

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 OCTOBER 24, 2018

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Oracle Payables - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Oracle Inventory Management - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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