EBS发票已经过账，但是FORM界面显示未过账问题修复脚本

 
UPDATE AP_INVOICE_DISTRIBUTIONS_ALL T
   SET T.POSTED_FLAG = 'Y', T.ACCRUAL_POSTED_FLAG = 'Y'
 where T.INVOICE_ID = 98972
   AND T.POSTED_FLAG = 'N';
 
UPDATE AP_PREPAY_HISTORY_ALL T
   SET T.POSTED_FLAG = 'Y'
 where T.INVOICE_ID = 98972;
 
UPDATE XLA_EVENTS A
   SET A.EVENT_STATUS_CODE = 'P', A.PROCESS_STATUS_CODE = 'P'
 where A.EVENT_ID = 6422219; 
UPDATE XLA_AE_HEADERS A
   SET ACCOUNTING_ENTRY_STATUS_CODE = 'F'
 where A.ENTITY_ID IN (select ENTITY_ID
                         from XLA.XLA_TRANSACTION_ENTITIES T
                        where T.ENTITY_CODE = 'AP_INVOICES'
                          AND T.LEDGER_ID = 2024
                          AND T.SOURCE_ID_INT_1 = 98972)
   AND A.ACCOUNTING_ENTRY_STATUS_CODE = 'D';