Tuesday, October 4, 2011

Recreate/Validate WF AQ (The scripts lists the queues they create and its details). Please try using ADADMIN to compile the APPS Schema before trying any of the 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:
Recreate/Validate WF AQ (The scripts lists the queues they create and its details). Please try using ADADMIN to compile the APPS Schema before trying any of the scripts.


Solution:



Recreate/Validate WF AQ (The scripts lists the queues they create and its details). Please try using ADADMIN to compile the APPS Schema before trying any of the scripts.

 sqlplus APPSusr/APPSpwd @wfquec2.sql APPSusr FNDusr FNDpwd

Example Syntax:
sqlplus apps/apps @$FND_TOP/patch/115/sql/wfquec2.sql apps applsys apps
 sqlplus APPSusr/APPSpwd @wfjmsqc.sql FNDusr FNDpwd

Example Syntax:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfjmsqc.sql applsys apps

OR

sqlplus APPSusr/APPSpwd @wfjmsqc2.sql FNDusr FNDpwd
sqlplus apps/apps @$FND_TOP/patch/115/sql/wfjmsqc2.sql applsys apps
 sqlplus APPSusr/APPSpwd @wfevquec.sql FNDusr FNDpwd WF_DEFERRED APPSusr

Example Syntax:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfevquec.sql APPLSYS APPS WF_DEFERRED APPS
OR

sqlplus APPSusr/APPSpwd @wfevquc2 FNDusr FNDpwd qname APPSusr retry delay retention
sqlplus apps/apps @$FND_TOP/patch/115/sql/wfevquc2 APPLSYS APPS WF_DEFERRED APPS 5 3600 86400
 sqlplus APPSusr/APPSpwd @wfmqsubc.sql FNDusr FNDpwd

Example Syntax:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfmqsubc.sql applsys apps
 sqlplus APPSusr/APPSpwd @afwfqgnt.sql APPSusr APPSpwd FNDusr FNDpwd

Example Syntax:

sqlplus apps/apps @FND_TOP/patch/115/sql/afwfqgnt.sql apps apps applsys apps


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

No comments: