Who's Online
1 registered (CT), 10 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Concurrent Request - running slow
by CT
Today at 11:16 AM
Element to recover value in balance on leaving
by jkavia
Today at 11:04 AM
P11d's
by jkavia
Today at 10:49 AM
Assignment EIT not displaying in Self Service
by CT
Today at 06:45 AM
Vehicle Mileage Setup
by Chris Abraham
Yesterday at 12:24 PM
In which table is external learning data stored
by DMC
Yesterday at 08:45 AM
Oracle Payroll and Cash Management
by Gus
20/05/12 11:27 AM
Pension Auto Enrolment
by CT
18/05/12 09:46 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
Top Posters (30 Days)
CT 38
delboy 36
Vigneswar Battu 15
pat.woodall 9
bcooper 4
Gus 4
DMC 3
Mani 3
7Giri 3
Ryan 3
(Views)Popular Topics
Family Pack K issues thread 20153
CREATE_GRADE api returns:PLS-00306: wrong number o 15194
Still trying to locate... 13844
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 11889
Viewing Output of another user 10307
HR_PF.K RUP4 10271
Review of my Release 12 laptop 9733
Enhanced Retro & Release 12 9397
Adding a taskflow button to a form 9129
Family Pack K 7906
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#4554 - 10/06/09 04:25 PM DFF Reference Field and ESS
ClanGowland Offline
warming-up

Registered: 10/04/07
Posts: 18
Loc: Surrey, England
Hi All

Firstly, I have checked this on metalink and Oracle say it's not possible so if no-one has an answer no probs, but then i always see "It's not possible" as "I challenge ye!" so here we go...

We want to add a DFF Segment for "Working pattern" to the ESS absence screen that does two things:

1. Displays/does not display based on the absence type being entered
2. Does not display for certain areas of the globe/different Business Groups

Where I have got to is to create the DFF for working pattern, populate the list dynamically with the working patterns in the system etc but I can only get it to appear on the ESS screen if I add it to the "Global Data Elements" Context field value of the DFF. This means folks in other countries around the world can also see it and those same folks don't need it and sure as hell don't want it (especially as it will cause them problems in the PUI as it is a mandatory field). Also it means it will display for all absence types.

If I add it to one of the other Context Field Values that link to the absence types themselves it displays in the PUI accordingly (depending on the absence type), but not at all in the ESS.

From what I see from Oracle, they state it is because we are using a reference field within the context field of the DFF (which apparently they do not support...). Long story short, lets just say we NEED to keep this reference field in there.

Does anyone know of a way (without a HUGE, UNSUPPORTED customisation) we can arrange for this extra segment to appear on the ESS without it appearing for all global users, and (preferably) based on the context of the absence type?

I'm not asking for much am I?! laugh

Many thanks
Craig
_________________________
Anyone who believes in telekinesis, raise my hand

Top
#4555 - 10/06/09 06:00 PM Re: DFF Reference Field and ESS [Re: ClanGowland]
PeterP Online   sad
hacker
*****

Registered: 08/03/07
Posts: 94
Loc: Manchester, UK
Hello,

This is a bit of a work-around, and as I haven't tried it myself, may not work (I know it will in PUI, but not certain about SS).

Rather than Reference field based, try using two segments along the following lines ...

Segment(X) is table based and mandatory. It's based on the PER_BUSINESS_GROUPS view, and has a WHERE clause that ensures the Users business group is the only valid value based on the Business Group profile option. The BG Id or Name is defaulted using an SQL default.

Segment(Y) (the Working Pattern segment) is also table based and mandatory. It's based on a LookUp, or whatever table has the valid Working Pattern list, with an added value of "N/A". The WHERE clause looks at the previous segment, and if it's a BG that needs a Working Pattern, then excludes the "N/A" value, and if not, include the "N/A" as the ONLY valid value. Then a value is defaulted also based on the value of Segment(X) (the BG). If the BG is one that you DON'T need a Working Pattern for, the the defaulted value is "N/A". Hence the Working Pattern segment is mandatory for all cases, but only has a REAL value for BG's where it's applicable.

