My Oracle Support Banner

E1: 47: Carriage Returns In Flat File Record Types 7 and 8 Created By Outbound Flat File Conversions (Doc ID 2475223.1)

Last updated on DECEMBER 17, 2019

Applies to:

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

Symptoms

Outbound 810 Sales Invoice Flat file Extraction (R47042C)
Outbound 856 Advanced Ship Notice Flat file Extraction (R47032C)
Outbound 855 EDI P.O. Acknowledgment Flat file Extraction (R47022C)

Loss of functionality
When processing an Outbound EDI Flat File, if there is a media object text attachment with carriage returns in the text, the record type 7 in the flat file will get a carriage return in the middle of the flat file record which will cause the program importing the file into the external system to error.

Sequence of events

  1. Create a Sales Order
  2. Attach a media object text attachment to the sales order header that contains more than one paragraph with a carriage return at the end of the paragraph. 
  3. Add a Sales Order Line.
  4. Setup a version of Sales Invoice Print (R42565) that has EDI 855 (Sales Order Acknowledgement) activated on the EDI tab processing options.
  5. Run the Sales Invoice Print (R42565) EDI version with data selection on the order
  6. Verify the EDI outbound tables were populated.
  7. Run Outbound 855 EDI P.O. Acknowledgment Flat file Extraction (R47022C) to create the flat file.
  8. Check the flat file created with word wrap turned off. Notice that the record type 7 in the flat file will get a carriage return in the middle of the flat file record which will cause the program importing the file into the external system to error. 

Where the issue happens
All environments whenever media object text attachments to the sales order header contains more than one paragraph with a carriage return at the end of the paragraph.

Expected or acceptable result
They would like the Outbound EDI Flat File Extraction program to remove the carriage returns and not break the flat file record type 7 into two lines.

Cause

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
Symptoms
Cause
Solution
References


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