E1: 41: Cycle Count Update (R41413) PDF Reports a "Commit Failure Has Occurred" and "Violation of PRIMARY KEY constraint 'F4105_PK" appears in JDE.LOG (Doc ID 2872333.1)

Last updated on SEPTEMBER 13, 2023

Applies to:

Symptoms

Cycle Count Update Report (R41413), reported a "Commit Failure Has Occurred" on the last item processed.

It should be noted that there was no error Message sent to the Work Center.

It was further discovered that in addition to the last item, several other items processed by the job were updated in the Item Location (F41021) file but no records were written in the Item Ledger (F4111).

ERROR MESSAGE FROM REPORT PDF:
"Commit Failure Has Occurred"

ERROR MESSAGE IN THE JDE.LOG:
"Violation of PRIMARY KEY constraint 'F4105_PK'. Cannot insert duplicate key in object 'XXXXXX.F4105'.

The issue cannot be reproduced, but the issue occurred after following the steps below:

1. Run Cycle Count Update (R41413)
2. Enter data Selection on Cycle Number
3. Review the report PDF output
   1. All the lines except the last have the message "No errors detected".
   2. The last line has the message "Commit Failure Has Occurred"
4. Review the Work Center
   1. No errors were reported in the Work Center
5. Review the Item Location (F41021) and Item Ledger (F4111) records for the last item in the Cycle Count Transaction File (F4141).
   1. The Item Location (F41021) was updated with the Quantity counted but no record was written to the Item Ledger (F4111) for the Cycle Count Number.
6. Review the Item Location (F41021) and Item Ledger (F4111) records for other items.
   1. Some items were update in both inventory tables (F41021 and F4111)
   2. Other items showed that the Item Ledger (F4111) for the count was NOT written.

Cause

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