Hi ,

We faced one issue, I have explained the scenario
> Our table has multiple rows with primary key as number for an entity For ex: assuming employeeid for an employee
> We have a status column which suggests calculation status of the current employee id : For ex: OPEN ,IN-PROGRESS and CLOSED.
> Actual calculation will be done and will be inserted to an intermediate table and status will be updated from OPEN to IN-PROGRESS in the main table
> Once the data moves from staging to target it will be updated to CLOSED. Commit to the block is at the end.


Now the issue,

Node 1: Calculation was done and data was inserted to staging and status was updated to IN-PROGRESS
Our operation fetches 8000 rows which is IN progress state from Staging and commits it to target table and then updates the status to CLOSED and then commits entire session.
node 1 goes down due to patching activity.
Node 2: As our job is rerunnable, we trigger the same job on node 2.
When we restarted again so many rows which was committed on node 1 missing but the status in the main table was updated to CLOSED.



My question is

Is it possible that once committed rows on one node, which eventually goes down after committing , and when we re run the same job on other node will be missed? As far as I know data once committed will never be lost
Checked in the dba table of active session history but could not find any clue on this.
Please let me know if there is any other way we can trace that.