My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.