Import Mapping Rule with Data Component Failed with ORA-00907 Missing Right Parenthesis (Doc ID 743118.1)

Last updated on NOVEMBER 28, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
FEM

Symptoms

When attempting to import migrated mapping rules the following error occurs in the Target instance.

ERROR
Importing rows from xml file, and validating rows ......
An error occurred in API 'DriveAM'
View Object 'CatalogOfObjectsVO'
ObjectId = '31935'
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT OBJECT_ID,
OBJECT_TYPE_CODE,
FOLDER_ID,
OBJECT_NAME,
LOCAL_VS_COMBO_ID,
OBJECT_ACCESS_CODE,
OBJECT_ORIGIN_CODE,
DESCRIPTION
FROM FEM_OBJECT_CATALOG_VL) QRSLT WHERE (upper(Object_Name) = 'FE - ALL FINANCIAL FE'S')
ORA-00907: missing right parenthesis

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