So you have a DFF. Let say is is “Batch Information” of “Process Manufacturing Process Execution”. It has several contexts and each context has several segments.
What I want to do is to download FREEZE_BATCH segment inside “Global Data Elements” context
But how exactly go I get to this exact segment?
In the past Oracle provided detailed explanation about how to use FNDLOAD utility to download all parts of DFF. You can check them in the following metalink notes:
Note: 735338.1 - Tips About FNDLOAD
Note: 274528.1 - How To Download Single Context Using FNDLOAD For Descriptive Flexfield
Note: 745689.1 - How To Download A Single Flexfield Structure Using FNDLOAD?
Note: 316600.1 - Download Multiple Flexfields From FNDLOAD
Note: 603036.1 - How Do I Determine the DESCRIPTIVE_FLEXFIELD_NAME to be Used During FNDLOAD
Well, it is all good , but at the moment of writing this post, non of them will work, because Oracle changed the structure of DFF lct file, but didn’t inform users about this. So if you on the last release of 11i (and accrding to Oracle there are not going to be any more patches for 11i) or R12, all the notes above are useless.
But you still have lct file, right? So I tried to understand how to assemble the download command just by looking into lcf file.
and I found the following section in the file
Aha… Exactly what we need . Now when I have this information I can assemble the command in zero time
Here it is in details…..
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct ./MY_DFF.ldt DESC_FLEX
-- Process Manufacturing Process Execution application
-- DFF title
DESCRIPTIVE_FLEX_CONTEXT_CODE="Global Data Elements"
-- Segment Code
-- Database column name
Here it is as a single line command
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct ./MY_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME="GME" DESCRIPTIVE_FLEXFIELD_NAME="BATCH_FLEX" DESCRIPTIVE_FLEX_CONTEXT_CODE="Global Data Elements" END_USER_COLUMN_NAME=FREEZE_BATCH APPLICATION_COLUMN_NAME=ATTRIBUTE2