Results for “accounting_method_option”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_SYSTEM_PARAMETERS_ALL is the Payables system defaults and parameters table in the Oracle E-Business Suite Payables (AP) module, owned by the AP schema. It stores the setup-level control values that drive Payables processing behavior, including accounting options, currency defaults, payment handling, tax configuration, matching rules, and default accounting flexfield combinations. The table exists in both EBS 12.1.1 and 12.2.2 and remains structurally consistent across those releases, with the documented 12.2.2 schema containing 183 columns.

Each row represents one Payables system parameter configuration for a given operating unit and ledger combination. The primary key AP_SYSTEM_PARAMETERS_PK is defined on the combination of SET_OF_BOOKS_ID and ORG_ID, and the unique index AP_SYSTEM_PARAMETERS_U1 mirrors that same business key. From a Data Vault modeling perspective, this object is best characterized as a link: it associates a ledger (SET_OF_BOOKS_ID) with an operating unit (ORG_ID) while resolving numerous foreign key references to configuration and reference entities. Given the volume of descriptive setup attributes, it also carries hub-like reference semantics to those dependent tables.

Key Information Stored

The table stores a broad set of functional defaults. The most consequential columns include:

• SET_OF_BOOKS_ID and ORG_ID — the composite business key and primary key components; they scope every parameter row to a ledger and operating unit.
• BASE_CURRENCY_CODE, INVOICE_CURRENCY_CODE, PAYMENT_CURRENCY_CODE — default currencies for invoicing and payment processing.
• ACCTS_PAY_CODE_COMBINATION_ID, SALES_TAX_CODE_COMBINATION_ID, DISC_LOST_CODE_COMBINATION_ID, DISC_TAKEN_CODE_COMBINATION_ID, GAIN_CODE_COMBINATION_ID, LOSS_CODE_COMBINATION_ID — default GL code combinations used in accounting.
• PREPAY_CODE_COMBINATION_ID, FREIGHT_CODE_COMBINATION_ID, ROUNDING_ERROR_CCID, RATE_VAR_GAIN_CCID, RATE_VAR_LOSS_CCID, INTEREST_ACCTS_PAY_CCID — additional default accounting flexfield assignments.
• DEFAULT_EXCHANGE_RATE_TYPE — the default daily conversion type used for foreign currency transactions.
• BANK_ACCOUNT_ID and CE_BANK_ACCT_USE_ID — default bank account and its use assignment.
• TERMS_ID and EMPLOYEE_TERMS_ID — default payment terms for suppliers and employees.
• DEFAULT_AWT_GROUP_ID — default withholding tax group.
• ACCOUNTING_METHOD_OPTION, LIABILITY_POST_LOOKUP_CODE — core accounting behavior controls.

Common Use Cases and Queries

Because the user searched for "gl_code_combinations," the most frequent queries against this table involve resolving the default accounting flexfield assignments stored as CCID foreign keys. A typical pattern joins AP_SYSTEM_PARAMETERS_ALL to GL_CODE_COMBINATIONS to retrieve the concatenated account segments:

• Retrieving the default liability account for an operating unit: SELECT gcc.concatenated_segments FROM ap_system_parameters_all asp, gl_code_combinations_kfv gcc WHERE asp.accts_pay_code_combination_id = gcc.code_combination_id AND asp.org_id = :org_id.
• Auditing all default accounts configured for a ledger: join on each CCID column (ACCTS_PAY_CODE_COMBINATION_ID, SALES_TAX_CODE_COMBINATION_ID, DISC_LOST_CODE_COMBINATION_ID, DISC_TAKEN_CODE_COMBINATION_ID, and the gain/loss, prepay, freight, and rounding accounts).
• Validating setup consistency across operating units by comparing parameter rows joined to GL_SETS_OF_BOOKS_11I and FND_CURRENCIES.

Reporting use cases include setup migration validation, period-end configuration review, multi-org parameter comparisons, and troubleshooting of incorrect accounting defaults in invoice and payment processing.

Related Objects

This table is heavily referenced and itself references many configuration objects. The most significant related tables are:

• GL_CODE_COMBINATIONS — referenced through at least thirteen CCID columns, including ACCTS_PAY_CODE_COMBINATION_ID, DISCOUNT and gain/loss accounts, PREPAY, FREIGHT, and ROUNDING_ERROR_CCID.
• GL_SETS_OF_BOOKS_11I — joined via SET_OF_BOOKS_ID.
• CE_BANK_ACCT_USES_ALL — joined via CE_BANK_ACCT_USE_ID.
• AP_BANK_ACCOUNTS_ALL — joined via BANK_ACCOUNT_ID.
• FND_CURRENCIES — joined via currency code columns.
• AP_AWT_GROUPS — joined via DEFAULT_AWT_GROUP_ID.
• GL_DAILY_CONVERSION_TYPES — joined via DEFAULT_EXCHANGE_RATE_TYPE.
• HR_LOCATIONS_ALL — joined via LOCATION_ID.
• AP_TOLERANCE_TEMPLATES — joined via TOLERANCE_ID.
• AP_INCOME_TAX_REGIONS and AP_EXPENSE_REPORTS_ALL — joined via INCOME_TAX_REGION and EXPENSE_REPORT_ID respectively.

These relationships confirm the table's role as a central configuration anchor for Payables accounting, banking, taxation, and expense processing.