My Oracle Support Banner

Compile Descriptive Flexfield Ends In Error ORA-01403: no data found (Doc ID 2270228.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle U.S. Federal Financials - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

When compiling a descriptive flexfield, the following error occurs:


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
 FROM SYS.DUAL'


Steps to Reproduce:

Responsibility: System Administrator
Navigation
: Application > Flexfield > Descriptive > Segments

  1. Query the descriptive flexfield
  2. Compile the flexfield

 

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.