My Oracle Support Banner

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

Last updated on JULY 09, 2018

Applies to:

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

Goal

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:

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.