Arthur-Work

2019年4月8日星期一

Oracle EBS: ASCP執行memory-based snapshot worker時error

狀況: 出現以下error:

Calendar problem : mssdds_snp_other_demnads: 2458850 2458850 179

APP-MRP-22064: An internal error has occurred (mssdds_snp_other_demands, 1)

APP-MRP-20075: An internal error has occurred (mrsngi_snp_gross_rqmts, 8, , )
@ERRORTET     Cause:     The current routine encountered the specified@ERRORTEXT x

APP-MRP-20075: An internal error has occurred (mrsndi_snp_demand_info, 8, , )
@ERRORTET     Cause:     The current routine encountered the specified@ERRORTEXT x

APP-MRP-20075: An internal error has occurred (mrnspxt, 19, 10008, )
@ERRORTET     Cause:     The current routine encountered the specified@ERRORTEXT x

APP-MRP-20075: An internal error has occurred (mrnspgpt, 14, 202, 10008, )
@ERRORTET     Cause:     The current routine encountered the specified@ERRORTEXT x

APP-MRP-20075: An internal error has occurred (main, 13, , )
@ERRORTET     Cause:     The current routine encountered the specified@ERRORTEXT x

原因:ASCP plan的日期區間超過calendar的日期區間, 也有SO的日期超過calendar的範圍

解法:

1.查看日期
select to_date(&julian_number,'j')Julian
    from dual;

2.確認organization所使用的calendar, 並延長設定日期至少五年 (BOM/Setup/Calendars)

3.Rebuild calender (Tools/Build)

4.執行data collections

5.重執行ASCP plan

Ref:
1.MSCNSP Memory Based Snapshot On An Unconstrained Plan Errors With Calendar problem : APP-MRP-22064 mrsngs_snp_gross_rqmts (Doc ID 421723.1)

2019年4月2日星期二

Oracle EBS: 工單關結, 直接人工效率差異出現過高有利差

狀況:
1.Routing中設定的Resource未變動
2.工單上的Applied高於Required, 應是不利差

原因:
1.財會維護的rate在接近月底時有調高了約36%
2.工單中多數成品在調高前就已完工入庫
3.標準人工的resource因採調高後的rate計算, 因此遠高於原先的估計值

後記:
這是在月中改設定值的後遺症哪...

2019年4月1日星期一

Oracle EBS: CST_INVALID_WIP error

錯誤訊息:

CST_INVALID_WIP error The wip entity is either not defined or does not have a period balance entry

狀況:
1.transaction停在pending, 無法產生分錄
2.transaction_source_id是個很大的負值 (後來才注意到)

解法:
1.請user提供交易當時所處理的工單
2.對應出wip_entity_id, 並更改transaction_source_id
3.重新處理未產生分錄的交易

後記:

原先以為是曾發生過的WIP_PERIOD_BALANCES無資料, 後來比對才發現transaction_source_id有問題, 目前還不知道原因.

參考資料都找了, 還是列一下.

補入資料:
INSERT INTO WIP_PERIOD_BALANCES
(ACCT_PERIOD_ID, WIP_ENTITY_ID,
REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
LAST_UPDATED_BY, CREATION_DATE,
CREATED_BY, LAST_UPDATE_LOGIN,
ORGANIZATION_ID, CLASS_TYPE,
TL_RESOURCE_IN, TL_OVERHEAD_IN,
TL_OUTSIDE_PROCESSING_IN, PL_MATERIAL_IN,
PL_MATERIAL_OVERHEAD_IN, PL_RESOURCE_IN,
PL_OVERHEAD_IN, PL_OUTSIDE_PROCESSING_IN,
TL_MATERIAL_OUT, TL_MATERIAL_OVERHEAD_OUT, TL_RESOURCE_OUT,
TL_OVERHEAD_OUT, TL_OUTSIDE_PROCESSING_OUT,
PL_MATERIAL_OUT, PL_MATERIAL_OVERHEAD_OUT,
PL_RESOURCE_OUT, PL_OVERHEAD_OUT,
PL_OUTSIDE_PROCESSING_OUT,
PL_MATERIAL_VAR, PL_MATERIAL_OVERHEAD_VAR,
PL_RESOURCE_VAR, PL_OUTSIDE_PROCESSING_VAR,
PL_OVERHEAD_VAR, TL_MATERIAL_VAR, TL_MATERIAL_OVERHEAD_VAR,
TL_RESOURCE_VAR, TL_OUTSIDE_PROCESSING_VAR,
TL_OVERHEAD_VAR)
VALUES
(xxxx, yyyy, NULL, SYSDATE, 0, SYSDATE, 0, 0,
zzzz, ct, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

其中:
xxxx : Acct_period_id
yyyy : wip_entity_id
zzzz : organization_id
ct : class_type

Ref:
1.Oracle ERP R12. CST_INVALID_WIP (The wip entity is either not defined or does not have a period balance entry.) - Discrete Job
http://doggww.blogspot.com/2013/02/oracle-erp-r12-cstinvalidwip-wip-entity.html

2.CST_INVALID_WIP error The wip entity is either not defined or does not have a period balance entry (Doc ID 1531200.1)

2019年3月5日星期二

Oracle EBS: update cost時, 出現APP-BOM-24060 error

問題: update cost時, 出現error

APP-BOM-24060: You can not update costs when transactions exist for an item

看了看, 原因和解法都在訊息中.

原因: item已有交易, frozen cost已被用於評價交易

解法: 以Cost Update來更新forzen cost.

依Oracle文件所述, 用於判斷交易的是以下三個table:

MTL_MATERIAL_TRANSACTIONS
MTL_MATERIAL_TRANSACTIONS_TEMP
MTL_SUPPLY

Ref:
1.In Which Case APP-BOM-24060 Error Occur? (Doc ID 2243603.1)

Oracle EBS: item cost中的Material Overhead出現負數

問題: item cost中的Material Overhead出現負數

原因: 此item為Make, 設定為不捲算, 成本為0, 但客製程式又扣除特定原物料金額, 所以material overhead算出了負數.

2019年4月8日 星期一