We have encountered multiple drawbacks with "Import Chart of Account Segment Values". Below are the details.
- This program is not supporting DFF values to insert/Update in FND_FLEX_VALUES table. Also we do not have any public api available to update DFF's in flex values table.
- Coming to Flex hierarchies, Program is not supporting to insert/Update delta(only changes) for flex hierarchies. Every time it requires to upload all hierarchies. In this case, all the who columns are updating with latest records. flex hierarchies which do not have changes also updating with latest WHO columns. This seems to a big draw back.
- If we proceed only delta changes for Flex hierarchies, other existing flex hierarchies are deleting in that hierarchy and inserting with new delta records.