In case of error like "ORA-12034: materialized view log on "INV"."MTL_TXN_REQUEST_LINES" younger than last refresh ",
you need to a complete/automatic refresh of the problem snapshot.
.
In this case, there were 2 snapshots that had this issue:
MTL_TXN_REQUEST_LINES_SN
MTL_ITEM_CATS_SN
.
1. Please perform an automatic refresh of these snapshots INDIVIDUALLY.
The concurrent request : "Refresh Collection Snapshots", can be launched individually also.
Log into "Advanced supply Chain Planner" responsibility on the source instance.
Then from tools menu, choose View->Requests.
Click on the button, Submit a new request.
Type in "Refresh Collection Snapshots".
In the parameters choose the following:
Refresh Mode: Automatic
Snapshot Name: MTL_TXN_REQUEST_LINES_SN
Threshold for Truncating Logs: 0
Degree: 0
Click OK and submit the request.
Please repeat the same steps for the other snapshot: MTL_ITEM_CATS_SN
2. Do a fast refresh of ALL snapshots and ensure that it completes fine.
3. Please run data collection and is should complete successfully.
you need to a complete/automatic refresh of the problem snapshot.
.
In this case, there were 2 snapshots that had this issue:
MTL_TXN_REQUEST_LINES_SN
MTL_ITEM_CATS_SN
.
1. Please perform an automatic refresh of these snapshots INDIVIDUALLY.
The concurrent request : "Refresh Collection Snapshots", can be launched individually also.
Log into "Advanced supply Chain Planner" responsibility on the source instance.
Then from tools menu, choose View->Requests.
Click on the button, Submit a new request.
Type in "Refresh Collection Snapshots".
In the parameters choose the following:
Refresh Mode: Automatic
Snapshot Name: MTL_TXN_REQUEST_LINES_SN
Threshold for Truncating Logs: 0
Degree: 0
Click OK and submit the request.
Please repeat the same steps for the other snapshot: MTL_ITEM_CATS_SN
2. Do a fast refresh of ALL snapshots and ensure that it completes fine.
3. Please run data collection and is should complete successfully.
No comments:
Post a Comment