Results for “okl_sys_acct_opts_all_u1”

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

Overview

OKL.OKL_SYS_ACCT_OPTS_ALL is a transactional configuration table in the Oracle E-Business Suite (EBS) Oracle Lease Management (OKL) module, delivered under the FND design data path OKL.OKL_SYS_ACCT_OPTS_ALL. It stores set of book and accounting options for each operating unit, holding exactly one record per operating unit. The table is the first to be populated during accounting setup in OKL, when the user selects a set of books identifier for the current operating unit. Beyond the book assignment itself, the table captures rounding configuration and the rules by which rounding differences are applied to accounting lines.

The object carries a VALID status in both EBS 12.1.1 and 12.2.2. Its documented physical schema contains 59 columns stored in the APPS_TS_TX_DATA tablespace with PCTFREE 10. Seven indexes are defined — one unique index (OKL_SYS_ACCT_OPTS_ALL_U1) and six non-unique indexes — all residing in APPS_TS_TX_IDX. From a data modeling perspective, the heuristic classification derived from the documented foreign-key structure is standalone, meaning the table is not modeled as a dependent hub, link, or satellite in that heuristic; the single-row-per-operating-unit configuration nature of the object explains this classification.

Key Information Stored

The table’s surrogate primary key is the ID column, which is enforced by the unique index OKL_SYS_ACCT_OPTS_ALL_U1 and by the primary key constraint OKL_SYS_ACCT_OPTS_ALL_PK. The most operationally significant columns include:

• ID — Surrogate primary key and the single documented unique business-key candidate via OKL_SYS_ACCT_OPTS_ALL_U1.
• SET_OF_BOOKS_ID — The accounting books defining column; identifies which set of books is associated with the operating unit. Indexed non-uniquely by OKL_SYS_ACCT_OPTS_ALL_N6.
• CODE_COMBINATION_ID — Key flexfield combination defining column; indexed non-uniquely by OKL_SYS_ACCT_OPTS_ALL_N5.
• ORG_ID — Operating unit identifier; since the table holds one record per operating unit, this column distinguishes configuration rows.
• OBJECT_VERSION_NUMBER — Used for locking records during concurrent updates.
• CC_APPLY_ROUNDING_DIFFERENCE — Cross-currency rounding difference application option; valid values are Add to High, Add to Low, and Add New Line. Indexed by OKL_SYS_ACCT_OPTS_ALL_N3.
• AEL_APPLY_ROUNDING_DIFFERENCE — Rounding difference application option for the AEL (accounting events ledger) side. Indexed by OKL_SYS_ACCT_OPTS_ALL_N2.
• CC_REP_CURRENCY_CODE — Reported currency code for cross-currency processing; indexed by OKL_SYS_ACCT_OPTS_ALL_N4. Documented as not used.
• AEL_REP_CURRENCY_CODE — Reported currency code for AEL processing; indexed by OKL_SYS_ACCT_OPTS_ALL_N1. Documented as not used.
• CC_ROUNDING_RULE, AEL_ROUNDING_RULE — Rounding rule definitions for cross-currency and AEL calculations.
• CC_PRECISION, CC_MIN_ACCT_UNIT, AEL_PRECISION, AEL_MIN_ACCT_UNIT — Currency precision and minimum accounting unit configuration.
• ROUNDING_CCID, CROSS_CURRENCY_CCID, TAX_CCID — Account combination identifiers used for rounding, cross-currency, and tax postings.
• REALIZED_GAIN_CCID, REALIZED_LOSS_CCID, DIS_TAKEN_CCID, AP_CLEARING_CCID, AR_CLEARING_CCID, LIABLITY_CCID, PRE_PAYMENT_CCID, FUT_DATE_PAY_CCID — Account combinations for gain/loss, discount taken, clearing, liability, prepayment, and future-dated payment postings. Several are documented as not used.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 — Descriptive flexfield (DFF) columns for extensibility.

Common Use Cases and Queries

The primary use case is retrieving the accounting configuration for a given operating unit during accounting setup, period-close validation, and lease accounting event processing. Query patterns typically filter by ORG_ID or SET_OF_BOOKS_ID and join to accounting flexfield tables through CODE_COMBINATION_ID or one of the specialized CCID columns.

• Confirming which set of books is configured for an operating unit:
  SELECT org_id, set_of_books_id, code_combination_id FROM okl.okl_sys_acct_opts_all WHERE org_id = :p_org_id;
• Reporting rounding behavior across operating units by joining CC_APPLY_ROUNDING_DIFFERENCE and AEL_APPLY_ROUNDING_DIFFERENCE.
• Validating that rounding, tax, and clearing accounts (ROUNDING_CCID, TAX_CCID, AR_CLEARING_CCID, AP_CLEARING_CCID) are correctly assigned before accounting generation.
• Reconciling accounting entries against the configured CODE_COMBINATION_ID or SET_OF_BOOKS_ID during period-end close.

Related Objects

The documented metadata classifies this table as standalone, so no foreign-key relationships to parent tables are declared in the ETRM relationship data. The following objects are the most significant referencing or dependency-adjacent objects based on their shared key columns:

• OKL_SYS_ACCT_OPTS_ALL_PK — Primary key constraint on ID.
• OKL_SYS_ACCT_OPTS_ALL_U1 — Unique index on ID; the constraint and index most frequently invoked in lookups.
• OKL_SYS_ACCT_OPTS_ALL_N1 through _N6 — Non-unique indexes on AEL_REP_CURRENCY_CODE, AEL_APPLY_ROUNDING_DIFFERENCE, CC_APPLY_ROUNDING_DIFFERENCE, CC_REP_CURRENCY_CODE, CODE_COMBINATION_ID, and SET_OF_BOOKS_ID respectively.
• GL_SETS_OF_BOOKS — Joined via SET_OF_BOOKS_ID to resolve book name and currency.
• GL_CODE_COMBINATIONS — Joined via CODE_COMBINATION_ID and the CCID columns to resolve account descriptions.
• HR_OPERATING_UNITS — Joined via ORG_ID to resolve the operating unit name and short code.
• OKL Accounting Setup and OKL accounting generation APIs — Insert and update into this table during accounting setup and read it during lease accounting event processing.