My Oracle Support Banner

Question On Logic Behind Main Customer Lookup In Oracle Utilities Analytics 2.5 For CC&B (Doc ID 2092914.1)

Last updated on AUGUST 24, 2020

Applies to:

Oracle Utilities Business Intelligence - Version 2.4.0.0.0 and later
Information in this document applies to any platform.

Goal



In most of the fact tables in Oracle Utilities Analytics (OUA) 2.5 (for Customer Care and Billing (CC&B)), the document "OUES_CCB_DataMap_2.5.0.0.1 .pdf" mentions PER_KEY as the Key for Main persion in the account. How is the internal logic for fetching the main person in the OUA code?
Does it use the MAIN_CUST_SW column or ACCT_REL_TYPE_CD from the CI_ACCT_PER table in CC&B?


 

Solution

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
Goal
Solution
References


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