Hope this makes sense.

Regards,

Peter.

Top
#4558 - 11/06/09 09:25 AM Re: DFF Reference Field and ESS [Re: PeterP]
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 356
Loc: UK
There are 2 DFFs on the ESS LOA screen.
1. Add Absence details
2. Further Absence details - called as "Additional Absence Detail Information"

I have used Further Absence details to show/hide segments.
Now the reference for this DFF is "C_LEGISLATION_CODE" but this is infact made up of <leg code>_<absence category code> (
Mind you that this is based on "Absence category" and not "absence type" )

So if you have a Annual Leave for then you can define your own structure for "UK_AL" and define the segments..
then when you select the absence type (which internally defaults absence category) the segments will be displayed..

Top
#4563 - 12/06/09 02:12 PM Re: DFF Reference Field and ESS [Re: SBi]
ClanGowland Offline
warming-up

Registered: 10/04/07
Posts: 18
Loc: Surrey, England
Hi

Thanks for the proposed solutions. Shiva, I have tried yours and it is now working in ESS so that's awesome - thanks very much!

The only issue we have now is that in the PUI the further information is not accepting input directly - only when it comes from ESS can you click in the further information field to open up the applicable segments.

It seems when I check the diagnostics on the PUI, the C_LEGISLATION_CODE is showing only as 'GB' (even after selecting an absence type (and therefore category) this does not change to 'GB_xx' where xx is the category code).

Have you come across anything like this when you were configuring?

Many thanks
Craig
_________________________
Anyone who believes in telekinesis, raise my hand

Top
#4567 - 12/06/09 03:06 PM Re: DFF Reference Field and ESS [Re: ClanGowland]
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 356
Loc: UK
what is the absence category for the absence type?

Top
#4568 - 12/06/09 03:06 PM Re: DFF Reference Field and ESS [Re: SBi]
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 356
Loc: UK
you will find it on absence type definition screen

Top
#4571 - 12/06/09 03:54 PM Re: DFF Reference Field and ESS [Re: SBi]
ClanGowland Offline
warming-up

Registered: 10/04/07
Posts: 18
Loc: Surrey, England
Hi Shiva

The Absence Category is Vacation, the absence type is Annual Leave and the Absence Category Code is 'V'.

We have therefore set up a new segment for context field 'GB_V' which we would expect to work in the PUI the same as it is now (thanks to your solution) in ESS.

Now, when we enter 'Annual Leave' into the Absence PUI, the category gets populated with Vacation (as expected), but the C_LEGISLATION_CODE (per the diagnostics) is still showing as only 'GB'. This means the additional segments for the 'GB_V' are not showing. If I check an absence of Annual Leave that has come through from ESS, the C_LEGISLATION_CODE is correctly showing as 'GB_V', and therefore the additional segments can be viewed/edited.

I'm thinking maybe (a) it's a bug; or (b) we need to personalise the form to refresh once a user enters an absence type to (possibly) refresh the C_LEGISLATION_CODE value?

Many thanks
Craig
_________________________
Anyone who believes in telekinesis, raise my hand

Top
#4573 - 15/06/09 09:26 AM Re: DFF Reference Field and ESS [Re: ClanGowland]
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 356
Loc: UK
create a new absence category in the lookup "ABSENCE_CATEGORY" and try..

Top
#4594 - 22/06/09 12:46 PM Re: DFF Reference Field and ESS [Re: SBi]
ClanGowland Offline
warming-up

Registered: 10/04/07
Posts: 18
Loc: Surrey, England
Hi Shiva

Apologies for the delay in coming back to you - we managed to get it working in the end using a workaround of sorts. In the PUI we have made all the various fields available but made those that are specific to an absence type non-mandatory.

In the ESS we have attached the various fields to the absence categories as necessary but made them mandatory.

