Monday, July 11, 2016

Fetch PO's which have been receipts completed more than 90 days

Below query would fetch list of PO's record which have all the receipts closed before 90 days.

select ponum,REVISIONNUM,status from maximo.PO where
 status='APPR' and receipts='COMPLETE' and
 exists (select 1 from (select transdate from (
 select max(TRANSDATE) transdate from maximo.SERVRECTRANS
 where ponum=po.ponum group by ponum union select
 max(TRANSDATE) transdate from maximo.MATRECTRANS where
 ponum=po.ponum group by ponum ) order by transdate desc )
 where rownum <2 and="" p="" sysdate-transdate=""> >90)

using this query we can write an escalation which can change status of PO to COMPLETE or close etc

----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, April 26, 2016

using array in Maximo Automation script


from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants
from jarray import array

logger = MXLoggerFactory.getLogger("maximo.script");
logger.debug("==================== ATT_WO_WOPRIORITY." + launchPoint + ": START =====================")

# declaring as a set of double values
arrSubDiv = array([1,2,3,4,5,6],'d')

woPriority = mbo.getDouble("WOPRIORITY")

for i in arrSubDiv:
 if (i==woPriority):
   mbo.setFieldFlag("JUSTIFYPRIORITY",MboConstants.REQUIRED, True)
else:
   mbo.setFieldFlag("JUSTIFYPRIORITY",MboConstants.REQUIRED, False)


logger.debug("==================== ATT_WO_WOPRIORITY." + launchPoint + ": END =====================")





----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, April 19, 2016

Get a list of included/excluded/Non Persistent/Persistent fields used in a Integration Object in Maximo.

Below query fetches list of records which have been used in integration object in Maximo .Here i took the example of Integration Object = MXASSET

select * from (
select distinct i.intobjectname,m.objectname,m.attributename,   'INCLUDE' as intobjfldtype from maximo.maxattribute m,maximo.MAXINTOBJCOLS i, maximo.MAXINTOBJDETAIL intobjdtl  where i.INTOBJECTNAME in ('MXASSET')
and intobjdtl.INTOBJECTNAME in ('MXASSET') and m.objectname=intobjdtl.objectname and m.attributename not in (select b.name from maximo.MAXINTOBJCOLS b where b.INTOBJECTNAME in ('MXASSET')) and m.persistent != 0
union
select distinct i.intobjectname, m.objectname,m.attributename, i.intobjfldtype from maximo.maxattribute m,maximo.MAXINTOBJCOLS i where i.INTOBJECTNAME in ('MXASSET') and i.intobjfldtype='EXCLUDE'
and m.objectname=i.objectname and m.attributename in (select  b.name from maximo.MAXINTOBJCOLS b where b.INTOBJECTNAME in ('MXASSET')  and intobjfldtype in ('EXCLUDE')) and m.persistent != 0
union
select distinct i.intobjectname, m.objectname,m.attributename, i.intobjfldtype from maximo.maxattribute m,maximo.MAXINTOBJCOLS i where i.INTOBJECTNAME in ('MXASSET') and i.intobjfldtype='NONPERSISTENT'
and m.objectname=i.objectname and m.attributename in (select  b.name from maximo.MAXINTOBJCOLS b where b.INTOBJECTNAME in ('MXASSET')  and intobjfldtype='NONPERSISTENT')) order by objectname,attributename



----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, April 18, 2016

Fixing LocAncestor Data integrity In Maximo


·         Take a backup of existing database table using below query
o   create table locancestor_bkp as (select * from locancestor);

·         Create a new procedure like this below and execute it.
*******************************************************************
create or replace procedure BUILD_LOCANCESTOR as

  MODULE_NAME varchar2(50) := 'LOCATIONS';
  SCRIPT_NAME varchar2(50) := 'BUILD_LOCANCESTOR.sql';
  TABLE_NAME  varchar2(50) := 'LOCANCESTOR';
  ERROR_COUNT number := 0; --Track no of errors
  REC_COUNTER number := 0; --Track no of loaded records
  R           number := 200; --Number of records to commit

  V_MAX_ID number;

  cursor LOCATIONS_CUR is
    select L.LOCATION, L.ORGID, L.SITEID, L.SYSTEMID from LOCHIERARCHY L;

  FIX_LOCATION LOCATIONS.LOCATION%type;
  FIX_SITEID   LOCATIONS.SITEID%type;
  /*These two variables are to hold the LOCATION and SITEID of the location
  for which we are building the hierarchy (the entries in LOCANCESTOR table)*/

  X_LOCATION LOCATIONS.LOCATION%type;
  X_SITEID   LOCATIONS.SITEID%type;
  /*These two variables are to hold the LOCATION and SITEID of the current location in the loop*/

  X_ANCESTOR_LOCATION LOCATIONS.LOCATION%type;
  X_ANCESTOR_SITEID   LOCATIONS.SITEID%type;
  /*These two variables are to hold the LOCATION and SITEID of the ancestor
  of the current location in the loop*/

