Siebel Applications Administration Guide > Real-Time Decisions >

Creating Views in the SIEBEL_OLTP Database


At run time, Siebel RTD Server accesses views defined in the SIEBEL_OLTP database to populate the Siebel RTD Server entities. The login script that executes the Data Definition Language (DDL) statements to create the views must have CREATE VIEW privileges in the database. Only create the views for the inline service that you want to install. For example, if you want to install a B2B inline service, include only B2B views.

This task is a step in Process of Configuring Siebel Business Applications for Siebel RTD.

To create views in the SIEBEL_OLTP database

  1. Open the text file that contains the statements which create views specific to your OLTP database type and Siebel Enterprise application type. The filenames of the text files are listed in the following table:
    Application Type
    OLTP Database Type
    Filename

    B2B

    Siebel Business Applications

    \ALL\8.0\B2B\SQL_HOR_ORACLE.txt

    B2B

    Siebel Industry Applications

    \ALL\8.0\B2B\SQL_SIA_ORACLE.txt

    B2C

    Siebel Business Applications

    \ALL\8.0\B2C\SQL_HOR_ORACLE.txt

    B2C

    Siebel Industry Applications

    \ALL\8.0\B2C\SQL_SIA_ORACLE.txt

  2. Find the CREATE VIEW statement in the text file for the view that you want to create.
  3. Execute the CREATE VIEW statement on your database.
  4. Test that the CREATE VIEW statement worked correctly. For example, execute a statement similar to the following:

    SELECT * FROM RTD_B2C_CONTACT

    Make sure that you replace RTD_B2C_CONTACT with the correct view name.

  5. Repeat Step 2 to Step 4 for each view that you want to create.
Siebel Applications Administration Guide Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices.