Transfer to IPV to WIP for a blanket PO, the rcv_transaction_id is populated as null in wip_cost_txn_interface causing costing of wip transaction to fail cmlctw failed in direct shopfloor deliver transactions cmlctw returned error code : 0 in res_ovhd Dir (Doc ID 1378572.1)

Last updated on MAY 18, 2017

Applies to:

Oracle Cost Management - Version 11.5.10.2 to 12.2.6 [Release 11.5 to 12.2]
Information in this document applies to any platform.
*** Checked on Relevance on 18/MAY/2017 ***

Symptoms

In case of transfer to IPV to WIP for a blanket PO rcv_trasnaction_id is populated as null in wip_cost_txn_interface causing costing of wip transaction to fail

ERROR

cmlctw failed in direct shopfloor deliver transactions.
cmlctw returned error code : 0 in res_ovhd
Direct Item grp id = 3346695 in res_ovhd
res_ovhd failed. it was called to process resource&ovhd only.
res_ovhd returned error code : 9999


Steps:
The issue can be reproduced at will with the following steps:
1. EAM responsibility > Create a Work Order , with a direct material
2. Purchasing responsibility > check requisition created , Create a new Release from Blanket PO
3. Receive the PO and create the invoice
4. EAM responsibility > Run the IPV Transfer to work orders request
5.Check the pending resource transaction

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