Work Request Approval Notification Not Getting Additional Information Requested (Doc ID 1467123.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 07-AUG-2015***

Symptoms

Actual behavior:
After the Approver of Work Request requests Additional Information, Originator enters the additional Information, but is not getting reflected in the Work Request Notification.
After Patch Patch 13466741:
1. Department Approver after clicking on Additional Information/Reject Button in Work Request Approval Notification, the Work Request Requester is not getting any Notification.
2. After Creating Work request and click on Apply following java exception error occurs:
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'UPDATE_WORK_REQUEST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.eam.workrequest.webui.WorkRequestDetailCO.processFormRequest(WorkRequestDetailCO.java:1350)
--------------------------------------------------------------------------------------------------------------------
## Detail 0 ##
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'UPDATE_WORK_REQUEST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

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