My Oracle Support Banner

Purge_audit_tables Fails With ORA-00904 (Doc ID 2015900.1)

Last updated on MARCH 01, 2019

Applies to:

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


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

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


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



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.