My Oracle Support Banner

Unable to Create, Approve or Reject Adjustments due to Error: "ORA-01403: No Data Found" (Doc ID 2247298.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


Unable to create adjustment in Adjustments form, or approve/reject adjustments from Approve Adjustments form due to the following error:

ORA-01403: no data found


APP-AR-11503:  Invoice type adjustment must make the balance due zero

or in FND debug log, the following exception occurs:



Steps To Reproduce
1. Responsibility : Log into your Receivables Responsibility
2. Navigation: Control > Adjustments > Approve Adjustments and query Adjustment Number to be approved
3. Choose Approve from the Status LOV
4. Error occurs : ORA-01403: no data found



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.