Oracle Project Intelligence - Version 126.96.36.199 to 12.1.2 [Release 11.5.10 to 12.1] Information in this document applies to any platform.
For Project Intelligence, the Materialized View Refresh Utility (PJI_MV_REFRESH) errors out with the following error:
ORACLE error 12008 in FDPSTP
Cause: FDPSTP failed due to ORA-12008: error in materialized view refresh path ORA-12801: error signaled in parallel query server P002 ORA-01652: unable to extend temp segment by 20 in tablespace BISD ORA-06512: at "APPS.PJI
Based on <Note 290448.1> DBI Initial Refresh Concurrent Process Fails with Multiple Errors, the profile options have been setup to '1' at site level, but error persists.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!