R12: AP: Payables Open Interface Import Rejects Invoices : INVALID PAY METHOD
(Doc ID 1062955.1)
Last updated on OCTOBER 07, 2024
Applies to:
Oracle Payables - Version 12.1.2 to 12.1.2 [Release 12.1]Information in this document applies to any platform.
Symptoms
On : 12.1.2 version,
After having upgraded from 12.1.1 to 12.1.2 ,
Payables Open Interface Import (APXIIMPT) rejects invoices ( source='CLAIMS' )
with the following reject code: INVALID PAY METHOD
The problem does not happen in REL 12.1.1, but it happens in REL 12.1.2
The APXIIMPT debug log file shows:
(Check Invoice Validation 17) Check Payment Info
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : ENTER
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Application_id :
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : 1st party LE id :
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Org Id :
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Org Type : OPERATING_UNIT
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Payer Id :
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Payee Site Id :
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Supplier Site Id :
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Trxn Type Code : PAYABLES_DOC
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Payment Currency : USD
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Payment Amount : -1000
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Payment Function : PAYABLES_DISB
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext: ENTER
..
..
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext: Given payee context: payee party id , party site id , supplier site id , org id , org type , pmt_function PAYABLES_DISB
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 : SQLerr is :ORA-01422: exact fetch returns more than requested number of rows
(Insert Rejections 1) Insert into AP_INTERFACE_REJECTIONS, REJECT CODE:INVALID PAY METHOD
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |