确保以下文件你拥有最新的代码:
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文件带有标题的格式:
SELECT * FROM cst_cogs_events
WHERE cogs_om_line_id = &om_line_id;
SELECT * FROM mtl_material_transactions
WHERE (trx_source_line_id = &source_line_idOR transaction_id = &txn_id);
SELECT * FROM oe_order_lines_all
WHERE line_id = &line_id;
SELECT * FROM cst_revenue_cogs_match_lines
WHERE cogs_om_line_id = &om_line_id;
应用 Patch 7121674
更新文件 RCVCOTRX.pld 120.53.12010000.9 或更高
和Patch 7015709
更新文件 CSTRCMVB.pls 120.37.12000000.11或更高
12.0.4 到12.X
成本管理器不能处理事务处理。结束时报错
CST_MATCH_DATE_PERIOD
CST_MATCH_DATE_PERIOD