Ukraine Localizations: Compiling Value Set CLE_F244_AR_EXCHREF_VS is Throwing Error ORA-00904: CLE_F244_ARFCEX_PKG.FN_GDFF_VALUE - Invalid Identifier (Doc ID 2861675.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

While clicking on "Test" button on value set CLE_F244_AR_EXCHREF_VS associated with descriptive flexfield - JG_AR_CASH_RECEIPTS  Context Name JE.UA.ARXRWMAI.CLE_FCE, system is throwing below error:

ERROR
-----------------------
ORA-00904: CLE_F244_ARFCEX_PKG.FN_GDFF_VALUE: invalid identifier

STEPS TO REPRODUCE THE ISSUE
-----------------------
1. Query the flexfield - JG_AR_CASH_RECEIPTS from Descriptive flexfields form.
(N):- Application Developer -> Flexfield -> Descriptive Flexfield
2. Select the Context code - JE.UA.ARXRWMAI.CLE_FCE,  This context code is added for "Receipt Number for FCE Ukraine".
3. Click on Test button.

Changes

Cause

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