Oracle ERP – Blogs

Lets Learn and Share Oracle Technology

Archive for the 'AOL' Category

Oracle Application Object Library

Winner of Oracle Excellence Award during OOW 2013

Posted by Kashif Manzoor on 19th November 2013

oeawardThought to just write separately about winning an award during OOW2013, so with the blessings of Almighty Allah, I have been awarded Oracle Excellence Award for the category of Proactive Support Champion—Global during Oracle OpenWorld 2013 at San Franciso, USA. The Oracle Proactive Support Champion Award recognizes individuals, who have made a significant impact on their company’s adoption and use of proactive support tools, best practices and have been able to influence others to adopt Oracle proactive tools.

I was so excited during the Award ceremony… can’t make out to express my feelings and getting the Oracle ProactiveSupport Champion Award is really a tremendous honour. Today I am more committed than ever to the Oracle community that has brought me so much joy and success.



Posted in AOL | No Comments »

Download – Oracle OpenWorld 2013 Presentations

Posted by Kashif Manzoor on 15th October 2013

Now available for download: most of the sessions from Oracle OpenWorld.

If you missed sessions, want to review what you learned, or spread the knowledge to others, now you can download most of the sessions presented at Oracle OpenWorld.

There are two ways to access the sessions for download (or online review):

  1. Directly through Content Catalog
  2. Indirectly through Schedule Builder to Content Catalog (registered attendees only)


– Sessions will be available for download for approximately six months (March 2014)
– Some presenters chose not to make their sessions available

Tags: , ,
Posted in AOL | No Comments »

Oracle e-Business Suite certification with JAVA 1.6 and 1.7

Posted by Kashif Manzoor on 11th September 2013

Oracle has announced certification of latest Java Runtime Environment 7u40 (a.k.a. JRE 7u40-b43) and later updates on the JRE 7 codeline and Java Runtime Environment 1.6.0_60 (a.k.a. JRE 6u60-b07) and later updates on the JRE 6 codeline through Steven Chan blog.

These versions are now certified with Oracle E-Business Suite Release 11i and 12 for Windows-based desktop clients.

Refer following notes of My Oracle Support further to Steven’s blog

All patches required for ensuring full compatibility of the E-Business Suite with JRE 7 are documented in these Notes:

For EBS 11i:

For EBS 12


Posted in AOL, EBS | No Comments »

How to use new Clone Log Parser utility of Oracle e-Business suite

Posted by Kashif Manzoor on 25th July 2013

Preparation of clone for Production eBusiness suite is a day to day work for Apps DBAs in any organization and also time consuming exercise. Sometime Functional/Development team will raise daily request to prepare fresh clone or even Oracle Support Analyst will release any solution through raised SR with the pre-set note that apply solution on fresh clone of Production. During the cloning process if error occurs due to any factor Apps DBA has to drill down to different locations to read out error logs and understand the reason for failure, it is quite time consuming and effort taking work.

Oracle Proactive Support Team has released new utility to consolidate error information from clone log files from various locations into an HTML report. A cloning activity may generate up to a dozen separate log files. This new Log Parser utility will allow you to view relevant snippets of each log at one time. Additionally the Log Parser will do some basic configuration and health checks of the environment and also may provide leads to solving problems. Major benefits of using this utility are:

  • Save time and efforts: will reduce considerable time and efforts to validating clone logs during clone process- Consolidates over 12 cloning log file types in a single HTML report!
  • Quick Fix of errors – Parses log file; exposes log snippets showing errors & warnings
  • Links solutions to key error messages in My Oracle Support content, for instant error-fix recommendations

As of now Clone Log Parser utility is available for:

  • 11i (11.5.9+)
  • R12 (12.0.x, 12.1.x)

Log Parser will consolidate error logs on all cloning, oraInventory and relinking logs in the following sequence.

  • StageDBTier.log
  • StageAppsTier_.log
  • ApplyDBTier.log
  • ApplyDatabase.log
  • ApplyDBTechStack.log
  • ApplyAppsTechStack.log
  • ApplyAppsTier.log
  • CloneContext.log
  • make_.log, make.log
  • adconfig.log
  • ohclone.log
  • adcrdb_.txt
  • NetServiceHandler.log
  • setup_stubs.log
  • Central/Global oraInventory/logs directory and all sub-directories,
    for any files with a .err, .log or .txt extension

Following are the main log files locations; DBAs usually refer to identify any error from these files:

