My Oracle Support Banner

E1: TC: Failed to Run Table Conversion UBE With "Clear Output Table" Against AS/400 Database On Local (Doc ID 1671560.1)

Last updated on JUNE 18, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.


When a Table Conversion (TC) UBE (flat file to EnterpriseOne database) was run with "Clear Output" option against AS/400 database, the TC UBE fails because EnterpriseOne fails to delete records in the target tables when the table is empty.  The issue only happens when the TC UBE run on Local.  If the same TC UBE run without "Clear Output" option, the TC UBE run correctly. If the same TC UBE run against SQL database, the TC UBE run correctly.

Errors seen in log:




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.