This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi All
I am using Maximo 7.2.1 with Service Provider. I have escalation which scheduled to runs every day once to close the Service Requests with Status 'ACCEPT' for 3 business days (72 Hours) which is working fine. The issue is We must exclude weekends and close service requests after 3 business day and exclude weekends (Saturday and Sunday).
Please help to resolve this issue.
I have used the below condition and it works in Escalation itself but still not reached the exact requirement.
Escalation Schedule:
1 day
Condition:
status='ACCEPT' AND TO_CHAR (statusdate, 'DY', 'NLS_DATE_LANGUAGE=ENGLISH') NOT IN ('SAT', 'SUN')
Escalation point and Elapsed time Interval:
Statusdate - 3 days
SR's not getting closed on Saturday and Sunday's. However there is an issue, Lets say the SR status moved to ACCEPT on Friday 2:00 PM it should calculate 2 days(exclude Saturday and Sunday) the SR to be closed on Tuesday 2:00 PM but the record get closed on Monday morning 5:00 AM. Since the Crontask scheduled to run on everyday morning 5:00 AM.
Please help.
Regards
GM
How about
Statusdate - Decode (TO_CHAR (statusdate, 'DY', 'NLS_DATE_LANGUAGE=ENGLISH'),’FRI’,5,3)
You might have to return ‘5’,’3’ and to_number the result I havn’t got an instance of oracle on my site so can’t test
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of murugovind@gmail.com
Sent: 12 December 2013 18:14
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Escalations for Excluding weekends
Hi All
I am using Maximo 7.2.1 with Service Provider. I have escalation which scheduled to runs every day once to close the Service Requests with Status 'ACCEPT' for 3 business days (72 Hours) which is working fine. The issue is We must exclude weekends and close service requests after 3 business day and exclude weekends (Saturday and Sunday).
Please help to resolve this issue.
I have used the below condition and it works in Escalation itself but still not reached the exact requirement.
Escalation Schedule:
1 day
Condition:
status='ACCEPT' AND TO_CHAR (statusdate, 'DY', 'NLS_DATE_LANGUAGE=ENGLISH') NOT IN ('SAT', 'SUN')
Escalation point and Elapsed time Interval:
Statusdate - 3 days
SR's not getting closed on Saturday and Sunday's. However there is an issue, Lets say the SR status moved to ACCEPT on Friday 2:00 PM it ! should calculate 2 days(exclude Saturday and Sunday) the SR to be closed on Tuesday 2:00 PM but the record get closed on Monday morning 5:00 AM. Since the Crontask scheduled to run on everyday morning 5:00 AM.
Please help.
Regards
GM
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************