2026-05-21

[Oracle]AR Interface Error(TYPE決定修正的位置)

l   無效的業務代表識別碼 (SALESREP_ID)

l   無效的銷售業績型態識別碼 (SALES_CREDIT_TYPE_ID)

l   'Oracle 應收帳款管理系統' 中需有帳單寄送地址識別碼, 且必須將其指定給帳單寄送地點客戶 (ORIG_SYSTEM_BILL_ADDRESS_ID)

l   無效的主要業務代表識別碼 (PRIMARY_SALESREP_ID)

l   無效的帳單寄送地點客戶識別碼 (ORIG_SYSTEM_BILL_CUSTOMER_ID)

l   Cannot get remit to address

檢查AR > Setup > Print > Remit to Addresses 

方案一、直接設定一組Default,方案二、設定指定國家(看那個客戶有問題)


參考文件

Troubleshooting Autoinvoice Import - Execution Report Errors (Request Status = Completed) (Doc ID 1089172.1)

Troubleshooting Remit To Address in Oracle Receivables: Cannot get remit to address (Doc ID 1101855.1)

How to Setup a Remit-To Address in Release 12 Oracle Receivables (Doc ID 1101666.1)


l   Please correct the receivable account assignment

檢查AR > Setup > Transaction > AutoAccounting

Receivable設定

l   Please correct the revenue account assignment

檢查AR > Setup > Transaction > AutoAccounting

Revenue設定

l   You must supply sales credit assignments for this transaction because the system option Require Salesreps is set to Yes.

RA_INTERFACE_SALESCREDITS_ALL這個資料表沒有建立

l   Conversion rate for the given date, currency code, set of books and conversion type has not been defined

l   Invalid Warehouse ID (WAREHOUSE_ID)

Tax code must be active, adhoc, and of type VAT or SALES TAX

l   Unable to derive a gl date for your transaction.  Please ensure that your transaction is in a gl period which you have defined

補充GL Date決定拋AR日期

發生錯誤原因:舉例AR要接8月,但是目前日期已經9/1,會發生問題,系統似乎會自動比對資料,需要於AR Interface填寫Conversion DateGL Date


沒有留言:

張貼留言