APXIIMPT APP-SQLAP-10000 ORA-01403 Payment Terms

(Doc ID 1607350.1)

Last updated on MAY 25, 2015

Applies to:

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


On : 12.1.1 version, Open Interface and Inv Import

When attempting to run the Payables Open Interface, the following error occurs.

(Import_invoice 15.3) Insert payment schedules from terms
ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in

The issue can be reproduced at will with the following steps:
1. Using Payables Manager responsibility
2. Navigate to Other > Requests
3. Click on Single Request
4. Enter Request Name (Payables Open Interface)
5. Enter Parameters
6. Click Ok
7. Click on Submit => check the concurrent request log and see above error.


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