Who's Online
0 registered (), 2 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
In which table is external learning data stored
by DMC
Yesterday at 03:43 PM
Pension Auto Enrolment
by CT
Yesterday at 09:46 AM
Vehicle Mileage Setup
by Shyam
Yesterday at 06:45 AM
11.5.10 "Extended Support" extended til..... when?
by Vigneswar Battu
17/05/12 10:59 AM
Hacking element definitions
by CT
15/05/12 08:42 AM
GB EOY reports
by Vigneswar Battu
09/05/12 02:07 PM
Oracle Payroll and Cash Management
by Vigneswar Battu
08/05/12 03:08 PM
BG setup/changes - brain dump
by Ryan
05/05/12 07:20 PM
Fusion Collateral
by CT
04/05/12 11:09 AM
BEE - ordering Batch lines
by Vigneswar Battu
03/05/12 04:22 PM
Top Posters (30 Days)
delboy 37
CT 35
Vigneswar Battu 15
pat.woodall 9
bcooper 4
Mani 3
7Giri 3
Gus 3
Ryan 3
SBi 2
(Views)Popular Topics
Family Pack K issues thread 20107
CREATE_GRADE api returns:PLS-00306: wrong number o 15174
Still trying to locate... 13817
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 11848
Viewing Output of another user 10266
HR_PF.K RUP4 10240
Review of my Release 12 laptop 9703
Enhanced Retro & Release 12 9375
Adding a taskflow button to a form 9111
Family Pack K 7882
Topic Options
Rate This Topic
#2253 - 07/09/06 09:59 AM Balance Initialisation dates
cjvanvuuren Offline
enthusiast

Registered: 18/03/05
Posts: 38
Loc: Cape Town
Problem:
Our techie friends here want to do the following for balance initialisations:
For uploading the YTD Payroll Balances the upload date is, for example, 31 Aug 2006, but the upload date is being defaulted in Oracle to 25 Apr 2006 which is the normal payment date for the month of April. Is this correct or should the date be 5/6 April of the current tax year.
Any help would be great.

Top
#2254 - 07/09/06 09:26 PM Re: Balance Initialisation dates [Re: cjvanvuuren]
CT Offline
Guru
***

Registered: 11/03/05
Posts: 1182
Loc: Bath
Hello Colette

Logically the upload date ought to reflect the end of the pay period of the last payroll run on the legacy system whence balances were extracted.

E.g. if your last legacy payroll was August 2006, then the upload date would reasonably be 31-Aug-2006. I seem to recall we had issues at that well-known guardian of the nation's healthcare, where one of their payrolls had (has?) an offset. We had to do some kind of monkeying about with that one - perhaps young Baz might care to comment further...

Anyways, back to the issue. The upload date supplied is really only a guide to the Initial Balance Upload process - in fact it takes a whole host of things into account before coming up with the actual effective date of the BI payroll action. For statutory balances (ie with the _ASG_TD_YTD dimension) it will more than likely end up being the end of the pay period for the first period in the tax year to which the upload date pertains. Still with me? No? OK then. For an _ASG_ITD dimension however, the date will end up being the earliest date at which the assignment is on the payroll to which the balace header relates. Which could be quite a while ago!

Whichever date the process decides to use, you should still be able to see the loaded balances as at the next period in Oracle (September 2006 in our example) by picking an employee then navigating to Assignment->Others->Balance (I think)

Edited to add:
If you look at the first page of posts in the 'Data Migration' forum, you'll see a thread entitled "CT's Handy Hints for Migrating Balances". There's an attachment on there which is probably overdue for an upgrade, but even so may give a few useful pointers.


Edited by CT (07/09/06 09:44 PM)
_________________________
L&K
CT

Remember: A dog is for life, not just for Christmas... unless you're in Korea

Top



Moderator:  bcooper, CT 
Forum Stats
790 Members
48 Forums
1580 Topics
7641 Posts

Max Online: 67 @ 14/04/12 05:38 PM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
CT 1182
bcooper 1112
delboy 594
Geoff Dixon 369
SBi 356
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 163
Gus 145
May
Su M Tu W Th F Sa
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 31