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

Last updated on DECEMBER 29, 2015

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 OUA 2.5 (for 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

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