Does the FND_TREE_LOG and FND_TREE_LOG_PARAMS table purge over time?
Could you please confirm if Oracle purges data from FND_TREE_LOG and FND_TREE_LOG_PARAMS tables over time? If yes, then what is the frequency, and is there a setup to control the same?
We need to use the FND_TREE_LOG and FND_TREE_LOG_PARAMS tables in the BIP report to fetch hierarchies data. We want to make sure that we don't lose any data without sending it to our boundary applications.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):