Invalid OLAP Objects and OLAP Components - APS / XOQ / AMD
This thread is for discussion and questions about Invalid OLAP Components and Objects.
General Advice:
You can review the basic troubleshooting Steps to resolve the issue.
- Invalid OLAP Objects and OLAP Components - APS / XOQ / AMD (Doc ID 2562988.1)
To Validate OLAP Components, You can refer
- Oracle OLAP API Invalid After Upgrade To 11.2.0.4 (Doc ID 1951630.1)
- Oracle Olap API Invalid After Adding or Upgrading OLAP (Doc ID 466363.1)
- Script to CREATE PROCEDURE xoq_validate_verbose12 Needed to Validate Invalid OLAP API in 12C (Doc ID 2235352.1)
- How To Change Olap Option Status from Loaded/Upgraded to Valid Before Upgrading Database (Doc ID 729494.1)
Below Documents will help you to decide on the removal of OLAP Invalid Objects. You have to cross verify your invalid List of Objects with the Object Names provided in the below documents, If there is a match You can remove that invalid Object.