ARM Reconciliations Status Not Chaging From "Pending" status with Historical Rates AND Rate Type checked. (Doc ID 1910823.1)

Last updated on AUGUST 02, 2016

Applies to:

Hyperion Financial Close Management - Version 11.1.2.2.350 to 11.1.2.3.500 [Release 11.1]
Information in this document applies to any platform.

Symptoms

When opening a period, all reconcillations remain in a pending status. The following error may be seen in the AccountReconcillation.log (error trimmed to accommodate space):

 

[2014-06-30T11:16:01.383-04:00] [FinancialClose0] [NOTIFICATION] [] [oracle.apps.epm.arm.model.applicationModule.server.serviceinterface.SchedulerAMServiceImpl_4osd0l_Impl] [tid: 16] [userId: kc013] [ecid: 0000KRhLaF94IvwK8EU4Ux1JfaQK0002Cf,0] [SRC_CLASS: oracle.jbo.server.svc.ServiceImpl] [APP: ACCOUNTRECONCILIATION#11.1.2.0] [SRC_METHOD: extractServiceException] [[
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
.............
at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO ARM_TRANSACTION_AMOUNTS(TRANS_AMOUNT_ID,OBJECT_ID,CURRENCY_BUCKET_ID,CURRENCY,OVERRIDE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATED_BY,CREATION_DATE) VALUES (?,?,?,?,?,?,?,?,?,?,?)".
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:585)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:8724)
..............
at oracle.apps.epm.arm.model.applicationModule.SchedulerAMImpl.openRecInstances(SchedulerAMImpl.java:322)
... 102 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("HYPARM"."ARM_TRANSACTION_AMOUNTS"."AMOUNT")

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
............
... 111 more

 

Changes

 A profile(s) had both Historical Rates and the Rate Type check box selected.

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