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

SELECT msi.inventory_item_id,mp.organization_id,mp.organization_code
FROM inv.mtl_system_items_b msi,inv.mtl_parameters mp 
WHERE NOT EXISTS ( SELECT \'X\' FROM bom.cst_item_costs cic WHERE cic.inventory_item_id = msi.inventory_item_id AND cic.organization_id = mp.cost_organization_id AND cic.cost_type_id = mp.primary_cost_method) AND msi.costing_enabled_flag = \'Y\' and msi.organization_id = mp.organization_id;

 

 

11.5.10.2

 
                       
    组件: COST_ERROR                  
   

装入利润分析执行报错CSTPMRGL.LOAD_OM_MARGIN_DATA(160) ORA-12899

 

ORA-20001: CSTPMRGL.load_om_margin_data(160): ORA-01403

 

 

应用补丁Patch 7215820

 

12.0.4

 
   

CST_MATCH_DATE_PERIOD 错误, 待定成本事务处理

 

错误代码: CST_MATCH_DATE_PERIOD
错误解释: The transaction date is not within the accounting period specified." 

COGS 确认 错误.请參考 Note 733275.1

 

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

SELECT oap.acct_period_id oap_acct_period_id,
mmt.acct_period_i d mmt_acct_period_id,
mmt.transaction_id mmt_transaction_id,
oap.period_start_date period_start_date,
mmt.transaction_date mmt_transaction_date
FROM mtl_material_transactions mmt,
org_acct_periods oap
WHERE mmt.costed_flag = \'E\'
AND mmt.transaction_source_type_id = 2
AND mmt.transaction_action_id = 36
AND mmt.organization_id = oap.organization_id
AND oap.acct_period_id = mmt.acct_period_id
AND ( mmt.transaction_date < oap.period_start_date
OR mmt.transaction_date > oap.schedule_close_date+.99999);

 


数据修复
----------
执行以下的修复语句更改为正确的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\';

 

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

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