Search Results ce_system_parameters_all




Overview
Explore in AI Chat

Overview

CE_SYSTEM_PARAMETERS_ALL is the Cash Management system options table in Oracle E-Business Suite (Release 12.1.1 and 12.2.2). It stores the configuration parameters that govern how Oracle Cash Management behaves for a given organization and ledger context, including the accounting set of books used for reconciliation accounting and the default receivables transaction type used when bank statement lines are matched and converted into receipt-related transactions. Because Cash Management operates at the boundary between treasury functions and subledger accounting, this table links general ledger accounting configuration to receivables processing.

The ETRM metadata classifies this object heuristically as a link in a Data Vault model. That classification is derived from the foreign key structure: the table does not describe a single business entity but rather associates entities — the general ledger set of books and the receivables transaction type. In Data Vault terms, CE_SYSTEM_PARAMETERS_ALL is best understood as a junction or link record tying together GL and AR reference data within the Cash Management configuration context, rather than a hub or satellite.

Key Information Stored

The physical table includes an internal surrogate primary key and audit columns (creation, update, and related who-columns), but the documented metadata emphasizes two significant business-referencing columns:

  • SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS. Identifies the ledger (set of books) to which these Cash Management system options apply, anchoring reconciliation accounting to the correct chart of accounts and calendar.
  • RECEIVABLES_TRX_ID — Foreign key to AR_RECEIVABLES_TRX_ALL. Identifies the receivables transaction type used by default when Cash Management creates or matches receipt transactions originating from bank statement processing.

The presence of a conflict-detection or "ALL" designation in the table name indicates that the table is not org-striped at the base-table level; in EBS the "_ALL" convention typically denotes tables whose contents can span multiple operating units and are secured through Row Level Security or analogous access mechanisms. SET_OF_BOOKS_ID is the principal business-key candidate for isolating a single configuration record, since system options are scoped by ledger. The surrogate primary key uniquely identifies each row internally, while the ledger identifier serves as the meaningful external key for lookups and joins.

Common Use Cases and Queries

Typical scenarios include verifying which ledger a Cash Management configuration is tied to, confirming the default receivables transaction type used in reconciliation, and joining system options to GL and AR reference tables for reporting.

  • Retrieve system options for a ledger:

    SELECT set_of_books_id, receivables_trx_id FROM ce_system_parameters_all WHERE set_of_books_id = :p_sob_id;

  • Resolve the ledger name:

    SELECT csp.*, gsob.name FROM ce_system_parameters_all csp, gl_sets_of_books gsob WHERE csp.set_of_books_id = gsob.set_of_books_id;

  • Resolve the default receivables transaction type:

    SELECT csp.set_of_books_id, art.name, art.type FROM ce_system_parameters_all csp, ar_receivables_trx_all art WHERE csp.receivables_trx_id = art.receivables_trx_id;

These queries support reconciliation setup validation, implementation audits, and configuration migration checks between environments.

Related Objects

  • GL_SETS_OF_BOOKS — joined via CE_SYSTEM_PARAMETERS_ALL.SET_OF_BOOKS_ID; supplies ledger name, chart of accounts, and calendar.
  • AR_RECEIVABLES_TRX_ALL — joined via CE_SYSTEM_PARAMETERS_ALL.RECEIVABLES_TRX_ID; supplies the receivables transaction type used in reconciliation.
  • CE_BANK_ACCOUNTS / CE_BANK_ACCT_USES_ALL — bank account configuration consumed alongside Cash Management system options.
  • CE_STATEMENT_HEADERS_ALL / CE_STATEMENT_LINES — bank statement processing objects whose accounting behavior depends on the system options defined here.

These objects collectively form the configuration and transactional backbone of Cash Management reconciliation in Oracle EBS.