The task time taken should not include the Holidays. It should only consider Working Hours to calculate the time taken.
First, we need to know where we can feed in the working hours, holidays in Siebel.
Question: Do we have something OOTB?
Answer: Yes, we have got a View based on Shift BC using view Administration Service->Schedules
Question: Where can we put the Holidays?
Answer: Administration Service -> Schedules -> Exception Hours
Question: Do we need a customize BS to calculate the Time difference considering working hours only?
Answer: Yes we have got a OOTB BS 'FS Holiday API Service', that gives output as Elapsed Time using input as Start Time, End Time, Time Unit, Calender Id(Schedule Id)
FS Holiday API Service BS provides 3 methods:
- GetElapsedBusinessTime
- GetResponseTime
- IsHoliday
You can provide input argument as below:
- Calender Id : Id of the New Schedule
- End Time: 02/06/2009 12:54:28
- Schedule Time Zone:
- Start Time: 04/06/2009 10:54:28
- Time Unit: Hours
Sharing is the Power.
Posts
Hey excellent post Ankit...thanks for sharing
ReplyDeleteHi Ankit,
ReplyDeletethis business service is supported in 8.x version. But currently i am using 7.8. Can you help me i am stuck up, if i write the code then it will have huge performance impact on system because going through lot of looping.
This is a class based BS, so I don't have the code written behind that. You can also check for 'FS Verify Entitlement' if its available in 7.8
ReplyDeleteBasically, the whole Service Hours functionality is related to Field Service Guide.
I can only email the xml of this BS. You can import and check if it works for you. Whats your email address?
my id is md.ameen.uddin@gmail.com - can you please explain how i can use this BS for calculating service hours
ReplyDeletehttp://docs.google.com/leaf?id=0B1v-AxHpsRalZGM5MDAxNjMtZGExMi00MTVmLWJhNTgtY2I5ZWZiNGVlNWI5&hl=en
ReplyDeleteUsing the link above, download the zip file, Import the SIF for Class Object and Import the XML for BS and and save the dll into \Client\BIN folder. For Detail use, pl see the pdf for field Service 8.1 Bookshelf or contact Oracle.
ReplyDeleteGuys, is it possible to enter this in 7.5.2 version? We have a requirement to calculate the Appointment Start Date and end date based on SLA information and send to service power application.
ReplyDeleteI think the BS is not available in Siebel 7.x version. You may need to write your own custome BS.
ReplyDeleteBrilliant.. saved my day.. thanks a lot!
ReplyDeleteFantastic... crystal clear
ReplyDeletethank you... saved my time.
ReplyDelete