Queries on UIM Data Migration & Sequence Names used for generating EntityId and IDs of Entities . (Doc ID 1625180.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Communications Unified Inventory Management - Version 7.2.2 and later
Information in this document applies to any platform.

Goal

Q1.You want to know the Sequence names which are used to genereate EntityIds of Entities.

Q2.You want to know the Sequence names which are used to genereate IDs of Entities.

Q3: You want to migrate the Data from other systems to UIM,
You want to know how to access nextval()?
 
Q4: You want to know the Behavior of the Sequences which are used for EntityID generation for the Entities.

Q5: Most Reliable Method to migrate the Data.

Q6. You do not want to shut down the application while creating the entities and manipulating the sequences. You are creating a procedure which will create those records on production environment and you cannot shut it down.

How can you achieve that without damaging the application and with no ids/entityids collision?

 

Solution

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