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.

Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms