Populate fnd_flex_values and _TL tables
We have a requirement to load into Oracle GL cost centers(One of the segments in the KFF) and hierarchies from a 3rd party application. We are getting these as a flat file. After identifying the fields and the values, I am guessing the insert would be into the fnd_flex_values, fnd_flex_values_tl and ..norm_hierarchies. Not sure about the approach here.
Has anybody done this before? if yes, could you please, share how this can be done. Appreciate your help. Thanks in advance.