My Oracle Support Banner

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 FEBRUARY 06, 2019

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.

Changes

 

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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