Preclone ( log files in source instance

  • Database Tier-$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_<time>.log)
  • Apps Tier     – $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_<time>.log)

Post-Clone ( log files in target instance

  • Database Tier- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_<time>.logApps Tier
  • $INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_<time>.log

Installation of Clone Parser utility is very simple, no specific configuration requires, will follow 3 steps….unzip, run, view report

Download from Oracle My Support note E-Business Suite Clone Log Parser Utility (Rapid Clone)[VIDEO] (Doc ID 1447553.1) and install separately on db tier and apps tier separately through unzip utility.
















After download, you can install simply unzipping to specified directory as per note, it is very important installation must be done as per specified path.


Now you can unzip the file on the directory like  $ORACLE_HOME/appsutil/clone by creating $ORACLE_HOME/appsutil/clone/LogParser/


We need to install  separate Clone Log Parser utility for the dbTier and appsTier. for apps tier unzip into <COMMON_TOP>/clone/




E-Business Suite Clone Log Parser Utility (Rapid Clone)[VIDEO] (Doc ID 1447553.1)

Tags: , ,
Posted in AOL, Installation | No Comments »

Load Balancer with Oracle eBusiness Suite R12

Posted by Kashif Manzoor on 30th April 2013

What is a Load Balancer?

Hardware or software which assigns workload to a set of servers in order to optimally use computing resources A server load balancer intercepts traffic destined for a site/application, and redirects it to various machines in the cluster as per method load-balancing.  This optimizes use of system resources, resulting in higher performance, availability and scalability.  Load balancers are recommended for mission-critical enterprise deployments of web-based applications such as Oracle E-Business Suite.

A load balancer consists of a virtual server which comprises an IP address and port. This virtual server is bound to a number of physical services in a server farm. A client sends a request to the virtual server, which then selects a server in the server farm and directs this request to the selected physical server.

We can outline the major functions of a server load balancer:

  • Intercepts network traffic destined for a site.
  • Splits the traffic into individual requests and decides which machines in the cluster are to receive these requests.
  • Maintains a watch on the available machines, ensuring that they are responding to the traffic; if they are not, they are taken out from the load-balancing pool so that traffic can be routed to the machines that are available.
  • Provides redundancy by employing more than one machine for fail-over scenarios.
  • Provides context-aware load distribution, so that applications that need to maintain session-persistent connections do not fail. This feature of load balancer is very important for Oracle E-Business Suite as the various modules require session-persistent connections. To support this feature, the load balancer reads the cookies set on each request made by the client, and, based on the information in the cookie, it can rewrite the header information, then send the request to the appropriate machine in the cluster, where its session is maintained.

When is a Load Balancer required?

When we experience increase in user volumes- max utilization, need to add more resources to effectively service users.

When you wish to implement scalability and fault tolerance

A load balancer is essential when you have more than one application tier in an instance where at least 2 of the application tiers share a common entry point. You can have multiple application tiers without a load balancer but they must have an independent entry point.

What are the different types of Load Balancers?

  • Hardware HTTP load balancers (recommended)
  • DNS load balancers – network layer (Limitations include: unpredictable load distribution, DNS caching issues by the browser, lack of fault tolerance. Requires OC4J clustering)
  • Software HTTP load balancers (not recommended)–(Limitations include: Most software packages cannot handle large sites or complex networks. Packages that will support larger systems require an abundant amount of hardware.)

Tags: ,
Posted in AOL, Installation | No Comments »

Oracle EBS – Concurrent Manager – Not Running, inactive NoManager

Posted by Kashif Manzoor on 2nd March 2013

How to troubleshoot when Oracle eBusiness Suite Concurrent Request shows “Inactive NoManager”


Navigation Path to go to Concurrent Manager

System Administrator Responsibility -> Concurrent -> Manager ->

• Administer Form -> Verify the Concurrent Managers Status

Now Login into your apps node where concurrent program is is and you can verify with command

ps –ef | FNDLIBR process

Start Concurrent Manager through

Ensure All Managers are running now.


Posted in AOL | No Comments »

Oracle E-Business Suite R12.1 to R12.2 – Online Patching

Posted by Kashif Manzoor on 11th June 2012

Online Patching

One of the hot topic during Collaborate 12 at Las Vegas along with Fusion was what is going to come in R12.2 and this post is subsequent to my earlier post…where we have reviewed what new release will bring to us, lots of new features, usability improvements and new technology stack components (Oracle Database 11g R2 and Oracle Fusion Middleware 11g R1 as the application server) and the most important feature will be online patching so finally what we are going to get as ……planned for R.12.2 – all patching operations will be online, Oracle E-Business Suite will remain available to business users during patching processes.

The online patching will be changing the game completely. We all know that E-Business Suite environments requires downtime for patching. Although based on our experience it can be reduced with various techniques (e.g. staged APPL_TOP), some downtime is still required to apply a number of patches. Online patching will not eliminate downtime completely, but will reduce it significantly by using “Edition Based Redefinition” feature of 11g.

So what we will be getting just to summarize:

  • Business Operations Downtime will be measured in minutes not hours or days
  • Business Operations Downtime windows will be very predictable
  • Patches will be applied while the Oracle Production Application remains online

11gR2 Edition-Based Redefinition will enable us following:

  • Allows an application to efficiently store multiple editions of its Application Definition in the same database
  • Provides an isolation mechanism (The Edition) that allows pre-upgrade and post-upgrade schemas to co-exist
  • Client code chooses the particular “Edition” that it wants to connect to

Dual File System for R.12.2

End Notes:

Posted in AOL | No Comments »

Oracle e business suite, Generic Loader – FNDLOAD

Posted by Kashif Manzoor on 16th August 2011


We will examine FNDLOAD configuration management process in Oracle E-Business Suite. We will briefly examine concepts for configuration, customization. This note will describe how to use the FNDLOAD and java XMLImporter and XDOLoader utilities. Along with example commands and sample unix scripts, we will review how to download and upload Oracle Application data.

Data Synchronization?

Data Synchronization is a process in which some setup data would be synchronized, and this would be more important when you are working in Oracle application development/implementation project. The equally important that ATG data Migration takes place necessary to synchronize the data across databases instance during :
· Installations (New descriptive flex field creations etc)
· Upgrades (Apps upgrade etc.)
· Maintenance (Value set changes etc.

 FNDLOAD — The FNDLOAD utility is documented in Oracle Applications 11.5.7, 11.5.8, 11.5.9 System

Administration Guides, Appendix C. Starting with 11.5.10, the documentation has been expanded in the System Administration Guide – Configuration manual, Appendix B. The documentation for Release 12 has 3 new pages for Folders Configuration File.


Metalink notes are useful when you encounter an error or are not sure of the correct syntax or format for a specific use of FNDLOAD. Other good sources of documentation are Oracle blogs which can easily be found by entering the FNDLOAD command or error in google.


“FNDLOAD is a Generic Loader” – FNDLOAD can be used to download application data from an Oracle Application instance into editable text file(.ldt file). The data, in the FNDLOAD .ldt file can then be uploaded into another Oracle Application instance. This .ldt file contains not only the actual data representing the object(s) being downloaded, but it also contains metadata about the structure of that data.

The following diagram illustrates how FNDLOAD downloads data from an Oracle Application database according to a configuration (lct) file, and converts the data into a data file (ldt file) for subsequent uploading to another Application database.

What can be done?

These are the extensive list which can be done through FNDLOAD
· Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions/Personalizations
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Alerts
· Concurrent Manager Schedules

The FNDLOAD: Concurrent Program – FNDLOAD can be executed as a concurrent program.

FNDLOAD operates in one of two modes:

Download or Upload

In the download mode, data is downloaded from the database to a text file.

In the upload mode, data is uploaded from a text file to the database.


In both downloading and uploading, the structure of the data involved is described by the configuration file (lct file) and also the access methods to use to copy the data into or out of the database file. The same lct file is used for both uploading and downloading. Data structures supported by the loader include master-detail relationships and foreign key reference relationships.


The FNDLOAD executable can be found in $FND_TOP/bin and associated lct files are located in

$FND_TOP/admin/import/ or $FND_TOP/patch/115/import for the most current version.


FNDLOAD can be executed as a Concurrent Program or as a UNIX command line utility with the following format and parameters, as documented in the Oracle Application System Administrator’s Guide – Configuration:

FNDLOAD apps/pwd 0 Y mode configfile datafile entity [parameter….]



<apps/pwd> Apps schema / password


< 0 Y > Concurrent Program flags mode UPLOAD or DOWNLOAD


<config file> Configuration lct file to use. See the FNDLOAD configuration table below for names of the lct files by seed data types.


<datafile> Name of ldt data file written out when the FNDLOAD runs. This file is then used in an FNDLOAD upload to load the downloaded data into another application instance.


<entity> Entities to upload or download. Specify a “-” to upload all entities on uploads.


<[param]> Zero or more additional parameters used to provide bind values in the access SQL. Each parameter is in the form NAME=Value (Look at the specific .lct file being used for more details for these parameters.)


Some advantages when using FNDLOAD
1. Because downloaded data is stored in a text file, version administration is possible
2. There is nothing to worry to go to purchase because Investment = 0$
3. No learning curve. this is relief for developer and dba
4. Fully supported and recommended by Oracle
5. Capture the migrations in a file and use it during installations, clones etc. to migrate in batch
6. Pin-point when something happened and where (database) easily
7. Your AOL data migration process is now simplified and streamlined goal attained


Some disadvantages when using FNDLOAD
1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. UPLOAD_MODE=REPLACE only for menus
3. No validation against migrating database/instance sensitive data


Some sample examples:



FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct menu.ldt




FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct




FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct form.ldt

FORM FORM_NAME=${shortname}



FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct

formpersonalization.ldt FND_FORM_CUSTOM_RULES function_name=${shortname}



FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct

printer.ldt STYLE PRINTER_STYLE_NAME=${shortname}



FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct

concprog.ldt PROGRAM CONCURRENT_PROGRAM_NAME=${shortname}



FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct





FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/admin/import/afscursp.lct

responsible.ldt FND_RESPONSIBILITY RESP_KEY=”${respkey}”



FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct

${shortname}_flex.ldt DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME=${shortname}



FNDLOAD apps/$PASSWD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct

keyflex.ldt KEY_FLEX






FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct

valset.ldt VALUE_SET FLEX_VALUE_SET_NAME=${shortname}



FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct

profile.ldt PROFILE PROFILE_NAME=${shortname}



FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct

message.ldt FND_NEW_MESSAGES MESSAGE_NAME=${shortname}



FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct

reqgrp.ldt REQUEST_GROUP REQUEST_GROUP_NAME=${shortname}



OAUG Forum at COLLABORATE 08 Page 6

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct





FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/admin/import/bnelay.lct




With Release 12.1.1, FNDLOAD supports BLOB data (upload / download ) to better serve content-rich applications.

FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param … ]


Several different errors can occur when using FNDLOAD, so use attentiveness to review results and logs when using this utility. The FNDLOAD program can fail when the ldt file used to download and the corresponding lct file used to upload are not compatible.


Other Oracle Utilities – Similar to FNDLOAD, other Oracle Development tools, like the XML Publisher and

JDeveloper, also have Oracle Application utilities that can be used to download and/or upload application data.

These tools are supported by the java XML and XDO Loader utilities, which can be used to migrate additional types of Application entities among your instances. Finally, AD administration tasks are sometimes needed to support post-upload requirements for some entities.

Developers can use the XML Publisher to create XML reports for Oracle Applications. In the Apps, navigate to the XML Publisher Administrator responsibility, then to Templates and Data Definition web pages. Use these web pages to register custom XML reports and upload your report’s physical template file from your client, or you can use two command line utilities to automate moving XML report registration and the report’s physical files among instances. FNDLOAD will download and upload XML report data definitions and template metadata. The XDOLoader utility is a Java-based command line program to download and/or upload the physical template (RTF, PDF, XSL-FO, XML, and XSD) files from/to the XML Publisher database tables. The following examples show the FNDLOAD and XDO Loader commands to download/upload XML report data:


Data definition and template registration:


FNDLOAD apps/apps O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct tmpl.ldt




Physical template files:

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps –




-lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct


Developers can use JDeveloper to modify existing OA Framework pages or create new custom web pages. The web pages can then be downloaded and/or uploaded from one Oracle Application instance to another using the Java Exporter and/or Importer utility. OA Framework pages also have file system class and jar files which can be migrated by zipping your custom directories, using ftp to copy these files, and unzipping them into your other instance’s $APPL_TOP before running the XML Importer.


The following is a sample Java XML Importer command to load xml pages:



$XXLM_TOP/oracle/apps/xxlm/${shortname}/webui/ -username apps -password

$password -rootdir $XXLM_TOP -DBCONNECTION “hostname:dbport:sid” -jdk13 –

mmddir $OA_HTML/jrad


Once uploaded and prior to being used, some entities require AD administration tasks to be executed. For example, uploading messages requires the maintenance step of ‘Generate Message Files’. Before AD administration can be used non-interactively, a defaults file must be created interactively. eg:


adadmin defaultsfile=$APPL_TOP/admin/testdb1/adadmindef.txt


Once created, this defaults file is used in the non-interactive call to adadmin:


adadmin interactive=n defaultsfile=$APPL_TOP/admin/testdb1/adadmindef.txt


For details, see “Oracle Applications Maintenance Procedures.”


Utility download script – Running FNDLOAD, and other similar utilities, from a UNIX script allows you to

easily integrate the use of the download/upload utilities for your Oracle Applications data, e.g., registration of forms/reports/value sets, etc., for code promotion with the configuration management and promotion of your UNIX file system objects, e.g, your forms (fmb), reports (rdf), etc. Any execution of FNDLOAD assumes the Oracle


Application environment has previously been set. The code segment below is one example of how to call

FNDLOAD within a korn shell script.


## assumes APPS environment is properly set

## and other shell variables previously defined



## Prompt for type and parameter value


echo “Enter a category




read category

if [ -z “$category” ] ; then



typeset -u category

echo “Using category” $category | tee -a ${LOGFILE}



## determine appropriate user input prompt

case $category in


parm_prompt=”Please enter a request group.”



parm_prompt=”Please enter a responsibility key (include _ underscore

for spaces).”



parm_prompt=”Enter a short name.”


## Get input from user

echo $parm_prompt

read shortname

if [ -z “$shortname” ] ; then

echo $parm_prompt




## log files from FNDLOAD execution are not ‘well named’

## this is one attempt to identify a new file

OAUG Forum at COLLABORATE 08 Page 10

## Get initial list of *log files

ls *log > ${WORK_FILE1} 2>/dev/null


## execute appropriate form of FNDLOAD


case $category in


FNDLOAD apps/$PASSWD O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct

${shortname}_menu.ldt MENU MENU_NAME=${shortname}



FNDLOAD apps/$PASSWD O Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct

${shortname}_formpersonalization.ldt FND_FORM_CUSTOM_RULES




FNDLOAD apps/$PASSWD O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct





java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps –





FILE_CONTENT_TYPE ‘application/rtf’ -FILE_NAME ${shortname}.rtf -NLS_LANG

ENGLISH_UNITED_STATES.WE8ISO8859P1 $XDO_TOP/patch/115/import/xdotmpl.lct



## additional FNDLOAD command lines for each of the different

## categories of applications entities




echo You entered an incorrect category. Valid categories are:





sleep 1

## Additional work to attempt to identify the most recently

## created log file


## get new list of log files

ls *log > ${WORK_FILE2}

## find name of newly created log file (from concurrent mgr process)

FND_LOG=`diff ${WORK_FILE1} ${WORK_FILE2} | grep \> | cut -c3-`

echo “Logfile is:” ${FND_LOG} | tee -a ${LOGFILE}

## look for obvious success or failure tokens

grep “successfully” ${FND_LOG} | tee -a ${LOGFILE}

grep “ORA-” ${FND_LOG} | tee -a ${LOGFILE}


This code interactively prompts the user for the type and name of the entity that will be downloaded. It also uses the name (‘shortname’ parameter) to help label the created .ldt file along with its entity type. This naming convention helps to keep track of which ldt files contain which entities. An upload script for these files would look very similar. The script could be extended or used in conjunction with other scripts to implement a simple configuration process.




Note: 274667.1 FNDLOAD Commands to Download Different Seed Data Types.

Note: 287417.1 Parameters Of Different Configuration Files To Download And Upload Seed Data Types.

Note: 256573.1 How To Download/Upload Descriptive Flexfield With Name $SRS$

EBS Release : Oracle Applications System Administrator’s Guide – Configuration

EBS Release 12.0.4+ : Oracle Applications System Administrator’s Guide – Configuration

EBS Release 12.1.3 : Oracle Applications System Administrator’s Guide – Configuration

Customization Survival Guide: How to Use E-Business Utilities to Migrate Your Custom Code, Brad Simmons and Donna Campbell, Los Alamos National Laboratory document

Tips About FNDLOAD [ID 735338.1]

Is It Possible To Use FNDLOAD To Migrate Configurations Or Data To Another Instance? [ID 1316916.1]

How To Use XDOLoader to Manage, Download and Upload Files? [ID 469585.1]


Tags: ,
Posted in AOL | No Comments »