My Oracle Support Banner

EVENT_BILLING_TAXES_T Non-unique Records (Doc ID 1304041.1)

Last updated on FEBRUARY 06, 2024

Applies to:

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


Consider the below scenario:

In the BRM database, expect 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 data warehouse (DWH). In case DWH already downloaded the unique record, it is not downloaded in future runs.

During test found that 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:




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.