My Oracle Support Banner

OBIA 11g: Trailing Spaces Getting Trimmed When Loading From File To SQL (Doc ID 2510697.1)

Last updated on MARCH 08, 2019

Applies to:

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

Symptoms

After the data load got completed, we observe that if any value in a particular cell in the source file has a trailing space then it gets trimmed at the target table.

The leading/in-between spaces present in the source file works fine for any particular cell and gets loaded in the target table as is.

Hence the issue is only while handling Trailing spaces which is getting trimmed at the target.

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
References


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