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

Configuring Place
Installing Place Over Plan 6-5
Reference to the Data Load Scripts
The following table describes the scripts (required for the data load), and lists their
location in the AESample directory:
Table 6–1 Data Load Scripts for Place and Plan
Script Name
Script Location
(Place_Install\DataSets\AESample) Script Description
Custom Scripts
custom_ir_objects.sql AESample\Data\Seed This SQL script loads the customized inference
rules.
data_levels_tbl.sql AESample\Data\Seed This SQL script loads the size profile information,
based on your business, for the merchandise and
location hierarchy.
dist_centers_tbl.sql AESample\Data\Seed This SQL script loads the information on the
distribution centers.
merchandise_admin_settings_tbl.sql AESample\Data\Seed\Place This SQL script loads the customized merchandise
administration settings.
otr_component_types_tbl.sql AESample\Data\Seed\Place This SQL script loads the customized Open to
Receive (OTR) metric values.
Generic Scripts
a4p_required_data.sql AESample\Data\Seed\Place This SQL script loads the essential business data
required by the Place application.
create_default_users.sql AESample\Data\Seed\Place This SQL script creates the default user required
by the Place application.
emphasis_types.sql AESample\Data\Seed This SQL script loads the emphasis types.
grid_data_population.sql AESample\Data\Seed\Place This SQL script loads the grid and column
configurations.
media_types.sql AESample\Data\Seed This SQL script loads the information on the type
of media used in a promotion.
merch_admin_setting_types_tbl.sql AESample\Data\Seed\Place This SQL script loads the merchandise
administration setting types.
page_indicator_types.sql AESample\Data\Seed This SQL script loads the information on the
location, front or back, where the promotion
advertisement can be placed.
pl_dd_attributes.sql AESample\Data\Seed This SQL script enables the merchandise hierarchy
and location hierarchy CDAs (disabled by
default.)
pl_load_client_place.sql AESample\DeployScripts\Place This SQL script executes various procedures to
load the warehouse inventory, daily inventory,
OTR feeds, and weekly sales for the Place
application.
planned_item_types.sql AESample\Data\Seed This SQL script loads the planned item types.
pricing_types.sql AESample\Data\Seed This SQL script loads the pricing types.
store_attribute_names_tbl.sql AESample\Data\Seed This SQL script loads the store division (Str Div)
and subset records in the STORE_ATTRIBUTES_
NAMES_TBL table. These records are the initial
set of location hierarchy level descriptions (in the
Store Set User Interface) essential for the
application.
store_set_data.sql AESample\Data\Seed This SQL script loads the store set information.
upd_static_grid_data.sql AESample\Data\Seed\Place This SQL script loads the Store Division (STR DIV)
record in the CT_COLUMNS_TBL table. This table
stores the grid and column information in the
database.