Home » Applications » Oracle Fusion Apps & E-Business Suite » How to create Employee Work Schedule in Oracle HRMS (Oracle EBS HRMS R12)
How to create Employee Work Schedule in Oracle HRMS [message #615382] Tue, 03 June 2014 01:03 Go to next message
veenadshinde@gmail.com
Messages: 5
Registered: June 2014
Location: Hyderabad
Junior Member
Hi All,

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:

INSERT
INTO CAC_SR_SCHDL_OBJECTS
VALUES
(
objectSequenceNumber,
l_schedule_id,
'PERSON_ASSIGNMENT',
i.assignment_id,
start_date,
end_date,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.login_id,
NULL,
NULL
);


-- CAC_SR_SCHDL_DETAILS
cac_avlblty_pvt.POPULATE_OBJECT_SCHDL_DETAILS ( l_schedule_id,objectSequenceNumber,start_date,end_date,NULL );

INSERT
INTO CAC_SR_PUBLISH_SCHEDULES
VALUES
( CAC_SR_PUBLISH_SCHEDULES_S.nextval
, 'PERSON_ASSIGNMENT'
, i.assignment_id
, l_schedule_id
, start_date
, end_date
, fnd_global.user_id
, sysdate
, fnd_global.user_id
, sysdate
, fnd_global.login_id
);

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,
Thanks,
VS
Re: How to create Employee Work Schedule in Oracle HRMS [message #615793 is a reply to message #615382] Mon, 09 June 2014 05:54 Go to previous message
veenadshinde@gmail.com
Messages: 5
Registered: June 2014
Location: Hyderabad
Junior Member
I got the reply from OracleSR that there doesnt exists any such API/Interface for EWS data creation. there is an ER running already for same in MY Oracle Support.
So I finally resorted to using idrect inserts,

Thanks,
Veena Shinde
Previous Topic: How can i hide the Action History section in a Customised workflow
Next Topic: table type in value set
Goto Forum:
  


Current Time: Thu Mar 28 04:39:19 CDT 2024