No matching buffer found for level-PeopleSoft

This error => "No matching buffer found for level" in PeopleSoft, usually comes with a long description after this which is not that friendly and confuses the user. The complete error text is provided below

---------------------------

Microsoft Internet Explorer

---------------------------

No matching buffer found for level. (15,26)

When retrieving data for a page, a data value was retrieved for which there was no matching data value at a higher level scroll entry.  (For example, at scroll level 2, a value of ABC was read in and scroll level 1 contained this higher level field but did not have a row with a key value of ABC.)  This usually occurs because of an error in a database record or view; or because of improper deletion of values in a database.  Correct the page definition or contact your system administrator.

---------------------------

OK  

---------------------------

To understand how to go about and fix this error..The key statement of the error message is " was no matching data value at a higher level scroll entry".. This means, you are trying to open a component that contains multiple scroll levels. (Level 0, Level 1 and Level2) etc.

Consider the following table setup:

Level=>0	TV
		BRANDID
		BRANDNAME
	Level=>1	TV CITY
			BRANDID
			CITYID
			COUNTRY
		Level =>2	TV STORE
				BRANDID
				CITYID
				STOREID
				PRICE

Now, one row in TV table can have multiple rows in TV CITY for BRAND ID..on the same lines one row in TV CITY can have multiple rows in TV STORE for BRANID and CITY ID combination. Assume that all these tables are put together in a single component in PeopleSoft and the search record for the component allows query based on BRANDID

Now, the error comes in a scenario where a row in TV STORE table has no match for CITYID in TV CITY table..Even though the Brand ID matches. For example, consider the rows below

BRANDID	BRANDNAME
1	Samsung
BRANDID	CITYID	COUNTRY
1	Chicago	US
1	California	US
BRANDID	CITYID	STORE ID	PRICE
1	Chicago	ST1	900
1	California	ST2	1200
1	Florida	ST3	1400

Here, the CITYID "Florida" does not have a match in TV CITY table, possibly because of a deletion. When you try to open the page in PeopleSoft GUI for this BRANDID, this error will be thrown.

To fix the error, the row corresponding to the CITYID "Florida" needs to be deleted.