Issues while Enabling Management Segment for an Existing Setup
Last updated on MARCH 04, 2015
Applies to:Oracle General Ledger - Version 12.0 and later
Information in this document applies to any platform.
***Checked for relevance on Mar-2015***
In case of a fresh setup, where no transactions are entered in the system, Management Qualifier can be enabled for the desired segment like any other qualifier i.e
Setup -> Financials -> Flexfield -> Key -> Segments
Query the Chart of Accounts and check the Segments.
Assign the Management qualifier to the desired Segment (any segment other than the Balancing, Intercompany and Natural Account)
In case Management qualifier is being assigned to an existing Ledger, DO NOT enable it in Chart of Accounts form. Instead run the following two concurrent request in the specified order:
1. Program - Prepare Journal Batches for Management Segment Upgrade
2. Program - Complete Management Segment Upgrade
Once the above two requests complete successfully, the desired segment will automatically be enabled as Management Segment. However following two issues can come while doing so:
1. While running the request "Program - Prepare Journal Batches for Management Segment Upgrade", found that the LOV for Chart of Accounts is not showing the desired Chart of Accounts.
2. The request GLMGT2 "Program - Process Posted Journal Batches for Management Segment Upgrade" which is triggered by the request "Program - Prepare Journal Batches for Management Segment Upgrade" is erroring out with the following error:
ORA-00001: unique constraint (GL.GL_JE_SEGMENT_VALUES_U1) violated
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms