Oracle Audio Technologies Retail Place 12.2 사용자 설명서
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:
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
(Place_Install\DataSets\AESample) Script Description
Custom Scripts
custom_ir_objects.sql
AESample\Data\Seed
This SQL script loads the customized inference
rules.
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.
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.
distribution centers.
merchandise_admin_settings_tbl.sql
AESample\Data\Seed\Place
This SQL script loads the customized merchandise
administration settings.
administration settings.
otr_component_types_tbl.sql
AESample\Data\Seed\Place
This SQL script loads the customized Open to
Receive (OTR) metric values.
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.
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.
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.
configurations.
media_types.sql
AESample\Data\Seed
This SQL script loads the information on the type
of media used in a promotion.
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.
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.
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.)
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.
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.
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.
record in the CT_COLUMNS_TBL table. This table
stores the grid and column information in the
database.