错误和问题解决的成本 (5)

Failure in procedure CST_RevenueCogsMatch_PVT.Insert_OneSoIssue()
Unexpected error in CST_RevenueCogsMatch_PVT . Insert_OneSoIssue ( 40 )
The transaction date is not within the accounting period specified.

 

 

应用 Patch 8685863
或更高来更新文件CSTRCMVB.pls 到版本号120.37.12000000.25

以下的前置补丁须要首先被应用: Patch 8510248

 

12.0.6

 
   

成本处理程序死锁 (CMCMCW).

反复计划对WPB的更新先不锁住行,导致其它的处理程序能够试着去处理这些行并可能死锁. 

 

 

 

应用Patch 6709905

 

12.0.4

 
   

定期所有成本处理程序\'RUN OPTIONS\' 错误NO LOV NO ENTRIES FOUND

 

No entries found for list values

 

 

对有问题的期间。请向ORACLE技术人员提交一个服务请求,重设处理状态为 \'unprocessed\'

 

11.5.10.2

 
   

实际成本处理程序CMLACW()失败,因为错误ORA-01455: CONVERTING COLUMN OVERFLOWS INTEGER DATATYPE

 

ORA-01455: converting column overflows integer data type


 

 

执行并上传以下的输出,用EXCEL文件带有标题的格式:

select * 
from mtl_material_transactions 
where costed_flag =\'E\';

 

确保以下文件你拥有最新的代码:
inltcp.lpc
cmlacw.lpc
cmlmcw.lpc
cmllcw.lpc 

对于R12.x 应用 Patch 10435651:R12.BOM.A. 或更高
对于R12.1.1 应用补丁Patch 10416679:R12.BOM.C或更高

 

12.X

 
   

CSTPACDP.INV_COST_TXN (45): ORA-01086: SAVEPOIN 

这是因为代码中的拼写错误.在 Insert_OneSoIssue 过程里更改 \'ROLLBACK TO Insert_OneSoIssues_PVT\' 为 \'ROLLBACK TO Insert_OneSoIssue_PVT\'

 

CSTPACIN.COST_INV_TXN:CSTPACDP.inv_cost_txn (45): ORA-01086: savepoint
\'INSERT_ONESOISSUES_PVT\' never established
ORA-06512: at ""APPS.CST_REVENUECOGSMATCH_PVT"", line 2338
ORA-06510: PL/SQL: unhandled user-defined exception

 

 

应用 Patch 7384398

 

12.1.1

 
   

CSTPLCIR.COMPONENT_ISSUE():30:INVENTORY TOTAL TXN QTY WAS 0; EXPECTED -1 
  当在表cst_inv_layers中的层数量是0时    cst_inv_layer_cost_details 的分配没有被创建。
在表CST_INV_LAYERS 中有一些记录,他们在表CST_INV_LAYER_COST_DETAILS 中却没有数据,或报以下的错


CSTPLCIN.COST_INV_TXN:CSTPLENG.CREATE_LAYERS (130): ORA-1407 CANNOT UPDATE ("BOM

 

CSTPLCIR.component_issue():30:Inventory total txn qty was 0; expected 

or error:

CSTPLCIN.COST_INV_TXN:CSTPLENG.create_layers (130)::ORA-01407 cannot update (""BOM"".""CST_INV_LAYERS"".""LAYER_COST"") to NULL

 

执行并上传以下的输出,用EXCEL文件带有标题的格式:

SELECT *
FROM CST_INV_LAYERS CIL
WHERE NOT EXISTS
(SELECT 1
FROM CST_INV_LAYER_COST_DETAILS CILCD
WHERE CILCD.INV_LAYER_ID =CIL.INV_LAYER_ID);

 

应用 Patch 7282633

 

11.5.10.2

 
   

来自库存视图XLA_INV_AEL_GL_V XLAIQDRL行

 

No Error drill down from GL is incorrect

 

执行以下的脚本来确定错误的事务处理:
select * from 
from mtl_transaction_accounts mta,gl_je_lines jel
where mta.gl_batch_id = jel.reference_1
and mta.reference_account = jel.code_combination_id
and mta.transaction_id = NVL(jel.reference_3, mta.transaction_id)
and NVL(mta.gl_sl_link_id,-1)
= NVL(jel.gl_sl_link_id, NVL(mta.gl_sl_link_id,-1))
having SUM(base_transaction_value) = 0"

 

应用 Patch 7264369

 

11.5.10.2

 
   

RMA接收后,事务处理在表MMT里显示成本错误

 

Failure in procedure 
CST_RevenueCogsMatch_PVT.Process_RmaReceipt()

or error 
CSTPACIN.COST_INV_TXN:UNEXPECTED ERROR IN CST_REVENUECOGSMATCH_PVT.INSERT_ONES

 

执行并上传以下的输出。用EXCEL文件带有标题的格式:

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/zwxjys.html