My Oracle Support Banner

RETL Fixed Length Extracts With Multi-byte/special Characters Fails to Consume in RETL (Doc ID 2313890.1)

Last updated on AUGUST 21, 2020

Applies to:

Oracle Retail Extract Tranform and Load - Version 13.2.5 and later
Information in this document applies to any platform.

Symptoms

The RETL process extracts fixed length file with incorrect positioning when any information that contains multi-byte / special characters like "£", "é", "á" etc, which further fails to consume in subscribing applications.

Steps to Reproduce:
1. Create an item with special characters (like "£", "é", "á") in description .
2. Run RMS RETL extract "rmse_rpas_item_master.ksh".
3. Check the file created with incorrect character position.
4. Notice the file consumption fails in subscribing applications.

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.