Search Results po_system_parameters_all

Overview

The PO_SYSTEM_PARAMETERS_ALL table is a critical setup and configuration table within the Oracle E-Business Suite Purchasing (PO) module. It functions as the central repository for organization-specific purchasing options and system-wide control parameters. In the multi-org architecture of Oracle EBS 12.1.1 and 12.2.2, the `_ALL` suffix and the presence of the `ORG_ID` column indicate that this table stores unique configuration sets for each operating unit defined in the application. The settings stored in this table govern default behaviors, account derivation rules, approval workflows, and other foundational processes for procurement transactions, making it essential for the correct operation of the Purchasing module.

Key Information Stored

The table's primary key (`PO_SYSTEM_PARAMETERS_PK`) is a composite of `LAST_UPDATE_DATE` and `ORG_ID`, underscoring the importance of the operating unit context for all configuration data. While the provided metadata does not list all columns, the foreign key relationships highlight several crucial fields. These include `ACCRUED_CODE_COMBINATION_ID`, which stores the default liability account for accruals; `DEFAULT_RATE_TYPE`, which links to `GL_DAILY_CONVERSION_TYPES` for currency conversion; and `LINE_TYPE_ID`, which links to `PO_LINE_TYPES_B` to define a standard purchasing line type. Other typical columns (inferred from standard functionality) control settings for document numbering, approval hierarchies, receipt tolerances, and buyer assignments.

Common Use Cases and Queries

This table is primarily referenced for configuration validation, troubleshooting, and operational reporting. A common administrative query retrieves the complete set of purchasing options for a specific operating unit to verify setup. For example: SELECT * FROM PO_SYSTEM_PARAMETERS_ALL WHERE ORG_ID = <operating_unit_id>;. Developers and functional consultants often join this table to other purchasing entities to understand the account derivation logic for a given transaction. A frequent reporting use case involves verifying the default accrual account across all operating units: SELECT ORG_ID, ACCRUED_CODE_COMBINATION_ID FROM PO_SYSTEM_PARAMETERS_ALL ORDER BY ORG_ID;. Direct data manipulation via DML is strongly discouraged; configurations should be updated exclusively through the official "Purchasing Options" form in the application UI.

Related Objects

As indicated by the foreign keys, PO_SYSTEM_PARAMETERS_ALL has direct dependencies on several other key application tables. The foreign key to `GL_CODE_COMBINATIONS` ensures the accrued account is valid. The link to `GL_DAILY_CONVERSION_TYPES` validates the default currency rate type. The relationship with `PO_LINE_TYPES_B` ensures the default line type is properly defined. Furthermore, this table is a parent to numerous transactional tables in Purchasing (like `PO_HEADERS_ALL` and `PO_LINES_ALL`), which inherit and utilize its parameters. The settings are also accessed by core Purchasing APIs and underlying packages that enforce business rules during requisition and purchase order processing.