My Oracle Support Banner

Assign Accounts to FSG Reports Errors: APP-FND-01050 / APP-FND-00730; GLCOAM: Program - Generate Ledger Flexfield Errors ORA-00001: unique constraint (APPLSYS.FND_ID_FLEX_STRUCTURES_U1) violated (Doc ID 2152383.1)

Last updated on JANUARY 30, 2024

Applies to:

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

Symptoms

When attempting to assign accounts for a Financial Statement Generator (FSG) report row, the following errors occurs on the form. 

Compiling the Flexfield or performing certain changes in Accounting Setup Manager may throw errors through forms/html pages or concurrent programs triggered. The GLCOAM: Program - Generate Ledger Flexfield also generates error in the log file as described below.

Another symptom of this issue may be that the Accounting Flexfields is showing segments data, while the GL Ledger Flexfield is not showing any segments. This is something you may want to test (Setup > Financials > Flexfields > Key > Segments > Query for your structure and the GL Ledger Flexfield.

IMPORTANT: acknowledge the issue in the form but do not perform any manual changes to this flexfield as such action will not be supported along with all its consequences. 

 
ERROR in FSG Setup Forms
APP-FND-00814: Program error. Please contact your support representative.
FRM-92101: There was a failure in the forms server during startup.


ERROR in GLCOAM: Program - Generate Ledger Flexfield
GLCOAM: Program - Generate Ledger Flexfield
GL Ledger Flex Structure CODE is: ACCOUNTING_FLEXFIELD
GL Ledger Flex Structure NUMBER is:
ORA-00001: unique constraint (APPLSYS.FND_ID_FLEX_STRUCTURES_U1) violated


STEPS TO REPRODUCE
1. Login to GL responsibility.
2. Navigate Reports->Define->RowSet
3. Enter a name for 'Row Set' and click on 'Define Rows'
4. Enter the required information to create a new row, and click on the 'Account Assignments' button

Changes

The issue occurs on fresh install of 12.2.5, however it is not limited to being produced in this context only.

Cause

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
Symptoms
Changes
Cause
Solution
References


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