Inconsistent Display Of UOM Unit Cost In Report RCVTXRTR For Internal Requisition / Internal Sales Orders

(Doc ID 1991558.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


On the Receiving Transactions Register report RCVTXRTR, the Price column is coming from the Internal Requisition line rather than the receiving
It does not consider price UOM conversion when unit of measure of internal requisition line is different from unit of measure of receipt.

1) Create Unit of Measure 'Case of 6', class = Quantity.

2) Create UOM Conversion: 1 Case of 6 = 6 Each

3) Create item with Primary UOM = Each
Assign material cost to the item
Item Costs Summary form shows  
In org M2 Unit Cost = 12 / Each

4) Create Internal Requisition from org M2 to M1
Line 1, UOM = Each, Quantity = 10, Unit Price = 12

5) Process Internal requisition into ISO sales order. Run the Create Internal Orders program to interface the Internal item to OM.
In OM Run Order Import concurrent program. Pick Release / Ship Confirm /Run INV Interface Trip Stop Interface for the shipment.

6) In Org M1 Enter receipt for the Intransit shipment
- Change the uom 'Each' to 'Case of 6'
- Receive quantity 1 of 'Case of 6' / ie receive 6 Each.

Transaction_Id 5403372
Transaction_Type RECEIVE
Quantity 1
Unit_Of_Measure Case of 6
Shipment_Header_Id 5327911
Source_Document_Code REQ
Primary_Quantity 6
Primary_Unit_Of_Measure Each
Uom_Code CS6 
Requisition_Line_Id 895788
Organization_Id 207
Source_Doc_Unit_Of_Measure Each
Source_Doc_Quantity 6

Requisition_Line_Id 895788
Unit_Meas_Lookup_Code Each
Unit_Price 12
Quantity 10
Source_Type_Code INVENTORY
Item_Id 422956
Source_Organization_Id 209
Destination_Type_Code INVENTORY
Destination_Organization_Id 207
Quantity_Received 6
Org_Id 204

7) Run the RCVTXRTR module: Receiving Transactions Register Report for the Shipment.
It shows Amount = 1 Unit ='Case of 6' but still Price as 12 which should have
been 72 (Since price $ 12/ Each  ==> $ 72 / Case of 6)

Vision Operations (USA)                           Receiving Transactions Register
                                               Flo Receiving Transaction Register               

   Source Type: Internal Order
        Source: Boston Manufacturing 
Item            Category     Description  Number     Document     Txn Date          Txn Type  Unit            Amount    Price
-------------- -- ---------   ------------- ----------   --------------- ----------------- ----------- -----------     ---------- -----------
Flo-Internal   MISC.MISC Flo Item      241          16505           09/MAR/2015    Receive    Case of 6    1             12

         Destination Type: Inventory                  Document Type: Internal Requisitio      Parent Txn Type:
        Deliver-To Person: X, Florence                     Buyer: X, Florence                  Receiver: X, Florence
      Deliver-To Location: M1- Seattle Mfg      Packing Slip Number:                             Quality Code:
 Destination Subinventory:                            Creation Date: 09-MAR-15                      Exception:

--Unit is  correctly Case of 6 but Price is 12 , ie cost for one Each instead of 72.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms