BIC — Customer Intelligence(Obsolete)
14 documented tables · 73 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
BIC_MEASURE_ATTRIBS |
This table has the internal attributes for each measure. | hub |
BIC_MEASURES_ALL |
The list of measures will be seeded | satellite-leaning |
BIC_MEASURE_BUCKETS |
This table will store groups for Loyalty, Satisfaction and their child measures | hub-leaning |
BIC_CUSTOMER_SUMMARY_ALL |
Customer Intelligence Summary Information - for Org striped measures only | standalone |
BIC_PARTY_SUMM |
From Customer Summary table, the rows are transposed as columns for matrix reporting. i.e., Flattened table fo | satellite-leaning |
BIC_MEASURE_HIERARCHY |
Hierarchy of various measures, relating sub-measures to main measures | link |
BIC_BUCKET_VALUES |
Values are specified for groups belonging to measures which have lov_flag as ?Y? | link |
BIC_CATEGORY_HIERARCHY |
standalone | |
BIC_STANDARD_VALUES |
This table stores industry standard values for satisfaction | satellite-leaning |
BIC_PARTY_SUMMARY |
Customer Intelligence Summary information. This gets populated by the concurrent program 'Extract Customer Sum | satellite-leaning |
BIC_PARENT_CATEGORIES |
standalone | |
BIC_PARTY_STATUS_SUMM |
From Party Summary table, the rows are transposed as columns for matrix reporting. i.e., Flattened table for n | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.