Arthur-Work: 6月 2019

2019年6月28日星期五

Oracle EBS: 依Payment term計算Due Date

1.依cutoff day決定Calculated Due Date
若trx date大於cutoff day, calculated due date為Cut-off Day of Next Month + Months Ahead
   若trx date小於cutoff day, calculated due date為Cut-off Day of Current Month + Months Ahead
   若未設定Cutoff Day, calculated due date為Trx Date + Months Ahead

2.基於Day of Month決定Final Due Date
   若Calculated Due Date的日數(Day)大於Day of Month, Final Due Date依Months Ahead多加一個月

Ref:
1.How is Due Date Calculated From Payment Terms (Doc ID 978755.1)

Oracle EBS: 用於更改SO line資料之API

OE_ORDER_PUB.PROCESS_ORDER

Ref:
1.Sales Order Line Update API (OE_ORDER_PUB.PROCESS_ORDER)
https://aloz0101.pixnet.net/blog/post/39504171-sales-order-line-update-api-(oe_order_pub.process_order)

2.Script To Update An Existing Order Line using OE_ORDER_PUB.process_order API (Doc ID 746802.1)

2019年6月21日星期五

Oracle EBS: AR transaction number的跳號要由20改為1

修改ARPLBSUB.pls ($AR_TOP/patch/115/sql)
PACKAGE: ARP_BATCH_SOURCE
Procedure: create_trx_sequence

原程式:
l_sql_stmt := 'creat
e sequence '||l_sequence_name||
' minvalue 1 maxvalue 99999999999999999999 start with '||
to_char(P_last_number + 1)||' cache 20';

改為:

l_sql_stmt := 'create sequence '||l_sequence_name||
' minvalue 1 maxvalue 99999999999999999999 start with '||
to_char(P_last_number + 1)||' nocache ';

再recompile package.

Ref:
1.How To Create Automatic Transaction Numbering Sequence for Transaction Batch Source Always with Nocache option? (Doc ID 428561.1)

2019年6月18日星期二

Oracle EBS: Overhead設定Default Basis為Item之影響

在Overhead中, 通常Default Basis設定為Resource Unit, 因有誤設定為Item, 造成許多成品cost增加.

原因為:

1.Department DPT1下有Resource RSC1, 在RSC1中有設定此overhead

2.DPT1在許多routing中都有用到

3.成品/半成品的routing都有DPT1, 以成品來看, level 1有三筆, level 2捲算半成品彙總為一筆(包含2個半成品各2筆, 因此金額為4倍), 所以在成品階看到同一個Overhead出現四筆

修正方式: Default Basis調整為Resource Unit, Rate中的設定也需修正. 成品/半成品會cost update, 但已出貨就來不及了.

2019年6月10日星期一

Oracle EBS: Error "You are not Setup as an Employee."

問題: 新建立的user帳號, 在要作Receiving transaction時, 出現error:

You are not Setup as an Employee. To access this form you need to be an employee

原因: user帳號中的Person未指定對應的人員

解決方式: Person欄位中指定對應人員

Ref:
1.How to Resolve Error ' You are not setup as a worker' when Accessing PO forms (Doc ID 554484.1)

2019年6月2日星期日

Oracle EBS: 修改ra_interface_lines_all中error的資料, 以重拋AR

狀況:
user作銷退, 但reference到的AR transaction金額已改為0, 因此error.

You can not apply more than the original line amount

解法:
確認要拋AR, 先清掉reference_line_id, 再清掉兩個欄位:
1.interface_line_id
2.request_id

找資料時發現有人遇過資料在interface中沒error, 但也沒轉成功, 這時要清的欄位是:
1.interface_line_id
2.request_id
3.customer_trx_id
4.link_to_line_id

UPDATE ra_interface_lines_all
     SET interface_line_id = null,
         customer_trx_id = null,
         request_id = null,
         link_to_line_id = null
WHERE nvl(interface_status,'x') != 'P';

Ref:
"Stuck in the Interface" , Invoice not created in AR and no error is showing in the interface. (or) The AutoInvoice Master Program (RAXMTR) may complete without error but will not spawn the AutoInvoice Import Program. And Sales Order Line status is "closed"
http://oracleappserpsolutions.blogspot.com/2015/06/stuck-in-interface-invoice-not-created.html

2019年6月28日 星期五