My Oracle Support Banner

E1: 47: Invoice Print (R42565) EDI Outbound 810 Invoice Writes F4714 Records for Image in Header Attachment (Doc ID 2737010.1)

Last updated on DECEMBER 15, 2020

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When running R42565 EDI version over orders that have "text" header attachments that are a mix of text and images, F4714 records are created for the actual text and for all the BLOB data of the image in the F00165.

Steps to Replicate:

  1. P4210.  Create a sales order header first and add a text attachment. Save then enter a detail line and save the order.
  2. P4210. Re-inquire and add another text attachment by selecting the Text icon. Then use the Windows snipping tool to copy and paste an image into the text attachment window. Save the order.
  3. R42565. Run the EDI version over the order with logging activated. Review the logs and see there are 1024 inserts to the F4714. You can see the inserts for the actual text and inserts for all the BLOB data of the image.

Example:

INSERT INTO PRODDTA.F4714 (ZTEDTY, ZTEDSQ, ZTEKCO, ZTEDOC, ZTEDCT, ZTEDLN, ZTEDSP, ZTEDBT, ZTFILE, ZTKCOO, ZTDOCO, ZTDCTO, ZTLNID, ZTPNTC, ZTLINS, ZTTXLN, ZTTORG, ZTUSER, ZTPID, ZTJOBN, ZTUPMJ, ZTTDAY) VALUES ('7',1.000000,'00001',132818.000000,'SQ',0.000000,' ','4980','F47046','00001',18620.000000,'SO',0.000000,' ',1000.000000,'src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABaYAAA','USER','USER','ER42565','machine',120349,222115.000000)

Changes

 

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
Changes
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.