ORA-01001: Invalid Cursor, ORA-06512: At "<OWNER>.BIS_MV_REFRESH"
(Doc ID 602727.1)
Last updated on APRIL 06, 2024
Applies to:
Oracle E-Business Intelligence - Version 11.5.10.0 to 11.5.10.0 [Release 11.5.10]Information in this document applies to any platform.
Symptoms
The Financials Intelligence request set DBI_MAX_EXPENSES gets the following error every time it is run:
BIS_MV_REFRESH module: BIS Materialized View Refresh Program
ORA-01001: invalid cursor
ORA-06512: at "<OWNER>.BIS_MV_REFRESH", line 253
ORA-00933: SQL command not properly ended
DBI Page title: Expenses by Manager under Daily Financial Intelligence Responsibility.
Last Step Completed Without Error: Run Initial Load of Opportunity Log Tables Concurrent Program.
The issue can occur in any module. For example, it has been reported in the incremental load for Marketing Intelligence.
Oracle internal: Click here for details.
Workaround: None.
Documentation followed:
Oracle Daily Business Intelligence
Implementation Guide
Release 11i
Part No. B10706-03
August 2005
BIS patchset level Family Pack: 11i.BIS.L
Steps To Reproduce:
Responsibility name: Daily Business Intelligence Administrator
Application: Applications BIS
Navigation Path: Daily Processing > Run
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 |