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 APRIL 22, 2024

Applies to:

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

Symptoms

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. Responsibility : Cost management - SLA

2. Navigation : Inventory > Transactions > Enter Misc Transactions

3. Enter Project and Task

4. Run Cost Collection Manager

5. View error in Material transactions form or Cost Collection Worker log file

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


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