My Oracle Support Banner

Financial Close Management (FCM) Notifications Not Received With A New Period And ORA-01400 Error Viewed In FCM Log. (Doc ID 2323378.1)

Last updated on FEBRUARY 07, 2023

Applies to:

Hyperion Financial Close Management - Version and later
Information in this document applies to any platform.


1) Emails are not sent out when a new period is open.

2) Other batch type emails are not sent out.

3) Similar error will be seen:

####<Aug 6, 2017 4:30:00 AM EDT> <Error> <JDBC> <XXXX> <FinancialClose0> <[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <0000Lqqe^h0B5EopsSx0iX1PXJWl00015L> <1502008200051> <BEA-001112> <Test "SELECT 1 FROM ARM_ATTRIBUTE_VALUES WHERE 1 = 0" set up for pool "accountreconciliation_datasource" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

[2017-08-09T06:00:04.431-04:00] [FinancialClose0] [ERROR] [] [oracle.apps.epm.fcc.model] [tid: 133] [userId: XXXX] [ecid: 0000Lr6RwLSB5EopsSx0iX1PXj_500049R,0] [APP: FINANCIALCLOSE#] [SRC_CLASS:] [SRC_METHOD: getBatchUsers] ORA-01400: cannot insert NULL into ("XXXX_FCM"."FCM_BATCH_EMAIL_DATA"."USER_ID")[[


 Possible creation of a new group/team with no members.


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.