OBIA 11g: SDE_PSFT_EMPLOYEEEXPENSEFACT Is Failing In Load Plan (Doc ID 2105007.1)

Last updated on FEBRUARY 10, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 to 11.1.1.10.1 [Release 11g]
Information in this document applies to any platform.

Symptoms


SDE_PSFT_92_ADAPTOR_SDE_PSFT_EMPLOYEEEXPENSEFACT is failing in load plan. You are using a DB link to get the data from the source of PeopleSoft 9.2.

The following error is reported:

ODI-1217: Session SDE_PSFT_92_ADAPTOR_SDE_PSFT_EMPLOYEEEXPENSEFACT (3150501) fails with return code 22835.
ODI-1226: Step Run SDE_PSFT_EmployeeExpenseFact.W_EXPENSE_FS fails after 1 attempt(s).
ODI-1240: Flow Run SDE_PSFT_EmployeeExpenseFact.W_EXPENSE_FS fails while performing a Integration operation. This flow loads target table W_EXPENSE_FS.
ODI-1228: Task SDE_PSFT_EmployeeExpenseFact.W_EXPENSE_FS (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 5345, maximum: 4000)
ORA-02063: preceding line from FSCM_ODI.WORLD@DSN_21

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