Purge_audit_tables Fails With ORA-00904 (Doc ID 2015900.1)

Last updated on JANUARY 18, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

Customer has upgraded from 6.7 to 7.5 PS8. After the upgrade while running the script "purge_audit_tables.pl" , it fails with error ORA-00904.

Syntax:
purge_audit_tables.pl report -t au_collections_action -d <Date> -l "${ORACLE_USR}/${ORACLE_PWD_CLEAR}@${ORACLE_SID}"

 

Error:
purge_audit_tables.pl: ERROR: SQLPLUS failed (exitcode = 0)
EXCEPTION ERROR -904ORA-00904: "POID_ID0": invalid identifier
DECLARE
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at line 44
ORA-00904: "POID_ID0": invalid identifier

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms