Search Results oe_bis_cust_sat_t2




Overview
Explore in AI Chat

Overview

OE_BIS_CUST_SAT_T2 is a Business Intelligence System (BIS) summary table owned by the OE (Order Entry) schema in Oracle E-Business Suite. It is a denormalized reporting structure designed to store customer sales activity and satisfaction metrics aggregated across multiple business dimensions, including set of books, legal entity, operating unit, inventory organization, item, category, customer, geography, and accounting period. The table is part of the Order Management BI infrastructure that supports Oracle Daily Business Intelligence and related analytical reporting for order entry operations.

Based on the heuristic Data Vault classification mined from its foreign key structure, this table is modeled as a standalone object. In Data Vault terms, this suggests the table functions outside a traditional hub-link-satellite chain rather than acting as a hub, link, or satellite itself. That classification reflects the fact that the only documented foreign key — LEGAL_ENTITY_ID referencing FV_LEGAL_ENTITIES — is a single outbound reference, and the table otherwise consists of pre-joined descriptive and quantitative attributes rather than normalized business keys.

Key Information Stored

The table contains 31 documented columns. The most operationally significant are:

No surrogate primary key or unique business key index is documented in the ETRM metadata. The combination of dimension columns — set of books, legal entity, operating unit, organization, item, customer, and period — effectively serves as the business grain of the summary, while HEADER_ID and LINE_ID provide lineage to source order transactions.

Common Use Cases and Queries

This table typically supports sales performance dashboards, customer satisfaction analysis, and order management KPIs. Typical queries aggregate the sales measures across the descriptive dimensions:

  • Net sales by customer, period, and operating unit: SELECT customer_name, month_period, SUM(net_sales) FROM oe_bis_cust_sat_t2 GROUP BY customer_name, month_period;
  • Returns analysis as a percentage of delivered sales: SELECT category_desc, SUM(ret_sales)/SUM(del_sales) FROM oe_bis_cust_sat_t2 GROUP BY category_desc;
  • Regional and country-level revenue rollups using AREA, COUNTRY, and REGION.
  • Year-over-year comparisons by joining YEAR_PERIOD against prior-period rows.

Because the table is pre-aggregated, it is best suited to analytical reporting rather than transactional reconciliation; drill-through to order detail should use HEADER_ID and LINE_ID.

Related Objects

These objects provide the surrounding transactional and master-data context that the summary table abstracts into a single reporting structure.