java.sql.SQLException: object name already exists: PORTAL_REVENUEAMOUNTS in statement [create table PORTAL_REVENUEAMOUNTS(BRM_GL_ID NUMERIC(10) NULL, BRM_GL_IDORDER NUMERIC(10) NULL, ELEMENT NUMERIC(10) NOT NULL, GENERALLEDGERREPORTFK NUMERIC(10) NULL, RESOURCEID NUMERIC(10) NULL, RESOURCEIDORDER NUMERIC(10) NULL, REVENUEAMOUNTSORDER NUMERIC(10) NULL, REVENUEAMOUNTSPK NUMERIC(10) NOT NULL)]

soabyte.com | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    SOABYTE | SME:Oracle SOA,Oracle AIA, Oracle SOA Suite Training, Oracle RODOD Implementation & Oracle SOA Training

    soabyte.com | 7 months ago
    java.sql.SQLException: object name already exists: PORTAL_REVENUEAMOUNTS in statement [create table PORTAL_REVENUEAMOUNTS(BRM_GL_ID NUMERIC(10) NULL, BRM_GL_IDORDER NUMERIC(10) NULL, ELEMENT NUMERIC(10) NOT NULL, GENERALLEDGERREPORTFK NUMERIC(10) NULL, RESOURCEID NUMERIC(10) NULL, RESOURCEIDORDER NUMERIC(10) NULL, REVENUEAMOUNTSORDER NUMERIC(10) NULL, REVENUEAMOUNTSPK NUMERIC(10) NOT NULL)]

    Root Cause Analysis

    1. java.sql.SQLException

      object name already exists: PORTAL_REVENUEAMOUNTS in statement [create table PORTAL_REVENUEAMOUNTS(BRM_GL_ID NUMERIC(10) NULL, BRM_GL_IDORDER NUMERIC(10) NULL, ELEMENT NUMERIC(10) NOT NULL, GENERALLEDGERREPORTFK NUMERIC(10) NULL, RESOURCEID NUMERIC(10) NULL, RESOURCEIDORDER NUMERIC(10) NULL, REVENUEAMOUNTSORDER NUMERIC(10) NULL, REVENUEAMOUNTSPK NUMERIC(10) NOT NULL)]

      at com.sunopsis.jdbc.driver.xml.SnpsXmlStatementRedirector.execute()
    2. com.sunopsis.jdbc
      SnpsXmlStatementRedirector.execute
      1. com.sunopsis.jdbc.driver.xml.SnpsXmlStatementRedirector.execute(SnpsXmlStatementRedirector.java:125)
      1 frame