My Oracle Support Banner

How to Define Application Sources for OFSAA Applications (Doc ID 1282469.1)

Last updated on FEBRUARY 28, 2019

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)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

Goal

How to define application, create sources, map application to sources, and generate source model for OFSAA Applications.

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.

Note: In earlier OFSAA Installations, defining application sources was a pre-requisite step prior to running the Setup.sh for the applications.  It was 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.  In OFSAA 8.x installations however, this is no longer a required pre-requisite step as the application installer creates the application-sources during installation.

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
References


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