Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

EDI & E-Business Suite

Posted on February 9th, 2007 by anand ||Email This Post Email This Post

This is an article is all about EDI, deal mostly with basics and some information with underline Oracle E business Product within the suite. This article start with a typical business case and describe how this is evolves and how important is in ERP, the article helps you understand the high-level overview of the EDI process.

Why EDI Evolved?

Let us consider a simple business scenario. A Customer from PO department who wants to purchase an item creates a purchase order and then faxes it to the suppliers. At the moment vendor receives the purchase order and manually keys in a sales order. The vendor’s system generates a confirmation date that is sent back to the customer via fax or mail. The vendor then ships the goods via a carrier. The carrier delivers the products to the customer. When the goods are shipped, the vendor invoices the customer. The customer makes the payment by check, and the vendor deposits the check in the bank. Finally, funds are transferred from the customer’s account to the vendor’s account.



Figure: Typical business documents exchanged by business partners

Now It clears how much of information needs to be transferred and tracked to run the business, which in reality it is called trading partner. This simple scenario requires the exchange of various documents between several business partners at different times.

All this electronic data was exchanged using floppy disks and other secondary devices. So, ANSI committee was formed to define the standards. Hence the electronic exchange of business documents in a standard format gave birth to what is known as EDI, today the business world had accepted as one of most important entity.

What is EDI?

EDI (Electronic Data Interchange) is the electronic exchange of business documents between the computer systems of business partners, with a standard format over a communication network. It can also be called as paperless exchange.

EDI, electronic funds transfer (EFT), electronic mail and fax are increasingly being used to schedule operations, streamline order fulfilment, and optimise cash flow.


Standard Formats
The business documents that are been exchanged between business partners need to be in a standard format. ANSI X12 (American National Standards Institute) or EDIFACT (Electronic Data Interchange For administration, Commerce, and Transport) are two standards, which supply a common language for formatting the information content that is been exchanged.

There are five major Components in the EDI Process:

o Sender
o Receiver
o Language
o Content
o Medium

In EDI, the senders and receiver are called trading partners (Customers and Vendors) and the ANSI X12 or EDIFACT standards supply a common language for formatting the information content of common messages.

Oracle’s e-Commerce Gateway (EDI Gateway):

A standards-based integration product for Oracle Applications, which allows for companies to integrate Oracle Applications with applications residing inside or outside of the enterprise; communicating via Intranet, Extranet, or Internet.

Oracle’s e-Commerce Gateway is independent of all EDI standards and can be integrated with any upstream or downstream process via an ASCII file. Thus, any EDI translator or third party application, that best suits a company’s business requirements, can be selected.


The major advantage of using Oracle e-Commerce Gateway are listed below:

1. Reduction in labor hours dedicated to data entry
2. Increased data accuracy
3. Quicker communication of key information to and from customers/suppliers resulting in reduced business cycle times and more efficient planning
4. Promotes commonality of business documents and processes

Know the Terminology used in EDI

  • Transaction Set – Business document transmitted between companies (e.g. Purchase Order).
  • Data Segment – Units of data used to communicate specific information within a message (e.g. the header).
  • Data Element – Specific unit of data within a data segment.
  • Trading Partner – Entity such as a customer, supplier, or sister organization with whom electronic commerce is executed.
  • EDI Standards – Agreed to formats for exchanging electronic data (typically developed by representatives of industry verticals).
  • Translator – Software application that translates data into or out of a specific format or standard for processing by an ERP system.

Oracle EDI Gateway – functionality

  • Define Trading Partner Relationships
  • Define Code Conversions
  • Customize Flat File Formats
  • Use Standard Report Submission
    • Initiate Extract Process
    • Initiate Import Process
    • View Extract/Import Process Status

A typical flow can be understood as:


A note on File

  • ASC X12 is the EDI standard for North America and Canada.
  • EDIFACT is the EDI standard for Europe and Asia.

Transaction Supported in Oracle Apps

  • v10.6 – supports 4 transactions
  • v10.7 – supports 4 transactions
  • v11.0 – supports 14 transactions
  • v11i – supports 18 transactions
  • v11i10.2 – supports 23 transactions
  • R12 – data not available

Some Important EDI’s Details with Orcle E business suite Modules

Some Important EDI’s Details with Orcle E business suite Modules


Posted in 11i, EBS Suite, EDI | 11 Comments »

Its all about FNDLOAD

Posted on August 15th, 2006 by anand ||Email This Post Email This Post

What is 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 AOL data Migration takes place necessary to synchronize the data across databases instance during

  • Installations (New desc. flex field creations etc)
  • Upgrades (Apps upgrade etc)
  • Maintenance (Value set changes etc)

Then… What.. FNDLOAD

Yes, that is one and only oracle solution. It can be defined as a concurrent program that can move Oracle Applications data between database and text file representations. Or this can be defined as FNDLOAD can download data from an application entity into an editable text file, which can be uploaded to another database.

How it works

