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

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