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:

Symptoms

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

ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_CREATE_PAY_SCHEDS_PKG.AP_Create_From_Terms<-AP_INVOICES_POST_PROCESS_PKG.insert_children<-APXINWKB
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.

Cause

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