OZF Tables (183)

OZF - Trade Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
OZF_ACCOUNT_ALLOCATIONS 40 Table to store the Account Allocations
OZF_ACCTNG_EVENTS_ALL 35 This table stores accounting events occuring on a Claim
OZF_ACTIVITY_CUSTOMERS 50 Denorm table for Offer and Schedules Market Eligibility
OZF_ACTIVITY_CUSTOMERS_TEMP 49 Temporary Table for Trade Management Activitiy denorm program
OZF_ACTIVITY_HL_DENORM 21 Denorm table for Campaign Schedules
OZF_ACTIVITY_PRODUCTS 53 Denorm table for Offer and Schedules Product Eligibility
OZF_ACTIVITY_PRODUCTS_TEMP 53 Temporary Table for Trade Management Activitiy denorm program
OZF_ACT_BUDGETS 61 Holds the information about budget sources for a marketing activity.
OZF_ACT_BUDGETS_INT 15 Interface table to store data of ozf_act_budgets table when Chargeback Batch upload or Third Party Accrual programs are run in parallel.
OZF_ACT_FORECASTS_ALL 64 This table stores the Forecasts planned for a Marketing Activity.
OZF_ACT_METRICS_ALL 82 This table stores the value for budget or quota allocation
OZF_ACT_METRIC_FACTS_ALL 107 Store detail allocation value for each node
OZF_ACT_METRIC_FORMULAS 12 Stores the formulas to be executed at each hierarchy level for a metric.
OZF_ACT_METRIC_FORM_ENT 14 Stores the set of entries to be executed for a formula.
OZF_ACT_OFFERS 29 Holds the high level details of promotional offers related to a campaign
OZF_ADJ_TEMP_ELIGIBILITY 5
OZF_AE_HEADERS_ALL 46 This table stores all the account headers for every accounting event
OZF_AE_LINES_ALL 74 This table stores Accounting lines for a account header
OZF_AGING_BUCKET_DATES 7 This table stores the dates for aging bucket days range based on system date.
OZF_AGING_SUMMARY_ALL 7 This table stores the aging summary of claims by customer for an aging bucket
OZF_APPROVAL_ACCESS 17 This table stores approval information for ozf
OZF_BASELINE_SALES_FACTS 43 This table stores validated baseline sales for Market, Product and Time dimension
OZF_BASELINE_SALES_HISTORY 42 This table stores historical baseline sales as of history_snapshot_date
OZF_BASELINE_SALES_INTERFACE 44 This Interface table stores baseline sales across Market, Product and Time dimensions as uploaded by user
OZF_BASELINE_SALES_MV 9 Summary Table for Baseline Sales
OZF_BASELINE_SALES_MV_TEMP 9 Temporary Summary table for storing Baseline Sales Data
OZF_BATCHES_ALL 42 This table stores the batches for claims
OZF_CHARGEBACK_INT_ALL 106 chargeback interface table.
OZF_CHARGEBACK_INT_LOG 9 Log table for charge back interface table.
OZF_CHARGEBACK_PRICE_ADJ_ALL 26 charge back price adjustments
OZF_CLAIMS_ALL 150 This table stores the Claim headers
OZF_CLAIMS_HISTORY_ALL 150 This table is to store claim header history
OZF_CLAIMS_INT_ALL 137 This table is to store Claim Inteface headers
OZF_CLAIM_ADJUSTMENTS_ALL 38 This table stores the adjustments that have been dont to a claim amount
OZF_CLAIM_DEF_RULES_ALL 18 This table stores the default claim type, reason and custom setup a claim source
OZF_CLAIM_LINES_ALL 91 This table is used to store Claim Lines
OZF_CLAIM_LINES_HIST_ALL 92 This table is used to store Claim Lines History
OZF_CLAIM_LINES_INT_ALL 88 This table is used to store Claim Lines Interface
OZF_CLAIM_LINES_UTIL_ALL 26 This table stores eranings associated to claim lines
OZF_CLAIM_OFFER_PERF_ALL 12 This table stores the offer performances that have been performanced on submission for submission of that claim
OZF_CLAIM_STTLMNT_METHODS_ALL 16 This table stores the available settlement methods for a given claim source
OZF_CLAIM_THRESHOLD_ALL 39 This table stores the Claim Thresholds
OZF_CLAIM_TYPES_ALL_B 51 This table is used to store Claim Types (Base Table)
OZF_CLAIM_TYPES_ALL_TL 13 This table is used to store Claim Types (Translation Table)
OZF_CODE_CONVERSIONS_ALL 34 This table stores the convensions from external values to internal identified for claim reasons, products, price lists and unit of measures
OZF_COMPETITOR_PRICE_POINTS 51 Table to store the competitor pricing information
OZF_CUST_DAILY_FACTS 43 Table to store the Account Manager Dashboard Data
OZF_CUST_PROD_CONT_ALL 41 Table for the Customer - Product contact Information
OZF_CUST_TRD_PRFLS_ALL 60 Table for Storing Trade Customer Profiles
OZF_DASHB_DAILY_KPI 9 Table to store the Account Manager Dashboard KPI
OZF_DENORM_QUERIES 24 This table stores the SQL Queries for the Market and Product Eligibilities. The Queries for Market eligibilites shalll select the party_id
OZF_DISCOUNT_PRODUCT_RELN 9 Table to store the Discount line relationships
OZF_EARNING_SUMMARY_MV 20
OZF_FORECAST_CUSTOMERS 15 Stores all the customers eligible for an version of Forecast
OZF_FORECAST_DIMENTIONS 19 Stores all the dimentions defined for an object.
OZF_FORECAST_PERIODS 15 Stores the different periods the forecast is spread
OZF_FORECAST_PRODUCTS 16 Stores all the products eligible for a version of forecast
OZF_FORECAST_PROD_EXCLUSIONS 15 Stores the product exclusions derived for and object
OZF_FUNDS_ALL_B 116 Fund definition master base table.
OZF_FUNDS_ALL_B_INT 30 Interface table to store data of ozf_funds_all_b table when Chargeback Batch upload or Third Party Accrual programs are run in parallel.
OZF_FUNDS_ALL_TL 17 Fund setup master translation table.
OZF_FUNDS_PAID_ALL 39 Funds paid details
OZF_FUNDS_UTILIZED_ALL_B 87 Fund utilization details
OZF_FUNDS_UTILIZED_ALL_TL 16 This table is used to store Fund utilization details (Translation Table)
OZF_FUND_REQUESTS 34 Fund request tracking table.
OZF_INTERFACE_ERRORS 16 This table stores details of validation errors while loading data in interface tables.
OZF_INVENTORY_SUMMARY_MV 9 Summary table for Inventory
OZF_INVENTORY_SUMMARY_MV_TEMP 9 Temporary Summary Table for inventory
OZF_INVENTORY_TMP_T 13
OZF_LIFT_FACTORS_FACTS 51 This table stores validated lift factors for Market, Product and Time dimension
OZF_LIFT_FACTORS_HISTORY 51 This table stores historical lift factors as of history_snapshot_date
OZF_LIFT_FACTORS_INTERFACE 65 This Interface table stores lift factors across Market, Product and Time dimensions as uploaded by user
OZF_MARKET_PRESET_TIERS 11 This table stores preset discount tier of discount Price Break Header (PBH).
OZF_MC_TRANSACTIONS_ALL 58 Multi-currency transaction table.
OZF_MULTI_CURR_UTIL_BCK 4 OZF Fund Utilizations BACKUP for MULTI CURRENCY ER
OZF_NAE_COMPLETION_TIME 9 This table stores last completion time of net accrual engine for each org seperately
OZF_NA_CONC_EXCEPTIONS 28 Table to store the errored rows by Net Accrual Engine
OZF_NA_CUSTOMERS_TEMP 44 Table to store the customer eligibile for a Net Accrual Offer
OZF_NA_DEDUCTION_RULES_B 11 Table to store the Net Accrual Deductions Rules
OZF_NA_DEDUCTION_RULES_TL 10 Table to store the Translated Values for Deduction Rules
OZF_NA_PRODUCTS_TEMP 8 Table to store the products eligible for a Net Accrual Offer
OZF_NA_RULE_HEADERS_B 11 Table To store the Net Accrual Rule sets
OZF_NA_RULE_HEADERS_TL 10 Table To store the translated Net Accrual Rule Sets
OZF_NA_RULE_LINES 10 Table to store the Deduction rules for a Net accrual Rule Set
OZF_NA_UNIQUE_PRODUCTS_TEMP 1 Table to store the unique products eligible for Net Accrual Offer.
OZF_OBJECT_FUND_SUMMARY 49 Object Fund Summary Definition
OZF_OFFERS 63 This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B.
OZF_OFFER_ADJUSTMENTS_B 32 Stores all the adjustments made for an offer
OZF_OFFER_ADJUSTMENTS_TL 11 stores all translatable columns for offer adjustments
OZF_OFFER_ADJUSTMENT_LINES 21 Stores the discount information for an offer adjustment
OZF_OFFER_ADJUSTMENT_PRODUCTS 17 Stores the product information for an offer adjustment.
OZF_OFFER_ADJUSTMENT_TIERS 14 This table stores tier infomation for offer adjustments
OZF_OFFER_ADJ_NEW_LINES 21 Stores the discount information for new product adjustment
OZF_OFFER_ADJ_NEW_PRODUCTS 14 Stores the product information for new product adjustment.
OZF_OFFER_ADJ_RLTD_LINES 11 This table is used for Trade Deal offer adjustment. Trade Deal Offers can have two modifiers in one deal line. This table captures the relat
OZF_OFFER_DISCOUNT_LINES 48 Table to store the Discount Lines of a Net Accrual Offer
OZF_OFFER_DISCOUNT_PRODUCTS 21 Table to store the products for an Offer
OZF_OFFER_PARTIES 9 This table stores all the parties eligible for the request only active offers created through Oracle Trade Management.
OZF_OFFER_PARTIES_TEMP 9 This table stores all the parties eligible for the request only active offers created through Oracle Trade Management temporarily when full
OZF_OFFER_PERFORMANCES 41 The performance rules defined for an offer are stored in this table.
OZF_OFFER_PRODUCTS 9 This table stores all the products defined for the request only active offers created through Oracle Trade Management.
OZF_OFFER_PRODUCTS_TEMP 9 This table stores all the products defined for the request only active offers created through Oracle Trade Management temporarily when full
OZF_OFFER_QUALIFIERS 32 This table stores the market eligibility for Trade Management Offers
OZF_OFFR_DISC_STRUCT_NAME_B 8 This table stores name of discount table structure in volume offer.
OZF_OFFR_DISC_STRUCT_NAME_TL 11 This table stores translated value of discount structure name.
OZF_OFFR_MARKET_OPTIONS 17 This table stores market option for market eligibility group in volume offer.
OZF_ORDER_GROUP_PROD 19 This table stores order line info with qualifying product and market qualifiers
OZF_ORDER_MESSAGE_COUNTER 4 Table to store number of messages in Order Capture's Advanced Quque
OZF_ORDER_SALES_SUMRY_MV 8 Summary Table for storing Order Sales data
OZF_ORDER_SALES_SUMRY_MV_TEMP 8 Summary Table for storing Order Sales
OZF_PARTY_MARKET_SEGMENTS_T 26
OZF_PRICE_LIST_ATTRIBUTES 15 This is a surrogate table to QP_LIST_HEADERS_B for Price List related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS
OZF_PROCESS_SETUP_ALL 34 OZF_PROCESS_SETUP_ALL stores the Price Protection Execution process setup details (whether processes are enabled/disable or they are automat
OZF_PRODUCT_ALLOCATIONS 35 Table to store the Prooduct allocations
OZF_QP_DISCOUNTS 11 This table stores mapping between offer discount line and QP list line.
OZF_QP_PRODUCTS 10 This table stores mapping between offer discount product and QP pricing attribute.
OZF_QUALIFIER_MARKET_OPTION 10 This table stores relationship between offer market option and QP qualifier.
OZF_QUOTA_ALERTS 13 Table to store the Quota Alerts
OZF_REASONS 13 This Table is used to store Reason Codes
OZF_REASON_CODES_ALL_B 34 This table is used for storing the reasons for a claim
OZF_REASON_CODES_ALL_TL 12 This Table is used to store Reason Codes (Translatable Codes)
OZF_RELATED_DEAL_LINES 16 This table is used for Trade Deal Offers. Trade Deal Offers can have two modifiers in one deal line. This table will capture the relation
OZF_REQUEST_HEADERS_ALL_B 112 This table stores the request headers information for soft fund and special pricing
OZF_REQUEST_HEADERS_ALL_TL 13 This table stores the request headers information for soft fund and special pricing
OZF_REQUEST_LINES_ALL 49 This table stores the request lines information for soft fund and special pricing
OZF_RESALE_ADJUSTMENTS_ALL 52 charge back price adjustments
OZF_RESALE_BATCHES_ALL 74 This table stores the batches for Resale
OZF_RESALE_BATCH_LINE_MAPS_ALL 32 This table contains the mappings between the batch header and the resale order lines that were submitted along with that batch
OZF_RESALE_HEADERS_ALL 92 Resale header information
OZF_RESALE_LINES_ALL 194 Chargeback Lines information
OZF_RESALE_LINES_INT_ALL 232 Resale Lines Interface Table
OZF_RESALE_LOGS_ALL 9 Log table for resale interface table
OZF_RES_CUST_PROD 7 Table to store the Customer and Products for a user to show on Account Manager dashboard
OZF_RES_CUST_PROD_FACTS 46 Table to store the information that needs to be displayed on Account Manager Dashboard for a user
OZF_RETAIL_PRICE_POINTS 54 Table to store the retail price information
OZF_RULE_BASED_LOG 13 This table stores the Rule Based Claim Data
OZF_SALES_TRANSACTIONS_ALL 57 This table stores quantity, uom and rate in different units for all direct and resale orders
OZF_SD_BATCH_HEADERS_ALL 69 OZF_SD_BATCH_HEADERS_ALL stores the header information of Supplier Ship and Debit Batch in Oracle Trade Management
OZF_SD_BATCH_LINES_ALL 101 OZF_SD_BATCH_LINES_ALL stores the line information of Supplier Ship and Debit Batch in Oracle Trade Management
OZF_SD_BATCH_LINES_INT_ALL 266 interface table to receive data from vendor authorization transmission of Supplier Ship and Debit Batch in Oracle Trade Management
OZF_SD_BATCH_LINE_DISPUTES 17 store the line dispute information of Supplier Ship and Debit Batch in Oracle Trade Management
OZF_SD_CUSTOMER_DETAILS 32 stores ship and debit customer information
OZF_SD_REQUEST_ACCESS 15 OZF_SD_REQUEST_ACCESS stores the information of Approver/Owner for a Ship & Debit request.
OZF_SD_REQUEST_HEADERS_ALL_B 69 stores the ship and debit request header information
OZF_SD_REQUEST_HEADERS_ALL_TL 16 Translations for ozf_sd_request_headers_all_b
OZF_SD_REQUEST_LINES_ALL 63 stores the ship and debit request line information
OZF_SD_RES_CUST_INTF 34 To hold the customer details sent as part of response
OZF_SD_RES_DIST_PRICES_INTF 8 To hold the pricing information for each product
OZF_SD_RES_HEADER_INTF 65 To hold Vendor and distributor details sent as part of response
OZF_SD_RES_PROD_INTF 31 To hold the product line detail for a request
OZF_SD_STATUS_TRANSITIONS 17 OZF_SD_STATUS_TRANSITIONS stores the status transition information for a Ship & Debit request.
OZF_SETTLEMENT_DOCS_ALL 53 This table stores the settlement details
OZF_SUPP_CODE_CONVERSIONS_ALL 37 OZF_SUPP_CODE_CONVERSIONS_ALL stores the code mapping between the supplier item code and internal item codes.
OZF_SUPP_TRD_PRFLS_ALL 110 OZF_SUPP_TRD_PRFLS_ALL stores the supplier trade profiles created from the Supplier trade profile UI.
OZF_SYS_PARAMETERS_ALL 98 This table stores the system parameters for General Ledger interface
OZF_TERR_LEVELS_ALL 39 This table stores the levels that corrospond to territory types in JTF.
OZF_THRESHOLDS_ALL_B 38 Holds information on Funds Thresholds.
OZF_THRESHOLDS_ALL_TL 17 Holds information on Funds Thresholds.(Translation table)
OZF_THRESHOLD_RULES_ALL 48 Holds Funds Threshold Rule Information.
OZF_TIME_ALLOCATIONS 32 Table to store the time level allocations
OZF_TIME_DAY 18 This is a time structure table storing day information.
OZF_TIME_ENT_PERIOD 12 This is a time structure table storing enterprise period names.
OZF_TIME_ENT_QTR 11 This is a time structure table storing enterprise quarter names.
OZF_TIME_ENT_YEAR 12 This is a time structure table storing enterprise year names.
OZF_TIME_RPT_STRUCT 11 This is a time structure table used for calculating period amounts and XTD amounts for the given period range. It stores time structure data
OZF_TIME_WEEK 11 This is a time structure table storing the Gregorian week names
OZF_TP_TERRUSG_MAP 20 Table to store the territory and store mappings
OZF_TRADE_TACTICS_MAPPING 14 This table stores details all distinct trade medium ids and their respective column names. This information is derived from ozf_lift_factor_
OZF_VOLUME_DETAIL 24 This table stores volume transaction detail for volume offers
OZF_VOLUME_OFFER_TIERS 11 Stores tier info of volume offer
OZF_VOLUME_SUMMARY 14 This table stores accumulated volume for volume offers
OZF_VO_PRODUCTS_TEMP 8 This table stores denorm product id temporarily during volume offer activation
OZF_WORKSHEET_HEADERS_B 30 Table to store the Worksheet header information
OZF_WORKSHEET_HEADERS_TL 11 Table to store the translated values for Workhsheet Header
OZF_WORKSHEET_LINES 38 Table to store the Worksheet Discount lines
OZF_WORKSHEET_QUALIFIERS 18 Table to store the Market eligibilty for a Offer Worksheet
OZF_XLA_ACCRUALS 15 This table stores SLA Accrual extract information
OZF_XLA_ACCRUALS_BACKUP 15
OZF_XLA_CLAIM_HEADERS 13 This table stores the SLA Claim Extract Header Data
OZF_XLA_CLAIM_HEADERS_BACKUP 13
OZF_XLA_CLAIM_LINES 11 This table stores the SLA Claim Extract Lines Data
OZF_XLA_CLAIM_LINES_BACKUP 11
OZF_XREF_MAP 5 OZF_XREF_MAP table created for SIebel TPM Integration