Search Results offer_product_id




Overview
Explore in AI Chat

Overview

The OZF_OFFER_PRODUCTS_TEMP table is a temporary staging table within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its primary role is to serve as a transient data repository during the execution of a full refresh concurrent program. Specifically, it temporarily holds product information for all active offers that have been created through the Trade Management system. This table facilitates batch processing and data synchronization operations, ensuring that offer product data is accurately consolidated and refreshed for reporting or downstream processing before being purged or archived.

Key Information Stored

The table's central purpose is to stage offer-product relationships. Based on the provided metadata, the most critical column is the primary key, OFFER_PRODUCT_ID. This column uniquely identifies each temporary record of a product associated with an offer. While the full column list is not detailed in the excerpt, a table of this nature typically would store foreign key references to the core offer (OFFER_ID) and product (INVENTORY_ITEM_ID, ORGANIZATION_ID) tables, along with attributes pertinent to the offer's product eligibility, such as quantity, discount applicability, and a timestamp for the temporary record's creation.

Common Use Cases and Queries

The primary use case is the execution and monitoring of the full refresh concurrent program. Database administrators and functional consultants may query this table to verify the progress of data loads or to troubleshoot failed refresh jobs. A common query pattern involves checking the volume of data staged for processing. For example:

  • SELECT COUNT(*) FROM ozf.ozf_offer_products_temp;

Reporting directly from this temporary table is atypical, as its contents are volatile. However, during a refresh, one might join it to product master tables to validate the data being processed:

  • SELECT temp.offer_product_id, msi.segment1 item_code FROM ozf.ozf_offer_products_temp temp, mtl_system_items_b msi WHERE temp.inventory_item_id = msi.inventory_item_id;

Related Objects

The table has a defined primary key constraint, OZF_OFFER_PRODUCTS_TEMP_PK, on the OFFER_PRODUCT_ID column. Its most significant relationship is with the permanent, transactional table from which its data is sourced, which is likely OZF_OFFER_PRODUCTS. The temporary table's data is a snapshot of active records from this permanent table. It may also have implicit relationships with core product tables (MTL_SYSTEM_ITEMS_B) and offer definition tables (OZF_OFFERS). The table is intrinsically linked to the specific concurrent request that performs the "full refresh," which populates and subsequently cleanses this temporary storage.

  • Table: OZF_OFFER_PRODUCTS_TEMP 12.2.2

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_OFFER_PRODUCTS_TEMP,  object_name:OZF_OFFER_PRODUCTS_TEMP,  status:VALID,  product: OZF - Trade Management ,  description: This table stores all the products defined for the request only active offers created through Oracle Trade Management temporarily when full refresh is performed through the concurrent program. ,  implementation_dba_data: OZF.OZF_OFFER_PRODUCTS_TEMP , 

  • Table: OZF_OFFER_PRODUCTS 12.2.2

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_OFFER_PRODUCTS,  object_name:OZF_OFFER_PRODUCTS,  status:VALID,  product: OZF - Trade Management ,  description: This table stores all the products defined for the request only active offers created through Oracle Trade Management. ,  implementation_dba_data: OZF.OZF_OFFER_PRODUCTS , 

  • Table: OZF_OFFER_PRODUCTS 12.1.1

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_OFFER_PRODUCTS,  object_name:OZF_OFFER_PRODUCTS,  status:VALID,  product: OZF - Trade Management ,  description: This table stores all the products defined for the request only active offers created through Oracle Trade Management. ,  implementation_dba_data: OZF.OZF_OFFER_PRODUCTS , 

  • Table: OZF_OFFER_PRODUCTS_TEMP 12.1.1

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_OFFER_PRODUCTS_TEMP,  object_name:OZF_OFFER_PRODUCTS_TEMP,  status:VALID,  product: OZF - Trade Management ,  description: This table stores all the products defined for the request only active offers created through Oracle Trade Management temporarily when full refresh is performed through the concurrent program. ,  implementation_dba_data: OZF.OZF_OFFER_PRODUCTS_TEMP ,