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 AUGUST 24, 2016

Applies to:

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

Symptoms

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

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