My Oracle Support Banner

"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 and later
Information in this document applies to any platform.


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.


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

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