Home/ Gomaa Elmokhtar/Followers Answers
  1. Asked: July 19, 2017In:

    how to check your URL in EBS Suite ?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

    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
  2. Asked: July 19, 2017In:

    How to Stop & Start Weblogic server services in Linux ?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

    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
  3. Asked: July 12, 2017In:

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

    Mmorsy
    Best Answer
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

    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
  4. Asked: July 12, 2017In:

    How can I cancel user Concurrent Requests in EBS R12 ?

    Mmorsy
    Best Answer
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    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
  5. Asked: July 15, 2017In:

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

    Mmorsy
    Best Answer
    Mmorsy Junior mahmoudmorsymm1985@gmail.com
    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
  6. Asked: July 12, 2017In:

    Can you provide me query to get specific report in EBS R12?

    Mmorsy
    Best Answer
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

    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 less
  7. Asked: July 14, 2017In:

    Error with concurrent managers ‘ actual value of the manager is 0’

    Mmorsy
    Best Answer
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

    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
  8. Asked: July 14, 2017In:

    How to restart the failed installation in EBS R12?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

    Hi , Try using the below steps: 1- Run this command ./rapidwiz -restart 2- it will open the install screen and will have the saved configuration file. The saved configuration file can be found at 2 places. *) /tmp/usr/conf_SID.txt *) $ORACLE_HOME/appsutil/conf_SID.txt 3- choose the right saved confiRead more

    Hi ,

    Try using the below steps:

    1- Run this command ./rapidwiz -restart
    2- it will open the install screen and will have the saved configuration file. The saved configuration file can be found at 2 places.
    *) /tmp/usr/conf_SID.txt
    *) $ORACLE_HOME/appsutil/conf_SID.txt
    3- choose the right saved configuration file, the installer will start from the same point where it got failed.

    See less
  9. Asked: June 19, 2016In:

    ORA-29280: utl_file.fopen invalid directory path with directory

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant

    utl_file.fopen takes the name of a directory, not the path. For example: (you may need to login as SYS to execute these) [code]Windows: CREATE DIRECTORY CUST_DIR AS 'C:'; Linux CREATE DIRECTORY CUST_DIR AS '/usr/tmp'; GRANT READ ON DIRECTORY CUST_DIR TO SCOTT;[/code] Then, you can refer to it in theRead more

    utl_file.fopen takes the name of a directory, not the path. For example:

    (you may need to login as SYS to execute these)

    [code]Windows:
    CREATE DIRECTORY CUST_DIR AS ‘C:’;

    Linux
    CREATE DIRECTORY CUST_DIR AS ‘/usr/tmp’;

    GRANT READ ON DIRECTORY CUST_DIR TO SCOTT;[/code]

    Then, you can refer to it in the call to fopen:

    [code]
    UTL_FILE.FOPEN(‘CUST_DIR’, ‘oraask_test.txt’, ‘W’);
    [/code]

     

    hope this help.

    See less
  10. Asked: June 18, 2016In:

    Error: PLS-00103: Encountered the symbol when trying to compile

    Hassan AbdElrahman
    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant

    You need to change ELSEIF to ELSIF . your code would be like this : [code]declare CURSOR abc IS select * from all_Objects; begin for rec in abc loop if rec.object_id is null then null; elsif rec.owner is null then null; end if; end loop; end;[/code]

    You need to change ELSEIF to ELSIF .

    your code would be like this :

    [code]declare
    CURSOR abc IS select * from all_Objects;
    begin
    for rec in abc
    loop
    if rec.object_id is null then
    null;
    elsif rec.owner is null then
    null;
    end if;
    end loop;
    end;[/code]

    See less