Duplicated Item Poids Within Multischema
(Doc ID 1953725.1)
Last updated on FEBRUARY 03, 2019
Oracle Communications Billing and Revenue Management - Version 126.96.36.199.0 and later Information in this document applies to any platform.
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;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!