4 Oct 2010

FNDLOAD utility in Oracle Apps






In this blog we will see what is FNDLOAD and why/how we use in Oracle Apps.

What is FNDLOAD:


This is utility provided by Oracle to migrate objects/entities from one instance to another.

Why do we need to migrate?

Good question :-) . Generally we need development in one server (let us call it instance hence forth) and business users will test in another instance and finally production would be final instance. So every time, we cannot and should NOT define concurrent programs/Request groups/Flex fields/Menus and messages etc…,
To make our life simple we will use utility.

How it works?


It is 2 step process,
1)      Download
2)      Upload

Download

 Using download command we will generate a .ldt file, which will hold the definition of entity.
Ex: We want to migrate a concurrent program from  instance 'Dev' to another.
First we need to download the definition from 'Dev' instance.
We will see the commands for the same in the later section for now just understand the concept.



Upload

Here we will load the definition of entity into new instance. (You need not to manually define the executable and concurrent program ;-D sounds good..isn't it? )

Using FNDLOAD we can migrate following entities
  1. Concurrent Programs
  2. Request Groups
  3. Profile Values
  4. Form Personalizations 
  5. Value Set Definitions
  6. Fnd Messages 
  7. Lookup Values
  8. User Definitions 
  9. Request Sets 
  10. Responsibilities
  11. Form Functions

Here are few commands:

Concurrent Programs
Download:
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt PROGRAM_NAME APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CUSTOM_ORACLE_INTERFACE_PROG"
  • This command will create XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt file in your server.
  • XXCUST will be your custom Application Shortname where concurrent program is registered
  • XX_CUSTOM_ORACLE_INTERFACE_PROG Will be the name of your request group
  • PROGRAM_NAME is your conc program short name.


Upload:
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt

References:

For the commands  and usage you can refer below site:


No comments:
Subscribe to: Posts (Atom)