You are browsing the archive for Oracle Trade Management.

Purge Baseline Sales and Promotional Lift Factor Data

 

NAME: Purge Baseline Sales and Promotional Lift Factor Data
SHORT CODE: OZF_TP_PURGE_BASELINE_LIFT
MODULE: Oracle Trade Management

Description: Program to Purge Baseline Sales and Promotional Lift Factor Data
Navigation: Oracle Trade Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_data_source : Data Source
  • p_data_type : Data Type (Baseline Sales or Promotional Lift Factors)
  • p_curr_or_hist : Current or Historical data
  • p_record_type : Record Types (Erroneous or Successfully Processed or All records)
  • p_as_of_date : Purge historical data up to this date

 

Promotional Lift Factors Flat File Upload – Pass 2

 

NAME: Promotional Lift Factors Flat File Upload – Pass 2
SHORT CODE: OZF_TP_LIFT4
MODULE: Oracle Trade Management

Description: Load Promotional Lift Factors Flat File into Trade Management Interface Tables – second pass
Navigation: Oracle Trade Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_data_source : Data Source

 

Promotional Lift Factors Flat File Upload – Pass 1

 

NAME: Promotional Lift Factors Flat File Upload – Pass 1
SHORT CODE: OZF_TP_LIFT3
MODULE: Oracle Trade Management

Description: Load Promotional Lift Factors Flat File into Trade Management Interface Tables – first pass
Navigation: Oracle Trade Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_data_source : Data Source