3 ORFI Database Installation Tasks

This chapter includes:

• Expand the ORFI Installer Distribution

• Database Schema Topology

• Create Tablespaces

• Create the ORFI Database User

• Run the ORFI Database Schema Installer

• Verification

Expand the ORFI Installer Distribution

1. Log in to the UNIX server as a user who has sufficient access to run sqlplus from the Oracle Database installation.

2. Create a new staging directory for the ORFI installer distribution (RetailFinancialIntegrationPak16.0.030ForRfi16.0.030_eng_ga.zip). There should be a minimum of 50 MB disk space available for the application and database schema installation files. This location is referred to as INSTALL_DIR for the remainder of this chapter.

3. Copy RetailFinancialIntegrationPak16.0.030ForRfi16.0.030_eng_ga.zip to <INSTALL_DIR> and extract its contents.

Database Schema Topology

This topology diagram shows how different schemas are integrated with each other. There are two diagrams one with EBS as integrating financial system and other Oracle PeopleSoft or Cloud Financials (CFIN) as integrating financial system

Figure 3-1 RFI Database Schema Topology (EBS)

Figure 3-2 RFI Database Schema Topology (PeopleSoft)

Create Tablespaces

Before you run the ORFI database schema installer, make sure that the RFI_DATA tablespace has been created in the database.

Below is an example of tablespace creation statement for the RFI_DATA tablespace. Oracle Retail recommends the use of locally managed tablespaces with automatic extent and segment space management.

Note: These tablespaces are not sized for a production environment. The customer's Database Administrator should create the tablespace based on their datacenter database architecture and size it appropriately based on expected data volume for their peak data usage.

CREATE TABLESPACE RFI_DATA DATAFILE
'<datafile_path>/rfi_data01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
;

Create the ORFI Database User

The user in the database who will own the ORFI tables must be created prior to running the ORFI database schema installer. A create_user.sql script has been provided that can be used for this:

$INSTALL_DIR/retail-financial-integration-solution/service-based-integration/setup-data/ddl/create_user.sql

After installation is completed, a detailed database user creation log file is created:

$INSTALL_DIR/retail-financial-integration-solution/service-based-integration/setup-data/ddl/create_user.log

The script takes three arguments on the command line in sqlplus: username, password and ORFI tablespace name. For example:

SQL> @create_user.sql <RFI Schema> <RFI Schema Password> <RFI Tablespace Name>

Review this script and run it as a user with adequate permissions, such as SYSTEM.

Run the ORFI Database Schema Installer

This installer installs the ORFI database schema, compiles ORFI objects, and inserts ORFI data.

1. Set the following environment variables:

   • Set the ORACLE_HOME to point to an installation that contains sqlplus. It is recommended that this be the ORACLE_HOME of the ORFI database.

   • Set the PATH to: $ORACLE_HOME/bin:$PATH

   • Set the ORACLE_SID to the name of your database

   • Set the NLS_LANG for proper locale and character encoding

   For example: NLS_LANG=AMERICAN_AMERICA.AL32UTF8

2. If you are using an X server such as Exceed, set the DISPLAY environment variable so that you can run the installer in GUI mode (recommended). If you are not using an X server, or the GUI is too slow over your network, unset DISPLAY for text mode.

3. Based on whether integrating Oracle Financials application is EBS, PeopleSoft, or Cloud Financials run one of the initial setup scripts available in $INSTALL_DIR/retail-financial-integration-solution/service-based-integration/bin/. After installation is completed, a detailed installation log file is created: $INSTALL_ DIR/retail-financial-integration-solution/service-based-integration/bin/<timesta mp>.log.

   For example:

   For EBS integration, run the prompt

   $ sh ebs-load-initial-setup-data-into-integration-schema.sh

   OR

   For PeopleSoft integration, run the prompt

   $ sh psft-load-initial-setup-data-into-integration-schema.sh

   The installer prompts for the following details:

   • Enter the ORFI database schema details

     Enter ORFI Userid:

     Enter ORFI Passwd:

   • Enter the ORFI database server name

     Enter Database Server Name or IP address:

   • Enter the ORFI database server port

     Enter Database Port Number:

   • Enter the ORFI database server SID

     Enter Database SID:

Verification

Log in to the ORFI database schema in the database and query

"SELECT * FROM TAB WHERE TNAME LIKE 'RFI%'"

This query should list the following tables:

• RFI_CURR_RATE_STAGE

• RFI_ODI_LOGS

• RFI_SUPP_CONTACTS_STAGE

• RFI_SUPP_SITES_STAGE

• RFI_SUPP_STAGE

• RFI_XREF_DVM

If integration with PeopleSoft as Oracle Financials application, then along with above mentioned tables the below two tables should also be listed:-

• RFI_TERMS_HEAD

• RFI_TERMS_DETAIL