My Oracle Support Banner

Repair Order DFF - Flexfield View Generator Error "Oracle Error 1403: ORA-01403: No Data Found (Doc ID 2449139.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

Oracle Depot Repair - Version 12.1.3 and later
Oracle Teleservice - Version 12.1.3 and later
Oracle Customer Care - Version 12.1.3 and later
Oracle Field Service - Version 12.1.3 and later
Information in this document applies to any platform.
The case depicted here occurred in Oracle Depot Repair.
However, this can be applied to any Descriptive Flexfield in the Oracle E-Business Suite.

Symptoms

When compiling the Repair Orders Descriptive Flexfield, it is completing with an error.

Error:

Oracle error 904: ORA-00904: : invalid identifier
ORA-06512: at "SYSTEM.AD_DDL", line 195
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].do_ddl(APPLSYS,
 CSD, 2, $statement$, CSD_REPAIRS_DFV): private_do_ddl(APPS, APPLSYS,
CSD, 2, $statement$, CSD_REPAIRS_DFV): do_cd_view(1, APPS, 2,
CSD_REPAIRS_DFV, $statement$): : do_apps_ddl(APPS, $statement$): :
substr($statement$,1,255)='CREATE OR REPLACE VIEW  CSD_REPAIRS_DFV
 (ROW_ID, "CONTEXT_VALUE", OEM_RMA__, Upgrade, Comment, Processed_Flag, Service_Now,   CONCATENATED_SEGMENTS)  
 AS SELECT ROWID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE20, ATTRIBUTE19,  '

View Name: CSD_REPAIRS_DFV

Name                            Null?    Type
------------------------------- -------- ----
VIEW_HAS_FAILED_CHECK_LOG_FILE           CHAR(61)
 
Steps:

- Define columns for the DFF
- Compile the DFF.

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


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