Who's Online
0 registered (), 11 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Search Engine Optimizers
by delboy
Today at 09:09 AM
Function for getting retropay-maintained balances
by delboy
Yesterday at 02:20 PM
Abseces in oracle hrms, super user: how to do I:
by tovia123
04/02/12 09:33 PM
Grade End Date
by Chris
03/02/12 10:46 AM
OLM Mandatory Enrolments
by bcooper
01/02/12 12:23 PM
Retro-Notifs Report missing some ele entries
by CT
01/02/12 06:51 AM
P45 as PDF's
by SBi
30/01/12 11:58 AM
Employer Charges element in SOE
by Sachin
30/01/12 11:31 AM
Skinning SSHR?
by Duncan Casemore
28/01/12 10:49 AM
Time and Labour & Oracle Projects
by SBi
27/01/12 02:23 PM
Top Posters (30 Days)
delboy 24
CT 24
bcooper 17
Gus 14
paulgos 10
christm 5
Sahir 4
Simon_Mc 3
Tim Bailey 3
tovia123 3
(Views)Popular Topics
Family Pack K issues thread 18126
CREATE_GRADE api returns:PLS-00306: wrong number o 13685
Still trying to locate... 12118
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 10583
Viewing Output of another user 9062
HR_PF.K RUP4 8783
Review of my Release 12 laptop 8453
Adding a taskflow button to a form 7807
Enhanced Retro & Release 12 7597
Family Pack K 7068
Page 2 of 3 < 1 2 3 >
Topic Options
Rate This Topic
#4536 - 05/06/09 07:58 AM Re: Custom Function issue in Fast Formula [Re: JayTee]
JayTee Offline
enthusiast

Registered: 30/11/05
Posts: 32
I am thinking that when Retropay by Element is run, it does something to the payroll tables which affects the run result data (for the periods which Retropay is running) and thus invalidates my SQL query (above). It may just be that a small tweak is required to the code.

Top
#4537 - 05/06/09 08:00 AM Re: Custom Function issue in Fast Formula [Re: JayTee]
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 344
Loc: UK
did you try passing diff dates for c_end_date?? using PLSQL

Top
#4538 - 05/06/09 08:08 AM Re: Custom Function issue in Fast Formula [Re: SBi]
JayTee Offline
enthusiast

Registered: 30/11/05
Posts: 32
Yes I've tried that and the function works consistently through pl/sql. I've even tried hard-coding the dates in the formula but still have the problem with Retropay.

Top
#4540 - 05/06/09 08:18 AM Re: Custom Function issue in Fast Formula [Re: JayTee]
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 344
Loc: UK
try deleting/creating new holidy entry to check whether any changes to retro..

Top
#4541 - 05/06/09 08:45 AM Re: Custom Function issue in Fast Formula [Re: SBi]
JayTee Offline
enthusiast

Registered: 30/11/05
Posts: 32
Already tried that! I have also tried different employees, in case it was a data issue against a particular employee but the issue is across all employees. I am going to raise an SR with Oracle, but I don't anticipate much help as it is custom code!

Top
#4545 - 08/06/09 11:57 AM Re: Custom Function issue in Fast Formula [Re: JayTee]
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 344
Loc: UK
any luck? did you get it working?

Top
#4547 - 08/06/09 01:05 PM Re: Custom Function issue in Fast Formula [Re: SBi]
JayTee Offline
enthusiast

Registered: 30/11/05
Posts: 32
Not yet - got an OWC with Oracle today.

Top
#4597 - 24/06/09 08:02 AM Re: Custom Function issue in Fast Formula [Re: JayTee]
JayTee Offline
enthusiast

Registered: 30/11/05
Posts: 32
Just to let you know this seems to be a bug - I managed to replicate the issue with the seeded function pay_balance_pkg.get_value.

Oracle Development are currently investigating...

Top
#4600 - 24/06/09 03:19 PM Re: Custom Function issue in Fast Formula [Re: JayTee]
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 344
Loc: UK
ohhh surprising..

Top
#4695 - 27/07/09 08:22 AM Re: Custom Function issue in Fast Formula [Re: SBi]
JayTee Offline
enthusiast

Registered: 30/11/05
Posts: 32
Just to let you know, this issue was resolved by creating the function as an autonomous transaction...

Top
Page 2 of 3 < 1 2 3 >



Moderator:  CT, delboy 
Forum Stats
754 Members
48 Forums
1514 Topics
7262 Posts

Max Online: 63 @ 24/11/10 07:21 AM
Today's Birthdays
No Birthdays
Recent vacancies
Tea boy available 4 basic chores & some! services
by Simon_Mc
19/01/12 03:59 PM
Top Posters
bcooper 1094
CT 1073
delboy 493
Geoff Dixon 369
SBi 344
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 160
Gus 132
February
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