My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution

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