Who's Online Now
0 registered members (), 8 guests, and 7 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Krati, Taposh, Jafar Habeebulla, CloudShine Softw, Aaa
1305 Registered Users
Recent Posts
Top Posters(30 Days)
CT 1
Popular Topics(Views)
508,331 PAYE RTI
63,666 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#6172 - 14/12/10 09:43 AM Grade Ladders  
Joined: Mar 2009
Posts: 21
Jan Offline
regular
Jan  Offline
regular

Joined: Mar 2009
Posts: 21
Hi, I am trying to create grade/step ladders utilising Total Compensation setup wizard, I have went through the seven setup steps, submitted my ladder but I am receiving the following error message "ORA-01400" cannot insert null into "BEN"."BEN"_VRBL_RT_PRFL_F."NAME". I have tried locating the error message on Metalink but to no avail, has anyone seen this error message before, and what does it mean? Is this something to do with enrollment plans??

#6175 - 15/12/10 03:11 AM Re: Grade Ladders [Re: Jan]  
Joined: Aug 2005
Posts: 149
MarinaH Offline
nothin' better to do
MarinaH  Offline
nothin' better to do

Joined: Aug 2005
Posts: 149
Away with the fairies
Hi Jan

It's to do with the GSP grade rates. Were they setup prior to the creation of the grade ladder?

Marina

#6178 - 15/12/10 06:56 AM Re: Grade Ladders [Re: Jan]  
Joined: Mar 2005
Posts: 1,293
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,293
Earth, Europe, England, here
Hi Jan
I'm not familiar with the BEN module, however the error is complaining about a mandatory column being NULL when the process is trying to insert a row.
The NAME colum is the name of the Variable Rate Profile that is trying to be created by the process/step you are doing.

Whether this gives you any pointers to assist you further....

Either that or wait for one of the (few) BEN Aces to wander by.

Regards

Barry


No signature required
#6179 - 15/12/10 07:04 AM Re: Grade Ladders [Re: MarinaH]  
Joined: Mar 2009
Posts: 21
Jan Offline
regular
Jan  Offline
regular

Joined: Mar 2009
Posts: 21
Hi Marina,
thank you for responding, I'm assuming that you are referring to the Grade Rates as @ step 5 of the grade ladder, if you were then Yes, although I did do some amendments afterwards, if this was the issue, would I have to delete the grade ladder and start again?

#6180 - 15/12/10 07:14 AM Re: Grade Ladders [Re: Jan]  
Joined: Mar 2009
Posts: 21
Jan Offline
regular
Jan  Offline
regular

Joined: Mar 2009
Posts: 21
Hi Marina,
I forgot to add that the actual grade rate table was setup prior to the grade ladders being created, with the min/max and mid values.

#6184 - 15/12/10 08:39 PM Re: Grade Ladders [Re: Jan]  
Joined: Aug 2005
Posts: 149
MarinaH Offline
nothin' better to do
MarinaH  Offline
nothin' better to do

Joined: Aug 2005
Posts: 149
Away with the fairies
Hi Jan

Amending the grade rate information after the grade ladder has been created does not mean you need to delete the grade ladder, so don't worry about that. Did you make the amendments through the total compensation wizard or throught grade rates table? Have you run the Recalculate Participation Values: Grade/Step Progression concurrent request?

Might be barking completely up the wrong tree here, but we had issues withour grade ladders and the way the rates were being setup!

#6187 - 16/12/10 07:20 AM Re: Grade Ladders [Re: Jan]  
Joined: Mar 2009
Posts: 21
Jan Offline
regular
Jan  Offline
regular

Joined: Mar 2009
Posts: 21
Hi Marina,
once again thank you for your update, I have to admit GSP is relatively new to me, I thought that your grade ladder had to be successfully created before you ran the Recalculate Participation Values,in answer to your question I made my amendments through the wizard and not the grade rate tables

#6189 - 17/12/10 02:08 AM Re: Grade Ladders [Re: Jan]  
Joined: Aug 2005
Posts: 149
MarinaH Offline
nothin' better to do
MarinaH  Offline
nothin' better to do

Joined: Aug 2005
Posts: 149
Away with the fairies
Our issue centred around the fact that we needed to set the grade rates up in the Grade Rate table first.. Let me look a little more into it and I'll get back to you


Moderated by  andy.fisher, bcooper, CT 

Forum Statistics
Forums60
Topics2,230
Posts12,039
Members1,306
Most Online283
Dec 25th, 2019
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,120
delboy 1,311
bcooper 1,293
paulgos 439
SBi 427
pat 254
Gus 252
vkumar 223
April
S M T W T F S
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.021s Queries: 15 (0.005s) Memory: 2.7860 MB (Peak: 2.9722 MB) Zlib disabled. Server Time: 2021-04-11 13:26:30 UTC