1 Reply Latest reply: May 24, 2012 11:33 AM by Rapid E-Suite RSS

    TASK_GROUP_Extract_BOM

    user10330106
      Hi All,

      We are implementing OBIA 7.9.6.3 for the Supply Chain Module and Procurement modules.

      When we are trying to load the data thru DAC the TASK_GROUP_Extract_BOM gettting failed after applied patch as per oracle document.

      This below error shows in DAC log file

      ANOMALY INFO::: Error while executing : TRUNCATE TABLE:OPI_OBIA_W_BOM_HEADER_DS:"Table Action: Override OPI truncate command" template
      *          MESSAGE:::com.siebel.analytics.etl.execution.exceptions.ActionFailedException: Running Custom Sql list TRUNCATE TABLE:OPI_OBIA_W_BOM_HEADER_DS:"Table Action: Override OPI truncate command" template*
      *          *

      Default retries for this custom SQL is 1.

      executing sql (Truncate OPI:ORA_R1213)
      Call apps.OPI_OBIA_BOMPEXPL_WRAPPER_PKG.do_sql('TRUNCATE TABLE OPI.OPI_OBIA_W_BOM_HEADER_DS')

      *"Truncate OPI" failed on "ORA_R1213"*
      *          sql: Call apps.OPI_OBIA_BOMPEXPL_WRAPPER_PKG.do_sql('TRUNCATE TABLE OPI.OPI_OBIA_W_BOM_HEADER_DS')*
      *          Error: MESSAGE:::ORA-06576: not a valid function or procedure name*

      *          EXCEPTION CLASS::: java.sql.SQLException*

      Regards,
      Rama