begin
 

  execute immediate ('TRUNCATE TABLE ' || TABLE_NAME);
  execute immediate ('ALTER TABLE ' || TABLE_NAME || ' NOLOGGING');

  --RESET_SEQUENCE(TABLE_NAME);

  for LC in LOCATIONS_CUR loop
    declare
      FIX_SYSTEMID LOCHIERARCHY.SYSTEMID%type;

    begin
      FIX_LOCATION := LC.LOCATION;
      FIX_SITEID   := LC.SITEID;
      --These two variables will be fixed all the inner loop

     

      FIX_SYSTEMID := LC.SYSTEMID;

      X_LOCATION := LC.LOCATION;
      X_SITEID   := LC.SITEID;
      --These two variables will be changed for each iteration of the inner loop

      loop
        --Inner loop to build all LOCANCESTOR entries for the current location (FIX_LOCATION, FIX_SITEID)
        REC_COUNTER := REC_COUNTER + 1;

    

        insert /*+ APPEND */
        into LOCANCESTOR
          (LOCATION, ANCESTOR, SYSTEMID, SITEID, ORGID, LOCANCESTORID)
        values
          (FIX_LOCATION, --LOCATION
           X_LOCATION, --ANCESTOR
           FIX_SYSTEMID, --SYSTEMID
           LC.SITEID, --SITEID
           LC.ORGID, --ORGID
           LOCANCESTORSEQ.NEXTVAL --LOCANCESTORID
           );

        select max(H.PARENT), max(H.SITEID)
          into X_ANCESTOR_LOCATION, X_ANCESTOR_SITEID
          from LOCHIERARCHY H
         where H.LOCATION = X_LOCATION
           and H.SITEID = X_SITEID
           and H.SYSTEMID = FIX_SYSTEMID;

        if (X_ANCESTOR_LOCATION is null) then
          /*If there is no parent of the current location,
          so it's the top level one and we have to exit the inner loop*/
          exit;
        else
          X_LOCATION := X_ANCESTOR_LOCATION;
          X_SITEID   := X_ANCESTOR_SITEID;
        end if;
      end loop; --End the inner loop

    exception
      WHEN DUP_VAL_ON_INDEX THEN
        null;
      when others then
        ERROR_COUNT := ERROR_COUNT + 1;
       
    end;

    commit;
  end loop;

  commit;

  execute immediate ('ANALYZE TABLE ' || TABLE_NAME ||
                    ' COMPUTE STATISTICS');
  execute immediate ('ALTER TABLE ' || TABLE_NAME || ' LOGGING');

  DBMS_OUTPUT.PUT_LINE(TABLE_NAME || ' errors = ' || ERROR_COUNT);

 
end BUILD_LOCANCESTOR;
/
************************************************************
---------------------------------------------------------------------------- 
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Friday, April 15, 2016

Never Give Up.. For those who don't want to give up

Once upon a time a father was very frustrated with his son because he did not seem very manly though he was already sixteen years old. The father went to see a Zen master and asked the master to help his son become a real man. The master said: "I can help you; however, you will have to leave your son at my place for three months. For the whole period, you are not allowed to come to see him. I will assure your satisfaction after the three months." As promised, the father did not come back until three month later. The master arranged a karate match to show the father the training result. When the competition was starting, the father found out that the opponent was a karate trainer. The trainer certainly made sure that he was fully prepared to win before he started to attack. On the other side, the son fell on the floor as soon as he was attacked without any resistance. However, the boy did not surrender and got up immediately after he fell. It went on like this for no fewer than twenty times. His father was embarrassed and felt pain but dared not say anything. The boy lost badly when the match was over. The master asked the father: "Don't you think your son was showing manliness?" "I felt ashamed of him! After three months' training, what kind of result is this?! He is so weak and falls to the floor as soon as he is attacked. I don't think he is manly at all." The father was very disappointed. The master said: "I am sorry that you only look at the superficial forms of failure and success. Didn't you notice that your son had courage and bravery for standing up after his falls? It is a success if the standing-ups are more than falls, which is what a real man should possesses." The father had a sudden enlightenment and thanked the master deeply, and then he took his son home. 

