Closing Inventory Period - Very Bad Performance
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***
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:
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.
The issue can be reproduced at will with the following steps:
1. Inventory Accounting Period>Close
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