Oracle® Retail Merchandising System Operations Guide, Volume 1 - Batch Overviews and Designs 16.0.024 E89599-02 |
|
Previous |
Next |
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.
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 |
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.
Module Name | cfamigrate.ksh |
Description | CFAS Metadata Migration Script |
Functional Area | CFAS |
Module Type | Admin |
Module Technology | ksh |
Catalog ID | RMS472 |
Runtime Parameters | NA |
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.
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 |
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 |
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).