Return
-
Title
Stat 7.0 raises error ORA-00904: "STAT_OAENV_DETAILS"."SUDO_USER": invalid identifier” -
Description
Clicking on the Server button for an EBS Environment, the error below is raised:
ORA-00904: "STAT_OAENV_DETAILS"."SUDO_USER": invalid identifier”
-
Cause
It's been identified as a historical script defect, corrected by STAT-6336.
-
Resolution
Solution:
While the defect STAT-6336 is not available, apply the workaround below.
From a SQL*Plus or Toad session against the Stat repository, run the following statement:
ALTER TABLE STAT.STAT_OAENV_DETAILS ADD SUDO_USER VARCHAR2(50 CHAR);