OBIA 11.1.1.8.1 SDE_ORAR1213_ADAPTOR_SDE_ORA_GLREVENUEFACT_ADJUSTMENTDISTRIBUTION & SDE_ORAR1213_ADAPTOR_SDE_ORA_GLR failed with ORA-01722: invalid number (Doc ID 2040748.1)

Last updated on AUGUST 14, 2015

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

1. When executing the load plan of "Financial Analytics" 2 tasks failed with errors.

 Errors:
SDE_ORAR1213_ADAPTOR_SDE_ORA_GLRevenueFact
 
"ODI-1217: Session SDE_ORAR1213_ADAPTOR_SDE_ORA_GLREVENUEFACT (10635510) fails with return code 1722.
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"
  
SDE_ORAR1213_ADAPTOR_SDE_ORA_GLREVENUEFACT_ADJUSTMENTDISTRIBUTION
 
"ODI-1217: Session SDE_ORAR1213_ADAPTOR_SDE_ORA_GLREVENUEFACT_ADJUSTMENTDISTRIBUTION (10152510) fails with return code 1722.
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.

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