Oracle EBS R12 資料一直卡在 AP_Invoices_Interface無法拋轉

如果資料一直卡在 AP_Invoices_Interface無法拋轉，而且 Rejection Report 也沒有資料的話，可以開啟 FND Log再跑一次 Payables Open Interface Import Program，如果有 log 有出現
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext: Fatal: Exception when attempting to perform exact match for given payee context.
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext: SQL code: -1422
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext: SQL err msg: ORA-01422: exact fetch returns more than requested number of rows
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext: EXIT
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : ERROR: Exception occured during call to API 
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : ERROR: Exception occured during call to API 
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : SQLerr is :ORA-01422: exact fetch returns more than requested number of rows
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : SQLerr is :ORA-01422: exact fetch returns more than requested number of rows

請下載 Patch:13857555:R12.AP.B for 12.1 (

R12: Generic Data Fix (GDF): Duplicate Payee in IBY_EXTERNAL_PAYEES_ALL [ID 1315812.1]

)

後執行 data fix‧