Search Results ap_system_parameters_all




Overview
Explore in AI Chat

Overview

The AP_SYSTEM_PARAMETERS_ALL table is a central configuration repository within Oracle E-Business Suite Payables (AP) module. It stores the system defaults and operational parameters that control the behavior of the Payables application for each operating unit. As a multi-org enabled table, it contains a distinct set of parameters for each ORG_ID, allowing for unique Payables configurations across different business units within a single installation. This table is fundamental to the setup and ongoing operation of Payables, defining critical accounting rules, default accounts, payment methods, and tolerance controls.

Key Information Stored

The table's primary key is a composite of SET_OF_BOOKS_ID and ORG_ID, establishing the foundational link between a ledger and an operating unit's configuration. Key columns store references to default accounts and control settings, many of which are foreign keys to other core tables. Based on the provided metadata, critical columns include BANK_ACCOUNT_ID for the primary payment bank account, and numerous code combination ID columns (e.g., DISC_LOST_CODE_COMBINATION_ID, GAIN_CODE_COMBINATION_ID) that define the default general ledger accounts for various transaction types like discounts, exchange rate gains and losses, and prepayments. Other significant columns configure default settings for the Automatic Withholding Tax (AWT) group (DEFAULT_AWT_GROUP_ID), the daily conversion rate type (DEFAULT_EXCHANGE_RATE_TYPE), and tolerance rules (referenced via AP_TOLERANCE_TE).

Common Use Cases and Queries

This table is primarily queried for configuration analysis, audit reporting, and troubleshooting. A common use case is to verify the default accounting flexfields assigned to an operating unit to ensure proper financial posting. Developers often reference it in custom reports or integrations to determine the correct default accounts or payment banks for a given ORG_ID. A typical diagnostic query retrieves the core parameters for a specific operating unit:

  • SELECT org_id, set_of_books_id, bank_account_id, default_exchange_rate_type FROM ap_system_parameters_all WHERE org_id = :p_org_id;

Another frequent pattern involves joining to GL_CODE_COMBINATIONS to translate the stored CCIDs into readable account segments for reporting on the complete account structure used for payables transactions.

Related Objects

As indicated by its extensive foreign key relationships, AP_SYSTEM_PARAMETERS_ALL is a hub table that references numerous other key Payables and General Ledger entities. It has direct foreign key relationships to CE_BANK_ACCT_USES_ALL and AP_BANK_ACCOUNTS_ALL for bank account setup, to multiple GL_CODE_COMBINATIONS for default accounts, and to AP_AWT_GROUPS for tax settings. The table is also referenced by application logic throughout the Payables module to retrieve configuration values. While not listed in the provided metadata, related views like AP_SYSTEM_PARAMETERS (the operating unit-specific view) provide a filtered access point, and setup forms in the "Payables Options" and "Financials Options" screens directly maintain records in this table.