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

Last updated on FEBRUARY 03, 2019

Applies to:

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

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

	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

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