MSRFWOR Refresh Collection Snapshots Failing In Stage MSCTRIGS Collections Triggers With No Visible Error (Doc ID 1456753.1)

Last updated on DECEMBER 03, 2019

Applies to:

Symptoms

When attempting to run collections for the first time MSCTRIGS fails with the message below. Subrequests all finish successfully.

ERROR
-----------------------

MSCTRIGS module: Collections Triggers
+---------------------------------------------------------------------------+

**Starts**08-MAY-2012 09:35:09
**Ends**08-MAY-2012 09:46:39
Error in creating Source Triggers

08-MAY 09:35:09 : Request : 421162 :Creates Item Triggers used by Collections Process
08-MAY 09:35:09 : Request : 421163 :Creates BOM Triggers used by Collections Process
08-MAY 09:35:09 : Request : 421164 :Creates Routing Triggers used by Collections Process
08-MAY 09:35:09 : Request : 421165 :Creates WIP Triggers used by Collections Process
08-MAY 09:35:09 : Request : 421166 :Creates Demand Triggers used by Collections Process
08-MAY 09:35:09 : Request : 421167 :Creates Supply Triggers used by Collections Process
08-MAY 09:35:09 : Request : 421168 :Creates Other Triggers used by Collections Process
08-MAY 09:35:09 : Request : 421169 :Creates Repair Order Triggers used by Collections Process
08-MAY 09:35:09 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
08-MAY 09:35:09 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual

Cause

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