My Oracle Support Banner

Associated Trade Operations And Allocate LCM Charges Based On The Receipt/ASN Quantity (Doc ID 2448379.1)

Last updated on NOVEMBER 23, 2018

Applies to:

Oracle Fusion Cost Management Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.02.0 version, Landed Cost Management

Associated Trade Operations and Allocate LCM Charges based on the Receipt/ASN Quantity

We are implementing Oracle Cloud Cost Management and are also implementing Landed Cost Management.

While creating Trade operations, we have created a charge line and when associating the PO Line, the system only shows PO Ordered Qty.
We have a scenario where the PO Ordered Qty is shipped by the supplier on multiple shipments and the LaseCM Charges (like Freight) are applicable on each shipment.

In the current scenario, where supplier ships partial ordered qty, the LCM Charges needs to be allocated based on the qty received and not based on the qty Ordered. This is creating a incorrect allocation rate for the qty received.
For Eg:
Ordered Qty 1000 units
Receipt Qty 600 units
Freight charges for 600 units = 1200 USD

Freight Charges Per unit (based on Trade Operations) = 1200 USD /100 units = 1.2 USD per unit
Total Freight Loaded on Inventory = 1.2 * 600 = 720 USD (Which is absolutely INCORRECT)




Please advice the option how the Trade Operations for LCM charges can be allocated based on the Actual Receipt/Shipped Qty and not on the Total Ordered Qty.

ERROR
-----------------------

Please advice the option how the Trade Operations for LCM charges can be allocated based on the Actual Receipt/Shipped Qty and not on the Total Ordered Qty.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Created a Purchase Order
2) Created a Trade Operation and add charge line with reference type
3) Entered a receipt against Purchase Order
4) Transfer Transactions from Receiving to Costing process.
5) Landed cost process "Allocate Landed Cost Charges"
6) Created a Charge AP Invoice with 'Match to Receipt Charges' Option.
7) Accounted an Invoice and run Transfer Costs to Cost Management process
8) Landed cost process "Prepare Invoice Data" and "Associate Invoices to Trade Operation Charges"
9) After performing all these step, trade operation is still showing as missing invoice charge line.
10) Only when Invoice line is manually created and add reference for charge line. Then the association to Trade operation happens.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the landed cost allocation

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.