OF选项包安装指南说明书

OFS Balance Sheet Planning

Applications Pack

Installation Guide

Release 8.1.0.1.0

October 2020

OFS Balance Sheet Planning Pack Installation Guide

Copyright © 2021 Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions

on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in

your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify,

license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means.

Reverse engineering, disassembly, or decompilation of this software, unless required by law for

interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-

free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it

on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,

any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users

are “commercial computer software” pursuant to the applicable Federal Acquisition Regulation and

agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and

adaptation of the programs, including any operating system, integrated software, any programs installed

on the hardware, and/or documentation, shall be subject to license terms and license restrictions

applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management

applications. It is not developed or intended for use in any inherently dangerous applications, including

applications that may create a risk of personal injury. If you use this software or hardware in dangerous

applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other

measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages

caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks

of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks

are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,

Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced

Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content,

products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and

expressly disclaim all warranties of any kind with respect to third-party content, products, and services

unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its

affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of

third-party content, products, or services, except as set forth in an applicable agreement between you and

Oracle.

For information on third party licenses, click here.

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

2

Document Control

Version Number

1.0

Revision Date

October 2020

Change Log

Created the draft document to capture the OFS BSP

Application Pack 8.1.0.1.0 Maintenance Level Release

installation instructions.

Added a note with information regarding Doc ID 2724021.1. 2.0

November 2020

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

3

Table of Contents

1

OFS BSP Application Pack Release v8.1.0.1.0 ...................................................................... 5

1.1

1.2

1.3

1.4

1.5

Audience ................................................................................................................................................................................ 5

Access to Oracle Support ................................................................................................................................................... 5

Related Documents ............................................................................................................................................................. 5

Conventions .......................................................................................................................................................................... 6

Abbreviations ........................................................................................................................................................................ 6

2

OFS BSP Application Pack Release v8.1.0.1.0 ...................................................................... 8

2.1

2.2

Pre-installation Requirements .......................................................................................................................................... 8

Installing this Release .......................................................................................................................................................... 8

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

4

OFS

BSP

A

PPLICATION

P

ACK

R

ELEASE V

8.1.0.1.0

A

UDIENCE

1 OFS BSP Application Pack Release v8.1.0.1.0

This section provides information about the Oracle Financial Services Balance Sheet Planning (OFS BSP)

Applications Pack.

You can find the latest copy of this document in the OHC Documentation Library which includes all the

recent additions or revisions (if any) done to date.

Before you begin the installation, ensure that you have access to My Oracle Support with the required

login credentials to quickly notify us of any issues at any stage.

Topics:











Audience

Access to Oracle Support

Related Documents

Conventions

Abbreviations

1.1 Audience

OFS BSP Application Pack Installation Guide is intended for administrators and implementation

consultants who handle installing and maintaining the application pack components.

This document assumes that you have experience in installing Enterprise components and basic

knowledge about the following:











OFS BSP Application pack components

OFSAA architecture

UNIX commands

Database concepts

Web server or web application server

1.2 Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit

/pls/topic/lookup?ctx=acc&id=info

Or visit /pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

1.3 Related Documents

We strive to keep this and all other related documents updated regularly; visit the OHC Documentation

Library to download the latest version available there. The list of related documents is provided here.

 OFS Balance Sheet Planning Application Pack Installation and Configuration Guide Release 8.1.0.0.0

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

5

OFS

BSP

A

PPLICATION

P

ACK

R

ELEASE V

8.1.0.1.0

C

ONVENTIONS





OFS Balance Sheet Planning System Administrator User Guide

OFS Planning Administrator and Planning Analyst User Guide

Additional Reference Documents:





OFS Analytical Applications Technology Matrix

OFS Analytical Applications Infrastructure Installation and Configuration Guide

1.4 Conventions

The following text conventions are used in this document.

Table 1: Document Conventions

Convention

boldface

italic

Meaning

Boldface type indicates graphical user interface elements associated with an action or

terms defined in text or the glossary.

Italic type indicates book titles, emphasis, or placeholder variables for which you supply

particular values.

Monospace type indicates commands within a paragraph, URLs, code in examples, file

names, text that appears on the screen, or text that you enter.

Hyperlink type indicates the links to external websites and internal document links.

monospace

Hyperlink

1.5 Abbreviations

The following table lists the abbreviations used in this document.

