Code Migration in Oracle APPS
FNDLOAD
FNDLOAD is an Oracle utility for the transfer of a wide range of Oracle
Foundation (FND) data from one instance(Developement) to another(Prod) instance.
It can be defined as a concurrent program that can move Oracle Applications
data between database and text file 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 a confirmation file and it is important to
just pass the configuration file name and then just call the loader and leave
everything.
What can be done using FNDLOAD?
These are the list, of configuration file and it’s Purpose
How to download different seed data types?
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 - Request Groups
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"
To upload the lookup type into a different instance you would use the equivalent upload statement, as follows:-
FND_TOP/bin/FNDLOAD apps/<apps_pwd>@<destination_db> 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct <the_name_of_your_data_file>.ldt
E.g.
FNDLOAD apps/msc123 0 Y UPLOAD afcpprog.lct /oraspace/patches/vjafcpprog.ldt
FNDLOAD apps/msc123 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct vjafcpprogmsccus.ldt
Steps for FNDLOAD
Step 1 : Login as applmgr user on application tier.
Set the environment variables as shown below:
$ cd /d01/oracle/prodappl
$. ./ APPSORA.env
Step 2 : Now Change directory to $FND_TOP.
$ cd $FND_TOP
Step 3 : Now download the responsibility data in sysadmin_resp.ldt file.
$ FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct
/home/applmgr/sysadmin_resp.ldt FND_RESPONSIBILITY RESP_KEY=SYSTEM_ADMINISTRATOR
Step 4 : Now open the log file using vi editor to check if there is any error.
$ vi 123455.log
Step 5 : Now open the sysadmin_resp.ldt file ,if there is any error
Step 6 : As the request is completed successfully, now we will edit the
sysadmin_resp.ldt file using vi. Now open the generated file using vi.
vi /home/applmgr/sysadmin_resp.ldt
$ FNDLOAD APPS/aps 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115
/import/afscursp.lct /home/applmgr/sysadmin_resp.ldt
Step 8 : Check the log file .if there is any error.
Step 9 : Now as the request completed successfully.Login as system
administrator and check responsibility in the application.
FNDLOAD
FNDLOAD is an Oracle utility for the transfer of a wide range of Oracle
Foundation (FND) data from one instance(Developement) to another(Prod) instance.
It can be defined as a concurrent program that can move Oracle Applications
data between database and text file 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 a confirmation file and it is important to
just pass the configuration file name and then just call the loader and leave
everything.
What can be done using FNDLOAD?
These are the list, of configuration file and it’s Purpose
How to download different seed data types?
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 - Request Groups
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"
To upload the lookup type into a different instance you would use the equivalent upload statement, as follows:-
FND_TOP/bin/FNDLOAD apps/<apps_pwd>@<destination_db> 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct <the_name_of_your_data_file>.ldt
E.g.
FNDLOAD apps/msc123 0 Y UPLOAD afcpprog.lct /oraspace/patches/vjafcpprog.ldt
FNDLOAD apps/msc123 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct vjafcpprogmsccus.ldt
Steps for FNDLOAD
Step 1 : Login as applmgr user on application tier.
Set the environment variables as shown below:
$ cd /d01/oracle/prodappl
$. ./ APPSORA.env
Step 2 : Now Change directory to $FND_TOP.
$ cd $FND_TOP
Step 3 : Now download the responsibility data in sysadmin_resp.ldt file.
$ FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct
/home/applmgr/sysadmin_resp.ldt FND_RESPONSIBILITY RESP_KEY=SYSTEM_ADMINISTRATOR
Step 4 : Now open the log file using vi editor to check if there is any error.
$ vi 123455.log
Step 5 : Now open the sysadmin_resp.ldt file ,if there is any error
Step 6 : As the request is completed successfully, now we will edit the
sysadmin_resp.ldt file using vi. Now open the generated file using vi.
vi /home/applmgr/sysadmin_resp.ldt
$ FNDLOAD APPS/aps 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115
/import/afscursp.lct /home/applmgr/sysadmin_resp.ldt
Step 8 : Check the log file .if there is any error.
Step 9 : Now as the request completed successfully.Login as system
administrator and check responsibility in the application.
