Oracle Applications: DATA Migration Concepts(FND

Movement of application data from one database to the other

Types Classification:
- Transactional Data (Journal Entries, WIP operations, PO entry etc.)
- Application Object Library Data (Concurrent programs, Profile Options etc.)
- Application Setup Data (Organization, Customers, Item Categories, Templates etc.)

For the Application Object Library Data (AOL Data) we use this FND_LOAD.

How to Migrate Applications Objects between instances

3rd Party Applications

Expensive

Complicated

One more in a list of apps to maintain

Database clone

Only useful if you want everything

Custom Script process
FNDLOAD

Combine with scripts to ensure consistent migration of objects with in Oracle Applications.

FNDLOAD

FNDLOAD is a concurrent program that can move Oracle Applications data between database and text file representations.

Command syntax:

FNDLOAD <apps/$APPS_PW> 0 Y <Mode> <Configfile> <target data file> <entity>

<parameter>

Mode = UPLOAD, UPLOAD_PARTIAL or DOWNLOAD

Configfile = Configuration file provided by Oracle in $FND_TOP/patch/115/import

Target Data File = Name of the file to be created by Download or used by Upload. This file contains the definition of the entity being migrated.

Entity = Type of object being migrated (printer style, lookup, executable, concurrent program …)

Parameter = Parameter related to the entity (name of the entity).

Command works:

Connects to apps
Downloads concurrent program data for the concurrent program short name <ex: ‘GLIMP’> using the .lct configuration file into .ldt file

AOL Entities:

The following entities support by the FND_LOAD.

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

Key Files for FND_LOAD:

Key files: .lct and .ldt(Data files)
Both are easily readable, editable and portable
DO NOT MODIFY Oracle’s .lct files
Without the config file, data file is useless
Without the data file, config file is meaningless

Configuration Files (.lct):

Concurrent Programs - afcpprog.lct
Request Groups - afcpreqg.lct
Lookup Groups - aflvmlu.lct
Profile Options - afscprof.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

FND_LOAD

It is used for to transfer the data from one instance to other instance. For example if we are worked in 'DEV' and we want the same data in 'TEST' also. For that we are using this FND_LOAD.

For this First connect to UNIX (ex: Putty or Telnet)

Go to particular top (ex: XXIF_TOP). In any top you have to go to admin/import. So you have to go to particular top after admin/import (ex: XXIF_TOP/ADMIN/IMPORT) Than Run the below FND_LOAD command in that path.

Download a Concurrent Program to file (from the command line):

-------------------------------------------------------------------------------------

-- acfprog.lct copies a program.

-- Table FND_APPLICATION.application_short_name has the short name you will need.

$FND_TOP/bin/FNDLOAD apps/apps@DB_INSTANCE 0 Y DOWNLOAD $FND_TOP/admin/import/afcpprog.lct WORLDS_BEST_PROGRAM.ldt PROGRAM APPLICATION_SHORT_NAME='SQLGL' CONCURRENT_PROGRAM_NAME='WORLDS_BEST_PROGRAM'

Note: You can find the concurrent_program_name in fnd_concurrent_programs table.

Application_short_name is not mandatory here. (It is from fnd_application table).

Upload the Concurrent Program:

----------------------------------------------------------------------------------

-- You can specify a different database with the credentials;

-- Just use different value for DB_INSTANCE

$FND_TOP/bin/FNDLOAD apps/apps@DB_INSTANCE 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct WORLDS_BEST_PROGRAM.ldt -

Download a Value Set:

----------------------------------------------------------------------------------

$FND_TOP/bin/FNDLOAD apps/apps@DB_INSTANCE 0 Y DOWNLOAD @FND:admin/import/afffload.lct BEST_VALUE_SET.ldt VALUE_SET FLEX_VALUE_SET_NAME='BEST_VALUE_SET'

Note: You can find the flex_value_set_name form fnd_flex_value_sets table.

Download Value Set Values:

----------------------------------------------------------------------------------

$FND_TOP/bin/FNDLOAD apps/apps@DB_INSTANCE 0 Y DOWNLOAD @FND:admin/import/afffload.lct BEST_VALUE_SET.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME='BEST_VALUE_SET'

Upload a Value Set:

----------------------------------------------------------------------------------

$FND_TOP/bin/FNDLOAD apps/apps@DB_INSTANCE 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct BEST_VALUE_SET.ldt