Table 2: Abbreviations

Abbreviation

BDP

DBA

DDL

DEFQ

DML

EAR

EJB

ERM

FTP

HDFS

HTTPS

Meaning

Big Data Processing

Database Administrator

Data Definition Language

Data Entry Forms and Queries

Data Manipulation Language

Enterprise Archive

Enterprise JavaBean

Enterprise Resource Management

File Transfer Protocol

Hadoop Distributed File System

Hypertext Transfer Protocol Secure

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

6

OFS

BSP

A

PPLICATION

P

ACK

R

ELEASE V

8.1.0.1.0

A

BBREVIATIONS

Abbreviation

J2C

J2EE

JCE

JDBC

JDK

JNDI

JRE

JVM

LDAP

LHS

MFA

MOS

OFSAA

OFSAAI

OFSAAAI

OHC

OLAP

OLH

ORAAH

OS

RAM

RDBMS

RHEL

SFTP

SID

SSL

TNS

URL

VM

WAR

XML

Meaning

J2EE Connector

Java 2 Enterprise Edition

Java Cryptography Extension

Java Database Connectivity

Java Development Kit

Java Naming and Directory Interface

Java Runtime Environment

Java Virtual Machine

Lightweight Directory Access Protocol

Left Hand Side

Multi-Factor Authentication

My Oracle Support

Oracle Financial Services Analytical Applications

Oracle Financial Services Analytical Application Infrastructure

Oracle Financial Services Advanced Analytical Applications Infrastructure Application

Pack

Oracle Help Center

On-Line Analytical Processing

Oracle Loader for Hadoop

Oracle R Advanced Analytics for Hadoop

Operating System

Random Access Memory

Relational Database Management System

Red Hat Enterprise Linux

Secure File Transfer Protocol

System Identifier

Secure Sockets Layer

Transparent Network Substrate

Uniform Resource Locator

Virtual Machine

Web Archive

Extensible Markup Language

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

7

OFS

BSP

A

PPLICATION

P

ACK

R

ELEASE V

8.1.0.1.0

P

RE

-

INSTALLATION

R

EQUIREMENTS

2 OFS BSP Application Pack Release v8.1.0.1.0

OFS Balance Sheet Planning Pack Installation Guide Maintenance Level (ML) release v8.1.0.1.0 includes all

the bug fixes and minor enhancements since the previous Minor release v8.1.0.0.0.

This ML release of OFS BSP Application Pack can be installed on a setup with any Oracle Financial Services

Balance Sheet Planning (OFS BSP) v8.1.0.0.0 Application Pack.

NOTE

In an environment consisting of multiple OFSAA applications, if

the October 2020 Critical Patch Update is applied for any one

application, it is mandatory to apply the respective October

2020 Critical Patch Updates for all other applications on that

OFSAA instance, regardless of the application’s version. See

the My Oracle Support Doc ID 2724021.1 for details.

2.1 Pre-installation Requirements

Ensure that the following prerequisites are present before you install this Maintenance Release:





The minimum patch level installed must be OFS BSP Release 8.1.0.0.0.

The unlimited cryptographic policy for Java is enabled during the installation of OFS BSP 8.1.0.0.0.

For more information, see the Enabling Unlimited Cryptographic Policy section in the OFS Analytical

Applications Infrastructure Administration Guide.

2.2 Installing this Release

To install this release patch, follow these steps:

1. Log in to My Oracle Support and search for 31982164 under the Patches & Updates tab.

2. Download the OFS PFT 8.1.0.1.0 OFS BSP ML Release archive file and copy it to your OFSAA server

in Binary mode.

NOTE

There are different archive files for different operating systems

such as Solaris, and RHEL or OEL.

3. Stop all the OFS AAI services. For more information, see the Stopping Infrastructure Services section

in the OFS Balance Sheet Planning Application Pack Installation and Configuration Guide 8.1.0.0.0.

4. Log in to My Oracle Support, search for the 33663417 Mandatory Patch in the Patches & Updates

Tab and download it.

ATTENTION

On the 10th of December 2021, Oracle released Security Alert CVE-

2021-44228 in response to the disclosure of a new vulnerability

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

8

OFS

BSP

A

PPLICATION

P

ACK

R

ELEASE V

8.1.0.1.0

I

NSTALLING THIS

R

ELEASE

affecting Apache Log4J prior to version 2.15. The application of the

