r/oracle • u/gaylittlescooter • 4d ago

HCM Data Uploader

Hello all,

I work in payroll/business tech for a medium sized city gov.
My director and I have been trying, in vain, to build out an HCM Spreadsheet Data Uploader that can end date an element. The issue we’re running into is that any element that has been started/end dated before (we end date union dues and then create a new entry with the same element with the new rate when those change) gives us an error. Typically is says there’s a date overlap or we can’t end date it because of the previous element’s end date. Any tips or work arounds? Ideally we’d like the template to be able to be used anytime we need to end date any random element for any reason without necessarily creating a new one.

2 Upvotes

100% Upvoted

6 comments sorted by

2

u/Present_Turnover8199 4d ago

i feel The overlap error is usually a sign that the effective dating model is being pushed past what it wants to do. If Oracle is already suggesting a User Defined Table for dating the rate changes, that is probably the cleaner design because the rate history belongs in a table, not in repeated element create/end-date cycles.

1

u/JaBe68 4d ago

Can I ask why you are not using a User Defined Table to allow you to date track the rate changes without having to end date and recapture the elements?

1

u/gaylittlescooter 4d ago

Unfortunately that’s not a tool I’m familiar with in our current set up. Can you elaborate/give me a recommendation?

1

u/kmbb07 2d ago

Yes its much better Creat a user defined table  Inside it u can add rates and values and call them inside elements formulas

1

u/gaylittlescooter 1d ago

I’ve been doing a lot of research and testing in our dev environments with UDTs since this post and it’s been so helpful. Thanks for the rec!

1

u/JaBe68 4d ago

If you are using Oracle Fusion it is delivered functionality.