Index: grails-app/services/com/lemans/ds/fitment/PartFitmentManagerService.groovy
===================================================================
diff -u -r5459d21381a29be0af40962fd8638c90b8d1adcb -rdb28f74ed17467b4b6a7e43982a3a484143116ba
--- grails-app/services/com/lemans/ds/fitment/PartFitmentManagerService.groovy	(.../PartFitmentManagerService.groovy)	(revision 5459d21381a29be0af40962fd8638c90b8d1adcb)
+++ grails-app/services/com/lemans/ds/fitment/PartFitmentManagerService.groovy	(.../PartFitmentManagerService.groovy)	(revision db28f74ed17467b4b6a7e43982a3a484143116ba)
@@ -50,6 +50,10 @@
                 }
                 log.debug("done with batch")
                 List createdPartFitmentIds = createdPartFitmentsByModelYearIdsAndPartNumber(modelYearIdsToBeCreated, partNumber, now)
+                String query = """SELECT partFitmentId FROM PartFitment WITH(NOLOCK) WHERE 
+                                         partNumber = :partNumber AND modelYearId IN (${modelYearIds.join(', ')}) AND dateDeleted is NULL"""
+                List results = sql().rows([partNumber: partNumber], query)?.partFitmentId
+                log.debug(partFitmentIdCreated: results)
                 log.debug("createdPartFitmentIds $createdPartFitmentIds")
                 qcChangeLogService.createAndLogForQC('Part', partNumber, 'PartFitment', createdPartFitmentIds, now, username)
                 qcChangeLogService.findAndDeleteChangeLogs('PartFitment', [partNumber], username)