33663417 Mandatory Patch fixes the issue.

For details, see the My Oracle Support Doc ID 2827801.1.

5. Log in to the OFSAA server as a non-root user and navigate to the $FIC_HOME directory.

6. Assign WRITE permission to the files or directories such as commonscripts, EXEWebService, ficapp,

ficweb, and ficdb using the command:

chmod -R 775 *

7. If you have the Unzip utility, skip to the next step or download the Unzip utility (OS-specific) and

copy it in Binary mode to the directory that is included in your PATH variable, typically $HOME path

or directory in which you have copied the 8.1.0.1.0 ML.

 Uncompress the unzip installer file using the command:

uncompress unzip_.Z

NOTE

If you notice an error message "uncompress: not found [No such file

or directory]" when the package is not installed, contact your UNIX

administrator.

 Assign EXECUTE permission to the utility using the command:

chmod 751 unzip_

For example, chmod 751 unzip_linux

8. Extract the contents of the 8.1.0.1.0 ML archive file using one of the following commands:

unzip_ -a

Or

unzip –a

NOTE

The above “-a” option is mandatory to extract the archive file.

An example for the Linux operating system,

unzip -a p31284429_81010_

9. Update the parameters in the file present in the

OFS_BSP_PACK/appsLibConfig/conf directory for the following parameters:

UPLOAD_MODEL=0

10. Navigate to the OFS_BSP_PACK directory to assign EXECUTE permission to the ML patch installer

script using the command:

chmod 755

11. Complete the patch upgrade using the command:

./

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

9

OFS

BSP

A

PPLICATION

P

ACK

R

ELEASE V

8.1.0.1.0

I

NSTALLING THIS

R

ELEASE

12. Verify if the ML patch is applied successfully by checking the log file generated in the

OFS_BSP_PACK/OFS_BSP/logs directory. You can ignore error codes ORA-00001 and ORA-

02292 in the log file. For any other errors, contact My Oracle Support.

NOTE

For an upgrade on Hive Infodom, you may encounter an

exception "PL/SQL: ORA-00942: table or view does not exist".

You can ignore this error.

13. After successful installation of the ML, follow these steps:

 Run the following command to execute the .profile file:

. $HOME/.profile

 Clear the application cache. Navigate to the following path depending on the configured web

application server and delete the files.

 Tomcat:

/work/Catalina/localhost/

name>/org/apache/jsp

 WebLogic:

/domains/

name>/servers//tmp/_WL_user/

 WebSphere:

/AppServer/profiles/

name>/temp//server1//<.war file name>

14. Delete the existing EAR or WAR file available in the $FIC_HOME/ficweb directory.

15. Install the OFSAAIRunner package. This is an optional step and applicable only if you have installed

Oracle R Enterprise Edition (ORE). For more information, see Install the Updated OFSAAI Runner

section in OFS AAI Installation Guide 8.1.0.1.0.

16. Generate the application EAR or WAR file and redeploy the application onto your configured web

application server. For more information on generating and deploying the EAR or WAR file, see the

Post Installation Configurations section in the OFS Balance Sheet Planning Application Pack

Installation and Configuration Guide 8.1.0.0.0.

17. Restart all the OFSAAI services. For more information, see the Starting Infrastructure Services

section in the OFS Balance Sheet Planning Application Pack Installation and Configuration Guide

8.1.0.0.0.

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

10

OFSAA

S

UPPORT

OFSAA Support

Raise a Service Request (SR) in My Oracle Support for queries related to the OFSAA applications.

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

11

S

END

U

S

Y

OUR

C

OMMENTS

Send Us Your Comments

Oracle welcomes your comments and suggestions on the quality and usefulness of this publication. Your

input is an important part of the information used for revision.











Did you find any errors?

Is the information clearly presented?

Do you need more information? If so, where?

Are the examples correct? Do you need more examples?

What features did you like most about this manual?

If you find any errors or have any other suggestions for improvement, indicate the title and part number

of the documentation along with the chapter/section/page number (if available) and contact the My

Oracle Support.

Before sending us your comments, you might like to ensure that you have the latest version of the

document wherein any of your concerns have already been addressed. You can access My Oracle Support

site that has all the revised/recently released documents.

OFS

B

ALANCE

S

HEET

P

LANNING

P

ACK

I

NSTALLATION

G

UIDE

|

12