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***


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

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
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod( 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


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