MSCTRIGS: Collections Triggers Error

+---------------------------------------------------------------------------+
Advanced Supply Chain Planning: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

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

Current system time is 16-JUL-2016 10:15:06

+---------------------------------------------------------------------------+

**Starts**16-JUL-2016 10:15:06
**Ends**16-JUL-2016 10:26:36
Error in creating Source Triggers
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
16-JUL 10:15:06 : Request : 7452875 :Creates Item Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452876 :Creates BOM Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452877 :Creates Routing Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452878 :Creates WIP Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452879 :Creates Demand Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452880 :Creates Supply Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452881 :Creates Other Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452882 :Creates Repair Order Triggers used by Collections Process
16-JUL 10:15:06 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
16-JUL 10:15:06 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
No completion options were requested.

Output file size:
0


Output is not being printed because:
The print option has been disabled for this report.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 16-JUL-2016 10:26:36

+---------------------------------------------------------------------------+

Solution:

To implement the solution, please execute the following steps:

1. Go into the responsibility: system administrator

2. Navigate to concurrent - manager - define

3. query for standard manager, click on workshifts and increase processes to 15

4. Retest the issue.

Demantra tables

a) Staging Tables

select * from t_src_item_tmpl;

select * from t_src_sales_tmpl;

select  * from t_src_loc_tmpl;


b) Patch

select * from version_details_history;


c) Base tables

select * from sales_data;--sales order historical data

select * from mdp_matrix;--combination data

select * from inputs;--time buckets

select * from queries;--worksheets

select * from items;--items

select * from location;--locations


d) Workflow

select * from wf_schemas;

select * from wf_process_log;


e) Integration interface

select * from transfer_query;

Demantra 12.2.5 Installation on windows

Pre-requisites:

   1) JDK 1.7 or 1.8
   2) Oracle client  11g higher or 12c installed on your server
   3) Make sure have 'SYS' credentials for installation.

Note: Demantra 12.2.5 best compatible with Windows 7. 

Installation:
  1) Install Demantra version 12.2.5.1 -  Patch 21951481 
  2)  Install mandatory patches
        a) 23088083
        b) 22254051
        c) 23016941
       

Note  : Follow note Installing Demantra 12.2.5.1 Screen Shot - Step by Step (Doc ID 2069281.1)

Demantra JVM installation issue

In the process of installing demantra 12.2.5,ran setup.exe as administrator but the system shows error.

or Error: Could not create the Java virtual machine

Solution:

To fix  this, set up _JAVA_OPTIONS from : Windows > go to Start > Control Panel > System > Advanced >  Click Environment Variables > in the System Variables section,click New > enter "_JAVA_OPTIONS" as the Variable Name, and set its  value to -Xmx512M > OK

  or

Run the install.exe file from D:\p21951481_122510_WINNT\Disk1\InstData\VM.

Installation will be done.Make sure u have setup the java_home in environment variable with value as the patch of JDK installed or else the server will not be up and application does not work.

or Run the setup.exe from command prompt.

Demantra Installation issue

Demantra Installation Importing Issue IMP-00058: ORACLE error 1950 encountered, ORA-01950: no privileges on tablespace( Doc ID 2094007.1)

Demantra installation issue

Install Demantra 12.2.5.1 (patch 21951481) we are getting error:

IMP-00058: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'DEV'

That implies, do not have access to Apps table space even though another demantra tablespace in the installation screen for standalone databases is working normal and was able to finish the installation.

Solution:

From internal Bug 12624910

The problem is new feature introduced in 11.2 database version.
The workaround is to run the following:

ALTER SYSTEM SET DEFERRED_SEGMENT_CREATION=FALSE;

This causes the import to work properly.

Please review this Note, which has more information on DEFERRED_SEGMENT_CREATION parameter:
11.2 Database New Feature Deferred Segment Creation [Video] (Doc ID 887962.1)

Same issue occurred for 12c database also and this above solution has resolved. Can be applied for 12c Database as well.