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

Last updated on MAY 15, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
APPRVL - Invoice Validation
APXINWKB - Invoice Workbench


Symptoms

Oracle Payables (AP) Information Center > Invoices > Note  1308904.1

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
Oracle Payables > Invoices > Entry > Invoices
Actions > Validate
or
Other > Requests > Run > Invoice Validation


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