Consolidations mapping
Hello Community,
I have a requirements to maintain the account rules against a consolidation. I have to say the account rules form is not particularly friendly and does not lend itself to querying back rules for deletion and/or modification due to only being able to "clever" query back 4 characters (including the wildcard!!).
I would love to be able to programmatically update this on table GL.GL_CONS_FLEXFIELD_MAP does anybody know if there is a PUBLIC API to do this? It would be a pretty simple DML routine to update this table which appears to be a "leaf node" in the table structure, on this point if there is no API how amenable would Oracle be to allowing me to develop my own routine to update this table given their form is so awful?