Request Information On A Purchase Requisition Results in ORA-01403: No Data Found ORA-06512 At "APPS.WF_NOTIFICATION"

(Doc ID 1281513.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Purchasing - Version 12.0.0 to 12.1.1 [Release 12 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2014***

Symptoms


On : 12.1.1 version, Approvals - Req, PO

When attempting to respond to a request for further information the following error occurs.

ORA-01403: no data found ORA-06512: at "APPS.WF_NOTIFICATION", Line 7133 ORA-06512 no data found


STEPS
-----------------------
1. Raise a purchase requisition and submit it for approval
2. Approver requests further information by clicking 'Request Information' link
3. Preparer receives a notification and when opening it the above mentioned error is received

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