Cannot set the element start date to 01-JAN-0001

When you enter the balance initialization element, you cannot set the start date to 01-JAN-0001. There are 4 tables which must be in sync with each other. These tables are :

• PAY_ELEMENT_TYPES_F
• PAY_INPUT_VALUES_F
• PAY_ELEMENT_LINKS_F
• PAY_LINK_INPUT_VALUES_F

 The only way that this can currently be done is in SQL*Plus. The following is a suggested script which can be used to update the start dates of the elements :

select element_type_id, effective_start_date
from pay_element_types_F
where element_name = &Element_Name

update pay_element_types_f
set effective_start_date = to_date('01-Jan-0001','dd-mon-yyyy')
where element_type_id = &&Element_Type_ID

Commit;


update pay_input_values_f
set effective_start_date = to_date('01-Jan-0001','dd-mon-yyyy')
where element_type_id = &&Element_Type_ID

Commit;


update pay_element_links_f
set effective_start_date = to_date('01-Jan-0001','dd-mon-yyyy')
where element_type_id = &&Element_Type_ID

Commit;


Select element_link_id
from pay_element_links_f
where element_type_id = &&Element_Type_ID

Commit;


update pay_link_input_values_f
set effective_start_date = to_date('01-Jan-0001','dd-mon-yyyy')
where element_link_id = &Element_Link_ID

Commit;

The Pay_Assignment_Link_Usages_F table will also need to be update if using People Group.

ORA-01403 : No data found

Leave a comment for any query.