My Oracle Support Banner

E1: 47: EDI Invoice (R42565) Writes EDI Order Text Lines - Header (F4714) Records for Image in Header Attachment (Doc ID 2779460.1)

Last updated on JULY 14, 2022

Applies to:

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


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 Duplicate: 

1. In P4210 create a sales order header first and add a text attachment. Save then enter a detail line and save the order.
2. In P4210, reinquire on the order 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. In Invoice Print (R42565) run the EDI version over the order with logging activated. Review the logs and see there are 1024 inserts to the F4714. Note the inserts for the actual text and inserts for all the BLOB data of the image.

For 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) 




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

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