数据修复
----------
执行以下的修复语句更改为正确的acct_period_id:
Update mtl_material_transactions
set acct_period_id =
, costed_flag = \'N\'
, transaction _group_id = NULL
, transaction_set_id = NULL
, error_code = NULL
, error_explanation = NULL
where costed_flag = \'E\'
and acct_period_id =
and error_code = \'CST_MATCH_DATE_PERIOD\'
and organization_id = \'\'
根本原因:
--------------
11i:
Patch 4447285 获取 CSTPACQB.pls 115.35.115100.5 期间成本更新
Patch.4870805CSTFEPCU.fmb 在版本号 115.18.115100.3期间成本更新
Patch.5398466 wms patch/115/sql WMSTKPTB.pls 115.141.115100.25
Patch 4992305CSTVCPVB.pls 版本号 115.0.115100.7
R12:
应用Patch 6873037
11.5.10.2
程序CST_REVENUECOGSMATCH_PVT.INSERT_ONESOISSUE() 失败
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