iSetup Mapping Rule Load Fails with AZW_FWK_USER_ROW_EXCEPTION & JBO-27122: SQL Error (Doc ID 1450712.1)

Last updated on APRIL 17, 2012

Applies to:

Oracle Profitability Manager - Version 12.0.6 and later
Oracle Enterprise Performance Foundation - Version 12.0.6 and later
Information in this document applies to any platform.
iSetup Import / Export / Migrate

Symptoms

When running a load for Profitability Manager (PFT) Mapping Rules in iSetup 12.0.6, the load request ends with an error.  The following error is listed in the load request's View Log:

 Importing rows from xml file, and validating rows ......

-----------------------------------------
Message not found. Application: AZ, Message Name: =
AZW_FWK_USER_ROW_EXCEPTION. Tokens: VONAME =3D Catalog Of Objects; KEY =
=3D  Object Id =3D '41354'
; EXCEPTION =3D oracle.jbo.SQLStmtException: JBO-27122: SQL error during =
statement preparation.  Statement: SELECT * FROM (SELECT OBJECT_ID,=20
       OBJECT_TYPE_CODE,=20
       FOLDER_ID,=20
       OBJECT_NAME,=20
       LOCAL_VS_COMBO_ID,
       OBJECT_ACCESS_CODE,=20
       OBJECT_ORIGIN_CODE,=20
       DESCRIPTION
FROM FEM_OBJECT_CATALOG_VL) QRSLT  WHERE (upper(Object_Name) =3D =
'COMPANY'S TEST ALLOCATION ENTRY - RULE ONE')
 ORA-00907: missing right parenthesis
;=20
-----------------------------------------

The error message prevents the Mapping Rules included in the extract from being imported into the target environment.

Steps to Reproduce:

  1. Go to the iSetup responsibility
  2. Go to Migrations > Loads
  3. Create and execute a Load that references a Mapping Rule extract

The request ends in an error.

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