Configure Shared Appl Top in EBS R12 - Step by Step

Hi All ...

Here the step by step of configure Shared Appl Top  in EBS R12:

1.   Run adpreclone procedure in DB and APPL (on Main server):

·         On DB Tier:

        cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

        perl adpreclone.pl dbTier

·         On APPL Tier:

         cd $INST_TOP/admin/scripts

         perl adpreclone.pl appsTier

2.   Stop APPL_TIER (on Main server)

3.   Add the F5 ip hosname.domain hostname to /etc/hosts on all servers.

4.   Connect the mount of the application tier to second appl server. 

5.   Add node (run the commands on second applserver ).

    cd $COMMON_TOP/clone/bin; (take a path from main appl node)

    perl adclonectx.pl addnode contextfile=<echo $CONTEXT_FILE from main node>

    *All servers need to be enabled

    perl <echo $AD_TOP/bin from main node >/adconfig.pl contextfile=<specify the path to the      new context file from previous step>

   Edit .bash_profile to point to new env files.

6.   Run AutoConfig in both nodes (main node need to be run as the last one).

7.   Edit Context file for 2 nodes

s_applcsf	Same on all nodes
s_fndreviverpiddir	Same on all nodes
APPLDCP	ON
s_appltmp	Same on all nodes
s_temp	Same on all nodes
s_custom_file	Same is in main node
s_webentryhost	F5 host
s_login_page	F5 host
s_external_url	F5 host

8.   Run AutoConfig in both nodes (main node need to be run as the last one).

9.   Start APPL tier in both nodes (main and after that secondary).

10. Enable Internal Monitor Managers for both nodes:

Go to Concurrent manager > Define > Look for Internal Monitor% > Work Shiftes

 Work Shift:Standard
  Processes: 1 > Save

 Do the same for the second one

Activate both managers.

Query which user session is on which application servers:

 select nodes.node_name,usr.user_name,usr.user_id,ses.function_type

from icx_sessions ses,

     fnd_nodes nodes,

     fnd_user usr

where ses.node_id=nodes.node_id

and ses.guest='N'

and ses.user_id=usr.user_id

order by usr.user_id,nodes.node_name

You are done.

Good luck ...

Useful documents:

Sharing The Application Tier File System in Oracle E-Business Suite Release 12 (Doc ID 384248.1)

Using Load-Balancers with Oracle E-Business Suite Release 12 (Doc ID 380489.1).

How to download Oracle Software from Edelivery or Oracle Metalink by script

Hi All ...

Here the step by step guide how to download Oracle software with script.
Many of you already tried to do it from Oracle Edelivery site and know that you need to download one by one and it can take a lot of time. Also there are some scripts that can do it for you , but need to install some plug-ins to google chrome or Mozilla to collect the cookies.

This is the guide that I got from Oracle Support (thanks guys) and hope will make you life a little bit easy.

1. Log-in to http://support.oracle.com 
2. Go to Certifications tab

3. Choose the software,release and platform that  you want to download  and press Search
In my I want to download EBS 12.2.4 installation release for Oracle Linux 5

4. Click on Version on  Number of Releases / Versions column

 5. Choose the release. At this time you can re-choose another release

 6. Select the Product and press Download

 7. Accept the Agreement and press Next

8. Now you will get the all zips that you can download. You can download it one by one or just press on WGET options 

 9. Press on Download.sh to get the scripts and save it. Please pay attention, the script will work only for 8 hours after the creation

10. That's it. Just enter you oracle account password and you can start downloading.

TIP: the release can include alot of file that you will not use, so just remove or remark the WGET line form the script (for example all NLS packages) 

Good Luck ...

FNDCPPUR - Purge Concurrent Request and/or Manager Data - run forever

Hi All ...

This is the issue that found after upgrade 11i instance with Base Line.
The Purge Concurrent Request and/or Manager Data run forever.

Here the action plan:
1. Stop the concurrent manager.
2. Connect to sqlplus as APPS user : 

SQL> truncate table APPLSYS.FND_CONCURRENT_PROCESSES;
SQL> truncate table APPLSYS.FND_ENV_CONTEXT;

