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 JUNE 01, 2023

Applies to:

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
('OFSAASEG') 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

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