Search Results csp_planning_parameters




Overview
Explore in AI Chat

Overview

The CSP_PLANNING_PARAMETERS table is a core master data table within the Oracle E-Business Suite Spares Management (CSP) module. It serves as the central repository for defining and storing the configuration rules that govern the planning and replenishment of spare parts inventory. Its primary role is to act as a parameter set that links specific inventory items, categories, or subinventories to the business rules used for forecasting demand, calculating safety stock, and identifying excess stock. This linkage is essential for executing the automated planning processes within CSP, ensuring that inventory levels are optimized according to predefined organizational policies.

Key Information Stored

The table's structure centers on a unique identifier, PLANNING_PARAMETERS_ID, which serves as the primary key. The critical data stored includes foreign key references that define the scope and rules for planning. Key columns typically include ORGANIZATION_ID to specify the inventory organization, and scoping columns such as CATEGORY_SET_ID, CATEGORY_ID, and SECONDARY_INVENTORY to target specific item groupings or stock locations. The core planning logic is dictated by references to rule tables: FORECAST_RULE_ID links to CSP_FORECAST_RULES_B for demand forecasting, EXCESS_RULE_ID to CSP_EXCESS_RULES_B for excess stock identification, and CALCULATION_RULE_ID to CSP_LOOP_CALC_RULES_B for safety stock and reorder point calculations. Additional columns often control planning horizons, review periods, and enablement flags.

Common Use Cases and Queries

A primary use case is the setup and maintenance of planning rules for different segments of the spare parts inventory. Analysts create distinct parameter records for different item categories or stocking locations, applying tailored forecasting and excess rules. Common reporting and validation queries include identifying all parameter sets for a given organization or verifying rule assignments. Sample SQL patterns include joining to referenced rule tables to display a complete parameter definition.

  • Listing Active Planning Parameters: SELECT planning_parameters_id, organization_id, forecast_rule_id FROM csp_planning_parameters WHERE NVL(disable_date, SYSDATE+1) > SYSDATE;
  • Validating Parameter Scope and Rules: SELECT cpp.*, msiv.segment1 item_number FROM csp_planning_parameters cpp, csp_product_populations cpop, mtl_system_items_b msiv WHERE cpp.planning_parameters_id = cpop.planning_parameters_id AND cpop.inventory_item_id = msiv.inventory_item_id AND cpp.organization_id = msiv.organization_id;

Related Objects

The CSP_PLANNING_PARAMETERS table is a central hub within the CSP schema, with documented relationships to several key tables. It references master data and rule definitions, and is itself referenced by transactional and setup entities.

  • Foreign Key References (This table references):
    • CSP_FORECAST_RULES_B via column: FORECAST_RULE_ID
    • CSP_EXCESS_RULES_B via column: EXCESS_RULE_ID
    • MTL_SECONDARY_INVENTORIES via columns: SECONDARY_INVENTORY, ORGANIZATION_ID
    • CSP_LOOP_CALC_RULES_B via column: CALCULATION_RULE_ID
    • MTL_CATEGORIES_B via column: CATEGORY_ID
    • MTL_CATEGORY_SETS_B via column: CATEGORY_SET_ID
  • Foreign Key References (Referenced by):