OIC Analytics - ORA-20002: Error occured while updating global amounts. (Doc ID 2043641.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Incentive Compensation Analytics for Oracle Data Integrator - Version 12.1.1 and later
Oracle Incentive Compensation - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

"Incentive Compensation Analytics - ODI" failed with error :

    ORA-20002: Error occured while updating global amounts.Error code: 1 Error Message: User-Defined Exception

    ORA-06512: at line 109

We are able to load USA OU successfully but the IRELAND OU (Currency "EUR") and SINGAPORE OU (Currency "SGD") are throwing the above error.

The log shows :

<![CDATA[CN.CN_V_MLUPD=01011900000000
CN.CN_N_ORG_ID=121
CN.CN_N_USERID=55567
CN.CN_N_BATCH_ID=2
CN.CN_V_ENTITY_NAME=Fact - Subledger (Srp Periods)
CN.CN_V_ETL_RUN_DATE=11082015182732
CN.CN_V_ETL_LOAD_TYPE=I
CN.CN_N_SRC_SYSTEM_ID=1
CN.CN_V_FUNC_CURRENCY=EUR
CN.CN_N_MIN_OPERIOD_ID=2011001
CN.CN_V_INTERFACE_NAME=CN_F_SUBLEDGER_PKG
CN.CN_V_CONVERSION_TYPE=1080
CN.CN_V_PBT_PROFILE_VALUE=N
CN.CN_V_DATAMART_CURRENCY=USD
.....
- <Field name="ErrorMessage" type="java.lang.String">
- <![CDATA[
ODI-1217: Session SCEN_CN_F_SUBLEDGER (664602) fails with return code 20002.
ODI-1226: Step CN_S_SRP_PERIODS_DDL_P fails after 1 attempt(s).
ODI-1232: Procedure CN_S_SRP_PERIODS_DDL_P execution fails.
ODI-1227: Task CN_S_SRP_PERIODS_DDL_P (Procedure) fails on the source ORACLE connection ORACLE_CN_OLTP.
Caused By: java.sql.SQLException: ORA-20002: Error occured while updating global amounts.Error code: 1 Error Message: User-Defined Exception
ORA-06512: at line 109

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)


Following profile options are set :

1. OIC Datamart Global Currency Code - 'USD'
2. OIC Datamart Global Conversion Type - '1080'

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