can anyone point me at a document which details what needs populating in Oracle e-business to utilise GL reporting hierarchies on the standard chart of account segments and which folder / subject area in OBIA to access to use it?
Or failing that words of one syllable would also be good...
W_GL_ACCOUNT_D and W_GL_GROUP_ACCOUNT_D,W_HIERARCHY_D(Dont remember exact name) tables being involved in it..
You can not directly modify the actual tables.Since Three .CSV files (group_acct,group_acct_names,fin_stmt) plays major important roles in the calculation of metrics and also routing accounts transaction.
Based on the combination(W_GL_COGS_F,W_GL_OTHER_F,W_AP_XACT_F,W_AR_XACT_F etc table are loaded).
You try changing the these 3 csv files and ensure to run full load every configuration change(or run group account cleaning task).
-For any further information you can refer lineage doc.
I did find these myself, but the extra detail on how they are accessed is welcome.
Unfortunately I do not think this is a solution for me with my clients current requirement as they want to apply a reporting hierarchy based on the code combination, so effectively each code combination id (gl_code_combinations back in Oracle GL e-business) will have one, many or no reporting structure applied to it, and in addition to this from that initial code => parent there will also be numerous levels of parent => parent.
These tables seem to link solely on one segment value, not the combination of all segment values.
I think therefore that the only way to do this is on a purely custom basis.