OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Cost Collection Manager:CSTPPCCB.pm_process_txn

Home » Applications » Oracle Fusion Apps & E-Business Suite » Cost Collection Manager:CSTPPCCB.pm_process_txn_mmt(30): No data found (R12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cost Collection Manager:CSTPPCCB.pm_process_txn_mmt(30): No data found [message #627110]

Fri, 07 November 2014 05:30

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Hello,

We have a custom program which does the costing calculations for Projects.
We are operating the system for 3 operating units.
At the end of the program we submit the Cost Collection Manager program CMCCCM,
fnd_request.submit_request (
application => 'BOM',
program => 'CMCCCM',
description => 'Cost Collection Manager',
start_time => SYSDATE,
sub_request => FALSE,
argument1 => ou_id,
argument2 => 0);
while for one of the operating units it is working fine for the other two even though the programs complete in Normal status the Material Cost Collection Worker Log shows the following error message
440375 -- 000000100 - CSTPPCCB.pm_process_txn_mmt(30): ORA-01403: no data found * TXN MARKED IN MMT.
I checked the mtl_material_transactions table there the COSTED_FLAG is NULL but the PM_COST_COLLECTED FLAG is 'E' and Error_Explanation is populated as CSTPPCCB.pm_process_txn_mmt(30): ORA-01403: no data found

Inventory Parameter Project Cost Collection is enabled and Project Reference is not required in our context(Please suggest if this is a mandatory setup.)

We have raised an SR also but no solution has been provided till now.

Please suggest.

Thanks,
Vaibhav

Report message to a moderator