REL 12.1.2 Payables Open Interface Import Rejects Invoices : INVALID PAY METHOD (Doc ID 1062955.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.2 to 12.1.2 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2015***

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 : 682
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : 1st party LE id : 23274
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Org Id : 110
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Org Type : OPERATING_UNIT
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Payer Id : 9718
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Payee Site Id : 6875
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : Supplier Site Id : 867
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 9718, 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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms