My Oracle Support Banner

Unable To Enable Operation Resources Descriptive Flexfield (DFF) (Doc ID 2245760.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.
View
ORA-00904: : invalid identifier

Goal

When attempting to enable Operation Resources DFF and compile the Descriptive Segment of "Operation Resources",
the following error occurs in the Flexfield View Generator program.

Error

Oracle error 904: ORA-00904: : invalid identifier
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, BOM, 2, $statement$, BOM_STD_OP_RESOURCES_DFV): private_do_ddl(APPS, APPLSYS, BOM, 2, $statement$, BOM_STD_OP_RESOURCES_DFV): do_cd_view(1, APPS, 2, BOM_STD_OP_RESOURCES_DFV, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW BOM_STD_OP_RESOURCES_DFV
(ROW_ID, "CONTEXT_VALUE", 1,
CONCATENATED_SEGMENTS)
AS SELECT ROWID, ATTRIBUTE_CATEGORY, (DECODE (ATTRIBUTE_CATEGORY, '1006', ATTRIBUTE1, NULL)),
(DECODE (ATTRIBUTE_CATEGORY,
'1006', ATTR'
CREATE OR REPLACE VIEW BOM_STD_OP_RESOURCES_DFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL


 

Solution

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
Goal
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.