Hi,

One of consultants previosuly setup some deduction elements with Post Termination rule as 'Final Close'.

Because of that deductions are processed even after the employees termination dates (upto final close as date mentioned in the Termination details).

Now we want the element post termination rule to be changed to 'Last Standard Process'. (Note : These deduction elements have already processed by payroll run)

How can we change/update the post termination Rule of the existing element?

OR

Do we need to re-create the whole setups with correct post termination rule?


Please do advice.

Thanks in Advance
KP/..

Any ideas.......

Hi KP

We have hit this many many times during the last year or so on the NHS project.

We have "a script" that amends the termination rule against the element definition.
In the stictest sense, this is not a supported option in the eyes of Oracle, however we have not encountered any issues whatsoever with doing this. Given the complexity and volume of payroll processing that goes on here i am confident that if there were any issues we would have hit them by now.

If you do go down the script route you will need to set the HR_GENERAL.G_DATA_MIGRATOR_MODE flag to 'Y' so that certain core triggers are disabled (otherwise you will not be able to update the termination rule).

Hope this helps.

B

Hi,

thanks for advice, I have prepared the following script to change the element termination rule from 'Final Close' to 'Last Stadrd'

==

SET VERIFY OFF;
WHENEVER OSERROR EXIT FAILURE ROLLBACK;
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;

alter trigger PAY_ELEMENT_TYPES_T1 disable;

update pay_element_types_f
set POST_TERMINATION_RULE ='L'
where ELEMENT_NAME =<<'***Element Name****'>>
and POST_TERMINATION_RULE ='F';

alter trigger PAY_ELEMENT_TYPES_T1 enable;


==

I belive this script will not cause any other problems.


Cheers
KP/.

Sharp intake of breath!!!!

As a payroll funkie, not a method I would encourage but I bow to Barry's superior knowledge.

Anyhow, not being a sql expert doesn't your script update every element from Final Close to Last Standard Process? Surely, you have some elements you want to remain as Final Close?

Delboy

Good spot Del

By the way KP - our script is within PL/SQL - we check the current setting first and only update if needed.
Also, rather than disabling specific triggers we set the g_data_migrator flag.
If you disable the trigger and other users are on the system then you have the possibility of another users action going through with the trigger not set!!!

By embedding the lot within pls and setting the flag you control it all at session level.

Regards

Barry

I have copied this script from one of Oracle's patch.

Don't know how they have given this script.

Hi ,


The termination rule on about 300 of are elements have been set up with the wrong termination rule. I have come across this thread were some of you have managed to overcome the problem without having to recreate element. Can you please advice on how to go about it. I have limited technical knowledge.

I will appreciate if you can share your script and experiences with me.

Thanks in advance
Alero

It is possible to do this through the front end using Help -> Diagnostics -> Examine.

This uses the API to update a specific Element.

Hi,

I have tried updating the termination rule on one the element from last standard process to Final Close via Help ->

Diagnostics -> Examine.
When I try to save the record a message is displayed.
APP-PAY-060909: Processing fields cannot be updated if run results exist.

I guess the only alternative is to update via the pl/sql script.

I will also like to know if anyone has experienced any problems later after updating termination rules on element definition via a PL/SQL script ?


Thanks in advance
Alero