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

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

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