5 Custom Flexible Attributes Solution

This chapter describes the batch processes related to the Custom Flexible Attributes Solution (CFAS). CFAS consists of a series of UI, database and batch processes that allow clients to configure and use sophisticated custom attributes on common RMS entities.

For additional information about CFAS, including detailed flow diagrams, see the Oracle Retail Merchandising System Custom Flex Attribute Solution Implementation Guide.

Program Summary

Table 5-1 Custom Flex Attributes Solution - Program Summary

Program	Description
cfagen.ksh	CFAS Database Object Creation Script
cfamigrate.ksh	CFAS Metadata Migration Script
cfastgload.ksh	Bulk load of CFAS Attribute Data

cfagen (CFAS Database Object Creation Script)

Module Name	cfagen.ksh
Description	CFAS Database Object Creation Script
Functional Area	CFAS
Module Type	Admin
Module Technology	ksh
Catalog ID	RMS471
Runtime Parameters	NA

Design Overview

This script creates the database objects required for CFAS.

For more information, see the following documents in the Oracle Retail Merchandising System documentation set:

• Oracle Retail Merchandising System Custom Flex Attribute Solution Implementation Guide

This script only needs to be run if a client is using CFAS and changing CFAS configuration.

Scheduling Constraints

Table 5-2 Scheduling Constraints

Schedule Information	Description
Frequency	As needed
Scheduling Considerations	NA
Pre-Processing	NA
Post-Processing	NA
Threading Scheme	NA

Restart/Recovery

NA

Key Tables Affected

Table 5-3 Key Tables Affected

Table	Select	Insert	Update	Delete
cfa_ext_entity	Yes	No	No	No
cfa_attrib_group_set	Yes	No	No	No
system_option	Yes	No	No	No
cfa_attrib	Yes	No	No	No
cfa_attrib_group	Yes	No	No	No
cfa_ext_entity_key	Yes	No	No	No

I/O Specification

NA

cfamigrate (CFAS Metadata Migration script)

Module Name	cfamigrate.ksh
Description	CFAS Metadata Migration Script
Functional Area	CFAS
Module Type	Admin
Module Technology	ksh
Catalog ID	RMS472
Runtime Parameters	NA

Design Overview

This script extracts CFAS metadata from the current environment so the metadata can be migrated to other environments. This allows CFAS metadata to be created and tested in a development/sandbox environment, then moved to production environments when it is fully ready.

For more information, see the following documents in the Oracle Retail Merchandising System Release 16.0 documentation set and the Oracle Retail Merchandising System Custom Flex Attribute Solution Implementation Guide.

This script only needs to be run if the client needs to move the CFAS configuration from one environment to another.

Scheduling Constraints

Table 5-4 Scheduling Constraints

Schedule Information	Description
Frequency	As needed
Scheduling Considerations	NA
Pre-Processing	NA
Post-Processing	NA
Threading Scheme	NA

Restart/Recovery

NA

Key Tables Affected

Table 5-5 Key Tables Affected

Table	Select	Insert	Update	Delete
cfa_rec_group	Yes	Yes	Yes	No
cfa_rec_group_labels	Yes	Yes	Yes	No
cfa_ext_entity	Yes	Yes	Yes	No
cfa_ext_entity_key	Yes	Yes	Yes	No
cfa_ext_entity_key_labels	Yes	Yes	Yes	No
cfa_attrib_group_set	Yes	Yes	Yes	No
cfa_attrib_group_set_labels	Yes	Yes	Yes	No
cfa_attrib_group	Yes	Yes	Yes	No
cfa_attrib_group_labels	Yes	Yes	Yes	No
cfa_attrib	Yes	Yes	Yes	No
cfa_attrib_labels	Yes	Yes	Yes	No

cfastgload (Bulk load of CFAS Attribute Data)

Module Name	cfastgload.ksh
Description	Bulk load of CFAS Attribute Data
Functional Area	CFAS
Module Type	Admin
Module Technology	ksh
Catalog ID	RMS117
Runtime Parameters	NA

Design Overview

This script allows clients to bulk load data into CFAS attributes. This utility is handy when upgrading from earlier versions of RMS or adding a new attribute with data already existing in another system.

For more information, see the following documents in the Oracle Retail Merchandising System Release 16.0 documentation set and the Oracle Retail Merchandising System Custom Flex Attribute Solution Implementation Guide.

This script only needs to be run if a client is using CFAS and needs to bulk load information from an external system (including previous version of RMS).

Scheduling Constraints

Table 5-6 Scheduling Constraints

Schedule Information	Description
Frequency	As needed
Scheduling Considerations	NA
Pre-Processing	NA
Post-Processing	NA
Threading Scheme	NA

Restart/Recovery

NA

Key Tables Affected

Table 5-7 Key Tables Affected

Table	Select	Insert	Update	Delete
cfa_attrib_group_set	Yes	No	No	No
cfa_ext_entity_key	Yes	No	No	No
cfa_ext_entity	Yes	No	No	No
cfa_attrib_group	Yes	No	No	No
cfa_attrib	Yes	No	No	No

I/O Specification

Integration Type	Upload to RMS
File Name	Determined by runtime parameter
Integration Contract	IntCon000001

Note: The staging table where the data will be inserted is determined during runtime.