3. cd $FND_TOP/bin              
adrelink.sh force=y link_debug=y "fnd FNDCPPUR"

4. Start the concurrent manager.
5. Retest the issue after running the concurrent program "Purge Concurrent Request and/or Manager Data".

Good Luck ...

R12 Purchase Order Preference Form Errors With "APP-PO-14142: get_po_parameters-10: ORA-01422: exact fetch rows more than requested number of rows"

Hi All ...

I Have got the following error in my R12 upgraded instance:
APP-PO-14142: get_po_parameters-10: ORA-01422: exact fetch rows more than requested number of rows

SELECT count(*) FROM po_document_types;

Right now the select show : 378 rows

Action Plan:

1. Connect /as sysdba

2. Revoke EXEMPT ACCESS POLICY from APPS;

3. Re-connect with APPS user and rerun SELECT count(*) FROM po_document_types;

4. Your issue would be resolved if this returns zero records.

5. Re-check the issue.

Good luck ...

Adcfgclone on DB tier fail with ouicli.pl

Hi All ... 

Here the issue that I have found during the clone DB tier:

AutoConfig could not successfully execute the following scripts:

    Directory: /clone/oracle/product/11.2.0/perl/bin/perl -I /clone/oracle/product/11.2.0/perl/lib/5.8.3 -I /clone/oracle/product/11.2.0/perl/lib/site_perl/5.8.3 -I /clone/oracle/product/11.2.0/appsutil/perl /clone/oracle/product/11.2.0/appsutil/clone

      ouicli.pl               INSTE8_APPLY       255

AutoConfig is exiting with status 1

RC-50013: Fatal: Instantiate driver did not complete successfully.

Action Plan:

1.  Change the DB CONTEXT_FILE PERL5LIB  parameter from 5.8.3 to 5.10.0 

2.  Change the $ORACLE_HOME/appsutil/template/adxdbctx.tmp as well as env file.

3. Run autoconfig on DB node

4. Run adpreclone procedure on DB tier

5. Copy the data to clone instance and rerun adcfgclone.

Good Luck ...

Script to compile APPS schema without running adadmin

Hi All ...

Here the  Script to compile APPS schema without running adadmin.

As the appl user in linux, define both env vars :

export APPS_PASS=xxxx

export  SYSTEM_PASS=xxxx

Then Run:

#R12

sqlplus -s APPS/$APPS_PASS @$AD_TOP/sql/adutlrcmp.sql APPLSYS $APPS_PASS APPS $APPS_PASS $SYSTEM_PASS 0 0 NONE FALSE

#11i

sqlplus -s APPS/$APPS_PASS @$AD_TOP/admin/sql/adutlrcmp.pls APPLSYS $APPS_PASS APPS $APPS_PASS $SYSTEM_PASS 0 0 NONE FALSE

Good Luck ...

R12 Restart Apache + Clear Cache Concurrent

Hi All,

Here the step by step guide for creating Concurrent to Restart Apache + Clear Cache in R12 EBS instance.
Hope that it will save your time during upgrade cycles and users tests.

Here we go....

1. Login to EBS with System Administrator responsibility.
2. Go to Concurrent --> Program --> Executable.

Executable : XX_RESTART_APACHE
Short Name : XX_RESTART_APACHE
Application : Your XX Custom Application
Description : Restart Apache
Execution Method : Host
Execution File Name : Restart_Apache

3. Save your changes.
4. Go to Concurrent --> Program --> Define

Program : XX Restart Apache

Short Name : XX_RESTART_APACHE

Application : Your XX Custom Application
Description : Restart Apache
In Executable Section:
Name : XX_RESTART_APACHE
Method : Host
5. Save your changes.
6. Create Restart_Apache.prog under your CUSTOM_TOP/bin directory:

########################################################
#!/bin/ksh

ORIG_CONC_OUTPUT_FILE=$1
COPIES=$2
TITLE=$3

REQUEST_ID=`echo $TITLE | awk -F"." '{ print $NF }'`


LOG_DIR=$APPLCSF/$APPLLOG
OUT_DIR=$APPLCSF/$APPLOUT
LOG_FILE=l${REQUEST_ID}.req
OUT_FILE=o${REQUEST_ID}.out
USER_LOG_FILE=$LOG_DIR/$LOG_FILE # this is the log file that the user see

