Results for “template_description”

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

Overview

CEBV_CASH_FORECASTS is a Business View in the Oracle E-Business Suite Cash Management (CE) module, owned by the APPS schema and shipped with a VALID status in both release 12.1.1 and 12.2.2. It is a read-only, denormalized reporting object that consolidates cash forecast definitions, header-level forecast template attributes, lookup descriptions, currency conversion metadata, transaction calendar details, and project identifiers into a single query surface. The view is exposed through the APPS layer and referenced by Oracle Business Intelligence, Discoverer workbooks, and custom dashboards that monitor cash positioning.

For users searching on "cbs business dashboard," this view is frequently the underlying data source. Reporting dashboards that display forecast names, aging rules, currency types, overdue transaction handling, and exchange parameters can query CEBV_CASH_FORECASTS directly rather than joining the base Cash Management tables, reducing the join complexity for dashboard developers and end-user ad hoc tools.

Underlying Base Objects

The view is defined over the following documented base objects:

• CE_FORECASTS (synonym) — forecast line definitions, exchange rate data, thresholds, and project linkage.
• CE_FORECAST_HEADERS (synonym) — header/template metadata, aging type, overdue options, and cutoff period.
• CE_LOOKUPS (view) — provides decoded meanings for the aging type, currency type, and overdue transaction flags.
• GL_DAILY_CONVERSION_TYPES (synonym) — names the user conversion type applied to the forecast.
• GL_TRANSACTION_CALENDAR (synonym) — supplies the business calendar associated with the forecast header.
• PA_PROJECTS_ALL (synonym) — resolves the project number when a forecast is tied to a project.

Joins are performed between CE_FORECASTS and CE_FORECAST_HEADERS on FORECAST_HEADER_ID, with three CE_LOOKUPS outer joins keyed on lookup type and code, and outer joins to conversion types, transaction calendar, and projects.

Key Columns

• FORECAST_ID, NAME, DESCRIPTION — identity and descriptive attributes of the forecast.
• TYPE — the forecast aging type meaning (decoded from FORECAST_AGING_TYPE).
• FORECAST_CURRENCY, CURRENCY_TYPE, SOURCE_CURRENCY — currency context, with CURRENCY_TYPE decoded from FORECAST_CURRENCY_TYPE.
• EXCHANGE_RATE_TYPE, EXCHANGE_DATE, EXCHANGE_RATE — conversion parameters tied to the forecast.
• START_DATE, START_PERIOD, CALENDAR_NAME — accounting period context.
• ERROR_STATUS, AMOUNT_THRESHOLD — tolerance and error handling indicators.
• TEMPLATE_NAME, TEMPLATE_DESCRIPTION, OVERDUE_TRANSACTION_OPTION, OVERDUE_TXN_CUTOFF_PERIOD, BUSINESS_CALENDAR — header template and overdue behavior, with the overdue option decoded from FORECAST_OVERDUE_TRX.
• PROJECT_ID, PROJECT_NUMBER — project association where applicable.
• CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY — audit columns.

Common Use Cases and Queries

Typical dashboard scenarios list active forecasts with their aging type, currency type, and exchange rate type; cross-reference forecasts to projects for project cash positioning; or validate that a business calendar and conversion type are configured for each forecast. A representative query is shown below.

SELECT name, type, forecast_currency, currency_type, exchange_rate_type,
  business_calendar, project_number
FROM apps.cebv_cash_forecasts
WHERE error_status IS NULL;

To filter by forecast type and project, developers commonly add predicates against TYPE and PROJECT_NUMBER, and join the result set to CE_FORECAST_ROWS or cash forecast results tables for further aggregation. The read-only nature of the view ensures it is safe for concurrent reporting, while the CE_LOOKUPS joins produce decoded, user-facing descriptions suitable for display captions in a business dashboard.