Conversion between database format and text file format is specified by a configuration file. Oracle does provide confirmation file and it is important to just pass the configuration file name and then just call the loader and leave everything .The schematic visual representation of the loader is like:


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
  • Attachments
  • Messages
  • Value Sets and Values
  • Lookup Types
  • User Responsibilities
  • Printer Definitions
  • FND Dictionary
  • Help Configuration
  • Document Sequences
  • Concurrent Manager Schedules

Then…what are advantages when using FNDLOAD are :

  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/dba’s
  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!!

And these are some Disadvantages also :

  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

The Syntax

To use FNDLOAD, the following syntax is needed.

FNDLOAD apps/appspwd 0 Y mode configfile datafile entity [parameter1…..]

As you can see, some info is needed.– First you will need to know the Apps password.

  • The mode is either DOWNLOAD or UPLOAD.
  • The configfile is the file that Fndload needs to download on upload data.
  • T he data file is the output file, in which the downloaded data is written
  • The entity is the entity you want to download,
  • Parameters van is passed to download a certain Alert

Modes of Operation

This is important because it would drive the whole flow, and it always be two mode .. Upload and Download…

Example of download:

FNDLOADapps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt \ PROGRAM CONCURRENT_PROGRAM_NAME= concurrent_program_short_name> APPLICATION_SHORT_NAME=<application_short_name>

Example of Upload

FNDLOAD apps/pwd 0 Y UPLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt – CUSTOM_MODE=FORCE undocumented parameter


  • Application level OR single entity level download
    • (Example) Download all the profile options of Inventory or just the INV: Default Primary UOM
  • Entire OR Partial upload of a data file
    • (Example) Upload the entire myfile.ldt or just a single enity indicated by – and mode UPLOAD or UPLOAD_PARTIAL
    • Entity name required for UPLOAD_PARTIAL mode
  • Custom mode force update
    • To override Oracle’s upload algorithm and update the custom AOL data regardless, use CUSTOM_MODE= FORCE
    • UPLOAD_MODE= REPLACE (only for menus)
  • Support for NLS uploads
    • NLS data uploads for translated columns are supported, use UPLOAD_MODE= NLS

Then ..Where is Config File Located

By default Oracle delivers most of configuration files you can use to download certain entities.

  • Configuration files with extension .lct
    • On Unix – all the configuration files are in $FND_TOP/patch/115/import directory
    • On Unix – Oracle also places the original configuration files in $FND_TOP/admin/import directory
  • Data files with extension .ldt

and..FNDLOAD File Structures is

  • The config files (.lct) are delivered and maintained by Oracle
  • It has entity definitions, parent-child relationships and user input parameters identified by :NAME
    • Downloading a parent automatically downloads all children – (Example) Concurrent Program download

Take a note FNDLOAD File Structures

  • The data files (.ldt) have both entity definition and the data
  • It also shows the version and the location of the config file (.lct) that was used
  • Without the config file, data file is useless
  • Without the data file, config file is meaningless

..Remember regarding FNDLOAD Files

  • Key files: .lct and .ldt
  • You must run the FNDLOADas apps user not as applsys or any other, otherwise you will receive Ora-6550
  • Both are easily readable, editable and portable
  • DO NOT MODIFY Oracle’s .lct files
  • Use your favorite editor (I would suggest Textpad or Editplus) to manipulate only the .ldt files but be cautious about data type, length, delimiter placements etc.
  • Use the log file outputs or .ldt file contents creatively for quick file comparisons and answer questions faster (Why can’t I access that? What is that profile option name, value and level? What is the value set used for that DFF segment attribute10 etc.)
  • Partial string searches (which value set has Priority “something” in its where clause? etc)

Sample Script Code for these Objects :

1 – Printer Styles

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=”printer style name”

2 – Lookups

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=”prod” LOOKUP_TYPE=”lookup name”

3 – Descriptive Flexfield with all of specific Contexts

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=?COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=”prod” DESCRIPTIVE_FLEXFIELD_NAME=”desc flex name” P_CONTEXT_CODE=”context name”

4 – Key Flexfield Structures

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=?COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME=”prod” ID_FLEX_CODE=”key flex code” P_STRUCTURE_CODE=”structure name”

5 – Concurrent Programs

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=”prod” CONCURRENT_PROGRAM_NAME=”concurrent name”

6 – Value Sets

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME=”value set name”

7 – Value Sets with values

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=”value set name”

8 – Profile Options

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME=”profile option” APPLICATION_SHORT_NAME=”prod”

9 – Requset Group

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME=”request group” APPLICATION_SHORT_NAME=”prod”

10 – Request Sets

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME=”prod” REQUEST_SET_NAME=”request set”

11 – Responsibilities

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY=”responsibility

12 – Menus

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME=”menu_name”

13 – Forms/Functions

FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt

14. User/Responsibilities

FNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER [<USER>]


  • Oracle Applications Systems Administrator’s Guide
  • Metalink Notes: 117084.1, 228614.1 232029.1 , 274667.1

Posted in 11i, AOL | 37 Comments »

Next Entries »