My Oracle Support Banner

E1: 42: Ship Confirm (P4205) Issues Unique Constraint F0911 G/L Table Insert Failure with In-Transit Accounting (Doc ID 2670542.1)

Last updated on JULY 26, 2021

Applies to:

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

Symptoms

When ship confirming a 3 line ST/OT order (with In-transit Accounting activated) where the first and third lines on the order go into receipt routing, a commit failure occurs and the following errors are found in the debug log:

OCI0000227 - Error - ORA-00001: unique constraint (PRODDTA.F0911_PK) violated
OCI0000178 - Unable to execute - INSERT INTO PRODDTA.F0911

NOTE:  If the non-receipt routing item is last on the order (below the receipt routing items), the order gets confirmed fine without error and the 3 lines are received properly with the 2 lines going into receipt routing.

The issue can be reproduced with the following steps:

  1. Set up a supplier item relationship for 2 items and attach a receipt route.2. Set the first step of the receipt route as Payable= Y.
  2. Enter a 3 line ST/OT order with the first and third lines being the items that will go through receipt routing.  The second line item will not go through receipt routing.  The second line item also does not have a cost or price.
  3. Set Ship Confirm P4205 processing option to perform In Transit Accounting and to call the version of P4312 with receipt routing activated.
  4. Ship confirm the ST OT order and a Commit Failure error occurs.  The following is found in the debug log:
    OCI0000227 - Error - ORA-00001: unique constraint (PRODDTA.F0911_PK) violated
    OCI0000178 - Unable to execute - INSERT INTO PRODDTA.F0911

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.