Search Results financials_system_params_all

Overview

The FINANCIALS_SYSTEM_PARAMS_ALL table is a core setup and configuration table within the Oracle Payables (AP) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central repository for financial system parameters and defaults that govern the behavior of the Payables application. As a multi-organization enabled table, denoted by the "_ALL" suffix and the ORG_ID column, it stores distinct parameter sets for each operating unit. Its primary role is to define critical accounting, currency, and control defaults that are applied during invoice and payment processing, ensuring consistent financial operations across the enterprise.

Key Information Stored

The table's structure is defined by its primary key, a composite of SET_OF_BOOKS_ID and ORG_ID, linking configuration to a specific ledger and operating unit. Key columns store essential default values, including the INVOICE_CURRENCY_CODE and PAYMENT_CURRENCY_CODE. Crucially, it stores numerous foreign keys to GL_CODE_COMBINATIONS, which define default accounting flexfields for central processes such as the accounts payable liability account (ACCTS_PAY_CODE_COMBINATION_ID), prepayments, discounts taken, and expense clearing. It also holds references to encumbrance types for requisitions, purchase orders, and invoices, linking Payables to budgetary control in General Ledger. Additional columns like BILL_TO_LOCATION_ID and SHIP_TO_LOCATION_ID provide default values for transactional data.

Common Use Cases and Queries

This table is primarily referenced for reporting on system setup, troubleshooting accounting issues, and validating configuration during implementations or upgrades. A common use case is identifying the default liability or prepayment accounts for a given operating unit. Sample queries include retrieving the complete set of parameters for a specific ledger and operating unit, or joining with GL_CODE_COMBINATIONS to get the concatenated segment values for key accounts. For instance:

• SELECT * FROM ap.financials_system_params_all WHERE org_id = 123;
• SELECT fsp.org_id, gcc.segment1, gcc.segment2 FROM ap.financials_system_params_all fsp, gl_code_combinations gcc WHERE fsp.accts_pay_code_combination_id = gcc.code_combination_id AND fsp.set_of_books_id = 1;

Direct data manipulation via DML is strongly discouraged; setup should be performed exclusively through the Oracle Payables "Financials Options" form, which maintains all necessary business logic and validation.

Related Objects

FINANCIALS_SYSTEM_PARAMS_ALL maintains extensive foreign key relationships, primarily with General Ledger and foundational tables. As documented, key relationships include:

• GL_SETS_OF_BOOKS_11I: via SET_OF_BOOKS_ID, linking parameters to a specific ledger.
• FND_CURRENCIES: via INVOICE_CURRENCY_CODE and PAYMENT_CURRENCY_CODE for currency validation.
• GL_CODE_COMBINATIONS: via numerous columns including ACCTS_PAY_CODE_COMBINATION_ID, PREPAY_CODE_COMBINATION_ID, DISC_TAKEN_CODE_COMBINATION_ID, RES_ENCUMB_CODE_COMBINATION_ID, RATE_VAR_CODE_COMBINATION_ID, RATE_VAR_GAIN_CCID, RATE_VAR_LOSS_CCID, and EXPENSE_CLEARING_CCID for default accounting.
• GL_ENCUMBRANCE_TYPES: via REQ_ENCUMBRANCE_TYPE_ID, PURCH_ENCUMBRANCE_TYPE_ID, and INV_ENCUMBRANCE_TYPE_ID for budgetary control integration.
• HR_LOCATIONS_ALL: via BILL_TO_LOCATION_ID and SHIP_TO_LOCATION_ID for default address information.