CSTPPINV.COST_INV_TXN:CSTPPAQH.ACQ_RECEIPT_COST_HOOK-No_Receipt_cost errorCSTPPACQ.get_acq_cost(45):

Start Processing Phase 5
Transfer cost flag not set for this LE 
Complete Processing Periodic Cost Update : 0 txns
Complete Processing Periodic Cost Update : 0 txns
txn id : 5293488.000000
CSTPPINV.COST_INV_TXN:CSTPPAQH.ACQ_RECEIPT_COST_HOOK-No_Receipt_cost errorCSTPPACQ.get_acq_cost(45):ORA-01403: 未找到任何数据
阶段 5 的处理失败。

 

运行计算PAC成本的时候报如上错误：

查询txn id : 5293488为MMT的transaction_id,为采购退货的数据，

后查询原来是3月份的采购退货关联的是4月份的采购接收，4月份的退货关联的是3月份的接收，错位了，导致退货的成本找不到接收的数据报错（如果界面做退货不会出现这样的情况，界面会设卡，但是用的是接口退货）

想到直接更新rcv_transactions的关系关联即可，但是没有更新过，从db克隆一份到测试环境，测试看是否可更改在上正式环境。

update rcv_transactions rcv set rcv.shipment_header_id = 428713,rcv.shipment_line_id = 456672,rcv.parent_transaction_id = 653656 where rcv.transaction_id = 789001
update rcv_transactions rcv set rcv.shipment_header_id = 428713,rcv.shipment_line_id = 456672,rcv.parent_transaction_id = 653655 where rcv.transaction_id = 789002

update rcv_transactions rcv set rcv.shipment_header_id = 488465,rcv.shipment_line_id = 516526,rcv.parent_transaction_id = 788962 where rcv.transaction_id = 788095
update rcv_transactions rcv set rcv.shipment_header_id = 488465,rcv.shipment_line_id = 516526,rcv.parent_transaction_id = 788961 where rcv.transaction_id = 788096

更新成功

metalink上的解决办法：改pls文件，直接给这笔数据一个成本（没试过）

 

: Oracle Cost Management - Version 11.5.9 to 11.5.10.3 [Release 11.5] Information in this document applies to any platform. *** Checked for relevance on 10-AUF-2017 *** SYMPTOMS When attempting to launch the CMCPAW module: Periodic Actual Cost Worker request ends with the following error: CSTPPINV.COST_INV_TXN:CSTPPAQH.ACQ_RECEIPT_COST_HOOK-No_Receipt_cost error CSTPPACQ.get_acq_cost(45):ORA-01403: no data found The issue can be reproduced at will with the following steps: 1. Costing -> Periodic Costing -> Periodic Cost (request) CAUSE The current period is the first period in which you are performing PAC processing.The return to vendor transaction that is erroring out has its parent receipt transaction in the previous period. See Bug.5101920 Periodic Actual Cost Worker CSTPPACQ.GET_ACQ_COST(45):ORA-1403 This is the reason why there is no acquisition cost available for the RTV transaction. SOLUTION To implement the solution, please execute the following steps: 1. Take backup of CSTPAHKB.pls 2. Follow up steps to Provide the acquisition cost for the receipt in the procedure -> "acq_receipt_cost_hook" make the foll changes-> a. Change following line o_error_num := -1; to o_error_num := 0; b. Change o_hook_cost := 0 to o_hook_cost := <ct specified cost>; c. Set o_error_msg := ''; 3. Save CSTPAHKB.pls 4. Run the Periodic Actual Cost Processor. 5. Please retest the issue. 6. If the issue is resolved, please migrate the solution as appropriate to other environments.