My Oracle Support Banner

INCR_LOAD_TEMP_MAP_DATA-INCR LOAD TABLE TEMP_CITY_LAT_LON Fails On The Target Connection ORACLE_FTI. (Doc ID 2846707.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.4.3 and later
Information in this document applies to any platform.

Symptoms

Running ETL, NCR_LOAD_TEMP_MAP_DATA-INCR LOAD TABLE TEMP_CITY_LAT_LON fails on the target connection ORACLE_FTI., with the following error:
Error on ODI Tool:


Reviewing the source data, The client noticed, LOCATION data for one record was populated with Japanese characters for PROVINCE_CODE and after that ETL process started failing
Did the following in ODI designer:

1. Increased PROVINCE_CODE length from 6 to 9
2. Designer > FTI_ETL>Procedures > INCR_LOAD_TEMP_DATA > Regenerate Scenario
3. RUN the scenario > INCR_LOAD_TEMP_DATA
4. Still, it returned the same error. It shows value on error as (actual: 9, maximum: 6) though the TEMP_CITY_LAT_LON>PROVENCE CODE has length of 9 bytes.

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!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.