Additional Java Mailer Scripts

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Additional Java Mailer Scripts


Solution:



Additional Scripts
 Work Flow Histograms Creation Script. This is for the Embedded version for Apps only. Performance improvements.

sqlplus apps/apps @wfhistc APPLSYS

 Create Index on WF Queue Tables

sqlplus apps/apps @wfqidxc APPLSYS APPS tablespace_name

Example Syntax:

sqlplus apps/apps @wfqidxc APPLSYS APPS USER_IDX

 Use to diagnose an individual notification once Java Mailer is starting:

sqlplus apps/apps @$FND_TOP/sql/wfmlrdbg.sql NID applsys
 Purges the wf_notification_out outbound message queue and repopulates from the WF_NOTIFICATION table:

sqlplus usr/passwd@db @wfntfqup APPSusr APPSpw FNDusr

Example Syntax:

sqlplus apps/apps@db @wfntfqup apps apps applsys

 This script will move the oracle.apps.wf.notificaiton.send messages from the WF_ERROR queue to the WF_DEFERRED queue for reprocessing. Substitute for Reset Failed in OWF G.

sqlplus usr/passwd@db @wfnequ APPSusr APPSpw FNDusr

Example Syntax:

sqlplus apps/apps@db @wfnequ apps apps applsys

 wfbkgbld.sql - Utility script to rebuild the background queue:

sqlplus wf_account/wf_account @wfbkgbld wf_schema

Example Syntax:

sqlplus apps/apps @wfbkgbld applsys


References:

Java Mailer and Other 11.5.9/OWF G Current Issues in Applications 11i [ID 260393.1]

Get Oracle Certifications for all Exams
Free Online Exams.com