My Oracle Support Banner

R12: AP: Create Invoice Getting "ORA-20001 ORA-01403 AP_CREATE_PAY_SCHEDS_PKG.AP_Create_From_Terms<-AP_INVOICES_POST_PROCESS_PKG.insert_children<-APXINWKB (Doc ID 2437761.1)

Last updated on DECEMBER 13, 2022

Applies to:

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


When created new invoices, received the following error message...

ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
with parameters (Invoice_Id = XXXX , Terms_Id = , Last_Updated_By = , Created_By = , Payment_Priority = 99, Batch_Id = , Terms_Date = , Invoice_Amount = , Amount_for_discount = , Payment_Method = , Currency = )
while performing the following operation:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_INVOICES_PKG", line 2858

FRM-40735: PRE-BLOCK trigger raised unhandled exception ORA-01403.


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

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