The script given below identifies which manager is going to execute a given Concurrent program: SELECT user_concurrent_program_name, user_concurrent_queue_name FROM apps.fnd_concurrent_programs_tl fcp, apps.fnd_concurrent_queue_content fcqc, apps.fnd_concurrent_queues_tl cq WHERE fcqc.type_application_id(+) = fcp.application_id AND…
Read More# To identify the long running concurrent requests for more than 1 hour Mailid=<List of Mail ids> <Set the Environment> sqlplus -s ‘apps/<apps password><<EOF >> /usr/tmp/logli1.log spool /usr/tmp/longrunco.log set line…
Read More1) Check java version after completion of glassfish installation . /java -version 2) Go to location /oracle/glassfishv3/jdk/bin and Run ./java -jar /oracle/apex/apex.war, (where /oracle/apex/ is the location of apex listener…
Read More1. Download the Glassfish http://www.oracle.com/technetwork/java/javaee/downloads/java-ee-sdk-6u3-jdk-6u26-downloads-439816.html Example File name : java_ee_sdk-6u1-jdk-solaris-sparc.sh 2. Download the Apex listener : apex_listener.1.1.2 http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html 3) Reset the password for APEX_040000 and apex_public_user i. Unlock the Apex…
Read MorePre Installation Tasks: 1. Create Tablespace for Apex Data and Files.SQL> create tablespace apex datafile ‘//apexd01.dbf’ size 500m;Tablespace created. 2. Ensure Shared pool size is atleast 100m (suggested 250m) 3.…
Read MoreGeneric Tips 1) Sleep Seconds – is the number of seconds your Concurrent manager waits between checking the list of pending concurrent requests (concurrent requests waiting to be started). Tip:…
Read MoreHow to Start tuning: Server Level (Focus from Oracle Database) Whenever there is server level issue, The tuning starts from the server .. Just remember the phrase “The person who…
Read More— This is to list the Apps User who are assigned a particular responsibility select a.user_name,b.responsibility_name from fnd_user a,fnd_responsibility_vl b ,FND_USER_RESP_GROUPS c where a.user_id = c.user_id and c.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID…
Read MorePurpose ——- This script helps in identifying the list of responsibilities that can run a given concurrent request REM Save this file as whocanrun.sql REM Usage: sqlplus apps/apps @whocanrun REM…
Read More