While im trying to add a new row into jobcode page, i get this error. And also, i get "standard hours cannot be less than minimum standard hours" but i checked in all default tables(installation table, org defaults by permission list, business unit defaults) all are showing correct. Please help me to solve this.
are you using PeopleCode to manage a Scoll or Rowset. I've seen this message before but normally when I've modified Scrolls show/hide data. If that is the case doing a &RS.refresh() can reset the scroll area so that your save can continue normally without issues.
Yes. we are using the scrolls, i tried refreshing the rowsets. but even then its not working. I checked by adding new jobcode.(instead of adding new row to the existing jobcode).It takes std hours of some other setid by default.so i feel that this is the reason for inconsistent data in the database. i donno how it takes this std hours of another setid.Any idea from where it takes this value?
You should probably look in your tables and verify that you are now trying to create data that already exists.
Level 0 - PS_TABLE_NAME_1 - Keys: 100
Level 1 - PS_TABLE_NAME_2 - Keys: 100, 1
Level 2 - PS_TABLE_NAME_3 - Keys: 100, 1, A
If you for instance have data in level 2 (100, 1, A) and no data in Levels 0 or 1 you could be open to this type of error. If you all of a sudden try and save your component after putting in data at level 0 it will error because it does not think you should have data in Level 2 already. At that point when it goes to save the page data is inconsistent with the database and it will give you an error.
