Arthur-Work: 12月 2019

2019年12月31日星期二

Oracle EBS: 修改AR due date

問題: 月結payment term的due date計算有誤, 每月26日之後的交易都少算一個月.

修改:

UPDATE AR_PAYMENT_SCHEDULES_ALL A

SET A.DUE_DATE = ADD_MONTHS (A.DUE_DATE, 1)
WHERE customer_trx_id IN (1825819, 1825818, 1825820)

UPDATE RA_CUSTOMER_TRX_ALL B
SET B.TERM_DUE_DATE = ADD_MONTHS (B.TERM_DUE_DATE, 1)
WHERE customer_trx_id IN (1825819, 1825818, 1825820)

先治標, 根本問題還要再解.

2019年12月25日星期三

Oracle EBS: 更改payment term中的balance forward billing cycle

問題: 更改payment term中的balance forward billing cycle

解答: 只要payment term已在交易中使用過, 就不能更改balance forward billing cycle

Ref:
1.How To Update Currently Used Payment Term With Balance Forward Billing Cycle (Doc ID 1578298.1)

Oracle EBS: BI Publisher report使用RTF template不能高於63欄位的解法

問題: RTF template不能高於63欄位, 源自於MS word單一表格最高只有63欄位

暫解: 巢狀式表格, 但資料量大時, 會因Java heap memeory問題而失敗

解法: 改為使用XSL-FO template

Ref:
1.Limitation of BI Publisher report using RTF template having more than 63 columns and how to resolve it.
https://erporaclesy.wordpress.com/2018/06/01/limitation-of-bi-publisher-report-using-rtf-template-having-more-than-63-columns-and-how-to-resolve-it/

Oracle EBS: AR concept

AR concept

1.AP/AR Netting in R12
https://erporaclesy.wordpress.com/2014/11/13/apar-netting-in-r12/

2.AR: Balance Forward Billing in R12
https://erporaclesy.wordpress.com/2014/11/04/ar-balance-forward-billing-in-r12/

3.AR: Auto Invoice
https://erporaclesy.wordpress.com/2014/11/03/ar-auto-invoice-process/

2019年12月24日星期二

Oracel EBS: 補入return to supplier之分錄

問題:
1.user進行return to supplier時, 不知怎麼作到一筆作業產生兩筆交易
2.在rcv_transactions_interface中, 第一筆正常處理完, 第二筆則是completed/error
3.在rcv_transactions的兩筆交易都有, 第二筆沒有分錄資料
4.第二筆因沒有庫存, 對INV的交易也卡住

針對沒有分錄, 可用以下procedure補入:

     RCV_AccrualAccounting_GRP.Create_AccountingEvents(
     p_api_version        => 1.0,
     p_source_type        => 'RECEIVING',
     p_rcv_transaction_id => c_rec.transaction_id,
     p_direct_delivery_flag=> null,
     p_gl_group_id      => null,
     x_return_status      => l_return_status,
     x_msg_count          => l_msg_count,
     x_msg_data           => l_msg_data
     );

備註: 要先執行

    mo_global.init('PO');
    mo_global.set_policy_context('S',&operating_unit_id);