EAR 9.2: Unable To Open Items With Over 50,000 Accounting Lines Even After Solution From Bug 26039750 Has Been Implemented

(Doc ID 2409869.1)

Last updated on JUNE 11, 2018

Applies to:

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

Symptoms

ISSUE:

Having downloaded, and implemented the solution provided by <Bug 26039750> (AR: PERFORMANCE AT ITEM_MAINTAIN COMPONENT FOR ITEM WITH MANY ACCTG LINES), a performance degradation still persists at the View/Update Item Details(ITEM_MAINTAIN) Component when the opened transaction has more than 50,000 accounting lines. While the Item got posted properly into the Customer's Account, it cannot be opened in the View/Update Item Details component (ITEM_MAINTAIN), eventually times out on the User.

REPLICATION STEPS:

     1.- Have applied the solution provided for <Bug 26039750>
     2.- Log into the FSCM Online Application with a Receivables User ID
     3.- Navigate to: Accounts Receivable > Pending Items > Online Item > Group Entry
     4.- Create a new Pending Item Group, with one Item ID, and generate its Accounting Lines, which should be containing over 47,000 rows
     5.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
     6.- Launch AR Update AE Program (AR_UPDATE) to post the new Item transaction
     7.- Navigate to: Accounts Receivables > Customer Account > Item Information > View/Update Item Details
     8.- The system starts suffering from a performance degradation problem, and it times out. ITEM_MAINTAIN Component is not getting opened.

ACTUAL RESULT:

For certain Items, which such high volume of Accounting Lines, the transaction data is not viewable online anymore, and the Component ITEM_MAINTAIN eventually times out.

EXPECTED BEHAVIOR:

The View/Update Item Details Component (ITEM_MAINTAIN) should be able to handle any Items with large volumes of accounting line rows, at any given time.

 

Changes

 

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