My Oracle Support Banner

Duplicated Item Poids Within Multischema (Doc ID 1953725.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

We identified several duplicite item_t poid_id0 (around 1000) within multischema.
e.g.
POID_DB    POID_ID0           POID_TYPE        POID_REV    CREATED_T
1 286524033177397918 /item/cycle_forward 3 1407189688
2 286524033177397918 /item/U_O2       0 1407238001

We have identified that duplicated poids are generated only in ITEM_T table and duplicities are always caused by combination of system and usage items.
e.g.
in DB1 poid 286524033177397918 is /item/cycle_forward
in DB2 poid 286524033177397918 is /item/U_O2


We have set POID_IDS2 sequence.
In DB1 ODD increment by 2:
POID_IDS2 MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 2 START WITH 100101180579 CACHE 20;
In DB2 EVEN increment by 2:
POID_IDS2 MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 2 START WITH 100038027536 CACHE 20;

Cause

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.