Page Data is Inconsistent With Database

If the message ‘Page data is inconsistent with database’ appears while saving the page, please refer the following resolution in MOS (My Oracle Support).

E-AS: How to Trace “Page data is inconsistent with database” error? [ID 655907.1]

Step 1: Set the following in psappsrv.cfg

TracePPR=1
TracePPRMask=32767

Step 2: Go to the PIA and before logging on, add & trace=Y (uppercase) at the end of the web address and press the ‘Enter’ key in the keyboard. Check the first five SQL options and for PeopleCode the ‘List Program’ & ‘Each statement’ options.

Step 3: Log in to PIA and reproduce the error.

Step 4: Check the trace, especially the portion which contains the below information:
PSAPPSRV.28630    1-167605 11.00.03    0.001 Record RO_LINE_ATTR.ROW_LASTMANT_DTTM database value “2007-06-11-10.58.44.000000? page value “2007-06-11-10.05.30.000000?
The trace should clearly show the field that is producing the error as well as the values that are populated both on database side and on page side.

The most common reason to encounter this issue is:

When you use a view to select data into a scroll based on a table and no Auto select option is turned on. The number of columns in view and scroll area base table differs and the additional column in base table contains not null values. Auto update for scroll can be used to change the value of the field in a scroll and save it.

To resolve this issue, add same number of columns to view similar to the base table or if possible, make the same view as a base record for the scroll that is used for selection.

Another reason could be using SQLExec in SavePostChange to update the Base Table Record and therefore changing the value.