Drop Collection Snapshots Fails with ORA-12003 (Doc ID 2923552.1)

Last updated on JULY 24, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.