E-PIA: PT 8.50 Auto-Persistent Grid Sorting or Column Resizing Can Create Wrong Grid Lock Issues After the Grid Design in Page Gets Changed (Doc ID 1288320.1)

Last updated on JANUARY 03, 2023

Applies to:

Goal

In PT 8.50 page design modifications might be affected by users sorting the new grids or adjusting some of columns width - By just clicking the grid header the user sorting preference would be stored in PSUSEROBJTYPE (tools table) - a new line would get inserted in this table, holding the persistent user grid options

The same would happen if some of the users are resizing any of the columns width, (by dragging with the mouse the grid header column border)  - this can cause columns to "not align properly" with the data cell (columns borders and headings borders don't exactly line up for these OPRID's) when longer data values are retrieved in the grid fields - these particular users can also be "detected" as a new line would get inserted in this PSUSEROBJTYPE storing the new preferred size for the grid column(s) for such users

In any release with user customizations (personalizations) enabled for grids and pages, those personalizations can cause problems for the page, particularly on the grid, if someone changes the page definition in Application Designer after the user personalization has been defined.

Symptoms can be things like columns no longer appearing in grids where they were before, or columns being repeated in grids where they weren't before, or sorts being messed up, etc.

This was not the case in older tools versions where the sorting preferences should have been saved using "Customize" link in the grid header

PeopleBooks 8.50 explains this new persistent behavior under this paragraph:
++++++++++++++++++++++++++++++++++++++++++++++++++++
Home > PeopleBooks > Enterprise PeopleTools 8.50 PeopleBook: Using PeopleSoft Applications > <Working With Scroll Areas and Grids>
<Changing Column Sort Order >

You can change the sort order of grid columns without leaving the transaction page. Click a single column header to toggle between ascending and descending order. Click multiple column headers in the reverse order that you want to sort them with the last column header that you click becoming the primary sort for the grid. Grids enable you to have primary, secondary, and tertiary sorts. A dark blue arrow to the right of a column header indicates a primary sort; a light blue arrow indicates a secondary or tertiary sort. Any sort changes that you make to a grid remain in place until you change them.
++++++++++++++++++++++++++++++++++++++++++++++++++++

The developers working with 8.50 grids should be aware about this potential wrong look in page and inform user community about pages and grids modified - If any grid would be modified or page layout would be modified by inserting new columns or new fields, all user stored customizations (page or grid customizations) would become obsolete and would need to be cleared by each user.

A select in DB could be performed in DB to see if there are users that customized the page or grid in the page modified

select * from PSUSEROBJTYPE where PNLNAME = 'SPECIFIC_PAGE'

NOTE: In the select above replace SPECIFIC_PAGE with the actual page name where user(s) are reporting grid problems (use CTRL+J to determoine the acual page name)

How users can delete personalization in new 8.50 grids?

Solution

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