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 09, 2022
Applies to:
Oracle Human Resources - Version 12.1.3 and laterInformation 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'
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
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 |
| Cause |
| Solution |
| References |