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 MAY 30, 2017

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.

Symptoms

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:

Cause

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 hundreds of Community platforms