You are browsing the archive for Oracle Trade Management.

Trade Management Tables

Oracle Trade Management Tables:

  • OZF_ACCOUNT_ALLOCATIONS
  • OZF_ACCTNG_EVENTS_ALL
  • OZF_ACTIVITY_CUSTOMERS
  • OZF_ACTIVITY_CUSTOMERS_TEMP
  • OZF_ACTIVITY_HL_DENORM
  • OZF_ACTIVITY_PRODUCTS
  • OZF_ACTIVITY_PRODUCTS_TEMP
  • OZF_ACT_BUDGETS
  • OZF_ACT_FORECASTS_ALL
  • OZF_ACT_METRICS_ALL
  • OZF_ACT_METRIC_FACTS_ALL
  • OZF_ACT_METRIC_FORMULAS
  • OZF_ACT_METRIC_FORM_ENT
  • OZF_ACT_OFFERS
  • OZF_AE_HEADERS_ALL
  • OZF_AE_LINES_ALL
  • OZF_AGING_BUCKET_DATES
  • OZF_AGING_SUMMARY_ALL
  • OZF_APPROVAL_ACCESS
  • OZF_BASELINE_SALES_FACTS
  • OZF_BASELINE_SALES_HISTORY
  • OZF_BASELINE_SALES_INTERFACE
  • OZF_BATCHES_ALL
  • OZF_CHARGEBACK_HEADERS_ALL
  • OZF_CHARGEBACK_INT_ALL
  • OZF_CHARGEBACK_INT_LOG
  • OZF_CHARGEBACK_LINES_ALL
  • OZF_CHARGEBACK_PRICE_ADJ_ALL
  • OZF_CLAIMS_ALL
  • OZF_CLAIMS_HISTORY_ALL
  • OZF_CLAIMS_INT_ALL
  • OZF_CLAIM_ADJUSTMENTS_ALL
  • OZF_CLAIM_DEF_RULES_ALL
  • OZF_CLAIM_LINES_ALL
  • OZF_CLAIM_LINES_HIST_ALL
  • OZF_CLAIM_LINES_INT_ALL
  • OZF_CLAIM_LINES_UTIL_ALL
  • OZF_CLAIM_OFFER_PERF_ALL
  • OZF_CLAIM_STTLMNT_METHODS_ALL
  • OZF_CLAIM_THRESHOLD_ALL
  • OZF_CLAIM_TYPES_ALL_B
  • OZF_CLAIM_TYPES_ALL_TL
  • OZF_CODE_CONVERSIONS_ALL
  • OZF_COMPETITOR_PRICE_POINTS
  • OZF_CUST_DAILY_FACTS
  • OZF_CUST_PROD_CONT_ALL
  • OZF_CUST_TRD_PRFLS_ALL
  • OZF_DASHB_DAILY_KPI
  • OZF_DENORM_QUERIES
  • OZF_DISCOUNT_PRODUCT_RELN
  • OZF_FORECAST_CUSTOMERS
  • OZF_FORECAST_DIMENTIONS
  • OZF_FORECAST_PERIODS
  • OZF_FORECAST_PRODUCTS
  • OZF_FORECAST_PROD_EXCLUSIONS
  • OZF_FUNDS_ALL_B
  • OZF_FUNDS_ALL_TL
  • OZF_FUNDS_PAID_ALL
  • OZF_FUNDS_UTILIZED_ALL_B
  • OZF_FUNDS_UTILIZED_ALL_TL
  • OZF_FUND_REQUESTS
  • OZF_INTERFACE_ERRORS
  • OZF_INVENTORY_TMP_T
  • OZF_LIFT_FACTORS_FACTS
  • OZF_LIFT_FACTORS_HISTORY
  • OZF_LIFT_FACTORS_INTERFACE
  • OZF_MARKET_PRESET_TIERS
  • OZF_MC_TRANSACTIONS_ALL
  • OZF_NAE_COMPLETION_TIME
  • OZF_NA_CONC_EXCEPTIONS
  • OZF_NA_CUSTOMERS_TEMP
  • OZF_NA_DEDUCTION_RULES_B
  • OZF_NA_DEDUCTION_RULES_TL
  • OZF_NA_PRODUCTS_TEMP
  • OZF_NA_RULE_HEADERS_B
  • OZF_NA_RULE_HEADERS_TL
  • OZF_NA_RULE_LINES
  • OZF_OBJECT_FUND_SUMMARY
  • OZF_OFFERS
  • OZF_OFFER_ADJUSTMENTS_B
  • OZF_OFFER_ADJUSTMENTS_TL
  • OZF_OFFER_ADJUSTMENT_LINES
  • OZF_OFFER_ADJUSTMENT_PRODUCTS
  • OZF_OFFER_ADJUSTMENT_TIERS
  • OZF_OFFER_ADJ_NEW_LINES
  • OZF_OFFER_ADJ_NEW_PRODUCTS
  • OZF_OFFER_ADJ_RLTD_LINES
  • OZF_OFFER_DISCOUNT_LINES
  • OZF_OFFER_DISCOUNT_PRODUCTS
  • OZF_OFFER_PARTIES
  • OZF_OFFER_PARTIES_TEMP
  • OZF_OFFER_PERFORMANCES
  • OZF_OFFER_PRODUCTS
  • OZF_OFFER_PRODUCTS_TEMP
  • OZF_OFFER_QUALIFIERS
  • OZF_OFFR_DISC_STRUCT_NAME_B
  • OZF_OFFR_DISC_STRUCT_NAME_TL
  • OZF_OFFR_MARKET_OPTIONS
  • OZF_ORDER_GROUP_PROD
  • OZF_ORDER_MESSAGE_COUNTER
  • OZF_PARTY_MARKET_SEGMENTS_T
  • OZF_PRICE_LIST_ATTRIBUTES
  • OZF_PRODUCT_ALLOCATIONS
  • OZF_QP_DISCOUNTS
  • OZF_QP_PRODUCTS
  • OZF_QUALIFIER_MARKET_OPTION
  • OZF_QUOTA_ALERTS
  • OZF_REASONS
  • OZF_REASON_CODES_ALL_B
  • OZF_REASON_CODES_ALL_TL
  • OZF_RELATED_DEAL_LINES
  • OZF_REQUEST_HEADERS_ALL_B
  • OZF_REQUEST_HEADERS_ALL_TL
  • OZF_REQUEST_LINES_ALL
  • OZF_RESALE_ADJUSTMENTS_ALL
  • OZF_RESALE_BATCHES_ALL
  • OZF_RESALE_BATCH_LINE_MAPS_ALL
  • OZF_RESALE_HEADERS_ALL
  • OZF_RESALE_LINES_ALL
  • OZF_RESALE_LINES_INT_ALL
  • OZF_RESALE_LOGS_ALL
  • OZF_RES_CUST_PROD
  • OZF_RES_CUST_PROD_FACTS
  • OZF_RETAIL_PRICE_POINTS
  • OZF_SALES_TRANSACTIONS_ALL
  • OZF_SETTLEMENT_DOCS_ALL
  • OZF_SYS_PARAMETERS_ALL
  • OZF_TERR_LEVELS_ALL
  • OZF_THRESHOLDS_ALL_B
  • OZF_THRESHOLDS_ALL_TL
  • OZF_THRESHOLD_RULES_ALL
  • OZF_TIME_ALLOCATIONS
  • OZF_TIME_DAY
  • OZF_TIME_ENT_PERIOD
  • OZF_TIME_ENT_QTR
  • OZF_TIME_ENT_YEAR
  • OZF_TIME_RPT_STRUCT
  • OZF_TIME_WEEK
  • OZF_TP_TERRUSG_MAP
  • OZF_TRADE_TACTICS_MAPPING
  • OZF_VOLUME_DETAIL
  • OZF_VOLUME_OFFER_TIERS
  • OZF_VOLUME_SUMMARY
  • OZF_VO_PRODUCTS_TEMP
  • OZF_WORKSHEET_HEADERS_B
  • OZF_WORKSHEET_HEADERS_TL
  • OZF_WORKSHEET_LINES
  • OZF_WORKSHEET_QUALIFIERS
