Preface

Intended Audience

Welcome to Release 12.2 of the Oracle Demantra Implementation Guide.

See Related Information Sources for more Oracle Applications product information.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Structure

1  Introduction to Demantra

This chapter provides an overview of the Demantra platform.


2  Core Concepts

This chapter explains worksheets and other basic concepts.


3  How Demantra Calculates and Stores Data

As an implementer, you should understand how Demantra calculates and stores data, because this can affect how you set up your solution. This chapter provides an overview of most important details.


4  Multiple Language Support

This chapter describes how to work with languages and internationalization in Demantra.


5  Implementation Tools and Process

This chapter provides a quick overview of the implementation and hand-off processes and tools you use during these processes.


6  Levels

This chapter describes levels and related concepts, outlines the primary configuration options, and summarizes the available tools.


7  Series
8  Units, Indexes, and Exchange Rates

This chapter describes units and related concepts, outlines the primary configuration options, and summarizes the available tools.


9  Worksheets

This chapter describes worksheets, outlines the primary configuration options, and summarizes the available tools.


10  Methods and Workflow

This chapter describes options that you can use to create automated actions in your application, outlines the primary configuration options, and summarizes the available tools.


11  Security

This chapter explains the Demantra security mechanisms.


12  Proport

This chapter explains the proport mechanism.


13  General Integration Guidelines

A pre-made model supports out-of-the-box integration of the Oracle e-Business Suite or EnterpriseOne applications with the Oracle Demantra Demand Management application. This model contains necessary definitions to support both Oracle e-Business Suite and EnterpriseOne applications and uses many common building blocks. The Oracle e-Business Suite model serves as the core best practice for Oracle Demantra Demand Management integration. Where EnterpriseOne information is missing, e-Business Suite documentation applies


14  Demantra Data Tables and Integration Processes
15  Getting Started with the Configuration Tools

This chapter introduces the primary tools you use to configure Demantra, namely, Business Modeler and Workflow Manager.


16  Database Tools

The Business Modeler provides a simple user interface for creating and modifying database tables that is useful during implementation.


17  Using the Data Model Wizard

This chapter describes how to use the Data Model Wizard.


18  Configuring Levels

This chapter describes how to configure levels with the Configure > Levels option.


19  Configuring Series and Series Groups

This chapter describes how to configure series and series groups.


20  Configuring Units, Indexes, and Update-Lock Expressions

This chapter describes how to perform miscellaneous configuration tasks.


21  Series and Level Integration

This chapter describes how to use the Integration Interface Wizard, which you use to import or export series data and level members.


22  Importing Supplementary Data

This chapter describes how to import data into the Demantra database by using Tools > Import File. You use this tool to import supplementary data such as lookup tables.


23  Creating Workflows

This chapter describes how to create Demantra workflows, which are automated or semi-automated processes that you can use for a wide variety of purposes.


24  Configuring Methods

This chapter describes how to configure methods that the users can run within worksheets or within a Members Browser content pane.bp


25  Using the Desktop BLE User Interface

This chapter describes how to configure and use the Business Logic Engine (BLE) to evaluate client expressions in worksheets.


26  Enhancements for Consumption-Driven Planning
27  Non-Engine Parameters

This chapter describes parameters unrelated to the Analytical Engine and lists their default values, if any. As indicated, most parameters are visible to all users; a few are visible only if you log in as the owner of the component.


28  Database Procedures
29  Key Tables

This chapter provides reference information for some of the most important tables in Demantra, especially the data fields used by or written by the Analytical Engine. Unless otherwise noted, this information applies to all Demantra products.


30  Server Expression Functions and Operators

This appendix provides reference information for the operators and functions that are allowed in server expressions.


31  Client Expression Functions and Operators

This appendix provides reference information for the operators and functions that are allowed in client expressions.


32  Workflow Steps

This chapter provides reference information for the available workflow steps.


33  Configuring Predictive Trade Planning
34  Configuring Promotion Optimization for Predictive Trade Planning
35  Configuring Deductions and Settlement Management

This chapter describes how to configure Oracle Demantra Deductions and Settlement Management and load an initial set of data.


36  Fine Tuning and Scaling Demantra
37  Customizing Demantra Web Pages

This chapter describes how to customize the Demantra Web pages.


38  Configuring Rolling Data

This chapter describes how to roll selected data, saving a copy of the current version of that data.


39  GL Synchronization

This chapter describes the GL synchronization feature and how to configure this feature.


40  Performing Constraint Profit Optimization

This chapter describes how to use the Constraint Profit Optimizer.


41  Creating a Demand Variability Process

This chapter describes the creation of a demand variability process.


42  Administering Demantra

This chapter briefly introduces the tasks that the system administrator for Demantra would perform. It also lists all the URLs that Demantra uses.


43  Managing Security

Demantra data and features are secured, so that not all users have access to the same data and options. This chapter describes how to maintain security.


44  Managing Workflows

This chapter describes how to use the Workflow Manager to start, stop, and view workflow instances and to manage schema groups.


45  Managing Worksheets

Worksheets are created within the user interfaces, but you can manage them from the Business Modeler.


46  Other Administration

Demantra provides a Web-based interface to perform other, less common administrative tasks, described here.


47  Using the Oracle Demantra Business Application Language
48  Tips and Troubleshooting

For reference, the first section describes the first-time login procedure for Demantra applications, followed by several sections of tips. After that, this chapter lists possible errors that users may encounter and describes how to resolve them. The errors are listed alphabetically by message text or general description.

See Also

Oracle Demantra Release Notes Oracle Demantra Installation Guide


A  Key Tables

Related Information Sources

Oracle Demantra products share business and setup information with other Oracle Applications products. Therefore, refer to other user guides when you set up and use Oracle Demantra.

User Guides Related to All Products:

User Guides Related to Oracle Demantra:

Integration Repository

The Oracle Integration Repository is a compilation of information about the service endpoints exposed by the Oracle E-Business Suite of applications. It provides a complete catalog of Oracle E-Business Suite's business service interfaces. The tool lets users easily discover and deploy the appropriate business service interface for integration with any system, application, or business partner.

The Oracle Integration Repository is shipped as part of the Oracle E-Business Suite. As your instance is patched, the repository is automatically updated with content appropriate for the precise revisions of interfaces in your environment.

Do Not Use Database Tools to Modify Oracle E-Business Suite Data

Oracle STRONGLY RECOMMENDS that you never use SQL*Plus, Oracle Data Browser, database triggers, or any other tool to modify Oracle E-Business Suite data unless otherwise instructed.

Oracle provides powerful tools you can use to create, store, change, retrieve, and maintain information in an Oracle database. But if you use Oracle tools such as SQL*Plus to modify Oracle E-Business Suite data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data.

Because Oracle E-Business Suite tables are interrelated, any change you make using an Oracle E-Business Suite form can update many tables at once. But when you modify Oracle E-Business Suite data using anything other than Oracle E-Business Suite, you may change a row in one table without making corresponding changes in related tables. If your tables get out of synchronization with each other, you risk retrieving erroneous information and you risk unpredictable results throughout Oracle E-Business Suite.

When you use Oracle E-Business Suite to modify your data, Oracle E-Business Suite automatically checks that your changes are valid. Oracle E-Business Suite also keeps track of who changes information. If you enter information into database tables using database tools, you may store invalid information. You also lose the ability to track who has changed your information because SQL*Plus and other database tools do not keep a record of changes.