View as Audit Records fails to return entries because the Method name contains an Oracle reserved word - WKB100311
SYMPTOMS
- View as Audit Records fails to return the expected Audit Trail entries
- Audit trail entries related to the method are present in the audit trail
- ORA-00920 reported in Empower Message Center - WKB26448
ENVIRONMENT
- Empower
- View as function
- Audit Trail
CAUSE
The issue occurs when an Oracle reserved word is used in the name of a method or other DB object. The SQL query fails.
The customer method is named Impurity D and B_Compound.
It was shallow copied during project creation and there is an audit trail entry.
View as AUDIT RECORDS reports no entries.
The view as AUDIT RECORDS SQL query fails because the method name includes an AND.
The following is seen in the message center associated with the view as AUDIT RECORDS action:
FIX or WORKAROUND
Do not use Oracle reserved words in method names or any other database object names.
ADDITIONAL INFORMATION
When a search condition contains any words on the list of Oracle SQL reserved words, an Oracle error can occur. An example is when a system name contains one of these reserved keywords.
The following is the list of current Oracle SQL reserved keywords:
ACCESS, ADD, ALL, ALTER, AND, ANY, AS, ASC, AUDIT, BETWEEN, BY, CHAR, CHECK, CLUSTER, COLUMN, COMMENT, COMPRESS, CONNECT, CREATE, CURRENT, DATE, DECIMAL, DEFAULT, DELETE, DESC, DISTINCT, DROP, ELSE, EXCLUSIVE,EXISTS,FILE,FLOAT, FOR, FROM, GRANT, GROUP, HAVING, IDENTIFIED,IMMEDIATE, IN, INCREMENT,INDEX,INITIAL,INSERT, INTEGER, INTERSECT, INTO, IS, LEVEL, LIKE, LOCK,LONG,MAXEXTENTS,MINUS,MLSLABEL,MODE,MODIFY,NOAUDIT,NOCOMPRESS,NOT, NOWAIT,NULL, NUMBER,OF, OFFLINE,ON, ONLINE,OPTION, OR, ORDER, PCTFREE,PRIOR, PRIVILEGES, PUBLIC, RAW,RENAME,RESOURCE,REVOKE, ROW,ROWID,ROWNUM,ROWS, SELECT, SESSION, SET, SHARE,SIZE, SMALLINT, START,SUCCESSFUL,SYNONYM,SYSDATE,TABLE, THEN, TO, TRIGGER,UID,UNION, UNIQUE, UPDATE, USER, VALIDATE,VALUES, VARCHAR, VARCHAR2,VIEW, WHENEVER, WHERE, WITH
id100311, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, SUP