My Oracle Support Banner

OFSAA 8.0.6 Unix FTPSHARE and OFSAA Application ID Question (Doc ID 2490034.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)

Goal

Working on 8.0.6 installation on RHEL and need more information on setting up the Linux IDs/groups correctly.

Currently have two Linux accounts to be setup to run the OFSAA application. One Linux account is to run OFSAA and the other Linux account is the OFSAA ftpshare account.

Want to make sure setup of the Linux groups correctly in order for the application to process correctly and to be able to share files between the OFSAA account and the OFSAA ftpshare account. Should the two users have the same primary group in Linux? Or can they have different primary Linux groups, but share secondary group(s)?

For example, should it be setup as:

ID Primary Group Secondary Groups
<OFSAA USER> ofsaa_group misc_group
<OFSAA FTPUSER> ofsaa_group misc_group

or can it be setup like:

ID Primary Group Secondary Groups
<OFSAA USER> ofsaa_group misc_group
<OFSAA FTPUSER> misc_group ofsaa_group

This request pertains to Excel upload and how the file is temporarily written to the web application server then sftp over to the OFSAA server written to ftpshare folder.

Current configuration is OFSAA and Web Application Server on the same server. In past installations when OFSAA and WAS were on the same server and an sftp usr is not used then the WAS user writes to ftpshare. This happens even if the OFSAA user was configured to do the sftp of the file. Also, security standards prefer using a designated sftp user to control privileges.

In 806, who owns the files that are uploaded via OFSAA UI and written to /ftpshare when OFSAA and WAS reside on the same server?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.