My Oracle Support Banner

R12: AP: Primary Note: Payables Invoice Validation Errors with APP-SQLAP-10000 and ORA-01403 Error Messages (Doc ID 1308904.1)

Last updated on APRIL 15, 2024

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
APPRVL - Invoice Validation
APXINWKB - Invoice Workbench




Symptoms

Important Note: The objective of a Individual Error Note is to take a specific error message (usually a handled error message but can be an unhandled error in certain cases) and explain the various causes and solutions for that error.


-- Problem Description
Unable to validate invoice due to the following error:

APP-SQLAP-10000: ORA-1403: no data found occurred in AP_ETAX_UTILITY_PKG.Return_Tax_Distributions


or

APP-SQLAP-10000: ORA-1403: no data found


or

ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in AP_APPROVAL_MATCHED_PKG.Exec_Matched_Variance_Checks


or

ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in AP_FUNDS_CONTROL_PKG.Calc_QV


or

ORA-20001: APP-SQLAP-10000: ORA-1403: no data found occurred in AP_APPROVAL_PKG.Approval_Init


or

ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults



-- Steps to Reproduce
1. Go to  Oracle Payables Responsibility > Invoices > Entry > Invoices
2 Actions > Validate
or
2.1 Other > Requests > Run > Invoice Validation
3.Error is returned.


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!

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