Field Length Definition For External ID For Install Event Sync Is Not Uniform Across Application. (Doc ID 2300581.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

Oracle Utilities Meter Data Management - Version 2.1.0 and later
Oracle Utilities Smart Grid Gateway - Version 2.1.0 and later
Information in this document applies to any platform.

Symptoms

In Meter Data Management if a user submits a sync request with external id of length 254, only 50 characters will be stored since DB can accommodate of that length.


It is expected that the field length would be the same such that the large length submitted could make it all the way through. Due to this issue, users cannot use large external ids on install events

Steps for Example Scenario:
1. External Id for Install Event Sync is present as adhoc characteristic value [char type : D1-EXTID] on Install Event. Generally Adhoc characteristic value is of length 254 in OUAF.
2. On D1-SmartMeterInstallEvent BO, externalId [D1_IE_EXTERNAL_ID] -> is defined to be of length 60.
3. At DB Level, D1_ON_IE_VW view has definition of length 50 for EXT_PK_VALUE_1 which is where external id gets stored.




Cause

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