OBIA 11g: SDE_PSFT_EMPLOYEEEXPENSEFACT Is Failing In Load Plan
Last updated on FEBRUARY 10, 2016
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 to 22.214.171.124.1 [Release 11g]
Information in this document applies to any platform.
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
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