How to process and consolidate Oracle GL account numbers in GL
Currently we are on EBS release R12 (12.1.3). We have defined our Chart of Account (COA) as 6 segments: Entity, Business Unit, Cost Center, Project and TBD.
i.e. 10-1000-10000-40555-X2014-00000
Note: Currently we are using the following Oracle financial applications:
GL, AP, AR, PO, Fixed Asset, Cash Management, Treasury, iProcurement & iExpense. Also, we have been using Oracle financial applications since 1992.
It seems every year our business creates about 1000 new GL project (segment) number per year. This is causing our number of GL Project segment inflated to over 20,000 since 1992 and our active gl code combination account numbers are now around 300,000. I have the following questions: