My Oracle Support Banner

Party Prof: Account Relationship Consolidation Process Hangs After Stopping It (Doc ID 401760.1)

Last updated on JANUARY 29, 2010

Applies to:

Oracle Profitability Manager - Version: 4.5.30 to 4.5.39 - Release: 4.5 to 4.5
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5.30 to 4.5.39
Party Profitability
Checked for relevance on 29-Jan-2010.


When running a Party Profitability ID, the Account Relationship Consolidation process on a table is taking hours to run when it usually takes around 10 minutes.  The process appears to be hanging.

The Party Profitability job was stopped from Performance Analyzer using the Server Status Update screen. While the job gets a status of "Cancelled" in the Server Status Update screen, rows still exist in USER_JOBS associated with the process and the related table, PFT_PARTY_PROFIT_DETAIL, is still locked.

The "Identify Orphan Values" option is set to "No".


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

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