Issues while Enabling Management Segment for an Existing Setup (Doc ID 733605.1)

Last updated on MARCH 04, 2015

Applies to:

Oracle General Ledger - Version 12.0 and later
Information in this document applies to any platform.
GLMGT2
***Checked for relevance on Mar-2015***

Symptoms

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
<x GL_MANAGEMENT_SEGMENT_UPGRADE.Process_Incremental_Data()

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms