Search Results as_pe_int_categories




Overview
Explore in AI Chat

Overview

The AS_PE_INT_CATEGORIES table is a core mapping and configuration table within the Oracle E-Business Suite (EBS) Sales Foundation module (AS). Residing in the OSM schema, its primary function is to establish a critical linkage between plan elements defined in the Oracle Sales Compensation (OSC) module and the forecasting engine. This table acts as a central hub, enabling the alignment of sales performance metrics, quotas, and compensation plans with specific product or service interest categories used for sales forecasting and analysis. Its existence is essential for ensuring data consistency and enabling integrated reporting between compensation management and sales forecasting processes in deployments of both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to store mapping identifiers. Its primary key, PE_INT_CATEGORY_ID, uniquely identifies each mapping record. The most significant foreign key column is QUOTA_ID, which links directly to a specific quota definition in the CN_QUOTAS_ALL table, thereby associating a quota with interest categories. The table further defines the type and specifics of the interest through INTEREST_TYPE_ID, which references AS_INTEREST_TYPES_B. For granular categorization, it holds references to primary and secondary interest codes via PRI_INTEREST_CODE_ID and SEC_INTEREST_CODE_ID, both linking to the AS_INTEREST_CODES_B table. This structure allows a single quota or plan element to be mapped to a hierarchy or combination of interest types and codes.

Common Use Cases and Queries

This table is primarily accessed during backend processes for quota validation, forecast roll-ups, and compensation calculations. A common reporting use case involves generating a list of all quotas mapped to a particular product interest for forecast accuracy analysis. For instance, to find all quota IDs associated with a specific primary interest code, one might execute a query such as: SELECT quota_id FROM osm.as_pe_int_categories WHERE pri_interest_code_id = <CODE_VALUE>;. Conversely, to audit the interest category mappings for a given quota, a join query is typical: SELECT cat.*, type.name FROM osm.as_pe_int_categories cat JOIN as_interest_types_b type ON cat.interest_type_id = type.interest_type_id WHERE cat.quota_id = <QUOTA_ID>;. This table is less frequently accessed directly by end-users and is more integral to system-driven integration workflows.

Related Objects

The AS_PE_INT_CATEGORIES table maintains defined foreign key relationships with several key tables in the Sales Foundation and Sales Compensation modules, as documented in the ETRM metadata:

  • CN_QUOTAS_ALL: Linked via the QUOTA_ID column. This is the central relationship that ties interest categories to a specific sales quota.
  • AS_INTEREST_TYPES_B: Linked via the INTEREST_TYPE_ID column. This defines the broad classification (type) of interest.
  • AS_INTEREST_CODES_B: Linked via two separate foreign keys: PRI_INTEREST_CODE_ID and SEC_INTEREST_CODE_ID. These tables provide the specific code values for primary and secondary interests, allowing for detailed categorization.

The primary key constraint AS_PE_INT_CATEGORIES_PK on the PE_INT_CATEGORY_ID column ensures the uniqueness of each mapping record within this integration framework.