Profiles Couldn't Determine The Valid Values For Profile POR_OVERRIDE_CHARGE_ACCOUNT - POR: Charge Account Override

(Doc ID 2017596.1)

Last updated on SEPTEMBER 17, 2015

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

After upgrading to 12.2.4 from 12.1.3, there is now a sql validation error for profile POR_OVERRIDE_CHARGE_ACCOUNT. The last update date indicates this profile was updated by ORACLE 12.2.0 on 08-APr-2013.

From 12.1.3 (icxprf.ldt 120.30.12010000.9)
SQL="select lookup_code, meaning \"Charge Account Override\"
into :profile_option_value, :visible_option_value
from fnd_lookups
where lookup_type = 'YES_NO'"
Column="\"Charge Account Override\"(*)"

No error is thrown

From 12.2.4 (icxprf.ldt 120.35.12020000.6)
SQL=\"select lookup_code, meaning \\\"Charge Account Override\\\"\n\
into :profile_option_value, :visible_option_value\n\
from fnd_lookups\n\
where lookup_type = 'YES_NO'\"\n\
Column=\"\\\"Charge Account Override\\\"(*)\""

Error:
Profiles couldn't determine the valid values for profile POR_OVERRIDE_CHARGE_ACCOUNT. This problem is usually due to an error in the SQL validation for that profile. Use the 'Define Profiles'
form to fix the SQL Validation for the POR_OVERRIDE_CHARGE_ACCOUNT profile. This error may appear information about what was wrong with the SQL Validation.

If replaces the 12.2.4 sql validation version with the 12.1.3 version, no exception is thrown.

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