Customer Form, Sites Error: Updating Site Information in Order Management and Receivables Customers Form - Receive Error - KeyFlexfieldDefinitionFactory - ORA-20001: ORA-06512: line 72 at "APPS.APP_EXCEPTION", ORA-06512: line 65 at "APPS.GL_GLOBAL" (Doc ID 1253394.1)

Last updated on MARCH 24, 2017

Applies to:

Oracle Receivables - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

When updating site information via the customer screen using Order Management responsibility, the following error is displayed

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. Application: FND, Message Name: FND_GENERIC_MESSAGE, Tokens: MESSAGE = java.sql.SQLException: ORA-20001:
Operating Unit -1 does not exist in the target database. ORA-06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.GL_GLOBAL", line 65 ORA-06512: at line 1;


If you query same customer and make same changes using Accounts Receivable responsibility, the changes are saved without any problems

The profile option MO: Security Profile has been set at site level.  If the profile is unset, the operation can be performed without error.

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