Enlightenment from the Story: We should not just focus on instant results when we do something. The experiences gained and the effort given are the most precious. If one's life is always smooth, he/she will not taste the final sweetness of success after many tries without giving up. The really important virtue is to remember experiences and lessons from failures and bravely move forward to the road of success after planning a new.


----------------------------------------------------------------------------

All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, April 11, 2016

Maximo automation script... Jython code similar to string Starts with


from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants

logger = MXLoggerFactory.getLogger("maximo.script");
siteVar=str(mbo.getMboValue("SITEID"))
## Below line does action similar to starts with in string. It compares if site variable starts with KSK or not, if it doesnt start it alerts the user
if(siteVar[:len("KSK")] <> "KSK"):
 logger.debug("Site validation")
 errorgroup = "Site"
 errorkey ="Checksite"


ref : Reference Link


----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, March 28, 2016

Dont mess with wives





After 37 years of marriage. Jake dumped his wife for his Young secretary. His new girlfriend demanded that they live in Jake and Edith’s multi million dollar home and since the man’s lawyers were a little better he prevailed. He gave Edith his now ex-wife just 3 days to move out. She spent the 1st day packing her belongings into boxes crates and suitcases. On the 2nd day she had to movers come and collect her things. On the 3rd day she sat down for the last time at their beautiful dining room table by candlelight put on some soft background music and feasted on a pound of shrimp a jar of caviar and a bottle of Chardonnay. When she had finished she went into each and every room and stuffed half-eaten shrimp shells dipped in caviar into the hollow of all of the curtain rods. She then cleaned up the kitchen and left. When the husband returned with his new girlfriend all was bliss for the first few days. Then slowly the house began to smell. They tried everything cleaning mopping and airing the place out. Vents were checked for dead rodents and carpets were cleaned. Air fresheners were hung everywhere. Exterminators were brought in to set off gas canisters during which they had to move out for a few days and in the end they even replaced the expensive wool carpeting. NOTHING WORKED. People stopped coming over to visit. Repairman refused to work in the house. The Maid quit. Finally, they could not take the stench any longer and decided to move. A month later even through they had cut their price in half they could not find a buyer for their stinky house. Word got out and eventually even the local realtors refused to return their calls. Finally they had to borrow a huge sum of money from the bank to purchase a new place. The ex-wife called the man and asked how things were going. He told her the saga of the rotting house. She listened politely and said that she missed her old home terribly and would be willing to reduce her divorce settlement in exchange for getting the house back. Knowing his ex-wife had no idea how bad the smell was… he agreed on a price that was about 1/10th of what the house ha been worth, but only if she were to sign the papers that very day. She agreed and within the hour his lawyers delivered the paperwork. A week later the man and his girlfriend stood smiling as they watched the moving company pack everything to take to their new home. INCLUDING THE CURTAIN RODS. :) -
















----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Friday, March 11, 2016

Hameed and his teacher

A small boy named Hameed lived in a village in Morocco. None of his classmates liked him because of his stupidity, especially his teacher, who was always yelling at him "You are driving me crazy Hameed!!!!!"


One day hameed's mother came into school to check on how he was doing. The teacher told his mother honestly, that her son is simply a disaster, getting very low marks and even she had never seen such a dumb boy in her entire teaching career!!!! The mother was shocked at the feedback and withdrew her son from the school & even moved to another town!!!!!




25 years later, the teacher was diagnosed with an incurable cardio disease! All the doctors strongly advised her to have an open heart operation, which only one surgeon could perform.......




Left with no other options, the teacher decided to have the operation, which was successful...... When she opened her eyes after the surgery she saw a handsome doctor smiling down at her! She wanted to thank him, but could not talk. Her face started to turn blue, she raised her hand, trying to tell him something but eventually died!


The doctor was shocked and was trying to work out what went wrong, when he turned around he saw our friend Hameed, working as a cleaner in the clinic, who had unplugged the oxygen equipment to connect his Mobile Charger !!!!!






Don't tell me you thought that Hameed became a doctor???? :D :D

Good Day..Have a great Week ahead :) collapse


----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, February 24, 2016

Adding messages in processing rules of Enterprise services in Maximo

Below are the steps which are to be followed to make sure messages can be properly added in enterprise services à processing rules.

·         Create an entry in Messages from database configuration making sure that messagegroup value is ‘iface’  example below
o   Message Group :iface
o   Message Key : VALIDATIONALERT
o   Display Method : MSGBOX
o   Value : Alerting user

