You are browsing the archive for Oracle Trade Management.

Promotional Lift Factors Flat File Upload Table Creation

 

NAME: Promotional Lift Factors Flat File Upload Table Creation
SHORT CODE: OZF_TP_LIFT2
MODULE: Oracle Trade Management

Description: Create External Table for Promotional Lift Factors Flat File Upload
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_dir_obj : Name of Directory Object Containing the flat file
  • p_data_filename : Name of Promotional Lift Factors flat file
  • p_log_filename : File name to store the log
  • p_bad_filename : File name to store all bad records
  • p_dsc_filename : File name to store all discarded records

 

Baseline Sales Flat File Upload – Pass 2

 

NAME: Baseline Sales Flat File Upload – Pass 2
SHORT CODE: OZF_TP_BASELINE4
MODULE: Oracle Trade Management

Description: Load Baseline Sales 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

 

Baseline Sales Flat File Upload – Pass 1

 

NAME: Baseline Sales Flat File Upload – Pass 1
SHORT CODE: OZF_TP_BASELINE3
MODULE: Oracle Trade Management

Description: Load Baseline Sales 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