E1: 47: Invalid Format (4569) Error During Flat File Conversion (R47002C) (Doc ID 2006939.1)

Last updated on MAY 05, 2015

Applies to:

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

Symptoms

On : 9.0 version, EDI - Flat File Conversion
Flat File Conversion (R47002C)

When attempting to run Flat File Conversion (R47002C) to upload a flat file into the EDI tables the following error occurs.

Error Information from the log file:
Flat File Conversion (R47002C) is issuing Invalid Format (4569) Error from ImportFlatFileToJDEFile (B4700240)

CAUSE. . . . An attempt was made to load a program with an incorrect format.
RESOLUTION. . Check format.

ERROR INFO JDEERR - ID= 0, Error= 4569 - b4700240.c, Line= 311

Failed SQL Statement from the Log File
SELECT UFUGRP, UFENHV, UFPID, UFVERS, UFFFENCODE, UFFFSTATUS FROM JDE900.SY900.F93081 WHERE ( UFUGRP = 'ATH' AND UFFFSTATUS = 'AV' AND UFPID = 'R47002C' AND UFVERS = 'KWH0001' AND UFENHV = 'JPY900' ) ORDER BY UFUGRP ASC,UFENHV ASC,UFPID ASC,UFVERS ASC,UFFFSTATUS ASC
No More Data found

The issue can be reproduced at will with the following steps:
1. Obtain a flat file from a EDI trading partner and save it on the Enterprise Server at the path "\\e9app\incoming\export.txt"
2. Go into the Flat File Cross Reference (P47002), find the Inbound EDI program and populate the flat file location as "\\e9app\incoming\export.txt"
3. Run Flat File Conversion (R47002C) with logs activated
4. Verify the error "Invalid Format" (4569) in the Work Center and the Logs

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