·         Now navigate to Enterprise services à Processing rules and select this value from lookup attached to Message Key.


----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Friday, February 19, 2016

Fetching last 6 months data in Maximo using SQL Server with output in a specific language

Below is one of the best ways to find number of tickets created in last 6 months in Maximo using SQL Server database in a specific language.
here i am using Portugese as lanuage in which my output should be

Query is self explanatory


select CASE month
WHEN  'January' THEN 'Janeiro de'
WHEN  'February' THEN 'Fevereiro'
WHEN  'March' THEN 'Março de'
WHEN  'April' THEN 'Abril'
WHEN  'May' THEN 'Maio'
WHEN  'June' THEN 'Junho de'
WHEN  'July' THEN 'Julho'
WHEN  'August' THEN 'Agosto'
WHEN  'September' THEN 'Setembro de'
WHEN  'October' THEN 'Outubro'
WHEN  'November' THEN 'Novembro de'
  ELSE 'Dezembro de'
END month,countoftickets from ( SELECT DATENAME(MONTH,DATEADD(month, -5, GETDATE())) month,COUNT(*) AS countoftickets , 1 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -5, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -4, GETDATE())) month,COUNT(*) AS countoftickets , 2 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -4, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -3, GETDATE())) month,COUNT(*) AS countoftickets , 3 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -3, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -2, GETDATE())) month,COUNT(*) AS countoftickets , 4 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -2, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -1, GETDATE())) month,COUNT(*) AS countoftickets , 5 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -1, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, 0, GETDATE())) month,COUNT(*) AS countoftickets , 6 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, 0, GETDATE()))  ) a1  order by fs

output:

month countoftickets
Setembro de 0
Outubro 0
Novembro de 0
Dezembro de 22
Janeiro de 57
Fevereiro 34






----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Thursday, February 18, 2016

Displaying data ticket count with in SLA by priority in MAXIMO using SQL Server.

Below query can be used for displaying data ticket count with in SLA by priority in MAXIMO using SQL Server.

Data would be displayed like below

Priority          Count Status
1                 1        SLA OK
1                   2        SLA NOT OK
3                  15      SLA OK


Query :

select internalpriority,count(*) count, 'SLA NOT OK'  status  from TICKET where targetcontactdate is not null and actualcontactdate is not null and targetcontactdate - actualcontactdate <0 -="" actualcontactdate="" and="" by="" count="" from="" group="" internalpriority="" is="" nbsp="" not="" null="" ok="" select="" status="" targetcontactdate="" ticket="" union="" where="">=0 group by internalpriority










----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Display Number of tickets solved with in SLA by person in Maximo .. SQL Server

Below query can be used for displaying data solved with in SLA by person in MAXIMO using SQL Server.

Data would be displayed like below

AffectedPerson Count Status
ABC                   1        SLA OK
ABC                   2        SLA NOT OK
XYZ                   15      SLA OK


Query :

select affectedperson,count(*) count, 'SLA NOT OK'  status  from TICKET where targetcontactdate is not null and actualcontactdate is not null and targetcontactdate - actualcontactdate <0 -="" actualcontactdate="" affectedperson="" and="" by="" count="" from="" group="" is="" nbsp="" not="" null="" ok="" select="" status="" targetcontactdate="" ticket="" union="" where="">=0 group by affectedperson







----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, February 16, 2016

Displaying tickets created from different sources in Maximo using Sql Server

Below query can be used to display number of tickets which are created from different sources(here external systems) as per months.

Output would be like below

Source  Month count
Email    Dec       10
Email     Jan        14
Phone    Jan         15
self Serv  Dec      05

Query:

select externalsystem,DATENAME(MONTH,DATEADD(month, 0, creationdate)) month ,count(*) count  from TICKET  group by externalsystem , DATENAME(MONTH,DATEADD(month, 0, creationdate))








---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Sunday, February 7, 2016

Fetching Last 6 months data in SQL Server for Maximo

Below is one of the best ways to find number of tickets created in last 6 months in Maximo using SQL Server database.

Query is self explanatory

select month,countoftickets from (
SELECT DATENAME(MONTH,DATEADD(month, -5, GETDATE())) month,COUNT(*) AS countoftickets , 1 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -5, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -4, GETDATE())) month,COUNT(*) AS countoftickets , 2 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -4, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -3, GETDATE())) month,COUNT(*) AS countoftickets , 3 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -3, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -2, GETDATE())) month,COUNT(*) AS countoftickets , 4 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -2, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -1, GETDATE())) month,COUNT(*) AS countoftickets , 5 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -1, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, 0, GETDATE())) month,COUNT(*) AS countoftickets , 6 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, 0, GETDATE()))  ) a1
order by fs

