Wrong UOM Passed to Inventory Transfer Price API (Doc ID 1905939.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.CU2 and later
Information in this document applies to any platform.

Symptoms

Transaction_cost and actual_cost for logical inter-company transactions are not properly calculated for the below cases. Due to this value is showing incorrectly:

1.Create Purchase Order (PO) in other than Item primary Unit of Measure (UOM) and receive the same in PO UOM

2.Create PO in Item Primary UOM and receive in a different UOM

For example:

Primary UOM = Each
Intercompany transfer Price list UOM = Each

Create a purchase order with three lines

2 lines have Non primary UOM (case)
1 line has primary UOM (Each)

In receipt (direct delivery)
2 lines are received in Primary UOM (Each)
1 line is received in Non Primary UOM (case)

Given below is what was observed:

Item PO Quantity (QTY) PO UOM Receipt QTY Receipt UOM Price list price Price list UOM AR invoice unit price AR Invoice UOM Currency
01 180 Case A Each 109.53000 Each 219.06 Each USD
02 170 Case B Each 107.38000 Each 214.76 Each USD
03 160 Each C Case 110.25000 Each 110.25 Case USD

After the PO receipt, the cost on the logical transactions at transfer org is correct but when it is imported to create an AR invoice the unit price is not correct.

The same issue is not seen when the PO and receipt are in the same UOM.

Cause

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