My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle General Ledger - Version 12.0 and later
Information in this document applies to any platform.


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()


To view full details, sign in with your My Oracle Support account.

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

In this Document
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.