My Oracle Support Banner

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


To view full details, 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 a vibrant support community of peers and Oracle experts.