My Oracle Support Banner

VW_EVENT_T Database View Invalid After Upgrading to PS20 (Doc ID 2416029.1)

Last updated on FEBRUARY 24, 2021

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


After upgrading BRM from PS15 to PS20, one of the database views, VW_EVENT_T, on EVENT_T table is invalid and can not be compiled as one of the column has been deleted from EVENT_T table.

The COMPACT_SUB_EVENT column has been removed from the EVENT_T table in PS20 however VW_EVENT_T still references the column hence below error is reported.

Error while compiling the view:


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.