My Oracle Support Banner

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

Last updated on SEPTEMBER 28, 2023

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.