Closing Inventory Period - Very Bad Performance (Doc ID 1391923.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Oracle Inventory Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance 25-Aug-2013***

Symptoms

On : 12.1.3 version, Period Close

When attempting to close an inventory period, not only does it take a long time (hours) but also seems to drain considerable system resource.
Multiple users notice and impacted by slow system response times when the inventory period close process is running. When trying to close the
period upon pressing the 'Close' button, after a significant delay the following error message pops up:

ERROR
-----------------------
ORA-01403: no data found

FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01086

The above error has again been produced after attempting to trace a period close. It took a day for that error to appear.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Inventory Accounting Period>Close

Changes

 

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