Last updated on MAY 23, 2017

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     =3D 3
legal entity id =3D 23276
cost type id    =3D 1000
period id       =3D 23001
coost group id  =3D 3000
proc. types     =3D 2
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: 4267555
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