ORACLE.JBO.SQLSTMTEXCEPTION: JBO-27122: Sql Error Running Folder PFT Mapping Rule Export / Extract

(Doc ID 1228584.1)

Last updated on OCTOBER 01, 2013

Applies to:

Oracle Enterprise Performance Foundation - Version 12.0.6 and later
Oracle Profitability Manager - Version 12.0.6 and later
Information in this document applies to any platform.
FEM

Checked for relevance on 01-Oct-2013.

Symptoms

On Profitability Manager 12.0.6,when attempting to do Extract in iSetup of a folder of Mapping Rules with over 400 rules, the following error occurs:

ERROR
Name: FEM_MAPPING_RULE
Type: BC4J
Path: oracle.apps.fem.mapping.server.ImpExpAllocBrAM
Time Taken(seconds): 47.0
java.lang.RuntimeException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT CatalogOfObjectEO.OBJECT_NAME,
CatalogOfObjectEO.OBJECT_TYPE_CODE,
CatalogOfObjectEO.OBJECT_ID,
CatalogOfObjectEO.OBJECT_ACCESS_CODE,
(select FOLDER_NAME from FEM_FOLDERS_VL where FOLDER_ID = CatalogOfObjectEO.FOLDER_ID) AS FOLDER_NAME,
CatalogOfObjectEO.FOLDER_ID,
CatalogOfObjectEO.LOCAL_VS_COMBO_ID,
CatalogOfObjectEO.DESCRIPTION,
CatalogOfObjectEO.OBJECT_ORIGIN_CODE,
CatalogOfObjectEO.CREATED_BY,
(select user_name from fnd_user where
user_id = CatalogOfObjectEO.CREATED_BY) as user_name
FROM FEM_OBJECT_CATALOG_VL CatalogOfObjectEO) QRSLT WHERE (OBJECT_ID IN (11159, 11580, 23581, 19370, 10948, 13264, 11369, 13685, 16001, 11790, 14527, 21054, 13053, 
...
11370, 13686, 16002, 11791, 14528, 13054)); 
at oracle.apps.az.fwk.server.BEExport.exportToXML(BEExport.java:563)
at oracle.apps.az.fwk.server.BEExport.exportToXML(BEExport.java:392)
at oracle.apps.az.fwk.server.BEApplicationModuleImpl.exportToXML(BEApplicationModuleImpl.java:354)
at oracle.apps.fem.impexp.server.RuleAMImpl.exportToXML(RuleAMImpl.java:2045)
at oracle.apps.fem.mapping.server.ImpExpAllocBrAMImpl.exportToXML(ImpExpAllocBrAMImpl.java:88)
at oracle.apps.az.r12.api.BC4JAPI.exportAPI(BC4JAPI.java:253)
at oracle.apps.az.r12.extractor.cpserver.APIExtractor$APIExecuter.run(APIExtractor.java:619)


Status: ERROR
******************************************
Time Taken to execute the API=47943
Extract failed:
java.lang.Exception: API execution terminated because of error
at oracle.apps.az.r12.extractor.cpserver.APIExtractor.callAPIs(APIExtractor.java:196)
at oracle.apps.az.r12.extractor.cpserver.ExtractorContextImpl.export(ExtractorContextImpl.java:61)
at oracle.apps.az.r12.extractor.cpserver.ExtractorCp.runProgram(ExtractorCp.java:62)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

STEPS
The issue can be reproduced at will with the following steps:
1. Run iSetup extract for Folder of Mapping Rules with large number of mapping rules

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