Oracle Audio Technologies Oracle Retail Place 12.2 - Manual (Page 58)

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.