Customer Form Error: When Trying To Create Ship_To Site For A Customer, Customer Territory Flexfield Raises Error: The data that defines the flexfield on this field may be inconsistent
(Doc ID 843809.1)
Last updated on OCTOBER 13, 2022
Applies to:Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
This problem can occur on any platform.
Trying to create a ship to address for a Customer and received the following error:
1. The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: KeyFlexfieldDefinitionFactory.getStructureNumber could not find the structure definition for the flexfield specified by Application = SQLGL, Code = GL# and Structure number =
2. The key flexfield with application name Receivables (AR), name Territory Flexfield (CT#), and structure Customer Territory Flexfield (CUSTOMER_TERRITORY_FLEXFIELD) is not frozen. Please contact your system administrator.
When this error is raised, you cannot cancel out of the error or get out of the Account Site Detail screen - the only way out is to log out.
Applied Patch 8250109:R12.AR.A as per Note 816607.1 but the issue remains.
Steps to Reproduce:
Responsibility: AR Super User
Navigation: Customers > Customers
- Query a Customer
- Click Account
- Click Account Details
- Click on Site Details
- Click on Business Purposes, select Ship To and click Details. The error is received.
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