VW_EVENT_T Database View Invalid After Upgrading to PS20
Last updated on JULY 09, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 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:
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