Oracle® Retail Financial Integration for Oracle Retail Merchandise Operations Management and Oracle Financials Installation Guide Installation Guide Release 16.0.023 E92036-01 |
|
![]() Previous |
![]() Next |
This chapter includes:
Log in to the UNIX server as a user who has sufficient access to run sqlplus from the Oracle Database installation.
Create a new staging directory for the ORFI installer distribution (RetailFinancialIntegrationPak16.0.023ForRfi16.0.023_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.
Copy RetailFinancialIntegrationPak16.0.023ForRfi16.0.023_eng_ga.zip to <INSTALL_DIR> and extract its contents.
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 as integrating financial system
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 ;
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.
This installer installs the ORFI database schema, compiles ORFI objects, and inserts ORFI data.
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
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.
Based on whether integrating Oracle Financials application is EBS or PeopleSoft, 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/<timestamp>.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:
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