Oracle E-Business Suite
Oracle E-Business Suite
Share
Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
How to query Gather schema statistic For Last week For Apps schema in EBS R12?
Hi, Try the below Query: [code] SELECT * FROM apps.fnd_concurrent_programs_vl p, apps.fnd_concurrent_requests r WHERE r.concurrent_program_id = p.concurrent_program_id AND r.program_application_id = p.application_id AND p.user_concurrent_program_name IN ('OnDemand Gather Schema Statistics', 'GatherRead more
Hi,
Try the below Query:
[code]
SELECT *
FROM apps.fnd_concurrent_programs_vl p, apps.fnd_concurrent_requests r
WHERE r.concurrent_program_id = p.concurrent_program_id
AND r.program_application_id = p.application_id
AND p.user_concurrent_program_name IN (‘OnDemand Gather Schema Statistics’,
‘Gather Schema Statistics’,
‘Gather Schema Statistics (IT_ANALYZE)’)
AND ( r.phase_code = ‘C’
AND r.status_code = ‘C’
AND r.actual_start_date >= sysdate)
[/code]
Regards,
Mahmoud Morsy.
See lessIssue : R12 apps – Application font, colour, feel and looks different .
Hi Vipul , The solution : Remove the files from the following directories $ rm -rf $OA_HTML/cabo/images/cache/* $ rm -rf $OA_HTML/cabo/styles/cache/* Run : perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile -p6 -log /tmp/ojspCompile.log --flush Remove the cache from browser and retry theRead more
Hi Vipul ,
The solution :
$ rm -rf $OA_HTML/cabo/images/cache/*
$ rm -rf $OA_HTML/cabo/styles/cache/*
Regards,
Mahmoud Morsy.
See lesshow to change all users password in EBS R12?
Hi Jihad, Stop Application services then * Connect as APPS user and run the SQL commands: $ sqlplus apps/apps [code] SQL>set head off SQL> set newpage none SQL> set pagesize 9999 SQL> spool changepassword.sh SQL> select 'FNDCPASS apps/apps 0 Y system/manager USER '||user_name||' '||'tRead more
Hi Jihad,
[code]
SQL>set head off
SQL> set newpage none
SQL> set pagesize 9999
SQL> spool changepassword.sh
SQL> select ‘FNDCPASS apps/apps 0 Y system/manager USER ‘||user_name||’ ‘||’tech@321’ from fnd_user ;
SQL> spool off
[/code]
Regards,
Mahmoud Morsy.
See lessHow to enable Forms Runtime Diagnostic Trace?
Hello Arika, Solution: 1. Go to SYSADMIN > System Administrator > Profile > System check profile option for "ICX Forms Launcher" and Make sure Site and User leave has been checked. 2. Set the value following values at user level only according to the version 3. For R12, http://url:/OA_HTML/Read more
Hello Arika,
Solution:
1. Go to SYSADMIN >
System Administrator >
Profile >
System
check profile option for “ICX Forms Launcher” and Make sure Site and User leave has been
checked.
2. Set the value following values at user level only according to the version
3. For R12, http://url:/OA_HTML/frmservlet?record=collect
For 11i, http://url:/dev60cgi/f60cgi?&record=collect&log=<>
4. Get the FRD trace from $FORMS_TRACE_DIR path at OS Level
Regards,
Mahmoud Morsy,
See lessError rman 06026 some targets not found aborting restore
Hi, Solution : try with the below command in RMAN Prompt catalog start with '/u03/oracle/hotbackup/DATE/' ; restore database ; Regards, Mahmoud Morsy.
Hi,
Solution :
try with the below command in RMAN Prompt
catalog start with ‘/u03/oracle/hotbackup/DATE/’ ;
restore database ;
Regards,
Mahmoud Morsy.
See lessHow to know Version Database $ Application?
Hi , The below query will help you. FOR DB: [code] SELECT * FROM PRODUCT_COMPONENT_VERSION; [/code] FOR Apps: [code] SELECT release_name FROM apps.fnd_product_groups; [/code] Regards, Mahmoud Morsy
Hi ,
The below query will help you.
FOR DB:
[code]
SELECT * FROM PRODUCT_COMPONENT_VERSION;
[/code]
FOR Apps:
[code]
SELECT release_name FROM apps.fnd_product_groups;
[/code]
Regards,
Mahmoud Morsy
See lessHow to get process ID By Concurrent request ID in EBS R12?
Hi Check this query. [code] SELECT request_id, TO_CHAR (ACTUAL_START_DATE, 'DDMMYYYY HH24:MI:SS'), TO_CHAR (ACTUAL_COMPLETION_DATE, 'DDMMYYYY HH24:MI:SS'), phase_code, status_code, os_process_id, oracle_process_id FROM apps.fnd_concurrent_requests WHERE request_id = &req_id [/code] Regards, MahmRead more
Hi
Check this query.
[code]
SELECT request_id,
TO_CHAR (ACTUAL_START_DATE, ‘DDMMYYYY
HH24:MI:SS’),
TO_CHAR (ACTUAL_COMPLETION_DATE, ‘DDMMYYYY
HH24:MI:SS’),
phase_code,
status_code,
os_process_id,
oracle_process_id
FROM apps.fnd_concurrent_requests
WHERE request_id = &req_id
[/code]
Regards,
Mahmoud Morsy.
See lesshow to check your URL in EBS Suite ?
hi, run this query : [code] SELECT home_url FROM icx_parameters; [/code]
hi,
run this query :
[code]
See lessSELECT home_url FROM icx_parameters;
[/code]
How to Stop & Start Weblogic server services in Linux ?
Hello Ahmed, You can Run the below scripts to Start and Stop Weblogic Server. 1- $ # Start NodeManager: $ nohup $WLS_HOME/server/bin/startNodeManager.sh > /dev/null 2>&1 & 2- $ # Start WebLogic: $ nohup /u01/app/oracle/config/domains/yourdomain/startWebLogic.sh > /dev/null 2>Read more
Hello Ahmed,
You can Run the below scripts to Start and Stop Weblogic Server.
$ nohup $WLS_HOME/server/bin/startNodeManager.sh > /dev/null 2>&1 &
2- $ # Start WebLogic:
$ nohup /u01/app/oracle/config/domains/yourdomain/startWebLogic.sh > /dev/null 2>&1 &
$ # or
$ nohup /u01/app/oracle/config/domains/yourdomain/bin/startWebLogic.sh > /dev/null 2>&1 &
$ /u01/app/oracle/config/domains/yourdomain/bin/stopWebLogic.sh
$ nohup /u01/app/oracle/config/domains/yourdomain/bin/startManagedWebLogic.sh AdminServer > /dev/null 2>&1 &
$ /u01/app/oracle/config/domains/yourdomain/bin/stopManagedWebLogic.sh AdminServer
Regards,
Mahmoud Morsy
See lessHow to Create a Read Only Schema in Oracle Application R12 ?
Hello Mina, you can follow the below Steps: Method :1 [code] SQL> CREATE USER APPSREAD IDENTIFIED BY APPSREAD; User created. SQL> GRANT CONNECT, RESOURCE,CREATE SYNONYM TO APPSREAD; Grant succeeded. [/code] Generate a Script for creating database objects of Application User ‘APPS’. [code] setRead more
Hello Mina,
you can follow the below Steps:
Method :1
[code]
SQL> CREATE USER APPSREAD IDENTIFIED BY APPSREAD;
User created.
SQL> GRANT CONNECT, RESOURCE,CREATE SYNONYM TO APPSREAD;
Grant succeeded.
[/code]
Generate a Script for creating database objects of Application User ‘APPS’.
[code]
set echo off set
pagesize 0
set linesize 300
spool cr8synonyms.sql
select ‘create synonym ‘ || OBJECT_NAME || ‘ for ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘;’ from all_objects where OWNER in (‘APPS’) and
OBJECT_NAME not like ‘%/%’ and OBJECT_TYPE in (‘TABLE’,’VIEW’,’SYNONYM’);
spool off
[/code]
Generate a script for selecting database objects of Application User ‘APPS’.
[code]
spool GrantSelect.sql
select ‘grant select on ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘ to APPSREAD;’ from all_objects where OWNER not in (‘SYS’,’SYSTEM’) and OBJECT_NAME not like ‘%/%’ and OBJECT_TYPE in (‘TABLE’,’VIEW’,’SYNONYM’);
spool off
[/code]
Connect to sqlplus as sysdaba and execute the following script
[code]
SQL> @GrantSelect.sql
SQL> @cr8synonyms.sql
[/code]
Connect to Read only schema User and check the objects.
[code]
SQL> conn APPSREAD/APPSREAD Connected.
SQL> select count(*) from tab;
COUNT(*) ———- 15515
[/code]
Regards.
See less