F0092 records disappearing

[SULLY1]

For the last couple of months we have had a few F0092 disappear from the database. The F98OWSEC record is still there. There is no audit trail in the F9312 table. I suspect the security ESU required with our upgrade to SP23_L1 has caused this problem. Has this happened to anyone else out there?

Patty

 

[custhe]

Possible culprit - I recall an issue with Security History Form exit from P98OWSEC. It displays records that are joined to the F0092, and deleting a history record deletes the User as well.

 

[SULLY1]

Curtis

I tested your theory. Your are correct. When you delete a security history record using P98OWSEC/W98OWSECC it deletes the F0092 record. Only a small group of people have access to this form and I don't know why anyone would delete records from it. I've locked it down so that only I can access this form. I search the KG and found nothing so I reported the problem to Oracle. Mystery solved? maybe.
Thanks for your help.

Patty