Party Prof: Account Relationship Consolidation Process Hangs After Stopping It
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
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".
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