Oracle Audio Technologies Retail Place 12.2 User Manual

Configuring Place

Installing Place Over Plan

The following table describes the scripts (required for the data load), and lists their 
location in the AESample directory:

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.

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.