Is there a way to access an audit trail for changes to MOS setup? For example, the user/timestamp for when an MOS was added to or deleted from a performance.
That would be TX_PERF_PKG_MOS in the database, and I see that it has no audit columns, so I'm guessing no. Also checked the TA_* tables and found nothing relevant.
Audits are all trigger based. Find the lowest level table and see if there's a trigger that enters data in the TA_AUDIT_TRAIL. If there isn't one, you can certainly add a local trigger to do this. You would need an Insert, Delete, and Update triggers to do this. There's also interceptors if you want to go down that route.
Thanks, all. I had a weird situation going on this morning where I was trying to clear an MOS off of a set of perfs, and another user was adding them back on right behind me. I was trying to figure out if I was just doing a terrible job of saving my work, or if I had an arch nemesis working in ticketing setup at the time. Not finding any sort of audit information in TX_PERF_PKG_MOS, I had to solve the mystery through basic human interaction of the face-to-face variety.
"basic human interaction of the face-to-face variety"
Scary stuff! I see why you looked into the audit trail first.