R12: AP: Payables Open Interface Returns "Payment Method Is Invalid" (Doc ID 1324691.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

OA release 12:  Payables Invoices Import

When attempting to run APXIIMPT module: Payables Open Interface Import, the following error occurs:

ERROR
-----------------------
Error: Payment Method is invalid

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
...


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run APXIIMPT module: Payables Open Interface Import
2. 27 invoices are rejected.
Error: Payment Method is invalid

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