Launch Request Set - Planning Data Collection And See Child Request - APS Collections Refresh Snapshot Thread - Has Error ORA-12052 for Snapshot CMRO_CLOSED_JOBS_SN
(Doc ID 2989809.1)
Last updated on NOVEMBER 28, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.6.3 and laterInformation in this document applies to any platform.
Symptoms
Planning Data Collection launches the child request Refresh Collection Snapshots (MSRFWOR), which launches child requests for each snapshot, the following error occurs in the APS Collections Refresh Snapshot Thread (MSCCLRFS).
Log shows error for one of the 50+ snapshots:
ERROR
-----------------------
[28-SEP-2023 10:34:55]: **Starts**
[28-SEP-2023 10:35:01]: **SQL error and free**
[28-SEP-2023 10:35:01]: ORACLE error 12052 in FDPSTP
Cause: FDPSTP failed due to ORA-12052: cannot fast refresh materialized view APPS.CMRO_CLOSED_JOBS_SN
ORA-06512: at "APPS.MRP_CL_REFRESH_SNAPSHOT", line 3192
ORA-06512: at line 1
The issue can be reproduced at will with the following steps:
- Responsibility: Advanced Supply Chain Planner
- Navigation: Collections > Oracle Systems > Standard Collections
- Enter parameters for Planning Data Pull and Planning ODS Load programs
- Submit
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |