Hi
Data conflict issue how this can be resolved
Trying to add a row for an employee . The employee is terminated say on 02/26/2008 but i want to add a rown 02/25/2008 , first time it gets added from page , doesnt save in the record. When trying to open the record for the same employee data conflict error happens the reason the data is not getting saved to the backend, how can we make sure the data is gettings aved to the database and data conflict error doesnt pop up.

Is PER099 is being run nightly?
Try after running the PER099 process, which updates the EMPLOYEE data current.

Solution 527287 elaborates more on that.

whats the solution 527287 is refered and wat does PER099 to do with data confilct and the save is not happening on job records its on other records
say ps_t record

If you have customer connect id, you can login to CSC to check the solution 527287.

i belive the problem which is mentioned is not clearly understood
this is a data conflict issue when someone is trying to add a historic row for an employee for a speciicc functionality.
its not directly linked to the job table or PER099
The problem happens when a row of data is entered which is earlier to his hire date. the row of data doesnt get savead in the database, in the page it shows data saved but the database doesnt have so when then user tries to access this row of data the 2nd time he gets data conflict errro the reason data is not saved in database. 527287. this wont solve the above mentioned problem

Yes, I am not clear what is the actual issue. Can you provied more details:

How does it show it is saved in the database?

What is the table name that you feel it is not saving in the database?

What is the hire date and when it was entered?

What is the termination date and when it was entered?

Is the issue is while entering date prior to hire date or termination date?

In the first post it is mentioned as termination date and the later one it is mentioned as hire date.

Can you provide the exact issue you are getting

Also if you can provide the screen shots it will be better. You can place the screenshots in word and attach here.

Have you tried to enter the row with trace on and if there are any error messages?

The scenario is like the following
The data is not getting saved in the database which is the reason for the data conflict issue.



The table is specific to global payroll.Am am giving an example here. the tables are say ps_a and ps_b. the change on the page doesnt reflect in ps_b which is the child table,The problem is with respect to entering a data for the employee prior to his/her hire date. say suppose the employee was hired in 01/01/1980. and then we try to save a row which is 12/31/1979, we save the page ,the page is saved but when we look the database the data doesnt get saved. to the record ps_b.
The issue is while entering data prior to the hire date and not with respect to termination date. IF any confusion is caused it was basically a typo error.There are no error messages. the problem is when we try to login to the page again and try to add a row for the same date as mentioned it shows data conflict error which is clearly understood that the data is not getting saved to the database

Please provide the actual table names where you have issue if you need help.

the tables names are as follows
GPGB_EE_SS
GPGB_EE_SS_S_VW

To add to this i have also made the fields as key fields specifically the date field bgn_date

Compshack has provided the answers including SQL trace as one of the option.

You can view the answer here. If you still have questions, you can write your comments in Compshack forum.

Cheers.