First of all the main reason for the cause was we had one more development apex environment and we moved the app from that environment to
prod, it made the user saved ir reports got deleted, even though the app no(200) is same as in prod app no(200).

The way i recovered the orphaned user saved ir reports ,was I need to update the worksheet id in one of the apex meta data tables.
I was able to reproduce the issue in test environment and applied the below fix it worked and later applied the fix in production, we did not see any kind of issues.

Run the below steps as SYSTEM user
Step 1:

-- create a temporary table

create ir_user_old_reports_backup as SELECT * FROM APEX_040000.WWV_FLOW_WORKSHEET_RPTS where FLOW_ID = 200 and
and IS_DEFAULT = 'N' and SESSION_ID is null and STATUS = 'PRIVATE'
and WORKSHEET_ID NOT IN (SELECT ID FROM APEX_040000.WWV_FLOW_WORKSHEETS WHERE FLOW_ID = 200 )