[Oracle]R12: APP-FND-01702 Document is not assignment

要先選付款文件後帶出文件編號，如先選付款處理設定檔後面會出錯

[Oracle]AP Payment 建立會計失敗

 

Data Fix方法，騙系統已經建立會計，再於總帳手動補入對應分錄

!!!!!重要提醒，進行任何資料修改記得備份，並且知道自己在做什麼!!!!!

SELECT AIP.ACCOUNTING_EVENT_ID, AIP.INVOICE_ID, AIP.AMOUNT, AIP.ORG_ID
  FROM AP_INVOICE_PAYMENTS_ALL AIP
 WHERE 1 = 1
   AND AIP.CHECK_ID = 371500
 ORDER BY AIP.INVOICE_PAYMENT_ID;

SELECT EVENT_ID,EVENT_STATUS_CODE,PROCESS_STATUS_CODE FROM XLA_EVENTS WHERE EVENT_ID IN (808092,18237498);

UPDATE XLA_EVENTS
   SET EVENT_STATUS_CODE = 'P', PROCESS_STATUS_CODE = 'P'
 WHERE EVENT_ID IN (18237498); --REFUND CANCELLED 的 ACCOUNTING_EVENT_ID

SELECT AIP.ACCOUNTING_EVENT_ID,AIP.ACCRUAL_POSTED_FLAG,AIP.CASH_POSTED_FLAG,AIP.POSTED_FLAG FROM AP.AP_INVOICE_PAYMENTS_ALL AIP WHERE AIP.ACCOUNTING_EVENT_ID IN (808092,18237498);

UPDATE AP.AP_INVOICE_PAYMENTS_ALL AIP
   SET AIP.ACCRUAL_POSTED_FLAG = 'Y',
       AIP.CASH_POSTED_FLAG    = 'Y',
       AIP.POSTED_FLAG         = 'Y'
 WHERE AIP.ACCOUNTING_EVENT_ID = 18237498; --Refund Cancelled 的 ACCOUNTING_EVENT_ID

SELECT APH.ACCOUNTING_EVENT_ID,APH.POSTED_FLAG FROM AP.AP_PAYMENT_HISTORY_ALL APH WHERE APH.ACCOUNTING_EVENT_ID IN (808092,18237498);

UPDATE AP.AP_PAYMENT_HISTORY_ALL APH
   SET APH.POSTED_FLAG = 'Y'
 WHERE APH.ACCOUNTING_EVENT_ID = 18237498; --Refund Cancelled 的 ACCOUNTING_EVENT_ID

執行Subledger Period Close Exceptions Report確認是否月底可以關帳

[Oracle]結帳後AP沒有關閉，造成帳務拋錯錯誤

l   說明目前時間12月份，AP模組11、12月份期間開啟，GL模組11月份期間關閉、12月份期間開啟，取消11月份AP商業發票，拋轉到11月份，正確資料應拋到12月份

l   解決方案重新開一張一樣的AP商業發票，並將新舊AP商業發票拋到總帳，關閉AP模組與GL模組11月份期間，再將新的AP商業發票取消，即可取消在12月份

科目餘額不會影響，但借貸都會增加數字

[Oracle]供應商建立於多組織

l   建立供應商，Organization Name與Supplier Number

l   Supplier Sites建立不同OU

備註如遇到已經建立可以先更換名稱並失效，再進行新增 

[Oracle]How to disable Suppiler

 只能設定失效時間，資料表的Flag找不到位置

[Oracle]R12:如何刪除供應商或相關資料(需備份資料庫有風險)

 l   PO > Management > Purge > Initiate

ü   Last Activity Date:決定哪些已前的資料準備清除

ü   Operating Unit:測試發現就算指定OU，仍列出其他OU，可能升級造成

l   Request > Initiate Purge (AP/PO Purge Initiation (Selection) Routine)

l   Request > Print Purge (Purge Report Listings) 可以查看此次Purge預選清單

l   PO > Management > Purge > Confirm 開始刪除資料

*Warning: AP accounting entries will be/have been purged along with their transaction records.* 供應商所有發票與付款也會被清除

How to Use Payables Purging Process for Invoice, Payment, Purchase Order, Requisition and Supplier Scheduling? (Doc ID 139316.1)

[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 Date與GL Date