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 OCTOBER 05, 2017

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.

Changes

 

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!

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