MSRFWOR module: Refresh Collection Snapshots Fails with Error: "Error Setting Up Source Objects with" (Doc ID 2051782.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When running Data Collections, you are encountering errors in MSRFWOR module (Refresh Collection Snapshots):


MSRFWOR module: Refresh Collection Snapshots

**Starts**31-AUG-2015 14:29:21
**Ends**31-AUG-2015 14:45:25
User-Defined Exception
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
31-AUG 14:29:21 : ref mode - 4
31-AUG 14:29:21 : snp name - COLL SNAPSHOTS
31-AUG 14:29:21 : The degree of parallelism for Refreshing snapshots is set to: 0
31-AUG 14:29:21 : select FND_PROFILE.VALUE ('MSC_COLL_TIME_WINDOW_IBUC_HISTORY') from dual
31-AUG 14:29:21 : Value of the Time Window Profile 12
31-AUG 14:29:21 : Request : 7446090 :Checks for Snapshots which have changed and Drops them
31-AUG 14:30:21 : select NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N') from dual
31-AUG 14:30:21 : CREATE INDEX CSD_REPAIRS_N11 ON CSD_REPAIRS (inventory_org_id ,last_update_date ,REPAIR_MODE ) TABLESPACE APPS_TS_TX_IDX
ORA-00955: name is already used by an existing object
31-AUG 14:30:24 : CREATE INDEX CSP_REPAIR_PO_HEADERS_N1 ON CSP_REPAIR_PO_HEADERS(WIP_id, REPAIR_PO_HEADER_ID, INVENTORY_ITEM_ID) TABLESPACE APPS_TS_TX_IDX
ORA-00955: name is already used by an existing object
31-AUG 14:30:24 : CREATE INDEX CSP_REPAIR_PO_HEADERS_N2 ON CSP_REPAIR_PO_HEADERS( purchase_order_header_id) TABLESPACE APPS_TS_TX_IDX
ORA-00955: name is already used by an existing object
31-AUG 14:30:24 : CREATE INDEX CSP_REPAIR_PO_HEADERS_N3 ON CSP_REPAIR_PO_HEADERS( requisition_line_id ) TABLESPACE APPS_TS_TX_IDX
ORA-00955: name is already used by an existing object

31-AUG 14:33:24 : Request : 7446107 :Creates Triggers used by Collections Process
31-AUG 14:45:25 : Source Setup Objects Creation Requests did not complete Successfully

31-AUG 14:45:25 : Error Setting Up Source Objects

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms