My Oracle Support Banner

OBIA 11g: SDE_FUSION_11_ADAPTOR_FTS_FUSION_FSCMTOPMODELAM_FINAPINVTRANSACTIONSAM_INVOICELINEPVO Mapping Fails with Error: 'ORA-12899: value too large for column' (Doc ID 2444938.1)

Last updated on FEBRUARY 16, 2019

Applies to:

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

Symptoms

  1. Trying to extract data from Fusion source using PVOs by running BICCC load.
  2. Due to FTS mapping (SDE_FUSION_11_ADAPTOR_FTS_FUSION_FSCMTOPMODELAM_FINAPINVTRANSACTIONSAM_INVOICELINEPVO) failure, load plan failed with below error -

Error:

ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection TST_SDS_FUSION_11.
Caused By: java.sql.BatchUpdateException: ORA-12899: value too large for column "TST_SDS_FUSION_11"."C$_492228500_15"."INVOICELINEAMOUNT" (actual: 57, maximum: 50)

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.end(SQLCommand.java:269)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:156)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:1)
at oracle.odi.runtime.agent.execution.DataMovemen => ORA-20942:
ORA-06512: at line 57

Environment Details:

  1. OBIA Version: 11.1.1.10.2
  2. Source System and its version: Fusion R13 on cloud.
  3. No changes made to OOTB mappings.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.