Demantra Using Weblogic: EBS Full Download Workflow Errors when Running the Procedure DL_RUN_PROC, ERROR dpweb.general: Process ID: and Database internal error:ORA-00900: invalid SQL statement

(Doc ID 1080360.1)

Last updated on AUGUST 03, 2016

Applies to:

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

Symptoms

Using Weblogic as application server with Database driver used as Oracle's Driver XA in JDBC Data source.

When attempting to run the 'EBS Full Download' the following error is seen in the Collaborator.log file:

2010-03-31 13:06:15,927 EDT [WFProcess_4] ERROR dpweb.general:
################ Step Failure. #################
2010-03-31 13:06:15,928 EDT [WFProcess_4] ERROR dpweb.general: Process ID:  781599
Schema ID:   1512
Schema name: 'test'
Step ID:     'Step3'
Step name:   'Step3'

Error description 'Database internal error:ORA-00900: invalid SQL statement'
2010-03-31 13:06:15,929 EDT [WFProcess_4] ERROR dpweb.general:
2010-03-31 13:38:49,737 EDT [WFProcess_6] INFO  appserver.integration:
2010-03-31 13:38:49,738 EDT [WFProcess_6] INFO  appserver.integration: Import Data.
2010-03-31 13:38:49,739 EDT [WFProcess_6] INFO  appserver.integration: ODPM-20044: Run Start Time: 03-31-2010 13:38:49
2010-03-31 13:38:49,740 EDT [WFProcess_6] INFO  appserver.integration: ODPM-20045: Interface Name: Purge History Data
2010-03-31 13:38:49,740 EDT [WFProcess_6] INFO  appserver.integration: ODPM-20046: Profile Name: Purge History Data
2010-03-31 13:38:49,740 EDT [WFProcess_6] INFO  appserver.integration: ODPM-20052: Owner: dm
2010-03-31 13:38:49,741 EDT [WFProcess_6] INFO  appserver.integration: ODPM-20053: Profile From Date: 03-01-2010
2010-03-31 13:38:49,742 EDT [WFProcess_6] INFO  appserver.integration: ODPM-20054: Profile Until Date: 03-01-2010
2010-03-31 13:38:50,126 EDT [WFProcess_6] INFO  appserver.integration: ODPM-20064: Rows processed: 0.
2010-03-31 13:38:50,253 EDT [WFProcess_6] INFO  appserver.integration: ODPM-20048: Run End Time: 03-31-2010 13:38:50
2010-03-31 13:38:50,253 EDT [WFProcess_6] INFO  appserver.integration: ODPM-20049: Run Duration Time (hh:mm:ss:msec):0:0:0.515
2010-03-31 13:41:30,019 EDT [WFProcess_6] FATAL workflow.general: ORA-02074: cannot ALTER PACKAGE COMPILE in a distributed transaction
ORA-06512: at "SYS.DBMS_DDL", line 202
ORA-06512: at "CCWDMP.DL_RUN_PROC", line 21
ORA-06512: at line 1

java.sql.SQLSyntaxErrorException: ORA-02074: cannot ALTER PACKAGE COMPILE in a distributed transaction
ORA-06512: at "SYS.DBMS_DDL", line 202
ORA-06512: at "CCWDMP.DL_RUN_PROC", line 21
ORA-06512: at line 1

 

STEPS

  1. Run the EBS full download workflow manually from Demantra Workflow portal or Responsibility: Demand Management system Administrator > collections > Shipments and Booking History
  2. Submit the request set with parameter Launch EP load as YES.
  3. After all the request finished, internally WF : EBS full download is launched and errors out.

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