EVENT_BILLING_TAXES_T Non-unique Records (Doc ID 1304041.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0 and later   [Release: 7.4.0 and later ]
Information in this document applies to any platform.

Symptoms

Consider the below scenario of a customer :

In the BRM database we expect the records to be unique based on identifiers: poid_id0 or obj_id0 or combination obj_id0 and rec_id. This assumption is used to uniquely identify data that shall be loaded from BRM to our data warehouse (DWH). In case DWH already downloaded the unique record, it is not downloaded in future run(s)).

During test we found, that our customized table EVENT_BILLING_TAXES_T has non-unique key combination obj_id0, rec_id (see below). Because of this, merge into the target table in DWH failed. 

With testnap:

robj - 0.0.0.2 /event 27686582396718167
# number of field entries allocated 60, used 59
0 PIN_FLD_POID           POID [0] 0.0.0.2 /event/billing/cycle/tax 27686582396718167 0
0 PIN_FLD_ACCOUNT_OBJ    POID [0] 0.0.0.2 /account 162555 0
0 PIN_FLD_NAME            STR [0] "Billing Event Log"
0 PIN_FLD_SYS_DESCR       STR [0] "Cycle Tax (acct)"
0 PIN_FLD_TAX_LOCALES     STR [0] ""
0 PIN_FLD_TAX_SUPPLIER    INT [0] 1
0 PIN_FLD_USERID         POID [0] 0.0.0.2 /service/pcm_client 1 115
0 PIN_FLD_BAL_IMPACTS   ARRAY [0] allocated 22, used 22
1     PIN_FLD_ACCOUNT_OBJ    POID [0] 0.0.0.2 /account 162555 11
1     PIN_FLD_BAL_GRP_OBJ    POID [0] 0.0.0.2 /balance_group 162375 1
1     PIN_FLD_ITEM_OBJ       POID [0] 0.0.0.2 /item/cycle_tax 161903 0
1     PIN_FLD_PERCENT      DECIMAL [0] 0.23
1     PIN_FLD_PRODUCT_OBJ    POID [0] 0.0.0.0  0 0
1     PIN_FLD_QUANTITY     DECIMAL [0] 81.96
1     PIN_FLD_RATE_OBJ       POID [0] 0.0.0.0  0 0
1     PIN_FLD_RATE_TAG        STR [0] "Tax"
1     PIN_FLD_RESOURCE_ID     INT [0] 985
0 PIN_FLD_TAX_JURISDICTIONS  ARRAY [0] allocated 20, used 8
1     PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] -81.96
1     PIN_FLD_AMOUNT_GROSS DECIMAL [0] -81.96
0 PIN_FLD_TAXES         ARRAY [0] allocated 20, used 7
1     PIN_FLD_AMOUNT       DECIMAL [0] -81.96
1     PIN_FLD_GEOCODE         STR [0] ""
1     PIN_FLD_RESOURCE_ID     INT [0] 985
1     PIN_FLD_TAXPKG_TYPE    ENUM [0] 0
0 PIN_FLD_TAXES         ARRAY [0] allocated 20, used 7
1     PIN_FLD_AMOUNT       DECIMAL [0] 81.96
1     PIN_FLD_GEOCODE         STR [0] ""
1     PIN_FLD_RESOURCE_ID     INT [0] 985
1     PIN_FLD_TAXPKG_TYPE    ENUM [0] 0

Cause

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