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:

Symptoms

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#11.1.2.0] [SRC_CLASS: oracle.apps.epm.fcc.model.manager.email.CMEmailManager] [SRC_METHOD: getBatchUsers] ORA-01400: cannot insert NULL into ("XXXX_FCM"."FCM_BATCH_EMAIL_DATA"."USER_ID")[[

Changes

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

Cause

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