Search Results ap_pol_schedule_options




Overview
Explore in AI Chat

Overview

The AP_POL_SCHEDULE_OPTIONS table is a core data structure within the Oracle E-Business Suite Payables (AP) module, specifically supporting the Policy Manager functionality in releases 12.1.1 and 12.2.2. It serves as a detailed rule repository for individual policy schedules. A policy schedule defines the specific conditions and constraints under which a business policy is applied, such as spending limits for different employee roles or locations. This table stores the granular, schedule-specific rules that link a high-level policy header to concrete operational parameters, enabling precise control and enforcement of financial and operational policies.

Key Information Stored

The table's primary purpose is to define the "who," "where," and "how much" for a policy schedule. Its key columns, as indicated by its foreign key relationships, establish critical linkages. The SCHEDULE_OPTION_ID serves as the unique primary key. The POLICY_ID column links the schedule rule back to its parent policy definition in the AP_POL_HEADERS table. The ROLE_ID is a pivotal column, referencing multiple HRMS objects (PER_JOBS, PER_GRADES, PER_ALL_POSITIONS) to specify the job, grade, or position to which the rule applies. The LOCATION_ID ties the rule to a specific operating location via the AP_POL_LOCATIONS_B table. Finally, the CURRENCY_CODE column, referencing FND_CURRENCIES, defines the monetary context for any amount-based limits or thresholds specified within the schedule rule.

Common Use Cases and Queries

This table is central to queries that validate transactions against corporate policies. A common use case is determining the applicable spending limit for an employee's expense report based on their job role and the trip location. System processes and custom reports frequently join this table to HR and policy header data. A typical SQL pattern involves filtering for active rules relevant to a specific policy, role, and location to retrieve the enforceable constraints.

  • Sample Query: Retrieving all schedule rules for a specific policy to audit coverage.
  • Use Case: A background engine validating invoice or expense line amounts against the currency-specific limit defined in the matching schedule option.
  • Use Case: Generating a report of all policies and their associated rules, grouped by role or location, for compliance review.

Related Objects

The AP_POL_SCHEDULE_OPTIONS table sits at the intersection of Payables Policy Manager and Human Resources data. Its documented foreign key relationships are fundamental to its operation:

  • AP_POL_HEADERS: Links via POLICY_ID to the master policy definition.
  • PER_JOBS, PER_GRADES, PER_ALL_POSITIONS: Links via ROLE_ID to HRMS objects defining the job, grade, or position governed by the rule.
  • AP_POL_LOCATIONS_B: Links via LOCATION_ID to define the applicable physical or operating location.
  • FND_CURRENCIES: Links via CURRENCY_CODE to establish the valid currency for financial limits.

These relationships ensure that policy enforcement is dynamically aligned with the organizational structure and operational setup defined elsewhere in the E-Business Suite.

  • Table: AP_POL_SCHEDULE_OPTIONS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_SCHEDULE_OPTIONS,  object_name:AP_POL_SCHEDULE_OPTIONS,  status:VALID,  product: AP - Payables ,  description: This table stores policy schedule-specific rules. ,  implementation_dba_data: AP.AP_POL_SCHEDULE_OPTIONS , 

  • Table: AP_POL_SCHEDULE_OPTIONS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_SCHEDULE_OPTIONS,  object_name:AP_POL_SCHEDULE_OPTIONS,  status:VALID,  product: AP - Payables ,  description: This table stores policy schedule-specific rules. ,  implementation_dba_data: AP.AP_POL_SCHEDULE_OPTIONS , 

  • Table: AP_POL_HEADERS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_HEADERS,  object_name:AP_POL_HEADERS,  status:VALID,  product: AP - Payables ,  description: This table stores the policy schedule header information. ,  implementation_dba_data: AP.AP_POL_HEADERS , 

  • Table: AP_POL_LOCATIONS_B 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_LOCATIONS_B,  object_name:AP_POL_LOCATIONS_B,  status:VALID,  product: AP - Payables ,  description: This table stores policy schedule location information. ,  implementation_dba_data: AP.AP_POL_LOCATIONS_B , 

  • Table: AP_POL_LOCATIONS_B 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_LOCATIONS_B,  object_name:AP_POL_LOCATIONS_B,  status:VALID,  product: AP - Payables ,  description: This table stores policy schedule location information. ,  implementation_dba_data: AP.AP_POL_LOCATIONS_B , 

  • Table: AP_POL_HEADERS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_HEADERS,  object_name:AP_POL_HEADERS,  status:VALID,  product: AP - Payables ,  description: This table stores the policy schedule header information. ,  implementation_dba_data: AP.AP_POL_HEADERS ,