i2ifunding coupons

Hi All

Please use the below links to get half discount on i2ifunding fees.
Using below links you will get coupon code / promotional code applied automatically

For borrower

borrow

For Investor

invest 


Happy investing ....

IBM Maximo : Simple way of Hiding New row button based on security groups

----------------------------------------------------------------------------------------------------------------------
 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.
----------------------------------------------------------------------------------------------------------------------

Case : Only users in SUPERVISIOR security group should be able to add new meters to locations.

• Navigate to Conditional expression manager and create a new condition like below
• Condition : nonsupervisior
• Type : Expression
• Expression : (:&USERNAME& not in (select userid from groupuser where groupname='SUPERVISIOR'))
• Always Evaluate : Y

• Navigate to Application designer , search for Location application and create a new sigoption
• Option : locationmeter
• Desc : Location Meter sigoption
• Visible : Y
• Click ok.
• Now click on the ‘new row’ button in Meter tab and go to its properties
• In advanced tab , add Signature Option as ‘locationmeter’
• Click on ‘Configure Conditional Properties’  and add the following
• Security group : EVERYONE
• Condition : nonsupervisior
• Condition is False à mxevent : addrow
• Condition is true à  property : display

        Value : false

• Now navigate to security groups and search for ‘SUPERVISIOR’ security group à application : location and grant access to
• Option : locationmeter
• Desc : Location Meter sigoption
• Save .

Note : Here we have assumed that every user in Maximo belongs to ‘EVERYONE’ security group.

Similar can be performed for delete button also.

Scheduled publishing of integration data

---------------------------------------------------------------------------- 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.
----------------------------------------------------------------------------------------------------------------------


Below solution can be helpful when business want to send the data out of maximo on scheduled intervals.

Below are the steps to be followed

1.       Use an existing object structure like MXASSET etc

2.       Add this object structure to a publish channel

3.       Add the publish channel to an external system (ex:EXTSYS1)

4.       Create a cron task and new cron instance with below mandatory information

   Class : custom.integration.cron.RunPublishChannelCrontask

   Access Level : Full

5.       Place  RunPublishChannelCrontask.class file in to the folder \SMP\maximo\applications\maximo\businessobjects\classes\custom\integration\cron.

6.       Build the ear, redeploy it and restart the servers.

7.       Reload the cron which is created earlier, data would be processed and kept in the MIF folder.

Please follow the below blog from Bruno for the class file and better solution

http://maximodev.blogspot.com/2012/04/mif-schedule-file-export.html 

Item Master

select action

---------------------------------------------------------------------------- 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.

Basis of Maximo

What are assets ?

 Asset  -- which has some business / economic value

 classified as
    Tangabile --> Current assets -- ex items present in inventory
  --> Fixed assets ex buildings etc
Intangable -- They have value but not physical --ex brand value / IP address


Asset Managment --  any system that monitors and maintains things of value to an entity or group

Enterprise asset management (EAM) involves the management of the maintenance of physical assets of an organisation throughout each asset's life cycle. EAM is used to plan, optimise, execute, and track the needed maintenance activities with the associated priorities, skills, materials, tools, and information. This covers the design, construction, commissioning, operations, maintenance and decommissioning or replacement of plant, equipment and facilities.

IBM Maximo

Maximo Addons

Maximo Asset Health Insights

Maximo Scheduler

Maximo Health Safety and Environment Manager

Maximo Spatial Asset Management

Maximo Linear Asset Manager

Maximo Calibration

Maximo Scheduler Plus

Maximo Asset Configuration Manager

Maximo Service Provider

https://www.ibm.com/products/maximo/add-ons

Maximo Industry Solutions

Maximo for Transportation

Maximo for Oil and Gas

Maximo for Utilities

Maximo for Nuclear Power

Maximo for Aviation

Maximo for Life Sciences

https://www.ibm.com/products/maximo/industries

----------------------------------------------------------------------------
 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.

How do I add an image to list screen and display it based on condition in Maximo?

1.       Here I am taking an example of asset application in which I want to make my asset to be flagged in as Green  color when it satisfies some condition.

2.       Navigate to a list screen from application designer, select the field which needs to be highlighted.

3.       Click on ‘Configure Conditional Properties’ and add below information like

·         Security Group : MAXEVERYONE

·         Conditional property : KKS_STAT

·         Property : image : st_MessageWarning.png

----------------------------------------------------------------------------
 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.

How do I change background color of a field in list screen in Maximo