Many thanks for your help
Craig
_________________________
Anyone who believes in telekinesis, raise my hand

Top
#4595 - 22/06/09 02:46 PM Re: DFF Reference Field and ESS [Re: ClanGowland]
SBi Offline
sitting tennant

Registered: 23/05/08
Posts: 356
Loc: UK
Ok. No worries.

Top
#6486 - 26/03/11 01:14 PM Re: DFF Reference Field and ESS [Re: ClanGowland]
sairajesh Offline
passing stranger

Registered: 26/03/11
Posts: 1
Hi Craig,

I have the same requirement like based on absence category/absence type I need to display Dff segments
however I followed the steps mentioned by you and Shiva,its not working for Global HRMS
May be for UK GB_V was working for you but same is not working for global HRMS

Top
#6883 - 08/09/11 12:22 PM Re: DFF Reference Field and ESS [Re: ClanGowland]
MichaelWest Offline
stranger

Registered: 08/09/11
Posts: 4
Hi all,

Bit late, but I have had the same issue with the C_LEGISLATION_CODE - GB_V only working in SSHR and not in Core Forms, so I thought I'd post a solution.

For Craig [ClanGowland] and sairajesh, and anyone else experiencing this issue, the way round this is a Forms Personalization to set the appropriate C_LEGISLATION_CODE in Core Forms.


Set up the "Additional Absence Detail Information" [PER_ABS_DEVELOPER_DF] DFF with a new Context code e.g. GB_V

GB_V GB Vacation
10 Part Day Indicator ABS_INFORMATION1 XX_YES_NO


In the SSHR create/update pages, you can personalize the Flex: "Further Absence Details" item with your segment list:

GB_V|Part Day Indicator


Next time a vacation is chosen in SSHR, your custom segment will appear.


In Core HRMS however, when entering a Vacancy, you will find via Diagnostics > Proprties > Item > that your C_LEGISLATION_CODE remains unchanged.
[depending on your system setup you will find the context of 'GB' or 'GB_PQP_OSP_OMP_PART_DAYS' appears]

In order to amend this do a Forms Personalization on the absence form that checks for the absence category and then automatically sets the legislation code.

10 Set C_LEGISLATION_CODE context for Vacation Form
CONDITION
Trigger Event WHEN-NEW-ITEM-INSTANCE
Trigger Object ABA.C_REASON_DESC
Condition :ABA.ABSENCE_CATEGORY = 'V'
ACTIONS
10 Property
Object Type Property
Target Object ABA.C_LEGISLATION_CODE
Property Name VALUE
Value GB_V

Note: You may notice that this is based on someone changing the 'absence reason' on the form rather than the type. I could not get it to work using type or category, but this one will work effectively enough anyway.

Close the absence form and re-open it.

Now any new vacation will trigger the setting of the C_LEGISLATION_CODE to GB_V and your pop-up for Further Information will show your custom segments.


This could be repeated for each absence category per business group. Or you could remove the condition and use =:CTL_GLOBALS.LEGISLATION_CODE||'_'||:ABA.ABSENCE_CATEGORY as the property value to set it in all instances.


Regards

Mike

Top
#6885 - 08/09/11 01:46 PM Re: DFF Reference Field and ESS [Re: ClanGowland]
bcooper Offline

Guru
*****

Registered: 11/03/05
Posts: 1112
Loc: Earth, Europe, England, here
Hi Mike

Thank you for taking the time to provide a detailed and useful response.

Regards

Barry
_________________________
HCM Aces is for sale! Please contact me if you are interested.
Also my random musings courtesy of Twitter

Top
Page 1 of 2 1 2 >



Moderator:  Administrator, Geoff Dixon 
Forum Stats
791 Members
48 Forums
1582 Topics
7651 Posts

Max Online: 67 @ 14/04/12 05:38 PM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
CT 1185
bcooper 1112
delboy 594
Geoff Dixon 369
SBi 356
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 163
Gus 146
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