Friday, April 4, 2014

R12: Create Accounting and scaling options

Coming fresh off the presses, yesterday we had a problem with our Create Accounting program where it gave us the following error:

****Warning!!! Due to high volume of data, got out of memory exception...***
****Please retry with scalable option or modify the Data template to run in scalable mode...***

Obviously this is not something we wanted (or expected) to see so we compared the run parameters to what was run before, and it did not appear to be anything out of the ordinary so off to My Oracle Support I went.  I found note 1470317.1 titled "PAXACCPB PRC: Create Accounting Completes With Error: Due to high volume of data, got out of memory exception...Please retry with scalable option or modify the Data template to run in scalable mode" which had steps for resolving our issue but the interesting part of this was we had already followed the note EXCEPT for a critical part of it where we made the scalable flag default to N instead of Y.  Once we made that change, after regression testing in QA first, the business re-ran the report for the same org that had the same volume of data, and the report completed successfully this time!

No comments:

Post a Comment