Server User Manual

Configuring Place
6-4 Oracle® Retail Place Installation Guide
load the seed data. For more information on the scripts, see Reference to the Data Load
Scripts.
To load the seed data:
1. At the SQL prompt, run the following scripts:
■ custom_ir_objects.sql (Custom script)
■ pl_dd_attributes.sql (Generic script)
■ data_levels_tbl.sql (Custom script)
■ dist_centers_tbl.sql (Custom script)
These scripts are common for the Place and Plan applications.
2. Run the following scripts for the Place application:
■ create_default_users.sql (Generic script)
■ merch_admin_setting_types_tbl.sql (Generic script)
■ merchandise_admin_settings_tbl.sql (Custom script)
■ otr_component_types_tbl.sql (Custom script)
■ grid_data_population.sql (Generic script)
■ upd_static_grid_data.sql (Generic script)
These scripts load data specific to the Place application.
3. Add the following script to the automation set up for the nightly run:
■ pl_load_client_place.sql (Place-specific script)
4. After the first automation process, run the following scripts:
■ store_set_data.sql (Generic script)
■ store_attribute_names_tbl.sql (Generic script)
■ planned_item_types.sql (Generic script)
■ media_types.sql (Generic script)
■ emphasis_types.sql (Generic script)
■ indicator_types.sql (Generic script)
■ pricing_types.sql (Generic script)
5. Run the Initialization Load process, and then the following script in the Place
application:
■ a4p_required_data.sql (Place-specific script)
Note: You need not run these scripts for the Plan application, if the
application was upgraded to Plan Version 2.6.
Note: You need not run these scripts for the Plan application, if the
application was upgraded to Plan Version 2.6.