My Oracle Support Banner

X1-MIGSA Migrate SA Issue In Setting MDM SP ID (Doc ID 2903857.1)

Last updated on OCTOBER 25, 2022

Applies to:

Oracle Utilities Customer to Meter Base - Version to [Release 2.9]
Information in this document applies to any platform.


On : NA version, Environment Related

X1-MIGSA Migrate SA issue in setting MDM SP ID

MDM SP ID generated by X1-MIGSP is incorrectly set by X1-MIGSA.

A CCB-SP ID plus '00' is suffixed by X1-MIGSP to create an MDM-SP ID.

The MDM-SP ID is expected to have a "prefix" of '00' + CCB-SP ID, but X1-MIGSA expects a '00' + CCB-SP ID to get the MDM ID and generate the US ID.

Script X1ProcSAIds sets MDM SP by "00" + CCB SP ID, but the actual MDM SP ID generated by X1-MIGSP was CCB SP ID + "00".

Steps to reproduce

Run X1-MIGSP in full dataset.
Run X1-MIGP in full dataset.
Run X1-MIGSA. Batch process X1-MIGSA manually submitted in single thread. Failed test in 22A with sizable data/PROD volumes but limiting the process to 9 SA IDs only.




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

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