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 JULY 11, 2022
Applies to:
Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |