|How to create Employee Work Schedule in Oracle HRMS [message #615382]
||Tue, 03 June 2014 01:03
Registered: June 2014
I am new to creating Employee Work Schedule (EWS) in oracle HRMS. My Requirement is that the rooster data will be provided from legacy in csv files and I will have to design an interface for creating this data in Application as EWS.
I could find out that there are 03 tables which maintain the data for EWS of an employee as :
CAC_SR_SCHDL_OBJECTS -- contain assigment ID for a person
CAC_SR_PUBLISH_SCHEDULES - populated if the schedule is published
CAC_SR_SCHDL_DETAILS -- Contains the period details for the schedule created.
However, I couldn't find API/Interface to create/insert data into these tables. Also, I had come across following code on OTN while searching:
cac_avlblty_pvt.POPULATE_OBJECT_SCHDL_DETAILS ( l_schedule_id,objectSequenceNumber,start_date,end_date,NULL );
Can we directly insert the data into tables : CAC_SR_SCHDL_OBJECTS, CAC_SR_PUBLISH_SCHEDULES as shown above. I am doubtful over the direct insert into base tables using insert queries.
Summarizing, I have two queries :
1. Are there any APIs/Interfaces for EWS data creation which I might have missed?
2. Can the above mentioned sample code be used?
Please let me know in case further details needed.
Appreciate your quick response,