My Oracle Support Banner

EAR: Performance Degradation At Item Accounting Entries Page (ITEM_DATA3) For Items With Volumes As High As 60,000 Accounting Lines (Doc ID 2330364.1)

Last updated on JUNE 14, 2023

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.