My Oracle Support Banner

ETL Application and ETL Application Source / Pair Are Not Visible in OFSAA (Doc ID 2390568.1)

Last updated on APRIL 24, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.5 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and later
Oracle Financial Services Asset Liability Management - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Extract, Transform and Load (ETL)
Table to Table (T2T) Data Mapping

Symptoms

After new installation of PFT 8.0.5 application pack, it appears that the selected ETL Application and ETL Application Source/Pair are not visible in the UI.

ACTUAL BEHAVIOR
While installing PFT 8.0.5, the following is specified in Silent.props:

#Please specify if you want create new ETL App/Src pair or use an existing one.
# 0 = If you want to create a new ETL app/src pair
# 1 = If you want to use an existing pair
ETL_APPSRC_TYPE=0

#ETL FSAPPS Application description
ETL_APP_1_DESC=PFTAPPS
#ETL Staging source description
ETL_SRC_1_1_DESC=STAGING
#ETL Processing source description
ETL_SRC_1_2_DESC=PROCESSING

However, after login to the OFSAA application page and navigate to Financial Services Profitability Management > Data Management Tools > Data Mapping, the PFTAPPS folder, given as ETL_APP_1_DESC=PFTAPPS is not visible.
Also, for FSAPPS folder, we can see only PROCESSING folder, but not STAGING folder, which is present in the backend server.

STAGING]$ cd -
OFSAA/ftpshare/FSDFINFO/erwin/Sources
Sources]$ ls -lrt
total 36
drwxrwxr-x 2 ofsaa staff 6 Mar 29 13:14 FSDF_TR_SRC
drwxrwxr-x 2 ofsaa staff 6 Mar 29 13:14 FSDF_IFRS_SRC
drwxrwxr-x 2 ofsaa staff 6 Mar 29 13:14 FSDF_CAP_ADQ_SRC
drwxrwxr-x 2 ofsaa staff 20480 Apr 13 11:05 STAGING
drwxrwxr-x 2 ofsaa staff 60 Apr 13 11:05 STAGING1
drwxrwxr-x 2 ofsaa staff 8192 Apr 13 11:05 PROCESSING

EXPECTED BEHAVIOR
Expect to see the PFTAPPS application and the PROCESSING and STAGING sources in OFSAA.

The issue can be reproduced at will with the following steps:
1. Login to the OFSAA application page
2. Navigate to Financial Services Profitability Management > Data Management Tools > Data Mapping

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.