Oracle application work flow table WF_LOCAL_USER_ROLES and WF_LOCAL_USER_ROLE_ASSIGNMENT and WF_USER_ROLE_ASSIGNMENTS are getting out of sync after nightly batch job run
batch job is doing alter table exchange partition on the workflow table with the stage table for each partition
1. You must include related staging tables such as WF_LOCAL_USER_ROLES_STAGE and WF_UR_ASSIGNMENTS_STAGE in replication
2. If after including the staging tables and post is still encountering ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
or ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION, make sure you create the same indexes on both the workflow table and staging tables on target and also make sure the constraints are enabled and validated on both tables.
see oracle note "ORA-14097:column type or size mismatch on Alter Table Exchange Partition [ID 946427.1] " for more information
