Sign Up

Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here

You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here

Sorry, you do not have permission to add post.

Forgot Password?

Need An Account, Sign Up Here

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.

Oraask Logo Oraask Logo
Sign InSign Up

Oraask

  • Write
    • Add A New Post
    • Ask A Question

Oraask Navigation

Search
Ask A Question

Mobile menu

Close
  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials

Mmorsy

Juniormahmoudmorsymm1985@gmail.com
Ask Mmorsy
36 Visits
4 Followers
0 Questions
Home/ Mmorsy/Answers
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Polls
  • Asked Questions
  • Comments
  1. Asked: July 19, 2017In: PL/SQL

    “What is the difference between Views and Materialized Views in Oracle? “

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    Added an answer on July 25, 2017 at 11:44 am

    Hello Nall, The Materialized views are disk based and are updated periodically based upon the query definition. The Views are virtual only and run the query definition each time they are accessed. Regards, Mahmoud Morsy.

    Hello Nall,

    The Materialized views are disk based and are updated periodically based upon the query definition.
    The Views are virtual only and run the query definition each time they are accessed.

    Regards,

    Mahmoud Morsy.

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  2. Asked: July 19, 2017In: Oracle E-Business Suite

    How to enable Forms Runtime Diagnostic Trace?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    Added an answer on July 20, 2017 at 11:53 am

    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=<&gt;
    4. Get the FRD trace from $FORMS_TRACE_DIR path at OS Level

    Regards,

    Mahmoud Morsy,

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  3. Asked: July 19, 2017In: Oracle Applications DBA

    Error rman 06026 some targets not found aborting restore

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    Added an answer on July 20, 2017 at 11:49 am

    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 less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  4. Asked: July 19, 2017In: Oracle Applications DBA

    How to know Version Database $ Application?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    Added an answer on July 20, 2017 at 11:43 am

    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 less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  5. Asked: July 19, 2017In: Oracle Applications DBA

    How to get process ID By Concurrent request ID in EBS R12?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    Added an answer on July 20, 2017 at 11:39 am

    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 less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  6. Asked: July 19, 2017In: Oracle Applications DBA

    how to check your URL in EBS Suite ?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    Added an answer on July 20, 2017 at 11:33 am

    hi, run this query : [code] SELECT home_url FROM icx_parameters; [/code]

    hi,

    run this query :

    [code]
    SELECT home_url FROM icx_parameters;
    [/code]

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  7. Asked: July 19, 2017In: Oracle Applications DBA

    How to Stop & Start Weblogic server services in Linux ?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    Added an answer on July 20, 2017 at 11:25 am

    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.

    • 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>&1 &
      $ # or
      $ nohup /u01/app/oracle/config/domains/yourdomain/bin/startWebLogic.sh > /dev/null 2>&1 &
    • 3- $ # Stop WebLogic:
      $ /u01/app/oracle/config/domains/yourdomain/bin/stopWebLogic.sh
    • 4-  # Start Managed Server:
      $ nohup /u01/app/oracle/config/domains/yourdomain/bin/startManagedWebLogic.sh AdminServer > /dev/null 2>&1 &
    • 5- # Stop Managed Server:
      $ /u01/app/oracle/config/domains/yourdomain/bin/stopManagedWebLogic.sh AdminServer

    Regards,

    Mahmoud Morsy

    See less
      • 2
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  8. Asked: July 12, 2017In: Oracle Applications DBA

    How to Create a Read Only Schema in Oracle Application R12 ?

    Mmorsy
    Best Answer
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    Added an answer on July 20, 2017 at 8:09 am

    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
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  9. Asked: July 12, 2017In: Oracle Applications DBA

    How can I cancel user Concurrent Requests in EBS R12 ?

    Mmorsy
    Best Answer
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    Added an answer on July 16, 2017 at 10:57 am
    This answer was edited.

    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 ————————

    • 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 NULL AND fu.created_by = fu1.user_id(+) AND fu.created_by NOT IN (0, 1) ORDER BY 1;
    • Check for the running request for that user to be canceled.
    SELECT * FROM fnd_concurrent_requests WHERE phase_code IN ('R') AND requested_by = 2111 ORDER BY last_update_date DESC
    • Cancel the request of that particular user from the back end.
    UPDATE fnd_concurrent_requests SET phase_code = 'C', status_code = 'D' WHERE phase_code = 'R' AND requested_by = 2933; 

    COMMIT;

    STATUS_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

    • PHASE CODE column. C Completed I Inactive P Pending R Running

    Regards

    Mahmoud Morsy.

    See less
      • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  10. Asked: July 15, 2017In: Oracle E-Business Suite

    What is the command to compile form and PL/sql Library manual?

    Mmorsy
    Best Answer
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    Added an answer on July 16, 2017 at 6:44 am
    This answer was edited.

    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.

    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 library

    frmcmp_batch module=/prod/apps/oraapp/apps_st/appl/au/12.0.0/resource/********.pll userid=APPS/****output_file=/prod/apps/oraapp/apps_st/appl/au/12.0.0/resource/********.plx module_type=library batch=yes compile_all=special

    Mahmoud Morsy

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
1 2 3

Sidebar

Adv 250x250

Explore

  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials

Footer

Oraask

About

Oraask is a website for developers and software engineers who want to learn new skills, share their knowledge, and solve their coding problems. Oraask provides free content on various programming languages and topics, such as Oracle, Python, Java, etc. Oraask also allows users to ask questions and get answers from other members of the community.

About Us

  • About Us
  • Contact Us

Legal Stuff

  • Privacy Policy
  • Terms & Conditions

Follow

Oraask is licensed under CC BY-NC-SA 4.0Oraask CopyrightOraask CopyrightOraask CopyrightOraask Copyright

© 2019 Oraask. All Rights Reserved
With Love by Oraask.