1.       Here I am taking an example of asset application in which I want to make my asset to be in Green background color when it satisfies some condition.

2.       Navigate to a list screen from application designer, select the field which needs to be highlighted.

3.   Click on ‘Configure Conditional Properties’ and add below information like

·         Security Group : MAXEVERYONE

·         Conditional property : KKS_CLR

·         Property : cssclass : bggreen

Similar trick can be followed to other colors like (bgred, bgyellow ) etc.

----------------------------------------------------------------------------
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.

Checklist before leaving Canada back to your home country

5 Important things to be done while relocating back to India from Canada.

1.Backup all your proofs which show you visited and worked in Canada

   Below are the documents which i want you to take backup as these documents can be very useful for you if you are applying PR etc
    1. Company Payslips
    2. Bank Statements- Please get them from starting of your back accounts. Ideally get them from bank with a bank seal on it.It might be useful for applying loan in India
    3.Lease agreements
    4.Company offer letters

2. Zero stains on your credit history

    Below are the points to be taken to make sure you have no bad credit history. This will help in getting easier loans if you ever back in Canada.
    1.Pay all the credit card dues and close them
    2.Pay all your phone bills and cancel the connection.
    3.Pay your rents and get a no objection certificate if possible.
    4.Pay your driving tickets and other tickets.

3. Be careful with your bank

    As you may be filling taxes and you might get some refunds it is always advisable to have one bank account active. Most of the Canadian banks charge for checking's account if you don't have enough balance. My advise is to close your checking's account and have only savings bank account. Advantage of savings bank is it gives you money on the funds you have and generally deposits are not charged only withdrawals are charged. If you are closing down your checking account please make sure you update below websites just to make money gets deposited properly into your account
    1. Update CRA - Canada Revenue Agency
    2.Update your personal / medical/vehicle insurance company
    3.Update your Working company which pays your salary.
    4.Update your Rental company
    5. Update the websites from which you do money transfers

4.Update CRA
As you are relocating i would suggest you to update CRA - Canada revenue Agency about your departure from the country. This will help CRA to calculate your taxes properly and process returns.

5.Make proper contacts.

 As Canadian job market is very small and each every person is connect with other people it is always better to have proper contacts, so I request you to give your details and all the required people to LinkedIn , Facebook etc.

As you would be moving back to your country , try to do a break over journey in Toronto or Vancouver etc places and appreciate the Canadian lifestyle.

If you like this post or have some more points to be added please write in the comment.


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

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.

IBM Maximo : Calling a report from a push button in Maximo

Idea here is to launch a report from a push button on any screen. In this way business can run a specific report by clicking a button in the screen itself.

1.       Find the report which you want to run (ex: woprint.rptdesign) and hit the database to find the report number and execute below query

select reportnum,reportname,appname from report where reportname='woprint.rptdesign' and APPNAME='WOTRACK';

2.       From Report Library file (REPLIBRARY) and search for reportnum="351" , note the id related to it (highlighted)

id="reportd351"

label="Request Page" mboname="WORKORDER" reportnum="351" reporttype="BIRT" width="550">

3.       Navigate to application designer, search for WOTRACK and a new button with details like

Event : reportd351 and save it

4.       From Work Order Tracking application , you can see a Print Report button, when you click it shows report page like below

And on Submit, it generates the report.

----------------------------------------------------------------------------
 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.

Maximo Environment refresh- Naming environments

-- Below are the scripts which can be executed after production refreshes to make sure every environment is named from login screen etc.
Below is a example where we are trying to set values in a system as Development Environment


------ Messages on the Login Screen -----

--Login Button ---
update maximo.maxmessages set value = 'Sign In to Development' where msgkey = 'loginbutton' and msggroup = 'login';

-- Welcome Message ---
update maximo.maxmessages set value = 'You are in Development' where msgkey = 'welcome' and msggroup = 'login';

update maximo.maxmessages set value = 'Welcome to Development' where msgkey = 'welcomemaximomessage' and msggroup = 'login';

update maximo.maxmessages set value = 'Welcome to Development, {0}' where msgkey = 'welcomeusername' and msggroup = 'login';

-- Maximo Log Out Messages ----
update maximo.maxmessages set value = 'All users will be logged out of Development Environment in {0} minutes. Save your work.' where msgkey = 'AdminLogoutSubject';

update maximo.maxmessages set value = 'Maximo configuration in progress on Development Environment' where msgkey = 'AdminLogoutMessage';

