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 NOVEMBER 20, 2017

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE:

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.

REPLICATION STEPS:

     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

ACTUAL RESULT:

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.

EXPECTED BEHAVIOR:

The Item Accounting Entries delivered page (ITEM_DATA3) should be able to handle any volume of accounting line rows, at any time.

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