Last updated on SEPTEMBER 17, 2015
Applies to:Oracle iProcurement - Version 12.2.4 and later
Information in this document applies to any platform.
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
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\
where lookup_type = 'YES_NO'\"\n\
Column=\"\\\"Charge Account Override\\\"(*)\""
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms