My Oracle Support Banner

BATCH_NBR And BATCH_CD Columns For C1_USAGE_LOG (Doc ID 2649753.1)

Last updated on MARCH 20, 2020

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 and later
Information in this document applies to any platform.

Goal

**Examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

CCB - Oracle Utilities Customer Care and Billing
MDM - Oracle Utilities Meter Data Management

This KB is to delete deprecated columns BATCH_NBR and BATCH_CD in table C1_USAGE_LOG.

 

There is a discrepancy on C1_USAGE_LOG table between two environments:.

1st environment - 2.3.1 upgraded to 2.7.0.1, applied Jun 2019 cumulative patch and then upgraded to 2.7.0.3

Name Null Type
------------------ -------- --------------
...
CHAR_VAL_FK5 NOT NULL VARCHAR2(50)
BATCH_CD NOT NULL CHAR(8)
BATCH_NBR NOT NULL NUMBER(10)
USER_ID NOT NULL CHAR(8)
VERSION NOT NULL NUMBER(5)



2nd environment - 2.3.1 upgraded directly to 2.7.0.3

Name Null Type
------------------ -------- --------------
...
CHAR_VAL_FK5 NOT NULL VARCHAR2(50)
USER_ID NOT NULL CHAR(8)
VERSION NOT NULL NUMBER(5)

Is there any patch during the upgrade to 2.7.0.1 or cumulative patch or any patch for 2.7.0.1 that may have introduced these columns and where not added to 2.7.0.3?
 

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.