Search Results as_sales_credits_denorm




Overview
Explore in AI Chat

Overview

The AS_SALES_CREDITS_DENORM table is a core denormalized data repository within the Oracle E-Business Suite Sales Foundation module (AS). Its primary role is to consolidate and store comprehensive opportunity and sales credit information from multiple transactional tables into a single, query-optimized structure. This denormalization is a standard performance optimization technique in EBS, designed to support complex reporting, analytics, and dashboard functionalities without requiring expensive joins across numerous base tables during runtime. The table is owned by the OSM schema and is valid for both releases 12.1.1 and 12.2.2.

Key Information Stored

The table's description indicates it denormalizes data from a wide array of source tables, including AS_LEADS_ALL, AS_LEAD_LINES_ALL, AS_SALES_CREDITS, and master data tables for parties, sales groups, and personnel. While the specific column list is not detailed in the provided metadata, the foreign key relationships reveal the critical identifiers and attributes it stores. The primary key is SALES_CREDIT_ID, linking it directly to the transactional AS_SALES_CREDITS table. Other essential foreign key columns include LEAD_ID, LEAD_LINE_ID, CUSTOMER_ID, SALESFORCE_ID, SALES_STAGE_ID, and various INTEREST_CODE_IDs. These columns collectively store a flattened view of the opportunity lifecycle, encompassing the involved customer, sales representative, product interest, current stage, probability, and competitive landscape.

Common Use Cases and Queries

This table is predominantly used for performance-sensitive reporting scenarios. Common use cases include generating real-time sales pipeline dashboards, calculating aggregate sales credit commissions, performing territory performance analysis, and running historical win/loss reports. Queries against this table avoid complex multi-table joins, leading to faster execution. A typical reporting query might aggregate opportunity value by sales group and stage:

Another common pattern is joining to resource or party tables for descriptive information, using the predefined foreign keys such as SALESFORCE_ID or CUSTOMER_ID.

Related Objects

The table maintains extensive foreign key relationships, integrating it deeply into the Sales and CRM data model. Key documented relationships include: