Sunday, 15 January 2012

Downloading single segment of specific context of Oracle Application Descriptive Flex Field

 

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.

image

What I want to do is to download FREEZE_BATCH segment inside “Global Data Elements” context

image

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.

vi $FND_TOP/patch/115/import/afffload.lct

and I found the following section in the file

 

image

 

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

APPLICATION_SHORT_NAME="GME"

-- DFF title

DESCRIPTIVE_FLEXFIELD_NAME="BATCH_FLEX"

-- Context

DESCRIPTIVE_FLEX_CONTEXT_CODE="Global Data Elements"

-- Segment Code

END_USER_COLUMN_NAME=FREEZE_BATCH

-- Database column name

APPLICATION_COLUMN_NAME=ATTRIBUTE2

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

No comments:

Post a Comment