Overgrowth of the PJI_FP_XBS_ACCUM_F Table and Indexes
(Doc ID 2972869.1)
Last updated on APRIL 12, 2024
Applies to:
Oracle Project Planning and Control - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
Production instance has seen an overgrowth of the PJI_FP_XBS_ACCUM_F table and related indexes.
select count(*) from PJI_FP_XBS_ACCUM_F; -- Count from Production is for example 2.6 billion records.
Example data:
TABLESPACE_NAME / OWNER / SEGMENT_NAME / SEGMENT_TYPE / SEGM_GB
APPS_TS_TX_DATA / PJI / PJI_FP_XBS_ACCUM_F / TABLE / 600,00
APPS_TS_TX_IDX / PJI / PJI_FP_XBS_ACCUM_F_N6 / INDEX / 300,00
APPS_TS_TX_IDX / PJI / PJI_FP_XBS_ACCUM_F_N2 / INDEX / 200,00
APPS_TS_TX_IDX / PJI / PJI_FP_XBS_ACCUM_F_N3 / INDEX / 170,00
APPS_TS_TX_IDX / PJI / PJI_FP_XBS_ACCUM_F_N4 / INDEX / 136,00
APPS_TS_TX_IDX / PJI / PJI_FP_XBS_ACCUM_F_N5 / INDEX / 136,00
APPS_TS_TX_IDX / PJI / PJI_FP_XBS_ACCUM_F_N1 / INDEX / 135,00
APPS_TS_TX_IDX / PJI / PJI_FP_XBS_ACCUM_F_N7 / INDEX / 130,00
The process, PRC: Delete Historical Workplans and Financial Plan, is not deleting any data.
Replication Steps:
1. Run the following query.
select count(*) from PJI_FP_XBS_ACCUM_F;
Note the large amount of records in the table.
2. > Projects responsibility > Other > Requests > Run. Run the process, PRC: Delete Historical Workplans and Financial Plan, but is not deleting any data.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |