BIC Tables (14)
BIC - Customer Intelligence(Obsolete) — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
BIC_CUSTOMER_SUMMARY_ALL |
18 | Customer Intelligence Summary Information - for Org striped measures only |
BIC_DEBUG |
4 | This table stores the debug messages. |
BIC_LC_SETUP_ALL |
15 | Lifecycle related Setup information |
BIC_MEASURES_ALL |
15 | The list of measures will be seeded |
BIC_MEASURE_ATTRIBS |
15 | This table has the internal attributes for each measure. |
BIC_MEASURE_BUCKETS |
13 | This table will store groups for Loyalty, Satisfaction and their child measures |
BIC_MEASURE_HIERARCHY |
11 | Hierarchy of various measures, relating sub-measures to main measures |
BIC_PARTY_STATUS_SUMM |
17 | From Party Summary table, the rows are transposed as columns for matrix reporting. i.e., Flattened table for non-org striped measures. |
BIC_PARTY_SUMM |
90 | From Customer Summary table, the rows are transposed as columns for matrix reporting. i.e., Flattened table for org striped measures. |
BIC_PARTY_SUMMARY |
18 | Customer Intelligence Summary information. This gets populated by the concurrent program 'Extract Customer Summary' - for non-Org striped m |
BIC_PERIODS |
15 | GL Periods information, populated by 'Extract Calendar' concurrent program |
BIC_PROFILE_VALUES_ALL |
19 | Activation and Retention related setup information |
BIC_RELATIONSHIP_TYPES |
8 | |
BIC_STANDARD_VALUES |
13 | This table stores industry standard values for satisfaction |