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