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:

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

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