output:

Month   Countoftickets
October 10
November 12
December   5
January   17
February 20
March 15











---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, January 18, 2016

Enable Workflow reassignments in Maximo based on security groups

1.       Simple way to enable workflow reassignments in application is through Signature options and security group.
2.       Navigate to any application in which you need Workflow reassignment option thorough application designer. In this case I am taking Requests and Defects (Oil) -- PLUSGDEF
3.       From select action add a sig option called ‘MAXWFRA’ with a  simple desc and save the record.



4.       Now navigate to the security group for which this access  has to be enabled and check the sigoption under the application (PLUSGDEF).

5.       After signing out and signing in as a user from that security group ,When you navigate to Requests and Defects (Oil) application and select a record with an active workflow . Observe that Reassignments icon is visible.









----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, January 6, 2016

How to wrap attributes in Birt based on space.


In the attribute which you want to wrap add the following code which wraps after every space to next line

if(dataSetRow["description"]!=null){
  dataSetRow["description "].replace(/ /g,"\n")
 }


/ /g à means white space anywhere in the string

----------------------------------------------------------------------------

All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Saturday, October 24, 2015

How to wrap data attributes in Birt Report

Below function would be useful for wrapping the data present in a field.

if(dataSetRow["description"]!=null){
function wrap(longStr,width){ length = longStr.length; if(length <= width) return longStr; return (longStr.substring(0, width) + "\n" + wrap(longStr.substring(width, length), width)); }wrap( dataSetRow["description"], 15 );
}

in the above function, i am trying to wrap description field to a size of 15.

Only disadvantage of this is that it includes hard stops so after every 15 characters which can be frustrating to a user who uses the report in a excel sheet.

----------------------------------------------------------------------------
All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, August 26, 2015

Maximo .. Update database using Birt report

Sometimes database has to be updated after each report run showing that a report  has been run(example like last run date).

In Birt simple way to achieve this is to execute update query in the 'beforeClose' method of dataset.



var myTxn = MXReportTxnProvider.create("maximoDataSource");


var updateSqlText = new String();

updateSqlText = " update poline set enterdate=SYSDATE  where enterdate is null'";

var apextractStmt = myTxn.createStatement();
apextractStmt.setQuery(updateSqlText);

myTxn.save();





---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

SQL Server & Maximo .. How to split GL account in SQL Server

Below query can be used in sql server to split a GL account which has 3 components in to individual components divided by '-' (ex : 100010123-abcd-1234 will be divided into gl1- 100010123, gl2- abcd , gl3 - 1234) .

select gldebitacc,

substring(gldebitacc,0,CHARINDEX('-',gldebitacc)) as gl1,

substring(gldebitacc,CHARINDEX('-',gldebitacc)+1,len(gldebitacc)-(CHARINDEX('-',gldebitacc)+charindex('-', reverse(gldebitacc)))), as gl2,

REVERSE(substring(reverse(gldebitacc),0, charindex('-', reverse(gldebitacc)) )) as gl3

 from

poline


----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Maximo Automation script .. How to find the parent Mbo and set value

Below is the sample code which can be used for finding the parent Mbo (ex invoiceline is parent for invoicecost) and setting values.I am using a attribute launchpoint on child mbo (ex invoicecost) which is called from invoiceline when filling gldebitaccout

from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants


parentMbo=mbo.getOwner()
parentMbo.setValue("description","test", MboConstants.NOACCESSCHECK|MboConstants.NOVALIDATION_AND_NOACTION)



----------------------------------------------------------------------------

 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Maximo Automation Script .. Split GL account

Below is the script which can be used for splitting the GL account to components

from psdi.mbo import MboConstants
from psdi.mbo import GLFormat
from java import util

 glComp1=mbo.getValue("gldebitacc").split('-')[0]
glComp2=mbo.getValue("gldebitacc").split('-')[1]
glComp3=mbo.getValue("gldebitacc").split('-')[2]

----------------------------------------------------------------------------

All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Sunday, May 10, 2015

Java Freshers Recruitment in Accenture


Destiny reveals fortune at the end of your expedition.

