My Oracle Support Banner

E1: ORCH: Unicode Character Strings Are Not Inserted or Updated in JD Edwards EnterpriseOne Tables When Using a Database Connector in an Orchestration (Doc ID 2882283.1)

Last updated on JULY 11, 2022

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

An orchestration has been designed to insert or update data into one JD Edwards EnterpriseOne table. The orchestration is using a database connector to connect to the database and perform the insert/update transaction and works fine when fields in the JD Edwards EnterpriseOne table are inserted with Latin characters for for fields defined as NCHAR, NVARCHAR (on SQL Server) or NVARCHAR2 (on Oracle Database). When the same orchestration is run to insert/update NCHAR, NVARCHAR (on SQL Server) or NVARCHAR2 (on Oracle Database) fields with Unicode character strings, the inserted/updated field contains only question marks characters (?).

If the same query containing Unicode character strings is executed from a query tool (e.g. SQL Server Management Studio for SQL Server or SQL Developer for Oracle Database), the NCHAR, NVARCHAR (on SQL Server) or NVARCHAR2 (on Oracle Database) fields will also show question marks characters (?).

If the same fields are inserted/updated from an Interactive/Batch Application, the character string inserted shows the correct characters.

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!


In this Document
Symptoms
Changes
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.