Unable to See Source Objects in Object Migration Screen and java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Errors (Doc ID 1983066.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.2.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On OFSAAI 7.3.3.2.0, no source rules are visible in the Object Migration screen.

ACTUAL BEHAVIOR
After setting up configuration, only objects from the Target instance are
visible, no objects from the source instance are listed.

The following error is found in the Web Server FUSIONSUBSYSTEMSService.log:

[FUSIONSUBSYSTEMS] Jan 13,15 12:36:36 : [MIGRATIONCOMMONSERVICE]Count
Query:::select count(1) from (SELECT DISTINCT FMODTL.OBJECT_DEFINITION_ID,
FMODTL.SHORT_DESC, FMODTL.LONG_DESC, FMODB.FOLDER_NAME, FMODB.ID_TYPE,
FITM.ID_TYPE ID_TYPE_DESC, FMODB.CREATED_BY, to_char(FMODB.CREATION_DATE,'DS
HH24:MI:SS'), FMODB.MODIFIED_BY, to_char(FMODB.LAST_MODIFIED_DATE,'DS
HH24:MI:SS') FROM FSI_M_OBJECT_DEFINITION_B  FMODB,
FSI_M_OBJECT_DEFINITION_TL FMODTL, FSI_ID_TYPE_MLS FITM WHERE
FMODB.OBJECT_DEFINITION_ID = FMODTL.OBJECT_DEFINITION_ID AND FITM.ID_TYPE_CD
= FMODB.ID_TYPE AND FITM.MLS_CD = FMODTL.LANG_CD AND FMODB.ID_TYPE IN
(4,8,21,25) AND FMODTL.LANG_CD = ? AND FMODB.DELETED_FLAG = 'N' AND
FMODB.ID_TYPE = COALESCE(?,FMODB.ID_TYPE) AND FMODB.FOLDER_NAME IN
('OFSAAISEG') AND UPPER(FMODTL.SHORT_DESC) like
UPPER(COALESCE(?,FMODTL.SHORT_DESC))  ORDER BY UPPER(SHORT_DESC) ASC)
[FUSIONSUBSYSTEMS] Jan 13,15 12:36:36 : [MIGRATIONCOMMONSERVICE]SQL Exception
occured while trying to get Object List
[FUSIONSUBSYSTEMS] Jan 13,15 12:36:36 : [MIGRATIONCOMMONSERVICE]
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


However, running the query on the Source instance produces the correct rows.

EXPECTED BEHAVIOR
Expect to see all source rules available for migration.

The issue can be reproduced at will with the following steps:

1. Navigate to Administration -> Utilities -> Object Migration
2. Create new Configuration
3. Create new Object Migration rule -> Financial Services Applications Infrastructure -> Filters

Cause

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