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

NAME: Funds Accrual Engine
SHORT CODE: OZF_FUND_ACCRUAL
MODULE: Oracle Trade Management

Description: Oracle Trade Management Accrual engine
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_run_exception : Run Exception Messages
• p_run_backdated_adjustment : Run Budget Utilization for Adjusted Offer
• p_run_volume_off_adjustment : Run Budget Utilization for Volume Offer
• p_run_unposted_gl : Repost Failed GL Posting
• p_process_message_count : Process Message Count
• p_debug : Run in Debug Mode