My Oracle Support Banner

Receipt Quantity in Match to Receipts form (APXRMTCH) Shows Incorrect UOM Conversion Values (Doc ID 1097036.1)

Last updated on APRIL 09, 2023

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form:APXRMTCH.FMB - Match to Receipts


Symptoms

Receipt Quantity section of "Match to Receipts" form (APXRMTCH) does not match with Quantity Received, Delivered and Accepted for on Purchase Order receipt.

Example steps to reproduce the issue:

  1. Deliver, Accept and Receiving Qty = 4 Pieces (UOM for PO and Receipt=Piece - Item Primary UOM = Each)..
    Since PO is for 4 Pieces and Receipt/Deliver/Acceptance is also for 4 Pieces, no uom conversion occured.
  2. Create invoice and try matching the receipt. Under Receipt Quantity section, columns "Received" and "Accepted" are showing as .125 and "UOM" column = Piece


PO/RCV table data for the above scenario:

1 Piece = 32 Each
1 Each = .03125 Piece

po_lines_all and po_line_locations_all:
   UOM = Piece
   quantity = 4

rcv_shipment_lines:
    UOM = Piece
    quantity_shipped = 4
    primary UOM = Each

rcv_transactions:
    UOM = Piece
    quantity = 4
    primary UOM = Each
    Primary quantity = 4
    Transaction performed on 24-SEP-2009 15:21:02
    ==>
     primary quantity * rate = 0.03125 * 4 Each = 0.125 Piece.
    (received_txn_qty := X_pr_to_txn_rate * X_received_quantity;)

mtl_material_transactions:
   TRANSACTION_QUANTITY = 4
   PRIMARY QUANTITY = 4

Expected behavior:

AP "Match Receipt" form should show under Receipt Quantity, Received/Accepted = 4 Piece or .125 Each (as Conversion defined as 1 Piece = 32 X Each)..

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
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.