How to bulk import Lookup Types and Lookup Codes using File Based Loader

[@OracleCloud-p5l]

Great demonstration

[@aldomartinezfragoso3139]

IT WORKS!!

[@FusionNexgenLearning]

Greetings,
Thanks for your valuable feedback.
Regards,
Fusion Nexgen Learning

[@kapilsharma331]

Very good demonstration

[@FusionNexgenLearning]

Thanks for your valuable feedback and support

[@matiastifosi]

Great video. Could you please let us know which roles are required to have the File import/export tool?

[@krishnaveni5856]

Thanks for the video.
Can you also please do a video on, how to upload lookup codes when we have multiple DF attributes for the lookup code. Basically lookup codes along with the DFF attributes

[@FusionNexgenLearning]

Great suggestion! Yes, we will release a video soon on this topic.
Regards,
Fusion NexGen Learning

[@oraclefusionhcmbestpractic2954]

Great work

[@FusionNexgenLearning]

Thank you so much 😀

[@oraclefusionhcmbestpractic2954]

Welcome

[@SandeepMishra-yj2bj]

Very informative

[@FusionNexgenLearning]

Glad you liked it

[@sauravjain5531]

very informative

[@FusionNexgenLearning]

Glad it was helpful!

[@yeswanthyesh2299]

Request to tell me how you can upload the common lookups which have the DFF in it?

[@FusionNexgenLearning]

Dear,
Thanks for watching our channel.
Please follow below mapping and update values accordingly
LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag|CONTEXT_ATTRIBUTE|segment1_apiName|segment2_apiName
Regards,
Fusion NexGen Learning

[@yeswanthyesh2299]

@@FusionNexgenLearning , i already tried this but getting an error that attribute value is not found

[@FusionNexgenLearning]

Thanks for the idea, I'll release soon next video on this.
Regards,
Fusion NexGen Learning

[@FusionNexgenLearning]

Dear,
Please refer
th-cam.com/video/Kut8EJyLRVI/w-d-xo.html
Regards,
Fusion NexGen Learning

[@arturoguevara8415]

I did the same steps for common lookups shown for standard lookups and it worked correctly

[@AMANGUPTA-cj6fk]

very good

[@FusionNexgenLearning]

Thank you! Cheers!

[@namitsingh1237]

Can you add the file to load the Lookup along with Context dff values??

[@FusionNexgenLearning]

Dear, Please find below
LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag|CONTEXT_ATTRIBUTE(Context Name)|segment1(apiName)|Ctx_segment2_apiName
Instructions:
CONTEXT_ATTRIBUTE(Populate Context name in place of CONTEXT_ATTRIBUTE)|segment1(Populate segment1 apiName) |segment2 (Populate segment2 apiName)
Regards,
Fusion NexGen Learning

[@SunilKumar-df1hv]

Good Sir

[@FusionNexgenLearning]

Thanks you for watching Fusion NexGen Learning

[@pareshkumar4980]

I was looking for the same solution, the Very Good Fusion NexGen team. Please share me SQL

[@FusionNexgenLearning]

Thanks for watching and your valuable feedback. Please find below SQL details
select a.lookup_type, b.MODULE_TYPE, b.MODULE_KEY
from fnd_lookup_types a, FND_APPL_TAXONOMY b
where a.lookup_type=''
and a.module_id=b.module_id;

[@Akshuking024]

Kindly provide the SQL

[@FusionNexgenLearning]

Thanks for watching, Please refer below SQL
select a.lookup_type, b.MODULE_TYPE, b.MODULE_KEY
from fnd_lookup_types a, FND_APPL_TAXONOMY b
where a.lookup_type=''
and a.module_id=b.module_id;