Search Results rs_partner




Overview
Explore in AI Chat

Overview

APPS.AS_SALES_FORECAST_UWQ_V is a reporting view in the Oracle E-Business Suite Sales Foundation module. Its name reflects its purpose: "UWQ" denotes universal work queue, indicating that the view is designed to feed forecast records into work queue-style processing or reporting pipelines, while "SALES_FORECAST" identifies the business domain. The view consolidates internal sales forecast data and enriches each row with a resource-category classification, making it suitable for downstream reporting, integration, and role-based routing.

One of the view's distinguishing features is a derived column that maps a resource category to a literal token. When the underlying resource is categorized as an employee, the view emits the string RS_EMPLOYEE; when the category is partner, it emits RS_PARTNER; otherwise the column is NULL. This token is central to consumers searching on the term "rs_partner," since it is the exact value that appears in that derived column for partner-related forecast rows.

Underlying Base Objects

The view is defined over two synonyms that resolve to Sales Foundation tables:

  • AS_INTERNAL_FORECASTS (aliased INF) — the primary source of forecast records, supplying identifiers, period, status, sales force, sales group, and the forecast amount measures.
  • JTF_RS_RESOURCE_EXTNS (aliased RES) — the resource extension table, providing the CATEGORY attribute used to classify each sales force resource.

The two objects are joined with an outer join: INF.SALESFORCE_ID = RES.RESOURCE_ID(+). Because the resource-side join is outer, every forecast row from AS_INTERNAL_FORECASTS is preserved even when no matching resource extension record exists. In that case the RES.CATEGORY value is NULL, and the derived category token also resolves to NULL through the DECODE expression.

Key Columns

  • FORECAST_ID — Unique identifier of the internal forecast record.
  • PERIOD_NAME — The accounting or forecast period to which the forecast applies.
  • STATUS_CODE — Status of the forecast (for example, submitted, approved, or working).
  • SALESFORCE_ID — Identifier of the sales force resource associated with the forecast; the join key to the resource extension table.
  • Derived category token — A DECODE over RES.CATEGORY returning RS_EMPLOYEE for EMPLOYEE, RS_PARTNER for PARTNER, and NULL otherwise. This is the column matched by "rs_partner" searches.
  • Literal 'FORECAST' — A constant string projected by the view, likely used to label the row type in unified or work queue output.
  • SALES_GROUP_ID — Identifier of the sales group owning the forecast.
  • FORECAST_AMOUNT — The primary forecast amount.
  • BEST_FORECAST_AMOUNT — The optimistic or best-case forecast amount.
  • WORST_FORECAST_AMOUNT — The pessimistic or worst-case forecast amount.

Common Use Cases and Queries

Typical usage includes forecast reporting by period, comparison of best, worst, and primary forecast amounts, and separating employee-sourced forecasts from partner-sourced forecasts. To retrieve only partner-related forecast rows, filter on the derived category token equal to RS_PARTNER:

SELECT forecast_id, period_name, status_code,
       salesforce_id, sales_group_id,
       forecast_amount, best_forecast_amount, worst_forecast_amount
FROM   apps.as_sales_forecast_uwq_v
WHERE  DECODE(...) = 'RS_PARTNER';

Because the derived column is unnamed in the source text, a positional or re-aliased reference is commonly used in practice. The view is also suited to aggregation: summing FORECAST_AMOUNT by PERIOD_NAME and SALES_GROUP_ID, or contrasting employee versus partner contributions to a sales group's pipeline. Reports that must include forecasts lacking a matching resource record should rely on the outer join behavior and treat a NULL category token as unclassified. All queries should be executed against the APPS schema or through a synonym with appropriate privileges.