My Oracle Support Banner

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

Last updated on JUNE 30, 2021

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 REPRODUCE

1) P4210.  Create a sales order header first and add a text attachment. Savethen enter a detail line and save the order.
 
2) P4210. Re-inquire and add another text attachment by selecting the Texticon. 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','USE
R','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.