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
Page 1 of 2 1 2
#7150 - 06/12/11 04:32 PM IBU Errors  
Joined: Mar 2011
Posts: 34
Vizay Offline
enthusiast
Vizay  Offline
enthusiast

Joined: Mar 2011
Posts: 34
Hyderabad
Hi , Please advise on the following errors , during initial balance upload in VALIDATE mode.

1.This combination of balances is invalid for the load date.
2.No DateTrack row found in table PAY_US_EMP_FED_TAX_RULES_F
3.The Defined Balance specified does not exist.

Please advise.
Thanks VJ--


Vijay--
#7151 - 06/12/11 05:44 PM Re: IBU Errors [Re: Vizay]  
Joined: Mar 2005
Posts: 2,120
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,120
1. Either trying to load the same balance/dimension twice for the same assignment, or different dimensions for the same balance have incompatible values, eg itd=100, ytd=50.

2. No idea, US legislation rule of some sort

3. Balance does not have the specified dimension allocated to it.


CT
#7152 - 07/12/11 04:59 AM Re: IBU Errors [Re: CT]  
Joined: Mar 2011
Posts: 34
Vizay Offline
enthusiast
Vizay  Offline
enthusiast

Joined: Mar 2011
Posts: 34
Hyderabad
Thanks CT for the quick help. VJ--


Vijay--
#7153 - 07/12/11 10:55 AM Re: IBU Errors [Re: Vizay]  
Joined: Mar 2011
Posts: 34
Vizay Offline
enthusiast
Vizay  Offline
enthusiast

Joined: Mar 2011
Posts: 34
Hyderabad
CT , I have checked the records and everything is proper i.e

1. no duplicates
2. the errored records have QTD and YTD dimeensions , having QTD values lessthan YTD.

Not sure why the validation failing for the records

Pls advise.
VJ--


Vijay--
#7154 - 07/12/11 12:29 PM Re: IBU Errors [Re: Vizay]  
Joined: Mar 2005
Posts: 2,120
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,120
Are you setting the upload date at the batch header level, or are you overriding it at line level?

What upload date(s) are you using?

Can you load a QTD on its own?

Exactly what YTD dimension(s) are involved here?


CT
#7156 - 07/12/11 11:13 PM Re: IBU Errors [Re: Vizay]  
Joined: Feb 2008
Posts: 174
Gavin Harris Offline
nothin' better to do
Gavin Harris  Offline
nothin' better to do
*****

Joined: Feb 2008
Posts: 174
Down under...
Hi Vijay,

What is the Effective Date on the Balance? I could be totally wrong, but doesn't it need to be 01-Jan-0001?

Hope this helps?
Gav


Gavin Harris
Sleeping on it...

Link to me on http://www.linkedin.com/in/gavinharris
#7157 - 08/12/11 06:46 AM Re: IBU Errors [Re: Gavin Harris]  
Joined: Mar 2011
Posts: 34
Vizay Offline
enthusiast
Vizay  Offline
enthusiast

Joined: Mar 2011
Posts: 34
Hyderabad
CT , Please find answeres to the questions asked

Are you setting the upload date at the batch header level, or are you overriding it at line level?
ANS : We are setting up upload date at header level not overriding at line level , which is sysdate of the run.
What upload date(s) are you using?
ANS : SYSDATE
Can you load a QTD on its own?
ANS : Few days back we deleted YTD balances for the errored records and succesfully loaded the QTD values.
Exactly what YTD dimension(s) are involved here?
ANS : 1.ASSIGNMENT WITHIN GOVERNMENT REPORTING ENTITY YEAR TO DATE
2.ASSIGNMENT WITHIN GOVERNMENT REPORTING ENTITY QUARTER TO DATE

Thanks
VJ--


Vijay--
#7158 - 08/12/11 06:48 AM Re: IBU Errors [Re: Vizay]  
Joined: Mar 2011
Posts: 34
Vizay Offline
enthusiast
Vizay  Offline
enthusiast

Joined: Mar 2011
Posts: 34
Hyderabad
CT ,

Here are the distinct dimensions those are involved for the error records , and the error is 'This combination of balances is invalid for the load date.'


DIMENSION_NAME

ASSIGNMENT IN JD WITHIN GRE QUARTER TO DATE
ASSIGNMENT IN JD WITHIN GRE YEAR TO DATE
ASSIGNMENT WITHIN GOVERNMENT REPORTING ENTITY QUARTER TO DATE
SUBJECT TO TAX FOR ASSIGNMENT WITHIN GRE YEAR TO DATE
SUBJECT TO TAX FOR ASSIGNMENT WITHIN GRE QUARTER TO DATE
ASSIGNMENT WITHIN GOVERNMENT REPORTING ENTITY YEAR TO DATE


Vijay--
#7159 - 08/12/11 09:33 AM Re: IBU Errors [Re: Vizay]  
Joined: Mar 2005
Posts: 2,120
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,120
I thought it might be a problem on MOS, but that is referring to the dimension 'Assignment within Government Reporting Entity Fiscal Year to Date' but it seems you aren't using that.

The only other thing i can think of is the upload date - I would normally use the period end date of the period in which the legacy system payroll last ran, whereby you extracted those balances. e.g. if the last pay run on legacy was Jun 2011, then set the upload date to 30-JUN-2011.

@Gav, good try fella but the effective date 01/01/0001 only refers to the Balance Initialization elements/links, not the balances themselves.


CT
#7160 - 08/12/11 11:58 AM Re: IBU Errors [Re: Vizay]  
Joined: Mar 2011
Posts: 34
Vizay Offline
enthusiast
Vizay  Offline
enthusiast

Joined: Mar 2011
Posts: 34
Hyderabad
CT , Thanks for the update , will update you the status.

Thanks VJ--


Vijay--
Page 1 of 2 1 2

Moderated by  Administrator, 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.028s Queries: 16 (0.009s) Memory: 2.8128 MB (Peak: 3.0134 MB) Zlib disabled. Server Time: 2021-04-11 13:15:01 UTC