My Oracle Support Banner

EPC: PC_TL_TO_PC Is Stuck at Step PC_FND_DIST.TRUEUP.Step20. How Can We Complete This Production Process? (Doc ID 2642364.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

The Time and Labor Cost Collection process PC_TL_TO_PC has been running for a long time and has not finished. Most of the time was spent on a single SQL UPDATE statement where it is "stuck".  This Process normally takes a few hours to run for 1 to 1.2 million rows. The current instance is processing 3.6 million rows and has been running for over two days.

Should we cancel this? How can we proceed to complete this?

Solution

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