Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Monday, September 9, 2013

To Migrate Description Flex Field(DFF) One Instance to Other Instance



/*DOWNLOAD DESCRIPTION FLEXFIELD*/
Run the below download command in home directory of Instance1, the ldt file descript_flex.ldt is created in the same directory.

FNDLOAD apps/<APPS PASSWORD> 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct descript_flex.ldt desc_flex_application DESCRIPTIVE_FLEXFIELD_NAME=description_flexfield_name

desc_flex_application - is the shortname of the Application of the DFF.
description_flexfield_name - This is not title of the DFF.

To get description_flexfield_name:
Open the DFF in Application Developer -->Flexfield -->Descriptive -->Segments

click help -->diagnostics -->examine -->
block=table, field=DESCRIPTIVE_FLEXFIELD_NAME.
The value in the field "Value" is the description_flexfield_name.

For Example, The description_flexfield_name of the DFF "Additional Information" in the above screenshot is: CS_INCIDENTS_ALL_B_EXT.
Application is: Service.
Short name of Service is: CS
And the download command is:

FNDLOAD apps/<APPS PASSWORD> 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct descript_flex.ldt CS DESCRIPTIVE_FLEXFIELD_NAME=CS_INCIDENTS_ALL_B_EXT


/*UPLOAD DESCRIPTION FLEXFIELD*/
Transfer the ldt file descript_flex.ldt from Instance1 to the home directory of the Instance2 and run the below upload command in the same directory.

FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afffload.lct descript_flex.ldt

/*COMPILING DESCRIPTION FLEXFIELD*/
After migration, run the below compilation command to compile the flexfield in the Instance2.

fdfcmp apps/ 0 Y D desc_flex_application description_flexfield_name

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect