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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!