Thursday, October 13, 2011

Missing responsibilities after 'affurgol.sql FORCE'

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: Missing responsibilities after 'affurgol.sql FORCE'


Symptoms:
Being in "11i.AD.I.6" patch level with "11.5.10.2" release , on following below steps mentioned in Metalink Note # 335487.1 & 316959.1; {I ran with 'affurgol.sql FORCE'.}we lost all the responsibilities that came as part of production cloning. Now when we login to HTML page, it doesn't show any responsibilities.
Log files:



Solution:




1. Install the Patch mentioned in Metalink Note #433473.1 that fixes the cache issue, otherwise ...you need to clear cache and bounce Apache very often
2. Run Workflow Directory Services User/Role Validation concurrent request only once with the parameters as "1000,yes,yes,no"
3. Rebuild the WF_deferred and java_deferred queues
4. disable AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments subscription


References:

Reference bug : 7410672 => HOW TO UNDOO RUN OF: AFFURGOL.SQL FORCE
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: