KK_BUDG_TRANS_TYPE: Fixing the Data From PS_KK_ACTIVITY_LOG When Posted To PS_LEDGER_KK And it is No

I have reviewed the following knowledge document:

EGL: FS_BP: How Should The Data From PS_KK_ACTIVITY_LOG Look When Posted To PS_LEDGER_KK And If Not Correct, How Do We Fix It? (Doc ID 1446505.1)

Per PeopleSoft Development's suggestion we are planning to do the following:

•   Compare sum(activity log by keys) with ledger rows (ledger rows by keys) and SQL update the LEDGER_KK

But we are receiving an error that there's a unique constraint error on the Budget Entry Type (KK_BUDG_TRANS_TYPE ).  Although we indicate a different process instance, process instance isn't part of the key.