Pages

Search This Blog

Thursday, February 4, 2010

User gets error while trying to approve the change request WF notification

Issue: User gets following error while approving the change request WF notification,
Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.WF_NOTIFICATION", line 5361 ORA-06512: at line 5

Facts: Oracle apps 11.5.9

Symptom: 1> User gets above error notification in the screen when taking action (when approve button is clicked) on the WF notification
2> After clicking the requisition no longer in the queue.

Facts: 1> It is a PO change request WF approval notification.
2> Requisition has undergone lots of changes. PO Action history has 65+ records for this requisition.
4> Although the error is displayed while approving the notificaiton, but all the updates in the requisition and the PO happens successfully.
PO_REQUISITION_HEADERS_ALL, PO_CHANGE_REQUESTS, PO_HEADERS, PO_LINES_ALL, PO_DISTRIBUTIONS_ALL tables get updated successfully.

Reason: Looks like this is a known Oracle bug. Similar issue can be found in Oracle metalink note id# 579729.1
The WF notification goes into error if the message has more than 32K characters in it.

Steps to Reproduce:
Use this requisition in non prod instance> create a change request and submit for approval>Login as the approver and try to approve it
> When approve button is clicked the above error is displayed in the screen.

Impact: User can ignore this message as this is displayed due to the above Oracle bug.
All the updates happen successfully. PO is updated with the change request detail successfully.

Suggested fix: Open an Oracle TAR to get a fix from Oracle.

No comments:

Post a Comment

Followers

Contributors