My Oracle Support Banner

Table EVENT_ESSENTIALS_T Doesn't Exist in BRM 12 Patchset 1 (Doc ID 2545596.1)

Last updated on FEBRUARY 23, 2021

Applies to:

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

Goal

On Oracle Communications Billing and Revenue Management (BRM) version 12.0.0.1.0, the Out-Of-The-Box (OOTB) table event_essentials_t doesn't exist in upgraded environment.

create table event_essentials_t (
obj_id0 number(38) not null,
balances_small varchar2(4000),
balances_large clob,
account_obj_id0 number(38),
end_t number(38)) tablespace pin00 initrans 64 storage (initial 1m next 100m maxextents unlimited pctincrease 0 freelists 32 )
lob (balances_large) store as ( tablespace pin00
enable storage in row initrans 32 storage (initial 1m next 100m maxextents unlimited pctincrease 0 freelists 40 )
);

Errors reported in pin_setup.log

-------------------------------------------
#------------- SQL Results:
Executing sqlplus -s /***@ORACLE_SID < "<PIN_HOME>/tmp/tmp.sql"
enable storage in row initrans 32 storage (initial 1m next 100m maxextents unlimited pctincrease 0 freelists 40 )
*
ERROR at line 8:
ORA-22853: invalid LOB storage option specification

However, the table should be created during installation itself, what could be the issue?

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!


In this Document
Goal
Solution
References


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