You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Same Record at Level 0 and Level 1

6 replies [Last post]
gpawar.ps's picture
User offline. Last seen 10 years 22 weeks ago. Offline
Joined: 02/06/2009
Posts: 10

We have added same record at Level 0 and level 1. Level 0 is having all key fields while Level 1 contains only one key field (i.e. EFFDT) and two non-key fields.
When we are trying to update existing row then it is working correctly but when we are trying to Add a New Value for current date, and try to Save the componet then it is throwing 'Data Conflict' Error. and for either previous date or future date it is Adding two rows- one row for the history/future date and one row for current date.

Please help us to resolve it.

Thank you in advance.

Regards,
Ganesh Pawar

Guest's picture
Guest (not verified)
Re: Same Record at Level 0 and Level 1

the data conflict error may be because the row which you are trying to add doesn't have a unique key combination and may be it is clashing with the values of keys for rows already present....my suggestion to you is you can add a field line number to your level 1 record and increment it everytime a row gets added and make it as a key apart from EFFDT.

Guest's picture
Guest (not verified)
Re: Same Record at Level 0 and Level 1

Create different record for level 0 and 1.

Ashar's picture
User offline. Last seen 4 years 31 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: Same Record at Level 0 and Level 1

Strange. DEPARTMENT_TBL component in HR has same record at level 0 & 1 and it works fine.

Hari_aindian's picture
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 08/02/2010
Posts: 84
Re: Same Record at Level 0 and Level 1

May be a trace will help you to identify... Use SetTracePC to find the exact trace of your component code alone

Guest's picture
Guest
Re: Same Record at Level 0 and Level 1

Did you get get solution for this ?? if so please post it here because am facing exactly the same issue

Guest's picture
Guest
Re: Same Record at Level 0 and Level 1

I am not able to understand the concept of level 0 and level 1 in peoplesoft.can anyone please help me with an example