How to Define Application Sources as Required Pre-Installation Step for OFSAA 5.2 Applications (Doc ID 1282469.1)

Last updated on JULY 20, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 5.2 to 5.2.1 [Release 5]
Oracle Financial Services Asset Liability Management - Version 5.2 to 5.2.1 [Release 5]
Oracle Financial Services Funds Transfer Pricing - Version 5.2 to 5.2.1 [Release 5]
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.2

Goal

How to define application, create sources, map application to sources, and generate source model as required pre-installation step for Oracle Financial Services (OFS) 5.2 Applications (OFS).

Every application has a data source associated with it. A data source definition refers to the physical location of data and its connection attributes, servicing one or more source applications. Data sources can be defined as two main source types:
  • RDBMS files - refers to Relational databases
  • Flat-Files - refer to text or ASCII files
Source Data Models should be generated from the source systems to enable the definition of source extracts. Infrastructure Data Integrator allows the generation of the Source Data Models for a Source Application-Data Source combination.

When you install an Oracle Financial Services (OFS) Analytical Application, defining application sources is a pre-requisite step prior to running the Setup.sh for the applications.

The following are Oracle Financial Services Analytical Application (OFSAA) products which currently require this step:
Oracle Financial Services Asset Liability Management 5.2
Oracle Financial Services Funds Transfer Pricing 5.2
Oracle Financial Services Profitability Management 5.2
It is required with Data Integrator to create a single application with two RDBMS data sources, one for "Processing" and one for "Staging" for OFSAA product installation.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms