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

NAME: Baseline Sales Flat File Upload Table Creation
SHORT CODE: OZF_TP_BASELINE2
MODULE: Oracle Trade Management

Description: Create External Table for Baseline Sales 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 Baseline Sales 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: Update Time Structure
SHORT CODE: OZF_TIME_LOAD
MODULE: Oracle Trade Management

Description: Update Time Structure
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_from_date : From Date
• p_to_date : To Date
• p_all_level : All Level