Wednesday, December 8, 2021

Oracle error 904: ORA-00904: : invalid identifier

 Oracle error 904: ORA-00904: : invalid identifier

ORA-06512: at "SYSTEM.AD_DDL", line 2376

ORA-06512: at line 1 has been detected in afuddl() [6_xad].

do_array_ddl(APPLSYS, PA, 2, 1, 179, PA_EVENTS_DFV): private_do_array_ddl(APPS, APPLSYS, PA, 2, 1, 179, PA_EVENTS_DFV): do_array_c_view(1, APPS, PA_EVENTS_DFV, 1, 179): array_assign_and_execute(APPS, 1, 179, FALSE): : do_apps_array_ddl(APPS, 1, 179, FALSE): : substr($statement$,1,255)='CREATE OR REPLACE VIEW  PA_EVENTS_DFV 

 (ROW_ID, "CONTEXT_VALUE", PO_Number, PO_Line_Number, Employee, Quantity, Unit_Price, Item_Code, UOM, Attachment, 1111_TRANSACTION_NUM, PO_Line_Numb_,  

 CONCATENATED_SEGMENTS)  

 AS SELECT ROWID, ATTRIBUTE_CATEGORY,'

CREATE OR REPLACE VIEW PA_EVENTS_DFV 

 AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE 

 FROM SYS.DUAL


+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+



+---------------------------------------------------------------------------+

No completion options were requested.


Output file size: 

866



Output is not being printed because:

The print option has been disabled for this report.




Solution:


Check the Column Names, Make sure Column name shouldn't start with Number or Special Characters

No comments:

Post a Comment