My Oracle Support Banner

Poor Performance With PA: Offline Microsoft Project Data Upload (PAXCPWBC) Process (Doc ID 2589055.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Oracle Project Planning and Control - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Users experience poor performance with concurrent program PA: Offline Microsoft Project Data Upload (PAXCPWBC)

PAXCPWBC (PA: Offline Microsoft Project Data Upload) runs for days when trying to load large projects.
Additionally, it generates a large amount of UNDO segments.
The program spends much of its time executing the query below. It is full scanning the index PJI.PJI_FM_XBS_ACCUM_TMP1_N1 on the global temporary table PJI.PJI_FM_XBS_ACCUM_TMP6 .

 

Changes

 

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
Changes
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.