OBIA: Error: "MESSAGE:::ORA-06576: not a valid function or procedure name" 'Analyze' Table Action Command for the OPI_OBIA_W_BOM_HEADER_DS Table Fails Running the Truncate Command (Doc ID 1397850.1)

Last updated on FEBRUARY 23, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

You have OBIA 7.9.6.3 and the ETL fails.  In DAC_SDE_ORA_BOMItemFact_ORA_R1213_DataWarehouse Task, you see the following error:

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

 

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