Purge Quote Program Completes Normal But Does not Purge Anything

(Doc ID 2187212.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Quoting - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.


Purge Quote Program not working.
Job runs successfully to completion, but no records deleted.

ASO Debug Log shows below:

ASO Before Purging the table ASO_SALES_CREDITS
ASO Exception raised in Main Procedure  : Error Code:  100 Error Msg  ORA-01403: no data found
ASO In others exception

Program should purge when it was run in Review Mode = No

The issue can be reproduced at will with the following steps:
1. Login to EBS with Quoting Sales Manager resp
2. Submit concurrent program Purge Quotes
3. Select Review Mode = No
4. Check concurrent log

The issue has the following business impact:
Unable to use Purge program


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