My Oracle Support Banner

Project Manufacturing Error CSTPPCCB.pm_process_txn_mmt(85): ORA-01403: no data found, Project/Task Invalid for Cost Collection (Doc ID 1530394.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Inventory Transactions

Need update for Inventory Material Transactions in 'E' status for Transfer to Projects


Missing Task Numbers Preventing Transfer of Inventory Material Transactions In E Status To Projects.  Created two Move Orders to Projects in Inventory. The move orders were fully approved and transacted. Somewhere between Inventory and Projects, the task numbers were dropped from the two move orders. Now they cannot be transferred to Projects because they do not have task numbers.

Require a script to update these material transactions with the correct tasks as interface update is not possible as Move Order is closed and cannot be updated. The Material Transaction query screen is not able to be updated. Need to update these transactions so they will import to Projects.

ERROR
-----------------------
CSTPPCCB.pm_process_txn_mmt(85): ORA-01403: no data found, Project/Task Invalid for Cost Collection.

STEPS
-----------------------
1. Somewhere between Inventory and Projects, the task numbers were dropped from the two move orders.

2. Now they cannot be transferred to Projects because they do not have task numbers.
 

Changes

 

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
Changes
Cause
Solution


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