echo log file is $LOG_DIR
echo out file is $OUT_DIR
echo user log file is $USER_LOG_FILE

$ADMIN_SCRIPTS_HOME/adoacorectl.sh stop 2>&1  $LOG_FILE
sleep 5
$ADMIN_SCRIPTS_HOME/adoacorectl.sh status 2>&1 $LOG_FILE
sleep 5
echo "Before clear cash"
rm -Rf $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/persistence/* >> $LOG_FILE
echo "After clear cash"
$ADMIN_SCRIPTS_HOME/adoacorectl.sh start 2>&1 $LOG_FILE
sleep 5
$ADMIN_SCRIPTS_HOME/adoacorectl.sh status 2>&1 $LOG_FILE
########################################################

7. chmod +x <YOUR CUTOM_TOP>/bin/Restart_apache.prog
8. Create soft link 
ln -s $FND_TOP/bin/fndcpesr <YOUR CUTOM_TOP>/bin/Restart_apache

9. Add you concurrent to request group under the System Administrator.

That's all...
Good Luck ... 

The Upgrade Assistant failed in bringing up the database .

Hi All

Got this error during the upgrading the database to 11.2.0.4 (DBUA step 2-3) :
The Upgrade Assistant failed in bringing up the database ....

Here the action for fix the issue.

1. Remove all  spfile from Old ORACLE HOME/dbs (copy them or change there names).

2. Remove all from $ORACLE_BASE/cfgtoollogs/dbua

*** ORACLE_BASE - base directory given by you during software installation

3. Re-run the DBUA: cd $ORACLE_HOME/bin; ./dbua

Good Luck ...

How to update patch adwork process manually

Hi All,

Here the way to update patch adwork process manually when the process is stuck during the patch apply:

1. Update the worker status :
UPDATE applsys.fnd_install_processes
SET status = 'F'   --- F = Failed
WHERE worker_id = 1 --- Number of stuck adworker process

2. Find the SID and the SERIAL# of stuck adworker process
select sid,serial#  from v$session where sid=xxx;

3. Kill the session
alter system kill session 'xxx,yyy';

Useful documentation:
Inadvertently Closing a Session of Adpatch Causes 'Unable to find job ' Error (Doc ID 257505.1)

Good Luck ....

APEX installation on Linux - Step by Step

Hi All,

Here the step by step for APEX installation on Linux.

You can download the latest Apex version from:
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

1. Copy the apex_4.2.2_en.zip to $ORACLE_HOME: 
cp apex_4.2.2_en.zip $ORACLE_HOME

2. Extract apex_4.2.2_en.zip : 
cd $ORACLE_HOME; unzip apex_4.2.2_en.zip;cd $ORACLE_HOME/apex

3. Create a new tablespace for Apex objects:

create TABLESPACE APEX 
    DATAFILE '/full_path_for_data_directory/apex01.dbf'
    SIZE 1000M
    AUTOEXTEND ON
    NEXT 100M
    MAXSIZE 8000M;

4. Start APEX installation:
sqlplus "/as sysdba" @apexins.sql APEX APEX TEMP /i/

Arguments:
   Position 1: Name of tablespace for Application Express application user
   Position 2: Name of tablespace for Application Express files user
   Position 3: Name of temporary tablespace or tablespace group
   Position 4: Virtual directory for APEX images

Example:
1)Local
sqlplus "sys/syspass as sysdba" @apexins SYSAUX SYSAUX TEMP /i/
2)With connect string
sqlplus "sys/syspass@10g as sysdba" @apexins SYSAUX SYSAUX TEMP /i/

5. Change ADMIN account password:
sqlplus "/as sysdba" @apxchpwd.sql

*** The password must contain at least one punctuation character: (!”#$%&()“*+,-/:;?_).

6. Run the Embedded PL/SQL Gateway configuration (EPG):
sqlplus "/as sysdba" @apex_epg_config.sql $ORACLE_HOME (full path)

7. Update the APEX images with those from the new release:
sqlplus "/as sysdba" @apxldimg.sql $ORACLE_HOME (full path)

8. Make sure that the following accounts are unlocked and not expired:
If EXPIRED - Change password for following users : ANONYMOUS,XDB,APEX_PUBLIC_USER,FLOWS_FILES,APEX_040200.
IF LOCKED - Unlock:
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
ALTER USER XDB ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER FLOWS_FILES ACCOUNT UNLOCK;
ALTER USER APEX_040200 ACCOUNT UNLOCK;

9. Enable network services (ACL) and XML DB HTTP server:
sqlplus "/as sysdba"
exec dbms_xdb.sethttpport(8080);

Verify the port:
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

10. Enable remote HTTP connections:
sqlplus "/as sysdba"
exec dbms_xdb.setlistenerlocalaccess(l_access => false);

11. Grant connect privileges to any host for the APEX_040200 database user:
sqlplus "/as sysdba"
DECLARE
ACL_PATH VARCHAR2(4000);
BEGIN
-- Look for the ACL currently assigned to '*' and give APEX_040200
-- the "connect" privilege if APEX_040200
-- does not have the privilege yet.
SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_040200', TRUE, 'connect');
END IF;
EXCEPTION
-- When no ACL has been assigned to '*'.
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
'ACL that lets power users to connect to everywhere',
'APEX_040200', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/
COMMIT;

run also the following command:
Alter system set shared_servers=10;
*add hared_servers=10 to your spfile/pfile.

12. Check that Apex was installed:
SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX';

COMP_NAME                      VERSION                        STATUS
------------------------------            ------------------------------   -----------

Oracle Application Express     4.2.2.00.11                    VALID

13. Login first time. You will be asked to change ADMIN password:
http://localhost:8080/apex/apex_admin

14. Workspace login page: 
http://localhost:8080/apex

Workspace: INTERNAL
Username: ADMIN
Password: Your new admin password

Good Luck ...

Hebrew data not shown correct in Oracle Reports with Text format

Hi All,

Here the new issue that was found during the upgrade R11 to R12.1.3.
After the upgrade all reports in Text format not show the Hebrew correct.
The columns are right to left with data left to right.

Here the simple action plan to fix this issue - VPASTA!!!!

1. Log-in to Oracle Application > System Administrator > Install > Viewer Options 
2. Add the following line:
File Format: Text
Mime Type: apps/bidi
Description:  Pasta Viewer for bidi

3. Go to Profile > System and look for "Viewer: Application for Text:

4. Choose the Pasta Viewer for bidi in SITE level.

5. Add the following lines to your custom*.env file or to .bash_profile / .profile

TK_LOCALE="bidi"

export TK_LOCALE

6. Add the following lines to $FND_TOP/reports/<your_file>.prt

nls locale "arabic"

nls datastorageorder "logical"

nls contextuallayout "no"

nls contextualshaping "yes

* You can find the needed prt file according the concurrent name and it's style

7. Re-login with appl user and restart concurrent manager.

$INST_TOP/admin/scrips/adcmctl.sh stop

$INST_TOP/admin/scrips/adcmctl.sh start

Oracle Notes:

How to Setup EBS, VPasta, And Pasta for BIDI Languages [ID 839520.1]

HOW TO CONFIGURE PASTA FOR ARABIC? (Doc ID 816879.1)

Good Luck ...

UPK to EBS 11i - Step By Step.

Hi All

Here the step by step guide how to connect the Oracle EBS 11i to use UPK help.


1. Create $XX_TOP/upk folder
2. Create $XX_TOP/upk/XX folder
3. Create $XX_TOP/upk/conf folder
4. Edit the CUSTOM.pll file to start using UPK functionality:

• Backup the CUSTOM.plx before installation.
• Copy the attached ODPN.pll file to $AU_TOP/resource.
• Compile the ODPN.pll using:
f60gen userid=apps/apps module=ODPN.pll module_type=LIBRARY    
• make sure that the ODPN.plx was created.
• Convert the CUSTOM.pll to text file (ECM_CUSTOM.pld)
f60gen userid=apps/apps module= CUSTOM.pll module_type=LIBRARY script=Yes
• Open the CUSTOM.pld
• Add the fillowing line at the begining of the file:
.attach LIBRARY ODPN END NOCONFIRM
right after the last attached pll
Add the following at the end of the Event procedure (before the line with  "end event;"), save and close the file:
/*************** UPK Module ****************************************/
gkod_event(event_name, 'SPECIAL20');
/*******************************************************************/
• Convert the ECM_CUSTOM.pld from text file to pll file (binary) using:
f60gen userid=apps/apps module= CUSTOM.pld module_type=LIBRARY parse=Yes (make sure that the CUSTOM.pll was created).
• Compile the CUSTOM.pll using:
f60gen userid=apps/apps module= CUSTOM.pll module_type=LIBRARY (make sure that the CUSTOM.plx was created).

