[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確認是否月底可以關帳