Flexfield View Generator Error "Oracle error 1403: ORA-01403: no data found ORA-06512: at "SYSTEM.AD_DDL", line 2086" (Doc ID 2004754.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to compile Personal Analysis Key Flexfield, Flexfield View Generator errors out with the follow error.

ERROR
CREATE OR REPLACE VIEW PER_ANALYSIS_CRITERIA_KFV
(ROW_ID, ANALYSIS_CRITERIA_ID, ID_FLEX_NUM,
CONCATENATED_SEGMENTS,
PADDED_CONCATENATED_SEGMENTS,

...
...
...
FROM PER_ANALYSIS_CRITERIA

Oracle error 1403: ORA-01403: no data found
ORA-06512: at "SYSTEM.AD_DDL", line 2086
ORA-06512: at line 1 has been detected in afuddl() [6_xad].
do_array_ddl(APPLSYS, PER, 2, 1, 151, PER_ANALYSIS_CRITERIA_KFV): : get_apps_schema_name(0,APPLSYS): c_statement=select oracle_username from APPLSYS.fnd_oracle_userid where (install_group_num = :install_group_num or install_group_num = (select min(install_group_num) from APPLSYS.fnd_oracle_userid where 1 = decode (:install_group_num,0,1,2) and read_only_flag = 'U')) and read_only_flag = 'U' : : substr($statement$,1,255)=''
CREATE OR REPLACE VIEW PER_ANALYSIS_CRITERIA_KFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL

Oracle error 1403: ORA-01403: no data found
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, PER, 2, $statement$, PER_ANALYSIS_CRITERIA_KFV): : get_apps_schema_name(0,APPLSYS): c_statement=select oracle_username from APPLSYS.fnd_oracle_userid where (install_group_num = :install_group_num or install_group_num = (select min(install_group_num) from APPLSYS.fnd_oracle_userid where 1 = decode (:install_group_num,0,1,2) and read_only_flag = 'U')) and read_only_flag = 'U' : : substr($statement$,1,255)='CREATE OR REPLACE VIEW PER_ANALYSIS_CRITERIA_KFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL'



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

     1. Add a new value set to one of the Personal Analysis KFF segments.

     2. Compile the structure.

     3. The 'Flexfield View Generator' errors out.

     4. After removing the value set also the same error continues.



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