Last updated on MAY 26, 2017
Applies to:Oracle U.S. Federal Financials - Version 12.2.5 and later
Information in this document applies to any platform.
When attempting to recompile descriptive flexfield definitions the concurrent request ends in error. Attached are the log and output from the Flexfield View Generator concurrent request.
Oracle error 1403: ORA-01403: no data found
ORA-06512: at "SYSTEM.AD_DDL", line 188
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, JG, 2, $statement$, AR_CASH_RECEIPTS_ALL2_DFV): private_do_ddl(APPS, APPLSYS, JG, 2, $statement$, AR_CASH_RECEIPTS_ALL2_DFV): do_cd_view(1, APPS, 2, AR_CASH_RECEIPTS_ALL2_DFV, $statement$): : get_apps_schema_name(1,APPS): c_statement=select oracle_username from APPS.fnd_oracle_userid where (install_group_num = :install_group_num or install_group_num = (select min(install_group_num) from APPS.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 AR_CASH_RECEIPTS_ALL2_DFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
The issue can be reproduced at will with the following steps:
1. Go to Flexfield form
2. Recompile flexfield
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