CMCPAW Periodic Actual Cost Worker raises CSTPPINV.COST_INV_TXN:CSTPPINV.COST_INV_TXN: (50): ORA-01403: No Data Found (Doc ID 1456553.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Symptoms

Inventory Costing

CMCPAW module: Periodic Actual Cost Worker is raising the following error message:

ERROR
-----------------------
CSTPPINV.COST_INV_TXN:CSTPPINV.COST_INV_TXN: (50): ORA-01403: no data =found
Processing failure on phase 5.

STEPS TO VERIFY THE ISSUE
--------------------------------
The issue can be reproduced at will with the following steps:
1. Cost Managment
2. Periodic Costing
3. Run PAC Acquisition process

CMCPAW module: Periodic Actual Cost Worker
+---------------------------------------------------------------------------+
Current system time is 23-APR-2012 17:24:20
+--------------------------------------------------------------------------+

debug_level =3D 0
CM_EXTENDED_DEBUG =3D 2
Parameter:
cost method     = <cost method>
legal entity id = <legal entity id>
cost type id    = <cost type id>
period id       = <period id>
coost group id  = <group id>
proc. types     = <proc types>
proc. upto date =3D 2012/04/30
Start Validation
Complete Validation

Running from  2012/04/01 00:00:00 to 2012/04/30 00:00:00
Start Phase : 2
Start Processing Phase 2
Complete Purging Phase 2 - 5
Complete Beginning Balance Setup
Finish Processing Phase 2

Start Processing Phase 3
Complete LLC Computation
Finish Processing Phase 3

Start Processing Phase 4
Complete WIP Job Build
Finish Processing Phase 4

Start Processing Phase 5
Transfer cost flag not set for this LE=20
Complete Processing Periodic Cost Update : 0 txns
Complete Processing Periodic Cost Update : 0 txns
Complete processing group 1 : 5 txns
Complete Processing Periodic Cost Update : 85 txns
txn_id: <transaction id>
CSTPPINV.COST_INV_TXN:CSTPPINV.COST_INV_TXN: (50): ORA-01403: no data =found
Processing failure on phase 5.

a)   

(transaction_type = 26)

Changes

 Removed Shipping Network setup.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.