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 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 lessHow can I cancel user Concurrent Requests in EBS R12 ?
Hi, TO Cancel user requests ------------------------ Check for the user Id for the requests to be canceled. SELECT DISTINCT fu.user_id, fu.user_name, fu.employee_id, fu.start_date, fu.end_date, fu.creation_date, fu1.user_name AS "User Created By" FROM fnd_user fu, fnd_user fu1 WHERE fu.end_date IS NRead more
Hi,
TO Cancel user requests ————————
SELECT * FROM fnd_concurrent_requests WHERE phase_code IN ('R') AND requested_by = 2111 ORDER BY last_update_date DESCSTATUS_CODE Column: A Waiting B Resuming C Normal D Cancelled E Error F Scheduled G Warning H On Hold I Normal M No Manager Q Standby R Normal S Suspended T Terminating U Disabled W Paused X Terminated Z Waiting
Regards
Mahmoud Morsy.
See lessWhat is the command to compile form and PL/sql Library manual?
Hi , To compile the form manually, do the following. frmcmp_batchmodule=/prod/apps/oraapp/apps_st/appl/au/12.0.0/forms/US/********.fmb userid=APPS/***** output_file=/prod/apps/oraapp/apps_st/appl/ap/12.0.0/forms/US/********.fmx module_type=form batch=yes compile_all=special To compile the pl sql libRead more
Hi , To compile the form manually, do the following.
To compile the pl sql library
Mahmoud Morsy
See lessCan you provide me query to get specific report in EBS R12?
Hello Mina, you can use the below query. [code] SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME, ROUND ( ( (SYSDATE - a.actual_start_date) * 24 * 60 * 60 / 60), 2) AS Process_time, a.request_id, a.parent_request_id, a.request_date, a.actual_start_date, a.actual_completion_date, (a.actual_completion_dRead more
Hello Mina,
you can use the below query.
[code]
SELECT DISTINCT
c.USER_CONCURRENT_PROGRAM_NAME,
ROUND ( ( (SYSDATE – a.actual_start_date) * 24 * 60 * 60 / 60), 2)
AS Process_time,
a.request_id,
a.parent_request_id,
a.request_date,
a.actual_start_date,
a.actual_completion_date,
(a.actual_completion_date – a.request_date) * 24 * 60 * 60
AS end_to_end,
(a.actual_start_date – a.request_date) * 24 * 60 * 60 AS lag_time,
d.user_name,
a.phase_code,
a.status_code,
a.argument_text,
a.priority
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_programs b,
apps.FND_CONCURRENT_PROGRAMS_TL c,
apps.fnd_user d
WHERE a.concurrent_program_id = b.concurrent_program_id
AND b.concurrent_program_id = c.concurrent_program_id
AND a.requested_by = d.user_id
AND status_code = ‘C’
AND c.USER_CONCURRENT_PROGRAM_NAME =
‘*************Name Of Report**********’
ORDER BY Process_time DESC;
[/code]
Thanks ,
Mahmoud Morsy
See lessError with concurrent managers ‘ actual value of the manager is 0’
Hello , you can follow the below steps: 1. Stop all Application services including the concurrent managers. Please make sure that no FNDLIBR, FNDSM, or any dead process is running. 2. Stop the database. 3. Start the database. 4. Go to cd $FND_TOP/bin $ adrelink.sh force=y link_debug=y "fnd FNDLIBR"Read more
Hello ,
you can follow the below steps:
1. Stop all Application services including the concurrent managers.
Please make sure that no FNDLIBR, FNDSM, or any dead process is running.
2. Stop the database.
3. Start the database.
4. Go to cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y “fnd FNDLIBR”
$ adrelink.sh force=y link_debug=y “fnd FNDFS”
$ adrelink.sh force=y link_debug=y “fnd FNDCRM”
$ adrelink.sh force=y link_debug=y “fnd FNDSM”
5. Run the CMCLEAN.SQL then Commit 6.Start All Application services
thanks ,
Mahmoud Morsy
See less