Search Results fst_sales_category_id




Overview
Explore in AI Chat

Overview

The AS_FST_SALES_CATEGORIES table is a core data object within the Oracle E-Business Suite (EBS) Sales Foundation module (AS). Functioning as a resolving or intersection table, its primary role is to establish and manage the many-to-many relationship between forecast categories (AS_FORECAST_CATEGORIES) and interest types (AS_INTEREST_TYPES_B). This table is essential for linking sales forecasting classifications with specific customer or product interest types, thereby enabling complex sales analytics, planning, and worksheet functionality within the application. It resides in the OSM schema and is a validated, active table in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers on its primary key and two critical foreign key relationships. The primary identifier is the FST_SALES_CATEGORY_ID column, a unique system-generated key for each relationship record. The two central data columns are FORECAST_CATEGORY_ID and INTEREST_TYPE_ID. These columns store the foreign keys that resolve the relationship, pointing to specific records in the AS_FORECAST_CATEGORIES_B and AS_INTEREST_TYPES_B tables, respectively. Each row in this table represents a single, valid association between one forecast category and one interest type.

Common Use Cases and Queries

This table is primarily used in backend processes for sales forecasting and production planning. A common use case is validating or retrieving the permissible interest types for a given forecast category when building sales worksheets or generating forecast reports. For instance, an application process might query this table to populate a list of values. A typical analytical query would join this resolving table to its parent tables to produce a human-readable mapping:

  • SELECT fst.fst_sales_category_id, fc.forecast_category_name, it.interest_type_name FROM as_fst_sales_categories fst, as_forecast_categories_b fc, as_interest_types_b it WHERE fst.forecast_category_id = fc.forecast_category_id AND fst.interest_type_id = it.interest_type_id;

Direct queries or modifications by end-users are rare; interaction is typically mediated through the application's standard user interfaces and APIs.

Related Objects

AS_FST_SALES_CATEGORIES is a central node in a small but critical data model. Its documented relationships, as per the provided metadata, are as follows:

  • Parent Tables (Foreign Key Constraints): The table draws its valid domain values from two reference tables.
    • AS_FORECAST_CATEGORIES_B: Linked via the column AS_FST_SALES_CATEGORIES.FORECAST_CATEGORY_ID.
    • AS_INTEREST_TYPES_B: Linked via the column AS_FST_SALES_CATEGORIES.INTEREST_TYPE_ID.
  • Child Table (Referenced by Foreign Key): The table's primary key is referenced by a transactional table.
    • AS_PROD_WORKSHEET_LINES: This table stores a foreign key, AS_PROD_WORKSHEET_LINES.FST_SALES_CATEGORY_ID, to associate individual worksheet lines with a specific forecast category and interest type combination.
  • Table: AS_FST_SALES_CATEGORIES 12.1.1

    owner:OSM,  object_type:TABLE,  fnd_design_data:AS.AS_FST_SALES_CATEGORIES,  object_name:AS_FST_SALES_CATEGORIES,  status:VALID,  product: AS - Sales Foundation ,  description: Resolving table between AS_FORECAST_CATEGORIES and AS_INTEREST_TYPES_B ,  implementation_dba_data: OSM.AS_FST_SALES_CATEGORIES , 

  • Table: AS_FST_SALES_CATEGORIES 12.2.2

    owner:OSM,  object_type:TABLE,  fnd_design_data:AS.AS_FST_SALES_CATEGORIES,  object_name:AS_FST_SALES_CATEGORIES,  status:VALID,  product: AS - Sales Foundation ,  description: Resolving table between AS_FORECAST_CATEGORIES and AS_INTEREST_TYPES_B ,  implementation_dba_data: OSM.AS_FST_SALES_CATEGORIES , 

  • View: AS_FST_SALES_CATEGORIES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:AS.AS_FST_SALES_CATEGORIES_V,  object_name:AS_FST_SALES_CATEGORIES_V,  status:VALID,  product: AS - Sales Foundation ,  description: This view refers to AS_INTEREST_TYPES_TL instead of view AS_INTEREST_TYPES_VL for the performance tuning considerations. Every interest type id in AS_FST_SALES_CATEGORIES will have corresponding entry in AS_INTEREST_TYPES_TL ,  implementation_dba_data: APPS.AS_FST_SALES_CATEGORIES_V , 

  • View: AS_FST_SALES_CATEGORIES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:AS.AS_FST_SALES_CATEGORIES_V,  object_name:AS_FST_SALES_CATEGORIES_V,  status:VALID,  product: AS - Sales Foundation ,  description: This view refers to AS_INTEREST_TYPES_TL instead of view AS_INTEREST_TYPES_VL for the performance tuning considerations. Every interest type id in AS_FST_SALES_CATEGORIES will have corresponding entry in AS_INTEREST_TYPES_TL ,  implementation_dba_data: APPS.AS_FST_SALES_CATEGORIES_V ,