DATA Migration Concepts(FND_LOAD)

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