Troubleshoot Workflow Errors
q Error: - ORA-20002: 3207: User 'SYSADMIN' does not have access to
notification 1621941. ORA-06512: at "APPS.WF_ADVANCED_WORKLIST", line
82 ORA-06512: at line 1
There
are two methods to resolve this perticular issue.
First
Method:
1. Login to E-Business as the user who will modify the Workflow
System Administrator and navigate as follows:
Workflow Administrator Web Applications >
Administration
Then select either the SYSADMIN user or
the Workflow Administrator Web Applications responsibility as the Workflow
System Administrator.
Please
Note: We can get the responsibility/role from backend by issuing the below sql
statement WF_ADMIN_ROLE.
select
text from wf_resources where name='WF_ADMIN_ROLE';
If
output of above query is not ‘SYSADMIN’ or ‘Workflow Administrator Web
Applications’ responsibility then we will get the issue. Therefore update the
table as per the requirement,as shown below.
update
wf_resources set text='*' where name='WF_ADMIN_ROLE';
commit:
2. Now send one more notification
and verify that that the issue has been
resolved.
Second
Method:
1.
Login to E-Business as the user who can modify the Workflow System
Administrator and navigate:
Workflow
Administrator Web Applications > Administration
Then select user or responsibility as the Workflow System
Administrator.
2. Change the Workflow Mailer Framework User
parameter from FND_USER.USER_ID = 0 to the USER_ID of the Workflow System
Administrator user or to a user that is assigned as Workflow System Administrator.
·
Obtain the FND_USER.USER_ID:
select
user_id, user_name from fnd_user where user_name=upper('');
·
Run $FND_TOP/sql/afsvcpup.sql to change
the Framework User parameter under
the Workflow Notification Mailer Component ID to the selected user_id.
·
Shutdown and restart the Workflow Mailer
Service.
3. Now send one more notification and verify that the issue
has been resolved.
q
Notification Mailer Fails to Send Email Notifications after
cloning.
After
cloning, mails are not floating through workflow mailer, even all agent
listener and notification mailer are up and running.
Some
times we may get the following error after cloning,we check mailer log file
FNDCPGSCXXXXX.txt at $APPLCSF/$APPLLOG.
Below
error was their in logs:-
'Problem obtaining the HTML content
oracle.apps.fnd.wf.common.HTTPClientException: Unable to invoke method
HTTPClient.HTTPConnection.Get caused by: java.net.ConnectException: Connection
refused'
Solution:-
Solution
is to purge the wf_notification_out outbound message queue and repopulates from
the WF_NOTIFICATION table.Please follow the below steps to fix the issue.
1.
Stop the Workflow mailer.
2. Purge the wf_notification_out queue and recreate it out
of the wf_notifications table by executing:
cd
$FND_TOP/patch/115/sql
sqlplus
APPS/ @wfntfqup.sql APPS APPLSYS
3.
Start the mailer
4. Verify the issue by re-submitting the
same workflow again.
No comments:
Post a Comment