EAR: Performance Degradation At Item Accounting Entries Page (ITEM_DATA3) For Items With Volumes As High As 60,000 Accounting Lines
Last updated on JANUARY 26, 2018
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
A performance degradation has been detected at the Item Accounting Entries page (ITEM_DATA3) when the opened transaction has around 60,000 accounting lines. While the Item got posted properly into the Customer's Account, and can be opened in the View/Update Item Details component (ITEM_MAINTAIN), the Item Accounting Entries tab spins endlessly, and eventually times out on the User.
1.- Log into the FSCM Online Application with a Receivables User ID
2.- Create a new Invoice in Billing, with around 50,000 rows in Accounting Lines
3.- Finalize and interface the Billing Invoice into the Accounts Receivable module
4.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
5.- Launch AR Update AE Program (AR_UPDATE) to post the new Item transaction
6.- Navigate to: Accounts Receivables > Customer Account > Item Information > View/Update Item Details
7.- Open the Item ID in question, and then go to the Item Accounting Entries tab (Page ITEM_DATA3)
8.- The system starts suffering from a performance degradation problem, and it times out
For certain Items, which such high volume of Accounting Lines, the transaction data is not viewable online anymore, and the Page ITEM_DATA3 eventually times out.
The Item Accounting Entries delivered page (ITEM_DATA3) should be able to handle any volume of accounting line rows, at any time.
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