Compile Descriptive Flexfield Ends In Error ORA-01403: no data found

(Doc ID 2270228.1)

Last updated on NOVEMBER 14, 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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms