R12: PJI_MV_REFRESH Materialized View Refresh Utility errors ORA-01652 (Doc ID 1264766.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Intelligence - Version 11.5.10.2 to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms