Date: Tue, 14 Feb 2012 12:40:23 -0800
In an ebiz environment, we have hit ora-8103 for a particular plsql program and while debugging it, I found note 1326404.1. The note says this "This problem is caused by the underlying partitioning exchange, which can lead to change in the ROWID for the records in any of the queried tables."
I think the tables involved are wf_user_role_assignments and wf_user_roles. How do I know if a partition exchange has been done at the time the custom plsql program run? This was not done manually by us (partition exchange).