Hyperion Financial Close Management (FCM) (MOSC)

MOSC Banner

ARM recalc failed Error in CommMap.updateTDATASEG_T_TDATASEGW

edited Nov 18, 2016 1:25AM in Hyperion Financial Close Management (FCM) (MOSC) 2 commentsAnswered ✓

Hi,

We encounter the following error in ARM.

Would appreciate if anyone can help.

We are using version 11.1.2.3.502.

2016-11-17 16:47:34,334 FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW

Traceback (most recent call last):

  File "<string>", line 2004, in updateTDATASEG_T_TDATASEGW

SQLException: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

I attached the logs.

The job failed after the following query. However, it does not have any details.

              UPDATE TDATASEG_T

              SET ACCOUNTX = (

                SELECT tdm.TARGKEY

                FROM TDATAMAP_T tdm

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center