My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.