My Oracle Support Banner

WORKFLOW VIEW APPROVERS - ORA-01403: no data found ORA-06512: at "APPS.WF_NOTIFICATION",line 5725 ORA-06512: at line 5 (Doc ID 1068902.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Order Management - Version 12.0 to 12.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

It is not possible to view approved notification in case of multiple approvers on Sales Agreement. (Negotiation with Approval flow).

Also, when attempting to view a rejected quote when logged as the person who created the Quote, the following error occurs.

ERROR
ORA-01403: no data found ORA-01403: no data found ORA-06512: at "APPS.WF_NOTIFICATION",line 5725 ORA-06512: at line 5

STEPS
1. Create a Negotiation Quote in Order Management and Submit.
2. Login as user who approves and Reject the Quote.
3. Login as the person who created the Quote.l
4. You will see a notification, click on it and it will display the error mentioned in this SR.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.