My Oracle Support Banner

Receipts Workbench: Apply an Invoice to a Receipt Using the AR_RECEIPT_API_PUB.APPLY API.GET_MAX_DISCOUNT API Error - 'ORA-01403: No Data Found if Called with Parameter grace_days_flag = Y (Doc ID 1608162.1)

Last updated on OCTOBER 08, 2019

Applies to:

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


Attempting to apply an invoice to a receipt using the AR_RECEIPT_API_PUB.APPLY API. 
Through this API, you can pass a parameter p_discount. 

You are attempting to calculate the discount amount using API arp_discounts_api.get_max_discount and the return value of this API into the p_discount parameter of APPLY API, but the discount API is always going into exception with the following error:

GET_MAX_DISCOUNT API returns error 'ORA-01403: no data found' if is called with parametre grace_days_flag = Y


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.