OZF_ACCOUNT_ALLOCATIONS
OZF_ACCTNG_EVENTS_ALL
OZF_ACTIVITY_CUSTOMERS
OZF_ACTIVITY_CUSTOMERS_TEMP
OZF_ACTIVITY_HL_DENORM
OZF_ACTIVITY_PRODUCTS
OZF_ACTIVITY_PRODUCTS_TEMP
OZF_ACT_BUDGETS
OZF_ACT_FORECASTS_ALL
OZF_ACT_METRICS_ALL
OZF_ACT_METRIC_FACTS_ALL
OZF_ACT_METRIC_FORMULAS
OZF_ACT_METRIC_FORM_ENT
OZF_ACT_OFFERS
OZF_AE_HEADERS_ALL
OZF_AE_LINES_ALL
OZF_AGING_BUCKET_DATES
OZF_AGING_SUMMARY_ALL
OZF_APPROVAL_ACCESS
OZF_BASELINE_SALES_FACTS
OZF_BASELINE_SALES_HISTORY
OZF_BASELINE_SALES_INTERFACE
OZF_BATCHES_ALL
OZF_CHARGEBACK_HEADERS_ALL
OZF_CHARGEBACK_INT_ALL
OZF_CHARGEBACK_INT_LOG
OZF_CHARGEBACK_LINES_ALL
OZF_CHARGEBACK_PRICE_ADJ_ALL
OZF_CLAIMS_ALL
OZF_CLAIMS_HISTORY_ALL
OZF_CLAIMS_INT_ALL
OZF_CLAIM_ADJUSTMENTS_ALL
OZF_CLAIM_DEF_RULES_ALL
OZF_CLAIM_LINES_ALL
OZF_CLAIM_LINES_HIST_ALL
OZF_CLAIM_LINES_INT_ALL
OZF_CLAIM_LINES_UTIL_ALL
OZF_CLAIM_OFFER_PERF_ALL
OZF_CLAIM_STTLMNT_METHODS_ALL
OZF_CLAIM_THRESHOLD_ALL
OZF_CLAIM_TYPES_ALL_B
OZF_CLAIM_TYPES_ALL_TL
OZF_CODE_CONVERSIONS_ALL
OZF_COMPETITOR_PRICE_POINTS
OZF_CUST_DAILY_FACTS
OZF_CUST_PROD_CONT_ALL
OZF_CUST_TRD_PRFLS_ALL
OZF_DASHB_DAILY_KPI
OZF_DENORM_QUERIES
OZF_DISCOUNT_PRODUCT_RELN
OZF_FORECAST_CUSTOMERS
OZF_FORECAST_DIMENTIONS
OZF_FORECAST_PERIODS
OZF_FORECAST_PRODUCTS
OZF_FORECAST_PROD_EXCLUSIONS
OZF_FUNDS_ALL_B
OZF_FUNDS_ALL_TL
OZF_FUNDS_PAID_ALL
OZF_FUNDS_UTILIZED_ALL_B
OZF_FUNDS_UTILIZED_ALL_TL
OZF_FUND_REQUESTS
OZF_INTERFACE_ERRORS
OZF_INVENTORY_TMP_T
OZF_LIFT_FACTORS_FACTS
OZF_LIFT_FACTORS_HISTORY
OZF_LIFT_FACTORS_INTERFACE
OZF_MARKET_PRESET_TIERS
OZF_MC_TRANSACTIONS_ALL
OZF_NAE_COMPLETION_TIME
OZF_NA_CONC_EXCEPTIONS
OZF_NA_CUSTOMERS_TEMP
OZF_NA_DEDUCTION_RULES_B
OZF_NA_DEDUCTION_RULES_TL
OZF_NA_PRODUCTS_TEMP
OZF_NA_RULE_HEADERS_B
OZF_NA_RULE_HEADERS_TL
OZF_NA_RULE_LINES
OZF_OBJECT_FUND_SUMMARY
OZF_OFFERS
OZF_OFFER_ADJUSTMENTS_B
OZF_OFFER_ADJUSTMENTS_TL
OZF_OFFER_ADJUSTMENT_LINES
OZF_OFFER_ADJUSTMENT_PRODUCTS
OZF_OFFER_ADJUSTMENT_TIERS
OZF_OFFER_ADJ_NEW_LINES
OZF_OFFER_ADJ_NEW_PRODUCTS
OZF_OFFER_ADJ_RLTD_LINES
OZF_OFFER_DISCOUNT_LINES
OZF_OFFER_DISCOUNT_PRODUCTS
OZF_OFFER_PARTIES
OZF_OFFER_PARTIES_TEMP
OZF_OFFER_PERFORMANCES
OZF_OFFER_PRODUCTS
OZF_OFFER_PRODUCTS_TEMP
OZF_OFFER_QUALIFIERS
OZF_OFFR_DISC_STRUCT_NAME_B
OZF_OFFR_DISC_STRUCT_NAME_TL
OZF_OFFR_MARKET_OPTIONS
OZF_ORDER_GROUP_PROD
OZF_ORDER_MESSAGE_COUNTER
OZF_PARTY_MARKET_SEGMENTS_T
OZF_PRICE_LIST_ATTRIBUTES
OZF_PRODUCT_ALLOCATIONS
OZF_QP_DISCOUNTS
OZF_QP_PRODUCTS
OZF_QUALIFIER_MARKET_OPTION
OZF_QUOTA_ALERTS
OZF_REASONS
OZF_REASON_CODES_ALL_B
OZF_REASON_CODES_ALL_TL
OZF_RELATED_DEAL_LINES
OZF_REQUEST_HEADERS_ALL_B
OZF_REQUEST_HEADERS_ALL_TL
OZF_REQUEST_LINES_ALL
OZF_RESALE_ADJUSTMENTS_ALL
OZF_RESALE_BATCHES_ALL
OZF_RESALE_BATCH_LINE_MAPS_ALL
OZF_RESALE_HEADERS_ALL
OZF_RESALE_LINES_ALL
OZF_RESALE_LINES_INT_ALL
OZF_RESALE_LOGS_ALL
OZF_RES_CUST_PROD
OZF_RES_CUST_PROD_FACTS
OZF_RETAIL_PRICE_POINTS
OZF_SALES_TRANSACTIONS_ALL
OZF_SETTLEMENT_DOCS_ALL
OZF_SYS_PARAMETERS_ALL
OZF_TERR_LEVELS_ALL
OZF_THRESHOLDS_ALL_B
OZF_THRESHOLDS_ALL_TL
OZF_THRESHOLD_RULES_ALL
OZF_TIME_ALLOCATIONS
OZF_TIME_DAY
OZF_TIME_ENT_PERIOD
OZF_TIME_ENT_QTR
OZF_TIME_ENT_YEAR
OZF_TIME_RPT_STRUCT
OZF_TIME_WEEK
OZF_TP_TERRUSG_MAP
OZF_TRADE_TACTICS_MAPPING
OZF_VOLUME_DETAIL
OZF_VOLUME_OFFER_TIERS
OZF_VOLUME_SUMMARY
OZF_VO_PRODUCTS_TEMP
OZF_WORKSHEET_HEADERS_B
OZF_WORKSHEET_HEADERS_TL
OZF_WORKSHEET_LINES
OZF_WORKSHEET_QUALIFIERS

