E1:47: EDI Inbound R47011 fails when processing Orders over 800 Lines (Doc ID 1612680.1)

Last updated on NOVEMBER 06, 2015

Applies to:

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

Symptoms

********************
E1 Release: 9.0
Program ID: R47011
Server/Environment: n/a
Tools Release: 8.98
***************************
When entering large sales orders with up to or more than 800 but less than 999 detail lines through Inbound EDI 850 the UBE R47011 fails to complete. This happens when additional, split order lines (e.g 1.010, 1.020,..) are added during order entry as part of an advanced pricing schedule that adds free goods lines to the order.
The logs show that there is an error on inserting the F40UI74 table when processing the order lines. Table F40UI74 has 2 line numbers, XLIN and LNID and there appears to be a discrepancy between XLIN and LNID. XLIN appears to be populated with a larger line number than LNID, so when when LNID is still less than 999, XLIN already exceeds the limit of 999 line numbers which again causes the failed insert into table F40UI74.

Cause

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