Demantra - Custom Type Methods Are Not Enabled On Worksheets (Doc ID 1926972.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Worksheet

ACTUAL BEHAVIOR
---------------
Methods of type as Custom are greyed out on worksheet

EXPECTED BEHAVIOR
-----------------------
Expect Custom Type Methods should be enabled on the Worksheet

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Collaborator Workbench
2. Open Worksheet
3. Select an Item -> Right-Click -> Select Methods
Notice the LOV is disabled
Unable to access
  Create Similar Product
  Publish SPF changes
  Remove combinations
  Update Lifecycle definitions
 

 

 

The following error appears in the Collaborator Log

ERROR

-----------------------
2014-08-13 10:49:17,648 PDT [[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN tunnel.general: ODPM-10306: Facade not found [1]
2014-08-13 10:50:14,983 PDT [Level_Method_0] INFO workflow.general: [NPIStep] ****** STEP::STARTS ******
2014-08-13 10:50:15,104 PDT [Level_Method_0] WARN workflow.general: [NPIStep] Statement Batch Clear failed
2014-08-13 10:50:15,110 PDT [Level_Method_0] WARN workflow.general: [NPIStep] Statement Batch Clear failed
2014-08-13 10:50:15,628 PDT [Level_Method_0] ERROR workflow.general: [NPIStep] ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
[Additional info: null]
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at com.demantra.NPI.CreateSimiliarProcess.createSimiliarMember(Unknown Source)
at com.demantra.NPI.CreateSimiliarProcess.runProcess(Unknown Source)
at com.demantra.NPI.NPIProcess.execute(Unknown Source)
at com.demantra.workflow.step.NPIStep.executeStep(Unknown Source)
at com.demantra.workflow.step.CustomStepHost.doExecute(CustomStepHost.java:196)
at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:938)
at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:1281)
at com.demantra.workflow.process.WFProcess.run(WFProcess.java:662)
at com.demantra.workflow.process.WFProcess.execute(WFProcess.java:630)
at com.demantra.workflow.process.WFProcess.launch(WFProcess.java:578)
at com.demantra.bridge.server.method.MethodUtil.runWorkflow(MethodUtil.java:69)
at com.demantra.bridge.server.method.methodInvokers.MethodInvoker.runWorkflow(MethodInvoker.java:127)
at com.demantra.bridge.server.method.methodInvokers.EditMethodInvoker.invoke(EditMethodInvoker.java:21)
at com.demantra.bridge.server.method.methodInvokers.MethodInvoker.run(MethodInvoker.java:449)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
2014-08-13 10:50:15,634 PDT [Level_Method_0] FATAL workflow.general: ODPM-70420: Create Similar Item process failed.
java.lang.RuntimeException: ODPM-70420: Create Similar Item process failed.
at com.demantra.workflow.step.NPIStep.executeStep(Unknown Source)
at com.demantra.workflow.step.CustomStepHost.doExecute(CustomStepHost.java:196)
at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:938)
at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:1281)
at com.demantra.workflow.process.


 

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