Views in Trade Management Module

List of Views in Oracle Trade Management Module

OZF_ACT_BUDGETS_DFV
OZF_ACT_FORECASTS_ALL_DFV
OZF_ACT_METRICS_ALL_DFV
OZF_AEL_GL_CLA_V
OZF_AEL_GL_UTL_V
OZF_AEL_SL_CLA_V
OZF_AEL_SL_UTL_V
OZF_AR_DEDUCTIONS_V
OZF_BASELINE_SALES_V
OZF_BATCHES
OZF_CHARGEBACK_HEADERS
OZF_CHARGEBACK_INT
OZF_CHARGEBACK_LINES
OZF_CHARGEBACK_PRICE_ADJ
OZF_CLAIM_LINES_ALL_DFV
OZF_CLAIM_LINES_HIST_V
OZF_CLAIM_LINES_V
OZF_CLAIM_OFFER_UTIL_V
OZF_CLAIM_REQ_HEADER_V
OZF_CLAIM_SUMMARY_V
OZF_CLAIM_TYPES_ALL_B_DFV
OZF_CLAIM_TYPES_ALL_VL
OZF_CLAIM_TYPES_VL
OZF_CLAIMS_ALL_DFV
OZF_CLAIMS_ALL1_DFV
OZF_CLAIMS_HISTORY_V
OZF_CLAIMS_V
OZF_CLAIMS_WEBADI_DOWNLOAD_V
OZF_CUST_PROD_CONT
OZF_CUST_TRD_PRFLS_ALL_DFV
OZF_CUST_TRD_PRFLS_V
OZF_FUND_ALLOCATIONS_V
OZF_FUND_ALLOCTREE_V
OZF_FUND_CHECKBOOK_V
OZF_FUND_DETAILS_V
OZF_FUND_REQUESTS_V
OZF_FUNDS
OZF_FUNDS_ALL_B_DFV
OZF_FUNDS_ALL_VL
OZF_FUNDS_CUST_V
OZF_FUNDS_PAID
OZF_FUNDS_PAID_V
OZF_FUNDS_UTILIZED_ALL_B_DFV
OZF_FUNDS_UTILIZED_ALL_VL
OZF_FUNDS_UTILIZED_VL
OZF_FUNDS_VL
OZF_JE_CATEGORIES_V
OZF_LOOKUP_TYPES
OZF_LOOKUPS
OZF_MC_TRANSACTIONS
OZF_OBJECT_CHECKBOOK_V
OZF_OFFER_ADJUSTMENTS_VL
OZF_OFFER_CLOB_V
OZF_OFFERS_V
OZF_ORDER_SALES_V
OZF_P_CAMPAIGN_OFFERS_V
OZF_PRICE_LIST_LINES_V
OZF_PRICE_LISTS_V
OZF_PRODUCT_OFFERS_V
OZF_PRODUCT_PRICING_V
OZF_QUOTA_CLOB_V
OZF_REASON_CODES_ALL_B_DFV
OZF_REASON_CODES_ALL_VL
OZF_REASON_CODES_VL
OZF_REQ_CLAIMS_V
OZF_REQUEST_HEADERS_ALL_B_DFV
OZF_REQUEST_HEADERS_ALL_VL
OZF_REQUEST_HEADERS_VL
OZF_REQUEST_LINES_ALL_DFV
OZF_RESALE_BATCHES_ALL_DFV
OZF_RESALE_BATCHES_V
OZF_RESALE_HEADERS_V
OZF_RESALE_LINES_ALL_DFV
OZF_RESALE_LINES_INT_ALL_DFV
OZF_RESALE_LINES_V
OZF_RESALE_WEBADI_DOWNLOAD_V
OZF_SALES_TRANSACTIONS
OZF_SD_BATCH_CONTENT_QUERY_V
OZF_SD_BATCH_FROM_ROLE_V
OZF_SD_BATCH_HEADERS_ALL_DFV
OZF_SD_BATCH_INFO_V
OZF_SD_BATCH_LINES_ALL_DFV
OZF_SD_BATCH_TO_ROLE_V
OZF_SD_BILL_TO_CUST_V
OZF_SD_CONTACT_V
OZF_SD_CUSTOMER_DETAILS_DFV
OZF_SD_END_CUST_V
OZF_SD_FROM_ROLE_V
OZF_SD_PRODUCTS_V
OZF_SD_REQUEST_HEADERS_ALL_DFV
OZF_SD_REQUEST_HEADERS_ALL_VL
OZF_SD_REQUEST_LINES_ALL_DFV
OZF_SD_RES_END_CUST_V
OZF_SD_RES_SHIP_TO_CUST_V
OZF_SD_SHIP_TO_CUST_V
OZF_SD_TO_ROLE_V
OZF_TARGET_CLOB_V
OZF_TERR_HIER_V
OZF_TERR_V
OZF_THRESHOLD_RULES
OZF_THRESHOLDS
OZF_THRESHOLDS_ALL_VL
OZF_THRESHOLDS_VL
OZF_WORKSHEET_HEADERS_VL
OZF_X_AGING_BUCKET_LNS
OZF_X_AGING_BUCKETS
OZF_X_CUST_SITE_USES
OZF_X_GET_TRX_TYPES
OZF_X_INVOICE_LINE_V
OZF_X_INVOICES_V
OZF_XLA_ACC_HEADER_V
OZF_XLA_ACCRUAL_V
OZF_XLA_CLAIM_HEADER_V
OZF_XLA_CLAIM_LINES_V
OZF_XLA_CLAIM_V

