OFSAA Missing New Tables, Views, or Columns or [2623] Operation at server failed [3124] Error while processing request Error When Choosing Entities in T2T Screen (Doc ID 1348564.1)

Last updated on JUNE 01, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.8 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)
Data Mapping
Table to Table (T2T)
Data Management Tools (DMT)

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI), when attempting to choose a _V view from the Data Integrator, Choose entity screen the FSI_AMORTIZATION_TYPE_MLS_V does not appear in the list.

The following error may appear on the screen:

ERROR

[2623] Operation at server failed. [3124] Error while processing request

In addition, there may be errors in the Web Server ETLService.log like the following:

[ETLLOG] Oct 25,18 12:18:11 : [CLSUETLEXTRACTIONROUTER]Fetching column details for...ASSET_PFT_BI_COLUMNS
[ETLLOG] Oct 25,18 12:18:11 : [CLSUETLENTITYSOURCE]Table passed is::ASSET_PFT_BI_COLUMNS
[ETLLOG] Oct 25,18 12:18:14 : [CLSUETLENTITYSOURCE]Error in fetching source model .
[ETLLOG] Oct 25,18 12:18:14 : [CLSUETLEXTRACTIONROUTER]asdfad34[S][ETL.UTIL.ERR_PROCN_REQ]en_US
[ETLLOG] Oct 25,18 12:18:14 : [CLSUETLENTITYSOURCE]Reason :[3124] Error while processing request
[ETLLOG] Oct 25,18 12:18:14 : [CLSUETLEXTRACTIONROUTER]asdfad34[S][ETL.UTIL.ERR_PROCN_REQ]en_US

EXPECTED BEHAVIOR
Expect to see all views and tables and columns in the source Atomic schema to appear.

The issue can be reproduced at will with the following steps:
1. Unified Metadata Manager -> Data Integrator Framework -> Warehouse Designer -> Database Extract
2. Open a seeded Staging T2T extract
3. Click Edit
4. Click Choose Entity
5. Scroll through the list