Skip Headers
Oracle Configurator Implementation Guide
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Introduction
Part 1 consists of chapters that present a baseline for understanding Oracle Configurator.
Implementation Tasks
- Overview
-
- General Implementation Tasks
-
- Database Tasks
-
- Required Database Tasks
-
- Optional Database Tasks
-
- Integration Tasks
-
- Required Tasks for All Integrations
-
- Optional Integration Tasks
-
- Tasks for Custom Integration
-
- Model Development Tasks
-
- Required Tasks for Model Development
-
- Optional Tasks for Model Development
-
- Deployment Tasks
-
- Required Tasks for All Deployments
-
- Optional Tasks for Deployment
-
- Tasks for Custom Deployments
-
- Conventions
-
- Product Support
-
- Troubleshooting
-
Configurator Architecture
- Overview
-
- Introduction
-
- Runtime Oracle Configurator
-
- Access
-
- Type of Host Application
-
- Login to Host Application
-
- Invocation of Oracle Configurator by Host Application
-
- Incorporation of Oracle Configurator in the Host Application’s UI
-
- Oracle Configurator Security on Publicly Accessible Web Servers
-
- Runtime UI Types
-
- Oracle Configurator Servlet
-
- UI Server
-
- Configuration Interface Object (CIO)
-
- Oracle Configurator Engine
-
- Oracle CZ Schema
-
- Oracle Configurator Developer
-
- Access
-
- Types of Configuration Models
-
- Unit Testing
-
- Multi-Tier Architecture
-
- Runtime Oracle Configurator
-
- Oracle Configurator Developer Three Tiers
-
Database Instances
- Overview
-
- Database Uses
-
- Multiple Database Instances
-
- Model Availability on Multiple Database Instances
-
- Import Source and Target
-
- Publication Source and Target
-
- Decommissioning a Database Instance
-
- Migration Source and Target
-
- BOM Synchronization Source and Target
-
- Linking Multiple Database Instances
-
- Instance and Host System Names
-
- Model Development
-
- Maintenance
-
- Production
-
- System Testing
-
- Deploying a Model
-
- Converting a Publication Target Instance to a Development Instance
-
Data
Part 2 presents information about working with the CZ schema as described in Database Tasks.
The CZ Schema
- Overview
-
- Characteristics of the Oracle CZ Schema
-
- Online Tables and Integration Tables
-
- CZ Subschemas
-
- Public Synonyms
-
- Schema Customization
-
- Import Tables
-
- Import Control Fields
-
- Online Data Fields
-
- Surrogate Key Fields
-
- Dependencies Among Import Tables
-
- Control Tables
-
- CZ_DB_SETTINGS Table
-
- Accessing the CZ_DB_SETTINGS Table
-
- Organization of the CZ_DB_SETTINGS Table
-
- CZ_DB_SETTINGS Parameters
-
- AltBatchValidateURL
-
- BadItemPropertyValue
-
- BatchSize
-
- BOM_REVISION
-
- CommitSize
-
- DISPLAY_INSTANCE_NAME
-
- FREEZE_REVISION
-
- GenerateGatedCombo
-
- GenerateUpdatedOnly
-
- GenStatisticsBOM
-
- GenStatisticsCZ
-
- MAJOR_VERSION
-
- MaximumErrors
-
- MemoryBulkSize
-
- MINOR_VERSION
-
- MULTISESSION
-
- OracleSequenceIncr
-
- PsNodeName
-
- PublicationLocalBOMSynch
-
- PublicationLogging
-
- PublishingCopyRules
-
- PurgeDeleteConfigBatchsize
-
- RefPartNbr
-
- ResolvePropertyDataType
-
- RestoredConfigDefaultModelLookupDate
-
- Revision Date and User
-
- RUN_BILL_EXPLODER
-
- SuppressSuccessMessage
-
- TimeImport
-
- UI_NODE_NAME_CONCAT_CHARS
-
- UseLocalTableInExtractionViews
-
- UtlHttpTransferTimeout
-
Populating the CZ Schema
- Overview
-
- Introduction
-
- Types of Data Stored in the CZ Schema During Development and Runtime
-
- Means of Populating the CZ Schema
-
- CZ_IMP Tables
-
- Standard Import
-
- Inventory and BOM Data That Can Be Imported
-
- Overall Standard Import Procedure
-
- Determining the Import Data Source Instance and the Target Instance
-
- Preparing the Data for Import
-
- Defining Inventory Items for Configuration
-
- Creating BOM Models for Configuration
-
- Defining and Enabling a Server for Import
-
- Exploding BOM Models in Oracle Applications
-
- Exploding a BOM Model in Release 12
-
- Exploding a BOM Model in Release 10.7 or 11.0
-
- Controlling the Data for Import
-
- Importing Data Into Specific Tables
-
- Importing Data from Specific Fields
-
- Populating Import Tables
-
- Modifying EXPLOSION_TYPE
-
- Identifying a BOM Model for Import
-
- Importing Decimal or Integer Quantities
-
- Importing Minimum and Maximum Instances
-
- Importing the Data
-
- Verifying the Data Import
-
- Refreshing Imported Data
-
- Refreshing Imported Data Recommendations
-
- Refreshing Procedures
-
- Importing a BOM Model that Contains Other BOM Models
-
- Refreshing a BOM Model that Contains Other BOM Models
-
- BOM Model References Have Changed
-
- BOM Models Referenced by Previously Imported BOM Model Have Changed
-
- BOM Model with a Common Bill
-
- Rule Import
-
- Populating CZ_IMP_RULES
-
- Populating CZ_IMP_LOCALIZED_TEXTS
-
- Rule Import Tables
-
- Stages of Rule Import
-
- Rule Validation
-
- Rule Import Procedure
-
- Custom Import
-
- Overview of Custom Data Import
-
- Identifying Data for a Custom Data Import
-
- Required ASCII File Format for Custom Import
-
- Loading Property Values by Type
-
- Custom Import Procedure
-
Migrating Data
- Introduction
-
- Migrating Data from a CZ Schema
-
- Migrating Models
-
- Migrating Referenced Models
-
- Restoring Saved Configurations of Migrated Models
-
- Synchronizing Migrated Model Data
-
- Synchronization Criteria During Model Migration
-
Synchronizing Data
- Overview
-
- Introduction
-
- Synchronizing BOM Model Data
-
- The BOM Model Synchronization Process
-
- Checking BOM and Model Similarity
-
- Criteria for BOM Model Similarity
-
- Result of Synchronizing BOM Models
-
- Synchronizing Publication Data
-
- Synchronizing Publication Data after a Database Instance is Cloned
-
- Example of Synchronizing Publication Data
-
- CZ_SERVERS Table
-
- CZ_MODEL_PUBLICATIONS Table
-
- Example Publication Data Before Cloning
-
- Example of Synchronizing Publication Data on a Cloned Target
-
- Example of Synchronizing Publication Data on a Cloned Source
-
CZ Schema Maintenance
- Overview
-
- Introduction
-
- Refreshing or Updating the Production CZ Schema
-
- Purging Configurator Tables
-
- Purge Configurator Tables
-
- Purge Configurator Import Tables
-
- Purge To Date Configurator Import Tables
-
- Purge To Run ID Configurator Import Tables
-
- Redoing Sequences
-
Integration
Part 3 presents integration information for setting up Oracle Configurator with other Oracle Applications or a custom application as described in Integration Tasks.
Session Initialization
- Overview
-
- Introduction
-
- Definition of Session Initialization
-
- Responsibilities of the Host Application
-
- Setting Parameters
-
- Parameter Syntax
-
- Omitting Parameters or Values
-
- Typical Parameter Values
-
- Minimal Test of Initialization
-
- Parameter Validation
-
- Logging of Parameter Use
-
- Initialization Parameter Types
-
- Login Parameters
-
- Model Identification Parameters
-
- Identifying the User Interface Definition
-
- Identifying the Configuration
-
- Identifying the Model
-
- Model Publication Identification Parameters
-
- Support of Multiple Instantiation
-
- Return URL Parameter
-
- Pricing Parameters
-
- ATP Parameters
-
- Arbitrary Parameters
-
- Parameter Compatibility
-
- Initialization Parameter Descriptions
-
Session Termination
- Introduction
-
- Overview
-
- Relationship to Initialization Message
-
- Definition of Session Termination
-
- XML Message Structure
-
- Submission
-
- Configuration Status
-
- Subelements for Configuration Status
-
- Configuration Outputs
-
- Subelements for Configuration Outputs
-
- Configuration Messages
-
- Subelements for Configuration Messages
-
- Cancellation
-
- Error
-
- The Return URL
-
- Specifying the Return URL
-
- Implementing the Return URL
-
Batch Validation
- Overview
-
- Introduction
-
- Passing the Batch Validation Message
-
- Calling the CZ_CF_API.VALIDATE Procedure
-
- Batch Validation Failure
-
- Skipping Batch Validation
-
- PL/SQL Callback
-
- PL/SQL Callback and Models that use Configurator Extensions
-
Custom Integration
- Overview
-
- General Directory Structure
-
- Files for the Servlet Directory
-
- Files for the HTML Directory
-
- Files for the Media Directory
-
Pricing and ATP in Oracle Configurator
- Overview
-
- Introduction
-
- Runtime Oracle Configurator Pricing Architecture
-
- Pricing Callback Interface Package
-
- Pricing Callback Interface
-
- Use of the Database in the Price Multiple Items Procedures
-
- Examples of the Pricing Callback Interface
-
- ATP Callback Interface
-
- Use of the Database with the ATP Callback Interface
-
- Examples of the ATP Callback Interface
-
- Runtime Pricing Behavior
-
- Integration of Pricing and ATP with Oracle Configurator
-
- Database Compatibility
-
- Initialization Parameters
-
- Controlling Pricing and ATP in a Runtime Oracle Configurator
-
- Displaying Prices and ATP Information
-
- Updating Prices
-
- Examples of Controlling Pricing
-
- Example: List Prices Only
-
- Example: Selling Prices Only
-
Multiple Language Support
- Overview
-
- Introduction
-
- Data Import
-
- New Models
-
- Existing Models
-
- Installed Languages in Multiple Server Environments
-
- Deploying a User Interface that Supports MLS
-
- Translating Data in CZ_LOCALIZED_TEXTS
-
- Translating XML Documents
-
Configuration Model
This Part presents information that enables you to extend a BOM Model’s structure, rules, and UI to reflect your business requirements and integrate with a host application as described in Model Development Tasks.
Controlling the Development Environment
- Overview
-
- Setting up Oracle Configurator Developer
-
- Setting up Access to Configurator Developer
-
- Oracle Configurator Developer
-
- Model Development
-
- Runtime Testing
-
Publishing Configuration Models
- Overview
-
- Planning Publications
-
- Designing A Project
-
- Preventing Publication Access Errors
-
- How Host Applications Select a Published Model
-
- Example: How a Usage Affects Model Structure, Rules, and Model Publications at Runtime
-
- Defining a Publication
-
- Source and Remote Publications
-
- Tables Used in Publishing
-
- Publication Details
-
- Model
-
- Product ID
-
- User Interface
-
- Target Database Instance
-
- Mode
-
- Publication Applicability Parameters
-
- Applications
-
- Languages
-
- Usages
-
- Date Range
-
- Publishing a Configuration Model
-
- Publication Profile Options
-
- Publishing and Model References
-
- Copying User Interface Data
-
- Copying Model Rules
-
- Checking BOM Model and Configuration Model Similarity
-
- Maintaining Publications
-
- Publication Status
-
- Editing Publications
-
- Disabling, Deleting, and Re-enabling Publications
-
- Republishing
-
- Determining Publishing Information
-
- Retrieving Orders from Previously Published Models
-
- Synchronizing Publication Data
-
- Example of Maintaining Publications
-
Programmatic Tools for Development
- Overview
-
- Overview of the CZ_CF_API and CZ_CONFIG_API_PUB Packages
-
- Purpose of the Packages
-
- Overview of Procedures and Functions
-
- Installation of the Packages
-
- References for Working with PL/SQL Procedures and Functions
-
- Choosing the Right Tool for the Job
-
- Establishing Session Identity
-
- Setting Configuration Dates
-
- Validating Configurations
-
- Verifying Configurations
-
- Copying and Deleting Configurations
-
- Working with Common Bills
-
- Identifying Publications
-
- Functions for Identifying Publications
-
- Applicability Parameters
-
- List Parameters
-
- Routing Models to Specified JVMs
-
- Reference for the CZ_CF_API and the CZ_CONFIG_API_PUB Packages
-
- Custom Data Types
-
- Procedures and Functions in the CZ_CF_API and CZ_CONFIG_API_PUB Packages
-
- COMMON_BILL_FOR_ITEM
-
- Syntax and Parameters
-
- CONFIG_MODEL_FOR_ITEM
-
- Considerations Before Running
-
- Timing
-
- Dependencies
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- CONFIG_MODELS_FOR_ITEMS
-
- Considerations Before Running
-
- Timing
-
- Dependencies
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- CONFIG_MODEL_FOR_PRODUCT
-
- Considerations Before Running
-
- Timing
-
- Dependencies
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- CONFIG_MODELS_FOR_PRODUCTS
-
- Considerations Before Running
-
- Timing
-
- Dependencies
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- CONFIG_UI_FOR_ITEM
-
- Considerations Before Running
-
- Timing
-
- Dependencies
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- CONFIG_UI_FOR_ITEM_LF
-
- Considerations Before Running
-
- Timing
-
- Dependencies
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- CONFIG_UI_FOR_PRODUCT
-
- Considerations Before Running
-
- Timing
-
- Dependencies
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- CONFIG_UIS_FOR_ITEMS
-
- Considerations Before Running
-
- Timing
-
- Dependencies
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- CONFIG_UIS_FOR_PRODUCTS
-
- Considerations Before Running
-
- Timing
-
- Dependencies
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- COPY_CONFIGURATION
-
- Considerations Before Running
-
- Prerequisites
-
- Timing
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- Troubleshooting
-
- CZ_CONFIG_API_PUB.COPY_CONFIGURATION
-
- Considerations Before Running
-
- Prerequisites
-
- Timing
-
- Warnings
-
- Syntax and Parameters
-
- COPY_CONFIGURATION_AUTO
-
- Considerations Before Running
-
- Prerequisites
-
- Timing
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
- Results
-
- Troubleshooting
-
- CZ_CONFIG_API_PUB.COPY_CONFIGURATION_AUTO
-
- Considerations Before Running
-
- Prerequisites
-
- Timing
-
- Warnings
-
- Syntax and Parameters
-
- Considerations After Running
-
-