--- Maximo Application ----

update maximo.maxapps set description = 'DEV - ' || description;

commit;

----------------------------------------------------------------------------
 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.

World's oldest Mosques in India to which every Indian Muslim should visit

I feel every Indian Muslim should visit these 2 mosques which were bulit when Prophet Muhammad was alive and also request respective states to improve tourism facilities

Cheraman Juma Mosque

Cheraman Juma Mosque which was bulit in 629 AD by Malik Deenar, an Arab propagator of Islam and a follower of Prophet Muhammad on the land given by
Cheraman Perumal, the Chera king of Kerala.

Many traders from Arab countries used to visit Malabar region of Kerala, in the process they also propogated Islam into this region.
As the legend goes, Cheraman Perumal (king) visited Arabia and converted himself to a true follower of Islam. He changed his name to Tajuddin.
Unfortunatly he couldnt visit Cheraman Juma Mosque as he died while coming back to his kingdom. He is now buried in Oman.

This mosque is located in NH 66, Kodungallur, Trichur Kerala 680664.
More details can be found on the mosque website :http://cheramanmosque.com

You can plan visit check Tripadvisor site : https://www.tripadvisor.ca/Attraction_Review-g2285465-d2709126-Reviews-Cheraman_Juma_Masjid_Mosque-Kodungallur_Kerala.html
FB Page : https://www.facebook.com/Cheraman-Juma-Masjid-The-First-Masjid-in-Hindustan-344554142298708/

Palaiya Jumma Palli

This mosque was bulit around 630 AD in Kilakarai, Tamil Nadu. Similar to Cherman Juma Mosque history it was also constructed in a port city by traders from Yeman.
This mosque looks like a temple from outside and mosque inside.This also shows how Islamic culture came to india much before Mughals came to India.

Website: I couldnt find if this mosque has any website.
You can plan visit :As i didnt find any good hotels near by, i would prefer to stay in Rameswaram or Madurai.

FB page : https://www.facebook.com/pages/Palaiya-Jumma-Palli/195504303966184

----------------------------------------------------------------------------
All the messages below/above 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 : To make field value to remove special characters and to make it in upper case

Below script is used to remove the special characters and make values in the field to uppercase

Script
------
Name : ASSET-DESCRIPTION-REMOVE-SPLCASE
Language : jython

Launch Points
-------------
Name : ATT-REMOVE-SPLCASE
Active : 1
Object : Asset
Attribute : DESCRIPTION

Autoscript
----------

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

logger = MXLoggerFactory.getLogger("maximo.script");
logger.debug("==================== ATT-REMOVE-SPLCASE." + launchPoint + ": START =====================")

#This script reformats the Description field to only have alphanumeric uppercase characters
#Characters A-Z and 0-9 inclusive are permitted.

description = mbo.getString("DESCRIPTION")
description = ''.join(i for i in description if i.isalnum())
description = description.upper()
mbo.setValue("DESCRIPTION", str(description), 2)

logger.debug("==================== ATT-REMOVE-SPLCASE." + launchPoint + ": END =====================")
----------------------------------------------------------------------------
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.

Discardable MBOSET / MBO in IBM Maximo

·         These can be used on MBOSETS which are used for traversing forward only ie looping in

·         They should not be used while doing edit/save etc operations

·         Mboset will not cache the MBOs as it fetches from directly from database. This will minimise the JVM memory usage.

·         Discardable Mbo Sets are always read only.

Example below to make a MBOset discardable

MboSetRemote personSet = getMboSet("PERSON");
personSet.setFlag(MboConstants.DISCARDABLE, true);

----------------------------------------------------------------------------
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.

Lord Krishna ..Master Strategist

This is a small story which tells Lord Krishna is a natural leader and master strategist.

In Vrindavan there was a powerful raging bull named as Hastin. It was so big ,arrogant and always willing to fight. People kept him because he was the source of a whole breed of cows in Vrindavan but he was so violent and dangerous that no one dared to go near him. Balram, brother of Lord Krishna always said that he want to become so strong that he can kill Hastin in one punch. That was the strength of the Bull.

One day during a friendly conversation Krishna declared that he would ride on Hastin by next full moon day for which all his friends laughed including his brother thinking it was an impossible act  . Time passed by ,just 2 days before next full Moon day Balram asked Krishna if he would be riding on Hastin just to make fun of him. Krishna asked everyone to wait till full moon day.