Trade Management Descriptive Flex Fields

Oracle Trade Management module DFF list:

DFF View DFF CODE NAME DFF name
OZF_OFFER_DISCOUNT_LINES_DFV OZF_OFFER_DISCOUNT_LINES_DFF Descriptive Flexfield for offer discount lines
OZF_ACT_BUDGETS_DFV OZF_ACT_BUDGETS DFF for budget request and transfer
OZF_ACT_METRICS_ALL_DFV OZF_BUDGET_ALLOCATION DFF for budget allocation
OZF_REASON_CODES_ALL_B_DFV OZF_CLAIM_REASONS Claim Reasons
OZF_CLAIM_TYPES_ALL_B_DFV OZF_CLAIM_TYPES Claim Types
OZF_ACT_FORECASTS_ALL_DFV OZF_FCST_HDR Forecast Header DFF
OZF_FUNDS_UTILIZED_ALL_B_DFV OZF_MANUAL_ADJUSTMENT DFF for budget manual adjustment
OZF_OFFER_PERFORMANCES_DFV OZF_OFFER_PERFORMANCE DFF for offer performance
OZF_OFFER_QUALIFIERS_DFV OZF_OFFER_QUALIFIERS_DFF Descriptive Flexfield for offer qualifiers
OZF_REQUEST_LINES_ALL_DFV OZF_REQUEST_LINE Request Line DFF
OZF_RESALE_BATCHES_ALL_DFV OZF_RESALE_BATCH Resale Batch DFF
OZF_RESALE_LINES_ALL_DFV OZF_RESALE_LINE Resale Line DFF
OZF_RESALE_LINES_INT_ALL_DFV OZF_RESALE_LINE_INT Resale Line Interface DFF
OZF_REQUEST_HEADERS_ALL_B_DFV OZF_SOFT_FUND_REQUEST Request Header DFF
OZF_SD_BATCH_HEADERS_ALL_DFV OZF SD Batch Headers Ship Debit Batch Header DFF
OZF_SD_BATCH_LINES_ALL_DFV OZF SD Batch Lines Ship Debit Batch Lines DFF
OZF_SD_CUSTOMER_DETAILS_DFV OZF_SD_CUSTOMER_DETAILS Ship Debit Request Customer DFF
OZF_SD_REQUEST_HEADERS_ALL_DFV OZF_SD_REQUEST_HEADERS_ALL_B Ship Debit Request Header DFF
OZF_SD_REQUEST_LINES_ALL_DFV OZF_SD_REQUEST_LINES_ALL Ship Debit Request Lines DFF