ALL_RT_AUDIT_MAP_RUNS
I have read several posts on getting information about a mapping run and using ALL_RT_AUDIT_MAP_RUNS.
I have seen in trying to put this table into a sub mapping that the values for inserted, merged, updated are not set and that the status is RUNNING,
because the mapping has not finished.
This seems to leave creating a procedure or function to insert the values from all_rt_audit_map_runs into a table that I have created for keeping information on runs so the average user can view them.
I have two questions
1) is it possible through a pluggable mapping to get the completed info on a mapping run to be able to insert.
2) If 1 is not possible is the context of the mapping still available ie getting the the audit id through get_audit_id in a post mapping procedure,
or do you have to get the audit id and then pass that to the post_mapping procedure.
It would also seem like that in the post mapping procedure that you would have to use the owbsys.workspace_management.set_workspace
function to get the right context.
Is this the way to go or am I missing something.
thanks
greG