R12: Error For GLCOAM Program: ORA-00001: Unique Constraint (APPLSYS.FND_ID_FLEX_STRUCTURES_U2) Violated

(Doc ID 461025.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

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


Symptoms

Set up a new Chart of Accounts, a new ledger and attach the new chart of accounts to this ledger.

Attach the new data access set to your General Ledger Super User responsibility, then run "Program - Generate Ledger Flexfield".

At this point, the program fails with the following errors in the log file:

ORA-00001: unique constraint (APPLSYS.FND_ID_FLEX_STRUCTURES_U2) violated

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