OTBIE Undocumented Asset History Column Change

(Doc ID 2370059.1)

Last updated on APRIL 03, 2018

Applies to:

Oracle Transactional Business Intelligence Enterprise for Human Capital Management Cloud Service - Version 11.13.17.11.0 and later
Information in this document applies to any platform.

Symptoms

OTBI-E 11.13.17.11.0 Oracle Transactional Business Intelligence Enterprise for Human Capital Management Cloud Service


Using BIAPPS 11.1.1.10.x & FA13 Dependency Analysis v1.0.xlsx where the column ManufacturerName found in VO FscmTopModelAM.FinFaSharedUtilAM.AssetHistoryPVO is documented as staying at type VARCHAR2(30).

ODI-1227: Task FTS_FUSION_FscmTopModelAM.FinFaSharedUtilAM.AssetHistoryPVO (Integration) fails on the source ORACLE connection BIAPPS_SDS_FUSION_11.
Caused By: java.sql.SQLException: ORA-12899: value too large for column "FMW_SDS_FUSION_11"."FSC_FI_ASSETHISTORYPVO347558"."MANUFACTURERNAME" (actual: 31, maximum: 30)

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