Search Results open_interface_float_status

Overview

CE_SYSTEM_PARAMETERS is a reporting and integration view in the Oracle E-Business Suite Cash Management (CE) module. It exposes the setup and control parameters that govern Cash Management processing for each set of books (ledger) and operating unit. The view presents a single logical row of configuration per ledger/operating unit combination, translated from the underlying CE_SYSTEM_PARAMETERS_ALL table. Because the view filters rows by the current operating unit context, it presents only the parameters relevant to the session's active organization, making it suitable for concurrent programs, forms, and reporting tools that must respect multi-org security.

The view is a multi-org (MO) secured view. Its WHERE clause derives the operating unit from USERENV('CLIENT_INFO') and matches it against ORG_ID, with a fallback of -99 where the client information is absent. This design means direct SQL against the view returns only the rows visible to the current operating unit unless the session is initialized appropriately. In 12.1.1 and 12.2.2 the definition is functionally identical; the primary difference in 12.2.2 is the underlying multi-org data model and the presence of the _ALL table for the same purpose.

Underlying Base Objects

According to the ETRM metadata the view is defined over a single base object, CE_SYSTEM_PARAMETERS_ALL. The view does not introduce new tables; it is a filtering and projecting layer over that table. The ETRM record notes that the object is "Not implemented in this database," which indicates the view was documented but not physically created in the reference environment, and that no separate referenced base objects were catalogued beyond the documented _ALL table. When the view is deployed, it selects all columns from CE_SYSTEM_PARAMETERS_ALL and applies the ORG_ID-based security predicate.

Key Columns

• SET_OF_BOOKS_ID — Ledger identifier for which the parameters apply.
• CASHBOOK_BEGIN_DATE — Beginning date governing cashbook activity, used when reconciling bank statements.
• AMOUNT_TOLERANCE / PERCENT_TOLERANCE — Automatic reconciliation tolerances applied when matching bank statement lines to transactions.
• LINE_AUTOCREATION_FLAG — Controls automatic creation of reconciliation lines from bank statement data.
• ENABLE_OPEN_INTERFACE_FLAG — Enables the open interface for importing bank statement or transaction data.
• INTERFACE_PURGE_FLAG / INTERFACE_ARCHIVE_FLAG — Determine whether interface records are purged or archived after processing.
• FLOAT_HANDLING_FLAG / OPEN_INTERFACE_FLOAT_STATUS — Govern float handling and the status assigned to float records on import.
• AP_MATCHING_ORDER / AR_MATCHING_ORDER — Define the matching order applied to Payables and Receivables transactions.
• DIFFERENCES_ACCOUNT / RECEIVABLES_TRX_ID — Accounting and transaction defaults for reconciliation differences.
• EXCHANGE_RATE_TYPE / EXCHANGE_RATE_DATE — Rate type and date basis for foreign currency conversion.
• ORG_ID — Operating unit identifier used by the multi-org security predicate.
• ATTRIBUTE1–ATTRIBUTE15, ATTRIBUTE_CATEGORY — Descriptive flexfield segments for extensibility.

Common Use Cases and Queries

The view is commonly queried to determine the reconciliation tolerances, interface settings, and matching rules in force for a ledger before running auto-reconciliation or bank statement import. A typical query retrieves the core control parameters for the current operating unit:

• SELECT SET_OF_BOOKS_ID, AMOUNT_TOLERANCE, PERCENT_TOLERANCE, LINE_AUTOCREATION_FLAG FROM CE_SYSTEM_PARAMETERS WHERE SET_OF_BOOKS_ID = :ledger_id;
• SELECT ORG_ID, ENABLE_OPEN_INTERFACE_FLAG, INTERFACE_PURGE_FLAG, INTERFACE_ARCHIVE_FLAG FROM CE_SYSTEM_PARAMETERS;
• SELECT SET_OF_BOOKS_ID, CASHBOOK_BEGIN_DATE, EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE FROM CE_SYSTEM_PARAMETERS;

Because the view enforces MO security, queries executed in a session without a properly initialized ORG_ID context may return no rows or rows for ORG_ID = -99. For diagnostic purposes, querying CE_SYSTEM_PARAMETERS_ALL directly is common when all operating units must be inspected regardless of session context.