Search Results ce_cp_worksheet_headers_u1

Overview

The CE.CE_CP_WORKSHEET_HEADERS table is a core configuration object within the Oracle Cash Management (CE) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the Cash Position worksheet header definitions used by the Cash Positioning and Forecasting functionality. Each row represents a named worksheet configuration that controls how cash position results are aggregated, filtered, and displayed to treasury and cash management users. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its unique indexes reside in APPS_TS_TX_IDX. It is registered in FND Design Data as CE.CE_CP_WORKSHEET_HEADERS. Based on the documented relationship metadata, the object is classified heuristically as standalone, so it is best modeled as a hub-type reference entity in a Data Vault sense, with no dependent link or satellite relationships surfaced by the foreign-key structure.

Key Information Stored

The table contains nine documented columns. The most significant are listed below, with the surrogate primary key and business-key candidates clearly distinguished.

• WORKSHEET_HEADER_ID (NUMBER, 15) — The surrogate primary key and unique identifier for the Cash Position worksheet header. This column backs the primary key CE_CP_WORKSHEET_HEADERS_PK and the unique index CE_CP_WORKSHEET_HEADERS_U1, which is the object referenced by the search term ce_cp_worksheet_headers_u1.
• WORKSHEET_NAME (VARCHAR2, 80) — The user-assigned name of the Cash Position worksheet. This is the natural business key and is enforced by the unique index CE_CP_WORKSHEET_HEADERS_U2.
• COLUMNS_DISPLAYED (NUMBER) — Defines the number of columns rendered in the Cash Position results for the worksheet.
• PD_FLAG (VARCHAR2) — A control flag indicating whether to use Summary Prior Day Cash Flow and Overdue Transactions when generating worksheet output.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard Oracle Who columns that capture audit and user-tracking information for each worksheet definition.

Both unique indexes CE_CP_WORKSHEET_HEADERS_U1 (on WORKSHEET_HEADER_ID) and CE_CP_WORKSHEET_HEADERS_U2 (on WORKSHEET_NAME) are legitimate business-key candidates, though U1 mirrors the primary key and U2 represents the true natural key.

Common Use Cases and Queries

This table is queried primarily to enumerate available worksheet definitions, resolve a worksheet name to its identifier, and audit configuration changes. A typical lookup by business key is:

• SELECT worksheet_header_id, columns_displayed, pd_flag FROM ce.ce_cp_worksheet_headers WHERE worksheet_name = :p_name;
• SELECT worksheet_header_id, worksheet_name FROM ce.ce_cp_worksheet_headers ORDER BY worksheet_name;

Reporting scenarios include listing all defined worksheets for a treasury dashboard, verifying whether the prior-day flag is enabled for a given worksheet, and surfacing configuration audit trails via the Who columns. Because WORKSHEET_NAME is unique, it is the preferred lookup predicate when only the display name is known, avoiding ambiguity. Extraction queries for ETL or reconciliation can select the full documented column list directly from the table.

Related Objects

The ETRM dependency metadata indicates that CE.CE_CP_WORKSHEET_HEADERS does not reference any other database object, confirming its standalone classification. It is referenced by the following CE object:

• CE_CP_WORKSHEET_HEADERS# — The internal table definition artifact associated with this table.

In practice, worksheet headers are consumed by Cash Position concurrent programs and the Cash Positioning UI, which join the worksheet header to the cash position configuration and worksheet line/column definitions using WORKSHEET_HEADER_ID. When extending or reporting on this object, join through WORKSHEET_HEADER_ID to the associated worksheet detail and column configuration tables, and reference CE_CP_WORKSHEET_HEADERS_U1 or CE_CP_WORKSHEET_HEADERS_U2 when validating uniqueness of identifiers or names.