Results for “site_use_code”

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

Overview

OZF_FORECAST_CUSTOMERS is a Trade Management (OZF) transaction table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the set of customer accounts eligible against a specific version of a Forecast. In the Trade Management data model, forecasts are used to project demand and to constrain promotion and offer planning; OZF_FORECAST_CUSTOMERS acts as the eligibility bridge that determines which customers are in scope for a given forecast version before offers and worksheets are generated and evaluated against that forecast.

The table resides in the OZF schema and is documented as VALID with a physical column count of 15. Its primary key is OZF_FORECAST_CUSTOMERS_PK on FORECAST_CUSTOMER_ID, and it is unique-indexed by OZF_FORECAST_CUSTOMERS_U1 on the same column, confirming the surrogate key also serves as the documented business-key candidate. From a heuristic Data Vault perspective, the metadata classifies this object as a link, reflecting its role as an associative structure connecting a forecast/offer/worksheet context (OBJ_ID) to a customer account and site use. This classification is a modeling suggestion only; functionally, the table behaves as a transactional eligibility or scope table rather than a reference hub.

Key Information Stored

The most significant columns in OZF_FORECAST_CUSTOMERS are the following:

• FORECAST_CUSTOMER_ID — the surrogate primary key (OZF_FORECAST_CUSTOMERS_PK), uniquely identifying each eligible-customer row and referenced as the unique business-key candidate via OZF_FORECAST_CUSTOMERS_U1.
• OBJ_ID — the polymorphic object identifier that ties the row to its owning forecast construct. Documented foreign keys point OBJ_ID to both OZF_OFFERS and OZF_WORKSHEET_HEADERS_B, identifying the offer or worksheet header the customer is eligible for.
• OBJ_TYPE — discriminates the type of object referenced by OBJ_ID, allowing the same table to serve multiple forecast object contexts (for example, offer versus worksheet).
• CUST_ACCOUNT_ID — the customer account made eligible for the forecast, joining to HZ_CUST_ACCOUNTS.
• SITE_USE_ID and SITE_USE_CODE — the specific customer site use and its code, enabling eligibility at the site level rather than only at the account level.
• QP_LIST_HEADER_ID — the Advanced Pricing list header associated with the forecast customer context, linking eligibility to pricing qualifiers.
• QUALIFIER_ID and QUALIFIER_GROUPING_NO — the qualifier definition and grouping number that establish the qualifying criteria for the customer within the forecast.
• SECURITY_GROUP_ID — the multi-org/security grouping, joining to FND_SECURITY_GROUPS, governing row-level access.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns recording who created and last modified each eligibility row.

Common Use Cases and Queries

Typical use cases include validating which customers are in scope for a forecast version, reconciling forecast eligibility against customer master data, and driving reporting on promotion or offer coverage.

• List eligible customers for a worksheet or offer header:

SELECT fc.forecast_customer_id, fc.cust_account_id, fc.site_use_code
FROM   ozf.ozf_forecast_customers fc
WHERE  fc.obj_type = :obj_type
AND    fc.obj_id   = :obj_id;

• Join eligibility to customer master to retrieve account names:

SELECT hca.account_number, fc.cust_account_id, fc.site_use_id
FROM   ozf.ozf_forecast_customers fc,
       hz.hz_cust_accounts hca
WHERE  fc.cust_account_id = hca.cust_account_id;

• Reconcile forecast customers to their offer or worksheet headers via OBJ_ID and OBJ_TYPE, and audit security grouping through SECURITY_GROUP_ID for access-control reporting.

Related Objects

The following referenced objects are the most significant dependencies for OZF_FORECAST_CUSTOMERS:

• OZF_OFFERS — joined on OZF_FORECAST_CUSTOMERS.OBJ_ID; identifies the offer a customer is eligible for.
• OZF_WORKSHEET_HEADERS_B — joined on OZF_FORECAST_CUSTOMERS.OBJ_ID; identifies the worksheet header context.
• HZ_CUST_ACCOUNTS — joined on CUST_ACCOUNT_ID; the customer account made eligible.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; governs access to the record.
• OZF_FORECAST_CUSTOMERS_PK / OZF_FORECAST_CUSTOMERS_U1 — primary key and unique index on FORECAST_CUSTOMER_ID, defining row identity and supporting direct lookups by primary key.