Drop Collection Snapshots Fails with ORA-12003
(Doc ID 2923552.1)
Last updated on AUGUST 07, 2024
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3.9.2 and laterInformation in this document applies to any platform.
Symptoms
Drop collection Snapshot with parameter ALL SNAPSHOTS fails with the following error:
ERROR
-----------------------
23-JAN 18:55:39 : ( 'SCAP', 'FCST','ITEM','MRP','MRP','OH','RES','PO','ONT','SRSP','BOM','WSH','USUD','ERO','WIP','NOTES','ISUB','EAM','CMRO','AHLSCH')
23-JAN 18:55:39 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
23-JAN 18:55:39 : Skipped the Snapshot : APPS.AHL_TASK_LINKS_SN
23-JAN 18:55:39 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
23-JAN 18:55:39 : Skipped the Snapshot : APPS.CMRO_CLOSED_JOBS_SN
23-JAN 18:55:39 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
23-JAN 18:55:39 : Skipped the Snapshot : APPS.EAM_ACT_ASSOC_SN
23-JAN 18:55:39 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
23-JAN 18:55:39 : Skipped the Snapshot : APPS.AHL_WO_OPERATIONS_RELN_SN
23-JAN 18:55:39 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
23-JAN 18:55:39 : Skipped the Snapshot : APPS.AHL_WORKORDERS_SN
23-JAN 18:55:39 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
23-JAN 18:55:39 : Skipped the Snapshot : APPS.AHL_VISITS_SN
23-JAN 18:55:53 : ORA-12003: materialized view or zonemap "APPS"."PO_ACCEPTANCES_SN" does not exist
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Advanced Supply Chain Planning
2. Navigation: Other > Requests > Submit a New Request
3. From the Name list of value, select the Drop Collection Snapshots concurrent program.
4. For the Snapshot Name parameter, select ALL SNAPSHOTS from the list of value.
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 |