5. copy the content of directory - Create Requisition Publish\Publishing content\PlayerPackage to $XX_TOP/upk/XX (or use windows shared directory).

6. Edit $IAS_ORACLE_HOME/Apache/Apache/conf/oracle_apache.conf

# Begin customizations
include $XX_TOP/upk/conf/xx_upk.conf "
# End customizations
(**** Need to enter full path)

8. Create $XX_TOP/upk/conf/xx_upk.conf
Alias /upk/              “$XX_TOP/upk/"
<Location /upk/>
  Order allow,deny
  Allow from all
</Location>
(**** Need to enter full path)

9. Login to Oracle Application and update Applications Help Web Agent profile with the following string:

http://<hostname>:<port>/upk/XX/oracle/hemi/oracle_gateway.html?dbc=$FND_TOP/secure/<hostname_sidname>.dbc
(**** Need to enter full path)

10. Restart Apache service
11. Now you can use the UPK to EBS functionality from EBS help menu.

Good Luck ...

Discoverer 10g installation Guide - Step by Step

Hi All

Here the Step by Step guide for installation Discoverer 10g on Linux.

1. Create an Linux user for your discoverer installation

2. Edit .bash_profile by adding ORACLE_HOME,TNS_ADMIN and TMP parameters

*** Pay attention, the TMP parameter need to be set before the starting Discoverer installation.

3. Login with created discoverer user to Linux

4. Download and extract the Discoverer 10g installation on Linux server.

(as_linux_x86_bi_101202_disk1.cpio and as_linux_x86_bi_101202_disk2.cpio)

To extract *.cpio files you can use the following command: cpio -idmv < file.cpio

5. Go to Disk1 folder and run : ./runInstaller -ignoreSysPrereqs .

6. In Destination section give the Name and Path for ORACLE_HOME from the previous steps.

7. Next

8. Next (need to fix any prerequisite issues if exists ).

9. Add the relevant languages --> Next.

10. Choose the automatic Port Configuration --> Next.

11. If you wan't to configure mail server you can leave it blank --> Next.

12. Specify name and password for ias_admin.
*** Remember the password. It will be on use on Upgrade to 10.1.2.3 PATCH SET RELEASE.

13. Install

14. Run $ORACLE_HOME/root.sh with root user --> OK.

Upgrade the discoverer to 10.1.2.3 PATCH SET

Download and extract Patch 5983622

Go to Disk1 directory and run:

./runInstaller -ignoreSysPrereqs

1. Choose the existed Name from the previous installation --> Next.

2. Choose the Oracle Applicatio Server and Developer Site 10g Rel2 Software Upgrade section. --> Next.

3. Enter the ias_admin password from the previous installation. --> Next.

4. Install.

5. Run $ORACLE_HOME/root.sh with root user --> OK.

6. Exit.

Install the latest Discoverer CP(cumulative patch).

1. Download and extract the latest Discoverer CP (For example CP10 - Parch 11674847)

2. Go to 11674847 folder

3. Run the following command for patch installation:

$ORACLE_HOME/OPatch/opatch apply

4. Go to $ORACLE_HOME/opmn/bin directory

5. ./opmnctl stopall

6. ./opmnctl startall

7. Update the $TNS_ADMIN/tnsnames.ora with instance tns names.

8. Enter to Discoverer page (default: http:<hostname>:7777/)

Good Luck ...