Search Results strategic_objective_id

Overview

The table AS_AP_STRTGC_OBJECTIVES is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Sales Foundation (AS) module. Owned by the OSM schema, its primary function is to store all strategic objectives defined for individual account plans. An account plan is a strategic sales tool used to manage key customer relationships, and this table serves as the repository for the high-level goals and targets established within those plans. It forms a critical link between the overarching account strategy and the tactical execution items, enabling structured sales performance management and tracking.

Key Information Stored

The table's structure is designed to capture the objective's definition, ownership, and relationship to the broader account plan. While the full column list is not provided in the metadata, the documented primary and foreign keys reveal its essential components. The primary key is STRATEGIC_OBJECTIVE_ID, a unique identifier for each objective record. A critical foreign key is ACCOUNT_PLAN_ID, which links each objective to its parent plan in the AS_AP_ACCOUNT_PLANS table. Another significant foreign key is OWNER_SALESFORCE_ID, referencing JTF_RS_RESOURCE_EXTNS, which ties the objective to a specific salesperson or resource responsible for its execution. Typical columns in such a table would also include fields for the objective description (OBJECTIVE_NAME, DESCRIPTION), status (STATUS_CODE), target metrics, creation dates, and last update information.

Common Use Cases and Queries

This table is central to reporting and analytics on account planning effectiveness. Common use cases include generating a list of all strategic objectives for a specific account plan, assessing the workload and objectives assigned to a particular sales resource, and tracking the status of strategic goals across the sales organization. A typical query would join this table to its related entities to produce actionable reports.

• Objectives by Account Plan: SELECT * FROM osm.as_ap_strtgc_objectives WHERE account_plan_id = <plan_id> ORDER BY strategic_objective_id;
• Objectives by Owner: SELECT aps.objective_name, aps.description, ap.plan_name FROM osm.as_ap_strtgc_objectives aps JOIN osm.as_ap_account_plans ap ON aps.account_plan_id = ap.account_plan_id WHERE aps.owner_salesforce_id = <resource_id>;
• Reporting for Plan Review: Queries often aggregate data from this table to show counts of objectives per plan or status, providing a high-level dashboard view of strategic planning activity.

Related Objects

The AS_AP_STRTGC_OBJECTIVES table exists within a defined hierarchy and has key dependencies, as indicated by its foreign keys.

• AS_AP_ACCOUNT_PLANS: This is the primary parent table. Every strategic objective must be associated with a single account plan record via the ACCOUNT_PLAN_ID foreign key.
• JTF_RS_RESOURCE_EXTNS: This table stores detailed information about sales resources and territories. The OWNER_SALESFORCE_ID foreign key establishes the resource responsible for the objective.
• Downstream Objects: While not specified in the metadata, it is architecturally common for this table to be referenced by child tables storing tactical initiatives, action items, or key performance indicators (KPIs) that roll up to a strategic objective. It is also likely the base for several Oracle reporting views within the AS module.