Extend FNDLOAD

There are several instances where you will be required to extend the standard FNDLOAD processing. This allows you to implement new data centric logic. Let us take a simple example. You might have descriptive flexfields on lets say FND_LOOKUP_VALUES table, and the descriptive flexfield Attribute1 might be attached to a table validated value set. Therefore the table will contain entries as

Record 1
------------
Lookup Code=ABCD
Meaning =Test abcd
Attribute1=1021

Record 2
------------
Lookup Code=DEF
Meaning =Test def
Attribute1=1023

Due to the table validated value set, the value 1021 equates to service request type = "Missing Equipment". Likewise, value 1023 could equate to request type = "Warranty Expired"

In case you use the standard lct file to download the lookup codes, then there the Attribute1 value will be loaded into destination environment with their original id's. However, in the destination system a value of 1023 might equate to service request type="Missing Paperwork". To overcome this problem, you can extend the lct file $FND_TOP/patch/115/import/afffload.lct

The steps are

1. Make a copy of $FND_TOP/patch/115/import/afffload.lct to XX_LOOKUP_SR_TYPE.lct
2. Modify XX_LOOKUP_SR_TYPE.lct
This is done at three places
   a. Register the custom fields that can be referenced in the download/upload section of lct file
   b. Modify the DOWNLOAD section, so that values like "Missing Equipment" and "Warranty Expired" are extracted within the ldt file itself
   c. Modify the upload section to convert the text values back to the id's. The UPLOAD is of course executed in the destination environment.

These steps are detailed as per the three figures below

Set as favorite

Bookmark

Email This

Comments (9)

Subscribe to this comment's feed

Good one
written by panks , June 21, 2010

Very Innovative and is useful too!
Thank you.

report abuse

vote down

vote up

Votes: +3

fnd load for web adi
written by Sheena Sidhu , June 24, 2010

Anil, was able to use fndload for the integrator and the layout. but how do i connect the integrator to the function
so i can use it in the responsibility's menu?

thanks
sheena

report abuse

vote down

vote up

Votes: +0

FNDLOAD RESPONSIBILITY
written by Siri , July 21, 2010

Anil,
I have two questions, i want to download menus attached to a Responsibility when I am downloading responsibility.
My requirement is when a User is downloaded i should be able to download all the responsibilities assigned to user and menus assigned to those responsibilities
etc.,. So when i import user in new instance, everything should be ready and get created.
I am a novice to Oracle apps, please guide me further. Thanks and in advance.

Regards
Siri

report abuse

vote down

vote up

Votes: +1

chellange
written by MK , August 09, 2010

Universal Lct for downloading evry LOOKUP with decoding ID->Names and Names->ID.
This kind of script will be very impressive. This one is not ...

report abuse

vote down

vote up

Votes: +1

this is tricky my friend ...
written by thomas_appsat , December 29, 2010

... but should do the trick.
well done.

report abuse

vote down

vote up

Votes: +0

I am not getting data from Org_Organization_definitions view in R12 from UAT.
written by raviraj.apps , February 12, 2011

But i got the data in DEV instance what is the problem.
Let me know
Please

report abuse

vote down

vote up

Votes: +0

...
written by raviraj.apps , February 12, 2011

i am searching about this in the internet it shows initialize the language.
What is the problem about this Org_organization_definitions view in R12
and How to initialyze a new language in R12.
is it possible in fronend also?
Let me know sir it is very urgent

report abuse

vote down

vote up

Votes: +0

Automating FNDLOAD
written by Mark ML , April 08, 2011

Use FNDLOAD GUI application. Efficiency of EBS migrations unheard of

report abuse

vote down

vote up

Votes: +0

Office 2007
written by Office 2007 , December 06, 2011

I will keep your new article. I really enjoyed reading this post, thanks for sharing