FND_FLEX_VALUES_VL & FND_FLEX_VALUES_TL
Hi,
My goal is to insert data for value set of chart of like branch, profit center and natural account. I am using data loader to load the values of values sets but i found it is very time consuming and not much effective as well and i have to wait until it complete loading while doing this i can not do any thing and have to monitor it as it always do some surprises during loading.
Therefore i am thinking to load via sql into tables but after searching on internet i found two different opinion one is asking to load these type of data via data loader and other one said you can insert into fnd_flex_values_vl and fnd_flex_values_tl as the package it self do the direct insert into these tables. Here i found contradiction and puzzle which way i should adopt or there are some other best possible way to do this in quiet efficient manner.
My goal is to insert data for value set of chart of like branch, profit center and natural account. I am using data loader to load the values of values sets but i found it is very time consuming and not much effective as well and i have to wait until it complete loading while doing this i can not do any thing and have to monitor it as it always do some surprises during loading.
Therefore i am thinking to load via sql into tables but after searching on internet i found two different opinion one is asking to load these type of data via data loader and other one said you can insert into fnd_flex_values_vl and fnd_flex_values_tl as the package it self do the direct insert into these tables. Here i found contradiction and puzzle which way i should adopt or there are some other best possible way to do this in quiet efficient manner.
0