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!
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.