E1: 47: Invalid Format (4569) Error During Flat File Conversion (R47002C)
Last updated on JUNE 13, 2018
Applies to:JD Edwards EnterpriseOne EDI - Version 9.0 and later
Information in this document applies to any platform.
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
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