Home/ isouravghosh/Followers Answers
  1. Asked: July 27, 2017In:

    Issue : R12 apps – Application font, colour, feel and looks different .

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

    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 :

    • 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 the Application URL.

    Regards,

    Mahmoud Morsy.

    See less
  2. Asked: July 19, 2017In:

    how to change all users password in EBS R12?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

    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,

    • 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||’ ‘||’tech@321’ from fnd_user ;
    SQL> spool off

    [/code]

    • Then run script changepassword.sh
    • Start Application services.

    Regards,

    Mahmoud Morsy.

    See less
  3. Asked: July 19, 2017In:

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

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

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

    How to enable Forms Runtime Diagnostic Trace?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

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

    Error rman 06026 some targets not found aborting restore

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

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

    How to know Version Database $ Application?

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

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

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

    Mmorsy
    Mmorsy Junior mahmoudmorsymm1985@gmail.com

    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
  8. 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
  9. 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
  10. 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