On full moon day, Krishna along with Radha rode on Hastin making every one in the village surprised.

Below is the approach / strategy Lord Krishna followed to make things happen (Here riding the dangerous Bull Hastin)

·         Every day (from the day of promising to ride the bull), Lord Krishna would spend some good quality of time understanding about the Bulls behavior.

·         He observed that Bull was always fed by 2 people who were always servicing the bull from its childhood.

·         With their permission , he would sit near the bull every day and play the flute for the bull

·         After few days bull became little tame to Lord Krishna, slowly he started feeding the bull with jiggery and straw.

·         Within a month he became close to the bull

·         On the final day he got what he has to achieve.

Lord Krishna has understood the problem ,  developed a proper strategy and executed it successfully.

This story is little modified from the source to make sure it is more related to the context

Source : http://isha.sadhguru.org/blog/yoga-meditation/history-of-yoga/krishna-and-the-raging-bull/

----------------------------------------------------------------------------
 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.

Aditi Ashok ...Lady Golfer ..Bio Data and unknown Facts

Name : Aditi Ashok
Father :Pandit Gudlamani Ashok
Mother : Maheshwari
Date of Birth : 29th March 1998
Age : 18 years
Birth Location : Bangalore, India
Sport : Golf
Coach : Steven Giuliano (Golf) and Nicolas Cabaret (Fitness)
Favorite Golfer :SEVE BALLESTEROS
Favorite course :Old Course at St. Andrews

Aditi with her father

Interesting facts

1.Ashok Aditi is the youngest player in Rio Olympics Golf Team

2.Aditi started playing at the age 5 1/2 years 

3.Aditi played her first tournament at age of 7 years 

4.Aditi turned to a professional on Jan 1st 2016 and within 8 months she is representing India in Olympics.

5.Aditi always carry some lucky charms for every match

6.Aditi has a own website http://www.aditiashok.com/

7.Aditi watched her first professional ladies golf match in year 2008.

8.Aditi has her father a caddie

9.Aditi got Arjuna Award in 2020.

10.Aditi Ashok's net worth is estimated to be between $100,000 and $1 million, with LPGA Tour Money Lenders earnings of $144,479 in 2019.

   

----------------------------------------------------------------------------
 All the messages above 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.

Sakshi makes Indians proud ..... Sakshi Quick Biodata

Name : Sakshi Malik
Father :Sukbhir Malik
Mother : Sudesh Malik
Date of Birth : 3rd Jan 1993
Age : 23 years
Birth Location : Rohtak, Haryana , India
Sport : Freestyle Wrestling
Coach : Ishwar Dahiya
Employee : Indian Railways
Major Wins
Bronze in Rio Olympics - 2016
Bronze in Doha Asian Champions -2015
Sliver in Glasgow Common wealth Games - 2014








---------------------------------------------------------------------------- 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 : Populating ownergroup with a person group a user belongs to

 Below script is used to populate a field (Owner Group) in work order application with logged in users person group.

Launch point 

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

Name : KS_OBJ_OWNERGROUP

Desc : Launch Point for User

Intialize = Y

Condition : 

Object : WORKORDER

Autoscript :

Name : KS_OWNERGROUP

Desc : Load person group

from psdi.util.logging import MXLogger

from psdi.util.logging import MXLoggerFactory

from psdi.mbo import MboConstants

from psdi.server import MXServer

logger =  MXLoggerFactory.getLogger("maximo.script");

logger.debug("====================KS_OWNERGROUP." + launchPoint + ": START  =====================")

mboServer = mbo.getMboServer()

user1 = mbo.getUserInfo()

personGroupQuery = "persongroup in (select distinct a.persongroup from persongroup a, persongroupteam b  where b.RESPPARTYGROUP = '"+user+"' and rownum<2 div="">

personGroupMboSet = mboServer.getMboSet("persongroup",user1)

personGroupMboSet.setWhere(personGroupQuery)

personGroupMboSet.reset()

if not personGroupMboSet.isEmpty():

 personGroupMbo=personGroupMboSet.getMbo(0)

 mbo.setValue("OWNERGROUP",personGroupMbo.getString("persongroup"),MboConstants.NOACCESSCHECK|MboConstants.NOVALIDATION_AND_NOACTION)

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

----------------------------------------------------------------------------
 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.

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.

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 =====================")

Ref: http://www.jython.org/archive/21/docs/jarray.html 

----------------------------------------------------------------------------
 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.

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.

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.

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.

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.

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.

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.