Core Workflow - EBS (MOSC)

MOSC Banner

APINV workflow notification intermittent error

edited Jan 30, 2012 11:51PM in Core Workflow - EBS (MOSC) 5 commentsAnswered
Hi,

When a user click on notification in worklist than error is coming intermittently. Error is not coming always but it is coming like 4 times in day.

Please suggest if anybody faced this type of problem.

Workflow : APINV

Error:

APINV_NAR                                     #MAIL           WF_ERROR                                                                               
[WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML. Caused by: 2020: Error when                 
 getting notification content. Caused by: ORA-06502: PL/SQL: numeric or value error: character string buffer too small                               
                                                                                                                                                     
Wf_Notification.NTF_Table(6, H)                                                                                                                      
Wf_Notification.GetComments2(62481185, text/html)                                                                                                    
Wf_Notification.runFuncOnBody(62481185, text/html)                                                                                                   
Wf_Notification.GetBody(62481185, text/html)                                                                                                         
WF_NOTIFICATION.GetFullBody(nid => 62481185, disptype => text/html)                                                                                  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center