2012年10月31日 星期三

2012年10月30日 星期二

如何取消void prepayment 的付款

Prepayment invoice, and it has been fully applied. Therefore, the check can be Voided only after the prepayment has been unapplied.

如果是 prepayment的發票且狀態是 fully applied的話,要先將此發票作 unapplied 的動作,其付款 payment才可以作void.

2012年10月15日 星期一

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 (
)

後執行 data fix‧