Last updated on AUGUST 14, 2015
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
1. When executing the load plan of "Financial Analytics" 2 tasks failed with errors.
ODI-1226: Step Run SDE_ORA_GLRevenueFact.W_GL_REVN_FS fails after 1 attempt(s).
ODI-1240: Flow Run SDE_ORA_GLRevenueFact.W_GL_REVN_FS fails while performing a Integration operation. This flow loads target table W_GL_REVN_FS.
ODI-1228: Task SDE_ORA_GLRevenueFact.W_GL_REVN_FS (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number"
ODI-1226: Step Run SDE_ORA_GLRevenueFact_AdjustmentDistribution.W_GL_REVN_FS fails after 1 attempt(s).
ODI-1240: Flow Run SDE_ORA_GLRevenueFact_AdjustmentDistribution.W_GL_REVN_FS fails while performing a Loading operation. This flow loads target table W_GL_REVN_FS.
ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.BatchUpdateException: ORA-01722: invalid number"
2. All Domain Mappings for the Revenue must be mapped to VARCHAR2.
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