Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

OLAP - Analytic Workspaces invalids found in SYS in preparation for upgrade of E-Business 12.2.5 dat

edited Aug 20, 2021 10:17AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 7 commentsAnswered ✓

Hello,

We are in the process of doing our first database upgrade of 11.2.0.4 to 12.1.0.2 that is part of our E-Business Suite 12.2.5. OS: Solaris SPARC-64 10

There are a number of invalid OLAP objects in the SYS schema, which I thought I could just remove, but it looks like E-Business is using some of it.

select name "FEATURE", first_usage_date "FROM", last_usage_date "TO"

from DBA_FEATURE_USAGE_STATISTICS

where name like '%OLAP%'

FEATURE                               FROM      TO

------------------------------------ ------------- --------------

OLAP - Analytic Workspaces 22-JAN-18 29-JAN-18

OLAP - Analytic Workspaces

OLAP - Analytic Workspaces 14-OCT-17 13-JAN-18

OLAP - Analytic Workspaces 30-JAN-18 17-APR-18

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center