Recruitment Event for ASE Level Candidates For Java Skill
At Accenture, we value achievers like you who have the zeal to go an extra mile for fulfilling a mission. We are on a look out for such high performers and we believe you can help us find some. Bring in exceptional talents from your network of friends and family who could seamlessly click at Accenture and help us take the path forward.  
Criteria:
1.      Good understanding of Core Java/ Java Concepts/ Java Enterprise Edition (Any of these)
2.      Knowledge on J2EE / Spring /Hibernate/Servlet (Any of these).
3.       Good Communication Skills.
4.      Engineering Graduate with =/> 60%.
5.      Work location – Across all locations(Bangalore, Chennai, Hyderabad, Mumbai, Pune)
6.     Experience level from 03 to 12 months.
7.   Candidates willing / available to join us in May 2015 (Immediate joiners) 
If your friend’s profile matches the abovementioned criteria, simply log on to https://employeereferrals.accenture.com and start referring
How to refer:
·         Search for opening on employee referral portal with the following criteria - [Search Box - J2EE Programming - Application ][location – Bangalore, Chennai, Hyderabad, Mumbai, Pune] [level – 12] [Career Track – Client Delivery and Operations]. (If you are not able to refer on employee referral portal please send the resume with subject line as ‘Opportunity for Java Skill!!’ at (idc.talentscout@accenture.com).
·         Upload the profile
·         Once the profile is successfully uploaded – you would get an auto generated mail with a unique CID number for the candidate.
·         You can use the CID number to track the status of the referred candidate.

Note:  Referral bonus is not applicable for this hiring

Event Details:

Date
14th 16th 20th & 23rd May-2015 (will be confirmed to selected candidates via email)
Reporting Time
Will be mailed to selected candidates
Venue
Will be mailed to selected candidates

Please Note:
·         Please refer only resume / CV of candidates matching the criteria. Any resume / CV of candidate referred but not matching criteria will not be considered for further processing.
·         Suitable candidates will be contacted directly from Accenture recruitment team
 Regards,
Talent Scout Team
Technology, India


----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, April 22, 2015

Accenture Recruitment for freshers


  Associate Software Engineer
Referrals are your clues to finding a treasure. Narrow your quest, search for peers, and find us credible crew members. Each referral will bring you closer to the treasure. The more number of referrals, the closer you get to your reward.
Qualifications and other criteria:
·       MCom pass-out (2011 onwards) who should be a graduate in BCom/Bachelor of Commerce in Accounting & Finance (BAF)/Bachelor of Management Studies (BMS)
·        Should have scored 60% or above with no current backlogs
·        Should be available to join us on or before May 15, 2015

Selected candidates would be trained in SAP FICO
.
Work location: Bangalore
Referral award: INR 5000
How to refer:
·         Search for an opening on employee referral portal with the following criteria - [Search Box - SAP-FI-Financial Accounting=] [location - Bangalore] [level – 12] [Career Track – Client Delivery and Operations].
·         Upload the profile.
·         Once the profile is successfully uploaded, you would get an auto generated mail with a unique CID number for the candidate.
·         You can use the CID number to track the status of the referred candidate.
If you are not able to refer on employee referral portal please send the resume with subject line ‘Destiny reveals fortune at the end of your expedition’ to idc.talentscout@accenture.com.
Shortlisted candidates will get a mail from Accenture recruitment team on schedule confirmation for interview on April 26, 2015 and May 3, 2015.
Do not wait any longer, start referring today.



----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, December 22, 2014

moral story ..change ur perspective


At a fundraising dinner for a school that serves children with learning disabilities, the father of one of the students delivered a speech that would never be forgotten by all who attended. After extolling the school and its


dedicated staff, he offered a question:


'When not interfered with by outside influences, everything nature does, is done with perfection.


Yet my son, Shay, cannot learn things as other children do. He cannot understand things as other children do.


Where is the natural order of things in my son?'


The audience was stilled by the query.


The father continued. 'I believe that when a child like Shay, who was mentally and physically disabled comes into the world, an opportunity to realize true human nature presents itself, and it comes in the way other people treat that child.'


Then he told the following story:


Shay and I had walked past a park where some boys Shay knew were playing baseball. Shay asked, 'Do you think they'll let me play?' I knew that most of the boys would not want someone like Shay on their team, but as a father I also understood that if my son were allowed to play, it would give him a much-needed sense of belonging and some confidence to be accepted by others in spite of his handicaps.


I approached one of the boys on the field and asked (not expecting


much) if Shay could play. The boy looked around for guidance and said, 'We're losing by six runs and the game is in the eighth inning. I guess he can be on our team and we'll try to put him in to bat in the ninth inning.'


Shay struggled over to the team's bench and, with a broad smile, put on a team shirt. I watched with a small tear in my eye and warmth in my heart. The boys saw my joy at my son being accepted.


In the bottom of the eighth inning, Shay's team scored a few runs but was still behind by three.


In the top of the ninth inning, Shay put on a glove and played in the right field. Even though no hits came his way, he was obviously ecstatic just to be in the game and on the field, grinning from ear to ear as I waved to him from the stands.


In the bottom of the ninth inning, Shay's team scored again..


Now, with two outs and the bases loaded, the potential winning run was on base and Shay was scheduled to be next at bat.


At this juncture, do they let Shay bat and give away their chance to win the game?


Surprisingly, Shay was given the bat. Everyone knew that a hit was all but impossible because Shay didn't even know how to hold the bat properly, much less connect with the ball.


However, as Shay stepped up to the


plate, the pitcher, recognizing that the other team was putting winning aside for this moment in Shay's life, moved in a few steps to lob the ball in softly so Shay could at least make contact.


The first pitch came and Shay swung clumsily and missed.


The pitcher again took a few steps forward to toss the ball softly towards Shay.


As the pitch came in, Shay swung at the ball and hit a slow ground ball right back to the pitcher.


The game would now be over.


The pitcher picked up the soft grounder and could have easily thrown the ball to the first baseman.


Shay would have been out and that would have been the end of the game.


Instead, the pitcher threw the ball right over the first baseman's head, out of reach of all team mates.


Everyone from the stands and both teams started yelling, 'Shay, run to first!


Run to first!'


Never in his life had Shay ever run that far, but he made it to first base.


He scampered down the baseline, wide-eyed and startled.


Everyone yelled, 'Run to second, run to second!'


Catching his breath, Shay awkwardly ran towards second, gleaming and struggling to make it to the base.


B y the time Shay rounded towards second base, the right fielder had the ball . the smallest guy on their team who now had his first chance to be the hero for his team.


He could have thrown the ball to the second-baseman for the tag, but he understood the pitcher's intentions so he, too, intentionally threw the ball high and far over the third-baseman's head.


Shay ran toward third base deliriously as the runners ahead of him circled the bases toward home.


All were screaming, 'Shay, Shay, Shay, all the Way Shay'


Shay reached third base because the opposing shortstop ran to help him by turning him in the direction of third base, and shouted, 'Run to third!


Shay, run to third!'


As Shay rounded third, the boys from both teams, and the spectators, were on their feet screaming, 'Shay, run home! Run home!'


Shay ran to home, stepped on the plate, and was cheered as the hero who hit the grand slam and won the game for his team


'That day', said the father softly with tears now rolling down his face, 'the boys from both teams helped bring a piece of true love and humanity into this world'.


Shay didn't make it to another summer. He died that winter, having never forgotten being the hero and making me so happy, and coming home and seeing his Mother tearfully embrace her little hero of the day!

silly jokes

Girlfriend: And are you sure you love me and no one else?


Boyfriend: Dead Sure! I checked the whole list again yesterday



*********



Waiter: Would you like your coffee black?



Customer: What other colors do you have?



*********



Manager: Sorry, but i can't give u a job. I don't need much help.



Job Applicant: That's all right. In fact I'm just the right person in this case. You see, I won't be of much help anyway!!



*********



Dad: Son, what do u want for ur birthday?



Son: Not much dad, Just a radio with a sports car around it.



*********





Diner: You'll drive me to my grave!



Waiter: Well, you don't expect to walk there, do you?



*********



Husband: U know, wife, our son got his brain from me.



Wife: I think he did, I've still got mine with me!



*********



Man: Officer! There's a bomb in my garden!



Officer: Don't worry. If no one claims it within three days, you can keep it.



*********



Father: Your teacher says she finds it impossible to teach you anything!



Son: That's why I say she's no good!

Marraige Life Story


When I got home that night as my wife served dinner, I held her hand and said, I've got something to tell you. She sat down and ate quietly. Again I observed the hurt in her eyes.

Suddenly I didn't know how to open my mouth. But I had to let her know what I was thinking. I want a divorce. I raised the topic calmly. She didn't seem to be annoyed by my words, instead she asked me softly, why? I avoided her question. This made her angry. She threw away the chopsticks and shouted at me, you are not a man!

That night, we didn't talk to each other. She was weeping. I knew she wanted to find out what had happened to our marriage. But I could hardly give her a satisfactory answer; I had lost my heart to a lovely girl called Dew. I didn't love her anymore. I just pitied her!

With a deep sense of guilt, I drafted a divorce agreement which stated that she could own our house, 30% shares of my company and the car. She glanced at it and then tore it into pieces. The woman who had spent ten years of her life with me had become a stranger. I felt sorry for her wasted time, resources and energy but I could not take back what I had said for I loved Dew so dearly.

Finally she cried loudly in front of me, which was what I had expected to see. To me her cry was actually a kind of release. The idea of divorce which had obsessed me for several weeks seemed to be firmer and clearer now.

The next day, I came back home very late and found her writing something at the table. I didn't have supper but went straight to sleep and fell asleep very fast because I was tired after an eventful day with Dew. When I woke up, she was still there at the table writing. I just did not care so I turned over and was asleep again.

In the morning she presented her divorce conditions: she didn't want anything from me, but needed a month's notice before the divorce. She requested that in that one month we both struggle to live as normal a life as possible. Her reasons were simple: our son had his exams in a months time and she didn't want to disrupt him with our broken marriage.

This was agreeable to me. But she had something more, she asked me to recall how I had carried her into out bridal room on our wedding day.. She requested that everyday for the month's duration I carry her out of our bedroom to the front door ever morning. I thought she was going crazy.

Just to make our last days together bearable I accepted her odd request.

I told Dew about my wife s divorce conditions. She laughed loudly and thought it was absurd. No matter what tricks she applies, she has to face the divorce, she said scornfully. My wife and I hadn't had any body contact since my divorce intention was explicitly expressed. So when I carried her out on the first day, we both appeared clumsy. Our son clapped behind us, daddy is holding mummy in his arms. His words brought me a sense of pain. From the bedroom to the sitting room, then to the door, I walked over ten meters with her in my arms. She closed her eyes and said softly; don't tell our son about the divorce. I nodded, feeling somewhat upset..

I put her down outside the door. She went to wait for the bus to work. I drove alone to the office.

On the second day, both of us acted much more easily. She leaned on my chest.. I could smell the fragrance of her blouse. I realized that I hadn't looked at this woman carefully for a long time. I realized she was not young any more. There were fine wrinkles on her face, her hair was graying! Our marriage had taken its toll on her. For a minute I wondered what I had done to her.

On the fourth day, when I lifted her up, I felt a sense of intimacy returning. This was the woman who had given ten years of her life to me. On the fifth and sixth day, I realized that our sense of intimacy was growing again. I didn't tell Dew about this. It became easier to carry her as the month slipped by. Perhaps the everyday workout made me stronger.

She was choosing what to wear one morning. She tried on quite a few dresses but could not find a suitable one. Then she sighed, all my dresses have grown bigger. I suddenly realized that she had grown so thin, that was the reason why I could carry her more easily. Suddenly it hit me; she had buried so much pain and bitterness in her heart.

Subconsciously I reached out and touched her head. Our son came in at the moment and said, Dad, it's time to carry mum out. To him, seeing his father carrying his mother out had become an essential part of his life. My wife gestured to our son to come closer and hugged him tightly. I turned my face away because I was afraid I might change my mind at this last minute. I then held her in my arms, walking from the bedroom, through the sitting room, to the hallway. Her hand surrounded my neck softly and naturally. I held her body tightly; it was just like our wedding day.

But her much lighter weight made me sad. On the last day, when I held her in my arms I could hardly move a step. Our son had gone to school. I held her tightly and said, I hadn't noticed that our life lacked intimacy. I drove to office... jumped out of the car swiftly without locking the door. I was afraid any delay would make me change my mind... I walked upstairs. Dew opened the door and I said to her, Sorry, Dew, I do not want the divorce anymore.

She looked at me, astonished. Then touched my forehead. Do you have a fever? She said. I moved her hand off my head. Sorry, Dew, I said, I won't divorce. My marriage life was boring probably because she and I didn't value the details of our lives, not because we didn't love each other any more.. Now I realize that since I carried her into my home on our wedding day I am supposed to hold her until death does us apart.

Dew seemed to suddenly wake up. She gave me a loud slap and then slammed the door and burst into tears. I walked downstairs and drove away. At the floral shop on the way, I ordered a bouquet of flowers for my wife. The salesgirl asked me what to write on the card. I smiled and wrote:
'I'll carry you out every morning until death do us apart'

The small details of our lives are what really matter in a relationship. It is not the mansion, the car, the property, the bank balance that matters. These create an environment conducive for happiness but cannot give happiness in themselves. So find time to be your spouse's friend and do those little things for each other that build intimacy. Do have a real happy marriage!

Telugu cinema actors who died in 2014.


Uday Kiran


 

                                              Telangana Sekunthala

                            

 

Akkenini Nageswarao


 

BAPU


                                                                

                                                                    CHAKRI

 

Nandamuri Janakiram


 

PJ Sharma





----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.