My Oracle Support Banner

R12: The Concurrent Program "Compile All Flexfields" Ends in Error <APP-FND-00798: Invalid reference XLA_SRS_PERCL_LEDGERS in value set attached to segment Aging Period Name> after 19C Database Upgrade and Oracle EBS to release 12.2.4 (Doc ID 2970783.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Oracle Payables - Version 12.2.4 and later
Oracle Application Object Library - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms


When attempting to run the concurrent program Compile All Flexfields [Short Name: FDFCMPA] to compile all flexfields after 19C database upgrade and Oracle EBS to release 12.2.4, the following error occurs in the log:

---------------------------------------------------------
Application Id: 200
    Short Name: SQLAP
          Name: Payables
Flexfield Name: $SRS$.APXINAGE
         Title: $SRS$.APXINAGE

Compilation aborted for current descriptive flexfield...

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

Please check the WHERE clauses of your table validated value sets.
 
Continuing...

---------------------------------------------------------



The issue can be reproduced at will with the following steps:

  1. Upgrade database to 19C and Oracle EBS to release 12.2.4
  2. Login to Application Developer responsibility
  3. Compile all flexfields using concurrent program Compile All Flexfields (Short Name: FDFCMPA)
    View - Requests - Submit a New Request - Single Request - OK
  4. Check the LOG.

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.