Issue -- Receipt Spreadsheet throwing unexpected errors

Issue -- Receipt Spreadsheet throwing unexpected errors for no reason while data is correct.

Analysis:

We checked that, Only those records having key value not matching to original key value to "4CE46160W8,HSH0" are failing. Somehow key value for those records got changed.

To apply the transactions to receipt, spreadsheet looks for the parent record with same sequence having receipt amount with same key value which could not be find in the sheet because of which multiple errors are thrown for the failing validations.

If all records have the same key value as "4CE46160W8,HSH0" in sheet then these errors would not be raised.

We didn't modify the Key column values, but it gets automatically updated to random values after upload failure for many records. We cannot manually modify the key value column, when we try to update the value of Key column, below warning get raised:

"You have modified cells in the key column. This operation can lead to data corruption. Your change will now be reverted. (ADFDI-05574)" and the value get revert to original value.

Solution:

There were blank records at the end of the sheet, these blank records were causing change in the key column values of the spreadsheet for many records, because of which receipt spreadsheet was throwing random errors.

Deleting the blank records at the last of sheet stop the change in key column values. As per oracle this sheet should have only records with data in sheet upload section and there should not be any blank record to avoid unexpected errors.