Solution : https://service.sap.com/sap/support/notes/731 (SAP Service marketplace login required)
Summary :
An ORA-00904 error is encountered when an invalid column is specified in an SQL statement. For Oracle versions 9.2 and higher, the erroneous column's name is included in the error message. To identify the problematic table and column, review the SQL statement in trace files (ST11), short dumps (ST22), or the syslog (SM21). Activate error stacks using “ALTER SYSTEM SET EVENTS='904 trace name errorstack level 1'” to aid in debugging. Possible causes include SAP bugs, inconsistencies between R/3-DDIC and Oracle DDIC, incorrect SQL statements, or issues during upgrades. Solutions vary from fixing inconsistencies with SE11 to implementing specific SAP Notes or Oracle scripts.
Key words :
se11 -> <table> -> execute -> utilities -> database object -> check, se11 -> <table> -> execute -> utilities -> runtime object -> check, deviation oracle ddic <-> oracle release <-> oracle software 6, alter system set events = '904 trace, component bc-dwb-dic, connect <sapuser>/<password>select, latest oracle patch set, alter table <table> add, /oracle/<sid>/saptrace/usertrace, /oracle/<sid>/saptrace/background
Related Notes :
| 1401282 | Oracle explain: Error 904 after SAP Basis or EHP upgrade |
| 898244 | ORA-904 with the DBMS_STATS package |
| 692214 | USER_TAB_MODIFICATIONS not UPDATED after DROP PARTITION |
| 648203 | Database objects with INVALID status |
| 633914 | Error when executing DBMS_STATS |
| 321060 | Backup not possible in the MODPROF_TRANS phase |
| 12826 | ORA-00904 or EXP-00037 during database export |