Error at POR_UTL_PKG.delete_requisition_internal When Using Edit Requisition Link in Notification

(Doc ID 881790.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Purchasing - Version 12.0.6 and later
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 14-Oct-2013***

Symptoms

When the approver access the requisition approval notification and click on the "Edit Requisition" link this error occurs:

ERROR
You have encountered un expected error.
Click here for exception details

Log displays these errors:

oracle.apps.fnd.framework.OAException: java.sql.SQLException:
ORA-20000: Exception at
POR_UTL_PKG.delete_requisition_internal(p_header_id:2386) 000
SQLERRM:ORA-01403: no data found
ORA-06512: at "APPS.POR_UTIL_PKG", line 186
ORA-06512: at line 1 at
oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:980)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)Approvers loggin gin
to worklist occasionally get JBO-27122 error

Steps To Reproduce:
1. Login as approver
2. Go to worklist or notification summary form
3. Access requisition notification
4. Click Edit Requisition link

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