EAR 9.2: Unable To Open Items With Over 50,000 Accounting Lines Even After Solution From Bug 26039750 Has Been Implemented
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.
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.
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.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms