My Oracle Support Banner

E1: TC: TC Design Aid ER Validation Error Using Input AS400 Foreign Table (Doc ID 2705582.1)

Last updated on NOVEMBER 06, 2020

Applies to:

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


We are attempting to convert data from Worldsoftware A7.3 World JDE instance running on iSeries to E1 9.2 JDE instance running on WIN/SQL.

We have created a foreign data source and are able to select tables from iSeries when using the Table Conversion Director.

For the test case, I selected F4201 from Worldsoftware for the Input Foreign Table and F4201 from the logged instance of E1 for the Output Table.

I am getting event rule validation errors for the string fields e.g.
/* CER ERROR #3004 : Unable to parse expression */
Function Name: RptVars
Function Description: ER for TST4201CNV_RptVars
Event: 4 - Row Fetched
Seq #: 2
Line #: 1
Line Text: OC KCOO (Order Company (Order Number)) (F4201) = [IC SHKCOO (F4201)]

Also, in the Mapping screen, String fields in the Input foreign table are listed as BINARY data type compared to Output E1 table listing the same column as String data type.





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

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