Effective Dated Grids are not Displaying all Rows
We are creating three custom pages, each with a grid on them. Two of the grids have tables as a source, and the third uses a view, and all of them have the delete a row function turned off. When I insert a new effective dated row (EFFDT, EFFSEQ, EFF_STATUS), the new row gets inserted above the existing row, which contradicts the grid behavior per peoplebooks. When I refresh the page, the new row and every single row below that one are removed from the grid. They still appear in the underlying record, and the Include History view.
For example, if my new row is to inactivate row four of ten rows, the new row will become row four. When I save and refresh the page, rows four through eleven will no longer be visible in the grid, unless Include History is on. In which case, all the active and inactive rows are displayed, which negates the effective dated logic.