"Amount" Considered Null When Creating Logic Group In FDMEE (Doc ID 2283328.1)

Last updated on JULY 24, 2017

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.4.210 and later
Information in this document applies to any platform.

Symptoms

Trying to create a summarized logic account in PBCS FDMEE. Constantly getting an error about null amount :

2017-06-13 19:31:31,614 FATAL [AIF]: Error in LogicGroup.createLogicAccounts
Traceback (most recent call last):
File "", line 321, in createLogicAccounts
File "", line 390, in _insertRowsForLogicAccount
SQLIntegrityConstraintViolationException: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("DPV2ZCSOCDFF"."TDATASEG_T"."AMOUNT")

The user limited his file to 2 valid lines. If he removes the logic group from location, they pass both import and validation stage and amount are recognised.

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