My Oracle Support Banner

R12 E-Business Suite Flexfield Fails To Compile With "Error APP-FND-00798 : Invalid reference " For GL_SRS_% Valuesets (Doc ID 757309.1)

Last updated on MARCH 08, 2023

Applies to:

Oracle General Ledger - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Oracle Application Object Library - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

E-business Suite Application Object Library, Flexfield related issues

 

 

 

 

 

When attempting to compile a Flexfield the following error is received:

Application Id: 101
Short Name: SQLGL
Name: General Ledger
Flexfield Name: $SRS$.RPU_CC_ANALYSIS
Title: $SRS$.RPU_CC_ANALYSIS

Compilation aborted for current descriptive flexfield...

APP-FND-00798: Invalid reference GL_SRS_COA_UNVALIDATED in value set attached to segment Page Break Segment

Please check the WHERE clauses of your table validated value sets

APP-FND-00798: Invalid reference GL_SRS_LEDGER_NO_SETS_STORE_ID in value set attached to segment Budget

APP-FND-00798: Invalid reference GL_SRS_LEDGER_ID_UNVALIDATED in value set attached to segment Period Name

APP-FND-00798: Invalid reference GL_SRS_ACCTANL_BALANCE_TYPE in value set attached to segment Budget or Encumbrance

$SRS$.RPU_CC_ANALYSIS indicates this is a parameter flexfield attached to the concurrent program report RPU_CC_ANALYSIS.

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

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