Who's Online Now
1 registered members (delboy), 5 guests, and 10 spiders.
Key: Admin, Global Mod, Mod
Newest Members
rdeshab, samba, kkshahbaaz, dpf6jbez9, hcmconfig
1293 Registered Users
Recent Posts
Help > Diagnostics > Examine
by delboy. 21/11/19 01:32 PM
Top Posters(30 Days)
delboy 2
CT 1
Popular Topics(Views)
487,403 PAYE RTI
58,755 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#5988 - 03/11/10 03:54 PM P45 Problem  
Joined: Sep 2005
Posts: 41
AlexChard Offline
enthusiast
AlexChard  Offline
enthusiast

Joined: Sep 2005
Posts: 41
Leamington Spa
Hi all

I've got a lovely P45 problem that I'm struggling with.

The P45PT1 process (P45PT1 EDI Process V6) has failed, but the log only gives this information:

Assignment NI Number Name / Error message
---------- --------- ----------------------------------------------------------

,

The Address Line 1 of the assignment is missing.
The Address Line 2 of the assignment is missing.
The Last Name of the assignment is missing.
The First Name of the assignment is missing.
The Gender of the assignment is missing.
The Date of Birth of the assignment is missing.
The Tax Code at Leaving Date of the assignment is missing.

As you can see, it looks like it's picked up a phantom record.

As this concurrent program is a spawned program, I'm struggling to find anything that will give me a hint as to where the records are selected from.
I've had a look at the PAY_P45_PKG, but that didn't make much sense to me.

If anyone can provide a pointer as to what the cursors are that select this data, it would be greatly appreciated.

Thanks

Alex

#5991 - 04/11/10 02:13 AM Re: P45 Problem [Re: AlexChard]  
Joined: Mar 2005
Posts: 436
paulgos Offline
battle-hardened campaigner
paulgos  Offline
battle-hardened campaigner
****

Joined: Mar 2005
Posts: 436
Gosport
Alex,

Have you looked under the Payroll Process Results form for this process? This should detail all the employees picked up within this run.

Just a thought

cheers



Paul

#5992 - 04/11/10 02:27 AM Re: P45 Problem [Re: paulgos]  
Joined: Mar 2005
Posts: 436
paulgos Offline
battle-hardened campaigner
paulgos  Offline
battle-hardened campaigner
****

Joined: Mar 2005
Posts: 436
Gosport
Something else to be aware of is when you have found the people in error and you've corrected them you'll have to either mark them for retry or remove them for the original run. I had issues like this all the time on a previous contract and even though they are in a status of error you can't just amend and retry.

Cheers



Paul

#5994 - 04/11/10 06:16 AM Re: P45 Problem [Re: paulgos]  
Joined: Mar 2005
Posts: 1,301
delboy Online content
The Grand Daddy
delboy  Online Content
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,301
Somewhere in South of England
The log should tell you the number of the offending assignment.

Delboy

#5998 - 04/11/10 06:48 AM Re: P45 Problem [Re: delboy]  
Joined: Mar 2005
Posts: 436
paulgos Offline
battle-hardened campaigner
paulgos  Offline
battle-hardened campaigner
****

Joined: Mar 2005
Posts: 436
Gosport
That is should Del but there is a bug which, like Alex is seeing, it doesn't show you who they are.

Paul

#5999 - 04/11/10 07:41 AM Re: P45 Problem [Re: paulgos]  
Joined: Mar 2005
Posts: 2,108
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,108
If there is a payroll action for this process, then there should be assignment actions for every assignment it processed under that payroll action. Somewhere in there is an assignment action which was in error - find that through the View Payroll Processes screen , then the assignment action id will lead you to the assignment id. Then a bit of sql to find the parent person record, should see you on your way.


CT
#6000 - 04/11/10 07:53 AM Re: P45 Problem [Re: CT]  
Joined: Sep 2005
Posts: 41
AlexChard Offline
enthusiast
AlexChard  Offline
enthusiast

Joined: Sep 2005
Posts: 41
Leamington Spa
Thanks for all the suggestions guys.

And hi Paul, long time no speak. smile


Oracle EBS Contractor
#6001 - 04/11/10 08:02 AM Re: P45 Problem [Re: AlexChard]  
Joined: Mar 2005
Posts: 436
paulgos Offline
battle-hardened campaigner
paulgos  Offline
battle-hardened campaigner
****

Joined: Mar 2005
Posts: 436
Gosport
Hi Alex,

It has been a while :-)

If you look at the Payroll Process Form you should be able to find your erroring employees. Like I say, make the changes to those employees and then mark them ALL for retry. If you only mark one of them then thats the only one that will be corrected. One of those many Oracle features :-)

Good luck


Paul

#6002 - 04/11/10 08:57 AM Re: P45 Problem [Re: AlexChard]  
Joined: Sep 2005
Posts: 41
AlexChard Offline
enthusiast
AlexChard  Offline
enthusiast

Joined: Sep 2005
Posts: 41
Leamington Spa
Sorted, thanks for all the help, guys. I used one of the other assignments that hadn't errored to track down the payroll action. The reason I was struggling so much is it was in the following week to what I expected.


Oracle EBS Contractor
#6003 - 04/11/10 09:50 AM Re: P45 Problem [Re: AlexChard]  
Joined: Mar 2005
Posts: 436
paulgos Offline
battle-hardened campaigner
paulgos  Offline
battle-hardened campaigner
****

Joined: Mar 2005
Posts: 436
Gosport
There you go :-) There is always a reason :-)


Moderated by  CT, delboy 

Forum Statistics
Forums60
Topics2,225
Posts12,010
Members1,293
Most Online195
Nov 16th, 2019
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,108
delboy 1,301
bcooper 1,291
paulgos 436
SBi 426
pat 254
Gus 252
vkumar 223
November
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.038s Queries: 16 (0.006s) Memory: 2.8065 MB (Peak: 3.0073 MB) Zlib disabled. Server Time: 2019-11-21 18:10:52 UTC