Solution : https://service.sap.com/sap/support/notes/308533 (SAP Service marketplace login required)
Key words :
Business Information Warehouse, temporary tables, query processing, DB02, BW, CLEAR_HLP_TBLS, ora-00942, truncate, SQLDBIF_DSQL2_OBJ_UNKNOWN
Related Notes :
648203 | Database objects with INVALID status |
449891 | Temporary database objects in BW 3.x |
373738 | BW: Avoiding the DROP VIEW for error analysis |
359835 | Design of the temporary tablespace in the BW System |
184905 | Collective note Performance BW 2.0 |
33814 | Warnings of inconsistencies between database & R/3 DDIC |