My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.