My Oracle Support Banner

E1: 42: Order Created When F47012 Has An Invalid Item Number (Doc ID 2047332.1)

Last updated on APRIL 04, 2025

Applies to:

JD Edwards EnterpriseOne Sales Order Entry - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, EDI - Distribution

DESCRIPTION OF PROBLEM
A sales order is created when there is an invalid item number in the F47012 table.  Also, all F47012 records are flagged as processed.  No sales order should be generated and no F47012 records should be flagged as processed if there is an invalid item number in the F47012 records being processed.  Note, this only happens when the invalid item number is on the first detail line of a 2 line order being processed.

STEPS TO REPRODUCE

  1. Use P47010 to populate the minimum required header fields.
  2. Populate the minimum required detail fields but make the first line an invalid item number.
  3. Run R47011.  The audit report shows an error on line 1 due to invalid item number.  The order is created with one line on it.  The order should not be created if there is an invalid item number error produced in R47011.  Both F47012 records are flagged as processed.  None should be flagged as processed due to the invalid item number error.

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.