ORA-33272: Analytic workspace FPA.FPAPJP cannot be opened.
Dear All,
While setting up the profile "PJP: Nominate Risk from Investment Criteria" ti implement project portfolio analysis, we got below error: app-fnd-01564: ORACLE error 33272 fdlget
select * from apps.fpa_inv_criteria_vl
ORA-33272: Analytic workspace FPA.FPAPJP cannot be opened.
ORA-00600: internal error code, arguments: [xsOBJTYPE1], [], [], [], [], [], [], [], [], [], [], []
33272. 00000 - "(DBERR06) Analytic workspace %s cannot be opened."
*Cause:
*Action:
here is profile query:
"SQL="SELECT name \"Criteria Category\", strategic_obj
INTO :visible_option_value,
:profile_option_value
FROM fpa_inv_criteria_vl where strategic_obj in (4,5,6,7,8)"
COLUMN="\"Criteria Category\"(80)""
Please advise how to overcome this issue.
Thanks
Venkat