Integration Control

Integration control used in making conditions for processing  provides a way to match xml field or object field with particular value.

We have 4 types of integration control
1. Value 2.List 3. XRef 4.Boolean

Value control is used to compare with single value.

List control is used to compare with list of values which may come from domains.

Boolean control is true or false value used to compare yorn field I personally never used it.

XRef control i.e cross reference control is used to to swap values foe example we have different orgid in other system than we can define cross reference control inorder to translate.

We create cross reference control and associate it with enterprise service or publish channel. We can also override these values at external system level.

Maximo ESTDUR Calculation

Hi Recently I came across a requirement where I have to calculated estimated duration value based sum of planned labor for all tasks and work order.

While implementing this I came across situation where I was not getting correct /modified values of planned labors via wplabor relationship.

We should use relationship "SHOWPLANLABOR" or "SHOWTASKS" to get modified relationship.
This will give modified values instead of WPLABOR.

Maximo Invoke Publish channel using automation script

Steps

1. Create an action.
2. Create an autoscript with below code

Option 1 
from psdi.iface.mic import PublishChannelCache
PublishChannelCache.getInstance().getPublishChannel(pubChannelName).publish(mbo, true);

Option 2 

server.lookup("MIC").exportdata("MYPUBLISHCHN","MYEXTSYS","WHERECLAUSE",
useirnfo,-1)

3. Create a object strucutre and Publish channel and External System.

4. Enable Publish channel and External System.

5. Apply autoscript on that action and Run that action.

List of Maximo Applications in 7.5

   
ACTION
 
ACTIONSCFG
 
ACTIVITY
 
ACTUALCI
 
ASSET
 
ASSETCAT
 
BBOARD
 
CALENDR
 
CHANGE
 
CHANGEPSWD
 
           
CHRTACCT
 
CI
 
CITYPE
 
COLLECTION
 
COMMTMPLT
 
COMPANY
 
COMPMASTER
 
COND
 
CONDCODE
 
CONDEXPMGR
 
           
CONFIGUR
 
CONTLABOR
 
CONTLEASE
 
CONTMASTER
 
CONTPURCH
 
CONTSFW
 
CONTWARRTY
 
CRAFT
 
CREATEDR
 
CREATESR
 
           
CRONTASK
 
CURRENCY
 
DEPLGROUPS
 
DESIGNER
 
DM
 
DOMAINADM
 
DPAMADPT
 
DPAMMANU
 
DPAMOS
 
DPAMPROC
 
           
DPAMSW
 
DPAMSWS
 
DPAMSWUSG
 
DPLDASSET
 
ECOMMADAPT
 
EMAILSTNER
 
ENDPOINT
 
ESCALATION
 
EXCHANGE
 
EXTSYSTEM
 
           
FACONFIG
 
FAILURE
 
FEATURE
 
FINCNTRL
 
FORGOTPSWD
 
HAZARDS
 
IM
 
INBXCONFIG
 
INCIDENT
 
INTERROR
 
           
INTMSGTRK
 
INTOBJECT
 
INTSRV
 
INVENTOR
 
INVISSUE
 
INVOICE
 
INVOKE
 
ITEM
 
JOBPLAN
 
KPI
 
           
KPIGCONFIG
 
KPILCONFIG
 
LABOR
 
LABREP
 
LAUNCH
 
LMO
 
LOCATION
 
LOGGING
 
MASTERPM
 
METER
 
           
METERGRP
 
MULTISITE
 
NDASSET
 
NPASSET
 
PERSON
 
PERSONGR
 
PM
 
PO
 
PR
 
PRECAUTN
 
           
PROBLEM
 
PROPMAINT
 
PUBLISH
 
QUAL
 
QUICKREP
 
RCNASTLINK
 
RCNASTRSLT
 
RCNCILINK
 
RCNCIRSLT
 
RCNCMPRULE
 
           
RCNLNKRULE
 
RCNRESULT
 
RCNTSKFLTR
 
RECEIPTS
 
RECONLINK
 
RECONTASK
 
RELATION
 
RELEASE
 
REPORT
 
RFQ
 
           
ROLE
 
ROUTES
 
RSCONFIG
 
SAFEPLAN
 
SCCONFIG
 
SEARCHSOL
 
SECURGROUP
 
SELFREG
 
SETS
 
SFWLICVIEW
 
           
SLA
 
SOLUTION
 
SR
 
SRVCOMMOD
 
SRVITEM
 
STARTCNTR
 
STOREROOM
 
TAGLOCKS
 
TERMCOND
 
TKTEMPLATE
 
           
TOOL
 
TOOLINV
 
USER
 
VIEWDR
 
VIEWDRFT
 
VIEWSR
 
VIEWTMPL
 
WFADMIN
 
WFDESIGN
 
WORKMAN
 
           
WORKVIEW
 
WOTRACK
 
WSREGISTRY

Email not sending from Workflow after fix 7.5.0.11

If you are getting error in logs Unable to sendemail sendto field is readonly on fix 7.5.0.11, Please refer this IBM Link-

http://www-01.ibm.com/support/docview.wss?uid=swg22011615

Maximo what web-service to chose

Soap

1. Soap uses HTTP Post Methods or Operations.
2. Creating soap web service we get wsdl files which have data and operations.
3. Soap has overhead so should not be used for Mobile
4. Soap gives data in XML format.
5. We can create java files from Soap Web services.

Rest

1. Uses Get and Post, Put and delete function to perform options.
2.  Here we get URI using which we can perform Get,Post or Put functions.
3. Rest is lightweight.
4. Rest gives data in XML, JSON and Text.

Maximo Status change in Future date

Maximo allows us to change status in future date using select action change status but with a catch that you can't go to next status in between dates

For example

If you select change status and change statusdate from todays date to 10 days after today.  Maximo will not allow you to change another status before these 10 days.

Entry for this is done in wostatus table in status date for the 10 th day from today.

Eclipse Shortcuts

F2 :- To display java docs associated with a class or method

Ctrl D:- To remove a line.

Extract Method from lines

Select lines --> Rt. Click refractor -----------> Select Extract Method -------> It will create method from these lines

Checks before Maximo Installation

Following checks should be done before Mximo installation

1. Stop antivirus.
2. Check domain name is defined.
3. Check ports, System space is available.
4. Installers are extracted properly in drive.

Also please create installation document where you can maintain password and port details which will be helpful in case something messed up.

Formula to Check for Duplicates Records in Excel

Below is the formulae you can use to check value is duplicate or not


=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2,D$2:D2,D2,E$2:E2,E2)>1,"Duplicate Value","Not Duplicate")

Using it you highlight duplicate value with  color except first one.

Create a war file from jsp,html etc

Below is the command to create a war file

jar cfv (name of the war file) WEB-INF [*.html] [*.jsp].........

here c is create, f is file and v is verbose.

Unable to change Tool status to Obsolute, Workorder exists on this item

Hi If you are getting this  error you need to close,complete or cancel these workorders otherwise you will not be able to make this tool Obsolute.

Below are other things you can check to make tools exists so as to not get error's like that:-

1. Check Workorders exists on it or not which are not in cancelled or complete or closed status

Query

1. Workorder

select * from maximo.wpitem where itemnum='YOURTOOLNUM' and wonum in
(select wonum from maximo.wonum where status not in (SELECT MAXVALUE FROM SYNONYM domain where domainid ='WOSTATUS' AND maxvalue not in ('COMP','CLOSE','CAN'))


2. Check for invbalances

Select * from maximo.invbalances where curbal>0 and itemnum='YOURITEMNUM'

3. Check if there is any asset exist on this item

Select * from maximo.asset where  itemnum='YOURITEMNUM'

4. check for joptool

Select * from maximo.jobitem where  itemnum='YOURITEMNUM'


5. Check for MR which are not close or cancel

Select * from maximo.mrline where itemnum='YOURITEMNUM' and mrnum in
(select mrnum from maximo.mr where status not in status not in (SELECT MAXVALUE FROM MAXIMO.SYNONYM domain where domainid ='MRSTATUS' AND maxvalue not in (,'CLOSE','CAN'))

6. Check for PR

select * form maximo.prline where itemnum='YOURITEMNUM' and itemsetid='YOURITEMSITEMSETiD' and prnum in (select prnum from pr where siteid=prline.siteid and status in ( select value from MAXIMO.synonymdomain where domainid='PRSTATUS' and  maxvalue not in ('COMP', 'CAN')));

7. Check for open PO exists

select * form maximo.poline where itemnum='YOURITEMNUM' and itemsetid='YOURITEMSITEMSETID' and ponum in (select ponum from maximo.po where siteid=poline.siteid and status in ( select value from MAXIMO.synonymdomain where domainid='POSTATUS' and  maxvalue not in ('COMP', 'CAN','REVISE')));

8. Check for open Contracts

select * form maximo.ContractLine where itemnum='YOURITEMNUM' and itemsetid='YOURITEMSITEMSETID' and contractnum in (select contractnum from maximo.contract where siteid=ContractLine.siteid and status in ( select value from MAXIMO.synonymdomain where domainid='CONTRACTSTATUS' and  maxvalue not in ('COMP', 'CAN','REVISE')));

9. Check for CI exists

How to start Apache tomcat server from command prompt

Hi All below are commands to run for starting apache  tomcate server


C:\Program Files\Java\jre1.8.0_161\bin>set JAVA_HOME=C:\Program Files\Java\JDK1.
8.0_161

C:\Program Files\Java\jre1.8.0_161\bin>set CLASSPATH=C:\PROGRAM FILES\JAVA\JDK1.
8.0_161

C:\Program Files\Java\jre1.8.0_161\bin>set CATALINA_HOME=C:\Downloads
\apache-tomcat-8.5.28-windows-x64\apache-tomcat-8.5.28

C:\Program Files\Java\jre1.8.0_161\bin>C:\Downloads\apache-tomcat-8.5
.28-windows-x64\apache-tomcat-8.5.28\bin\startup.bat

Error cannot change item number because location is inventory

This is a case where you were not able to change item number of this asset from change item number.

This error comes when we use select action "change Item Number" on asset application and assets location is inventory.

To resolve this error you need to transfer this item to non inventory location using inventory usage application only.

Also you need to select asset number or given full quantity if you want to move all asset attached with same item number and complete this record then asset location will be changed to your mentioned location inventory usage line.

Then you will be able to change item no. on asset application.

Tomcat error The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.

One reason of it will be you have not put your jsp file in webcontent folder of you dynamic web project.

How to check methods we can import in eclipse

Open class in which  you want  to import methods.

Rt. click select source option ---> Override / Implement Methods -->select method you want to override from parent or parent's parent class.

Company is not valid when adjusting inventory balance

This error could come when user's site is not matching item's vendor site.

SQL developer error code vendor error 17002

Go to services and start  required oracle services

How to generate stup files from WSDL

TO generate wsdl files from stub use following procedure
Go to bin directory in cmd prompt
C:\Program Files\Java\jdk1.8.0_161\bin

Enter command

WSIMPORT <Your wsdl Path?WSDL>

If you recieve error for space in program space files

use this command

Go to D:

"C:\Program Files\Java\jdk1.8.0_161\bin" -Keep <Your wsdl Path?WSDL>

To define path where you want your files to be placed

use

wdimport "C:\Program Files\Java\jdk1.8.0_161\bin" -Keep -s D:\MyProject <Your wsdl Path?WSDL>

Skip Copy Field Method

This method is used to skip certain attributes on duplication.

@Override
protected boolean skipCopyField(MboValueInfo arg0) throws RemoteException,
MXException {
// TODO Auto-generated method stub
boolean b=super.skipCopyField(arg0);
String attributeName=arg0.getAttributeName();
for (int i = 0; i < dup.length; i++) {
if(dup[i].equalsIgnoreCase(attributeName))
return true;
}

return b;


}

MboSet.SetValueNull(AttributeName,accessmodifiers) used to set current mbo's value to null

SetValueNull(Attributename) and setValueNull(Attributename,accessmodifiers) this is method is used to set current mbo's value to null it is a misconception that it will set all values of mboset to Null.

Creating button to make workorder to WSCH status

You need to extend statefull bean class for this

Sample class would be

package custom.webclient.beans.workorder;

import java.rmi.RemoteException;

import psdi.mbo.MboSetRemote;
import psdi.mbo.StatefulMboRemote;
import psdi.util.MXApplicationException;
import psdi.util.MXException;
import psdi.webclient.system.beans.DataBean;

public class CustStatefulAppBean extends StatefulAppBean {

public int WSCH() throws RemoteException, MXException {

DataBean db = app.getAppBean();
StatefulMboRemote mbo = (StatefulMboRemote) db.getMbo();
targetStatusOption = "WPCOND";
statusChangeButtonSigoption = "WPCOND";
mbo.setTargetStatusOption("WPCOND");
mbo.setStatusChangeButtonSigoption("WPCOND");
STATUSSUB();
clientSession.loadDialog("status");

return 1;
}

          public int STATUSSUB() throws MXException, RemoteException {
     DataBean appBean = app.getAppBean();
   StatefulMboRemote statefullRemote = (StatefulMboRemote)appBean.getMbo();
   if (app.onListTab())
             {
      statefullRemote.setOnListTab(true);
             }
             else
             {
     statefullRemote.setOnListTab(false);
       MboSetRemote statuslist = statefullRemote.getValidStatusList();
 if (statuslist.getMbo(0) == null)
      {
          statefullRemote.setTargetStatusOption(null);
      targetStatusOption = null;
        throw new MXApplicationException("system", "StatusChangeNotAllowed");
               }
             }
     return 2;
           }



}

Rewritting in Customization

Quite often peple write redundant code

Example

MboSetRemote invoiceLineSet=invoice.getMboSet("invoiceline");
if(invoiceLine.isEmpty()){
MboRemote invoiceLineMbo=invoiceLineSet.moveFirst();
while (invoiceLineMbo!=null) {
Long constransId=invoiceLineMbo.getLong("CONSTRANSID");
if(constransId>0)
{
StringBuilder sb=new StringBuilder();
sb.append(String.ValueOf(constransId));

}

}



Here this line if(invoiceLine.isEmpty()){ is not nacessary because we are not taking string value of out of mboset or calling any moethod  from it

sb.append(String.ValueOf(constransId)); this is also not required because sb.append method can handle Long values.

Textbox with Multiple values

To configure text to take multiple values as query you can either right a bean class for dialog or you can do this :-

<textbox dataattribute="persongroup" id="PersongGroupId1" inputmode="query" label="Person Group"

Query to Create New Synonym domain

Create Maxdomain :---------

insert into maxdomain
( domainid, description, domaintype, maxtype, length,
scale, maxdomainid, internal, rowstamp)
values
('APPSTATUS', 'App Status', 'SYNONYM', 'UPPER', 20,
0, maxdomainseq.nextval, 1, maxseq.nextval)
;

Query for inserting values in domain

insert into synonymdomain
( domainid, maxvalue, value, description, defaults,
siteid, orgid, synonymdomainid, valueid, rowstamp)
values
('APPSTATUS', 'WAPPR', 'WAPPR', 'Waiting on Approval', 1,
null, null, synonymdomainseq.nextval, 'APPSTATUS|WAPPR', maxseq.nextval)
;

Apprestriction

In Maximo Application XML you can restrict records to be display in list tab

For example to restrict records of workorder you can use

<presentation apphelp="com.ibm.mbs.doc,wotrack/c_wo_tracking_application.html"
 apprestriction="status!='CAN'"
beanclass="psdi.plusp.webclient.beans.pluspwo.PlusPWorkorderAppBean" id="wotrack" mboname="WORKORDER" resultstableid="results_showlist" version="7.1.0.0">

Reciept Tolerance

We can specify receipt tolerance for an item in item application. This will allow us to receipt  Item more than we define on Po line.

Steps

1. Specify reciept tolerance for an item and vendor details for example 10.
2. Create a PO and select vendor specified above, select vendor items to create POLINE with central as storeroom.Specify quantity as 100
3. Approve PO and Go to recieving application and select above and recieve those items. 
4. On recieving enter quantity 120 and select OK. Maximo displays a message Quantity specified on PO is greater and quantity ordered and reciept tolerance by 10 Click "OK" to receive 110 Qty.
5. Go ahead and Create an invoice on this PO an approve it with quantity 110
6. Go to invoice main tab and you will be able to see invoice amount .Also you will be able to see univoiced quantity which is for those 10 extra items you recieved.

Calculation of Uninvoiced Amount is 

Uninvoice Cost=PoTotalCost-InvoiceTotalCost

We can specify receipt tolerace in POLine table , itemvendor table, item/org details table, inventory table, service items .

Measurement Point Cron Not generating Workorder

Reason can be

1. Job plan not active
2. Site is not enabled  for Condition Monitoring WO gen..
3. Admin Email or vars 'AUTOMPWOGEN', 'MPWOGENEMAIL', 'MPWOGENUSECRITERIA' not specified  or Log file  access for users is not there .
4. PM  not active.
5. Asset is not in desired status.


To get More see data from below Queries


select * from maximo.maxvars where varname in ('AUTOMPWOGEN', 'MPWOGENEMAIL', 'MPWOGENUSECRITERIA')

select * from maximo.MEASUREPOINT ;

select * from maximo.pointwo;

select * from maximo.measurement

select * from maximo.CHARPOINTACTION

Maximo eclipse setup error type org.jdom.Element cannot be resolved.

To Resolve this error you need to configure build path and include jars inside Maximo\lib  and other jars like business objects.jar etc.

Create Inventory Usage Records from workorder

Go to Organiation and set inventory defaults to automatic create inventory reservation records.

Create a workorder and it will create inventory Usage  record in Maximo when you approve workorder.

InvreserveUpdate Cron will make automatic order to APHARD or APSOFT.

When you approve workorder it will create records in INVRESERVE table.

Once you complete Inventory Usage record and Complete it this will delete records from INVRESERVE Table.


You can also create an invusage record to transfer one item from one storeroom to another.

For this you need to select usage type as Transfer then only you can specify to storeroom value.

Once specified you can either change status to complete or change status to shipment when you change status shipment you need to go to shipment recieving application to complete shipment for this record. Check balance of your new storeroom for verifying values are updated or not.

It will also create a record in matrectrans with issuetype SHIPRECEIPT and SHIPTRANSFER


If you completed inventory usage record without shipment it will create a matrectrans record with ISSUETYPE TRANSFER

When Transferring item through cross you may get this error

BMXAA7691E - The status of inventory usage 1020 cannot be changed to COMPLETE.
BMXAA7791E - To transfer the items, you must create a shipment.


This is one of the organisation transfer option to transfer item from one site to another requires shipment receiving.

Oracle db connect error initialization or shutdown in progress error code 1033

steps

Open SQL PLUS and run below commands

1. logon as sysdba/admin
2. shutdown immediate
3. startup
4. recover database
5. alter database open

Maximo ways to create Invoice

Hi Following are ways to create invoice in Maximo :-

1. Create a PO and select pay on receipt, select items non consignment and receive those item. In receipt you can check invoice.

2. Return one of item it will again create a credit invoice.

3. Create a item and add it to inventory and check consignment option  and add vendor and type in consignment details option

Type

1. Consumption
2. Manual
3. Frequency

For all type you can create an invoice. Select consumption for now.


For consumption, create a WO and in actuals enter above item, this will create a invoice.

4. Select frequency in type field

Active consignment cron and add item to actuals. This will create a invoice.

5. Select Manual and create a invoice and select consignment item option in invoice line for this you can create a inventory usage record.

6. Create a Po and receive it and create invoice for this PO.

7. Create invoice for labor transaction based on contract.

8. Adjust balance of consigment item.

9. Update physical count and reconcile balance.

10 Create inventory usage record for consignment item(issue,return and adjustment)

To Be Continued...................

Location for Maximo Logs in Weblogic server

Maximo Logs location in weblogic server

here server name is admin server

C:\Oracle\Middleware\user_projects\domains\base_domain\servers\AdminServer\logs

Maximo.log file location

C:\Oracle\Middleware\user_projects\domains\base_domain\maximo\logs

If a workorder is deleted how to identify who delete this workorder

I maximo we can use audit table to identify who delete this record.

You can check W_AUDIT table for check this, entries will be created based on filter condition you apply in database configuration for this record.

Here we can see type of change like I for insert, D for Delete and U for update.

Interface table integration

Points on interface table integratio :-

1. While doing interface table integration we will create interface table.
2. Maximo Iface table cron pics data from this table and process them based on MXOUT_INTER_TRANS table accordingly.
3. When you make any change in obj structure, you need to recreate interface table.
4. While creating interface table again if you check rename option interface table creates backup table with interfacename_back.
5. Data will no delete from MXOUT_INTER_TRANS table when you regenerate interface table.
6. Interface table can also be seen as a object in database configuration.

Advance Configuration in Integration Framework

Exclude parent key attributes : This will exclude parent's key attributes in child object

Create a objectstructure with asset and spareparts as object.

Create publish channel and configure outbound transaction.

XML where parent key are excluded

<?xml version="1.0" encoding="UTF-8"?>
<max:CreateBOSASSET xmlns:max="http://www.ibm.com/maximo" creationDateTime="2008-09-29T07:19:45" baseLanguage="string" transLanguage="string" messageID="string" maximoVersion="string">
  <max:BOSASSETSet>
    <max:ASSET action="Delete" relationship="string" deleteForInsert="string" transLanguage="string">
      <max:MAXINTERRORMSG>string</max:MAXINTERRORMSG>
      <max:AMCREW changed="true">string</max:AMCREW>
      <max:ANCESTOR changed="true">string</max:ANCESTOR>
      <max:ASSETID changed="true">10</max:ASSETID>
      <max:ASSETNUM changed="false">string</max:ASSETNUM>
      <max:ASSETTAG changed="false">string</max:ASSETTAG>
      <max:ASSETTYPE maxvalue="string" changed="false">string</max:ASSETTYPE>
      <max:ASSETUID changed="true">10</max:ASSETUID>
      <max:AUTOWOGEN changed="true">false</max:AUTOWOGEN>
      <max:BINNUM changed="true">string</max:BINNUM>
      <max:BUDGETCOST changed="false">1.051732E7</max:BUDGETCOST>
      <max:CALNUM changed="false">string</max:CALNUM>
      <max:CHANGEBY changed="false">string</max:CHANGEBY>
      <max:CHANGEDATE changed="false">2009-10-14T12:46:36</max:CHANGEDATE>
      <max:CHILDREN changed="false">true</max:CHILDREN>
      <max:CLASSSTRUCTUREID changed="true">string</max:CLASSSTRUCTUREID>
      <max:CONDITIONCODE changed="true">string</max:CONDITIONCODE>
      <max:DEFAULTREPFAC changed="true">string</max:DEFAULTREPFAC>
      <max:DEFAULTREPFACSITEID changed="false">string</max:DEFAULTREPFACSITEID>
      <max:DESCRIPTION changed="false">string</max:DESCRIPTION>
      <max:DIRECTION maxvalue="string" changed="true">string</max:DIRECTION>
      <max:DISABLED changed="false">false</max:DISABLED>
      <max:ENDDESCRIPTION changed="false">string</max:ENDDESCRIPTION>
      <max:ENDMEASURE changed="false">1.051732E7</max:ENDMEASURE>
      <max:EQ1 changed="true">string</max:EQ1>
      <max:EQ10 changed="true">string</max:EQ10>
      <max:EQ11 changed="false">string</max:EQ11>
      <max:EQ12 changed="true">1.051732E7</max:EQ12>
      <max:EQ2 changed="false">string</max:EQ2>
      <max:EQ23 changed="true">2015-11-05T10:17:14</max:EQ23>
      <max:EQ24 changed="false">1.051732E7</max:EQ24>
      <max:EQ3 changed="true">string</max:EQ3>
      <max:EQ4 changed="true">string</max:EQ4>
      <max:EQ5 changed="false">1.051732E7</max:EQ5>
      <max:EQ6 changed="false">2000-07-29T06:54:48+05:30</max:EQ6>
      <max:EQ7 changed="true">1.051732E7</max:EQ7>
      <max:EQ8 changed="true">string</max:EQ8>
      <max:EQ9 changed="true">string</max:EQ9>
      <max:EXTERNALREFID changed="true">string</max:EXTERNALREFID>
      <max:FAILURECODE changed="false">string</max:FAILURECODE>
      <max:GLACCOUNT changed="false">
        <max:VALUE>string</max:VALUE>
        <max:GLCOMP glorder="3">string</max:GLCOMP>
      </max:GLACCOUNT>
      <max:GROUPNAME changed="false">string</max:GROUPNAME>
      <max:INSTALLDATE changed="false">2004-12-06T09:11:44+05:30</max:INSTALLDATE>
      <max:INVCOST changed="true">1.051732E7</max:INVCOST>
      <max:ISCALIBRATION changed="true">true</max:ISCALIBRATION>
      <max:ISLINEAR changed="true">false</max:ISLINEAR>
      <max:ISRUNNING changed="true">true</max:ISRUNNING>
      <max:ITEMNUM changed="true">string</max:ITEMNUM>
      <max:ITEMSETID changed="true">string</max:ITEMSETID>
      <max:ITEMTYPE changed="false">string</max:ITEMTYPE>
      <max:LOCATION changed="true">string</max:LOCATION>
      <max:LRM changed="false">string</max:LRM>
      <max:MAINTHIERCHY changed="true">true</max:MAINTHIERCHY>
      <max:MANUFACTURER changed="true">string</max:MANUFACTURER>
      <max:MOVED changed="true">false</max:MOVED>
      <max:ORGID changed="true">string</max:ORGID>
      <max:OWNERSYSID changed="true">string</max:OWNERSYSID>
      <max:PARENT changed="true">string</max:PARENT>
      <max:PLUSCASSETDEPT changed="false">string</max:PLUSCASSETDEPT>
      <max:PLUSCCLASS changed="true">string</max:PLUSCCLASS>
      <max:PLUSCDUEDATE changed="false">2009-07-29T00:44:45</max:PLUSCDUEDATE>
      <max:PLUSCISCONDESC changed="true">string</max:PLUSCISCONDESC>
      <max:PLUSCISCONTAM changed="false">true</max:PLUSCISCONTAM>
      <max:PLUSCISINHOUSECAL changed="false">true</max:PLUSCISINHOUSECAL>
      <max:PLUSCISMTE changed="true">false</max:PLUSCISMTE>
      <max:PLUSCISMTECLASS changed="false">string</max:PLUSCISMTECLASS>
      <max:PLUSCLOOPNUM changed="false">string</max:PLUSCLOOPNUM>
      <max:PLUSCLPLOC changed="false">string</max:PLUSCLPLOC>
      <max:PLUSCMODELNUM changed="false">string</max:PLUSCMODELNUM>
      <max:PLUSCOPRGEEU changed="true">string</max:PLUSCOPRGEEU>
      <max:PLUSCOPRGEFROM changed="true">string</max:PLUSCOPRGEFROM>
      <max:PLUSCOPRGETO changed="true">string</max:PLUSCOPRGETO>
      <max:PLUSCPHYLOC changed="true">string</max:PLUSCPHYLOC>
      <max:PLUSCPMEXTDATE changed="true">false</max:PLUSCPMEXTDATE>
      <max:PLUSCSOLUTION changed="true">true</max:PLUSCSOLUTION>
      <max:PLUSCSUMDIR maxvalue="string" changed="true">string</max:PLUSCSUMDIR>
      <max:PLUSCSUMEU changed="true">string</max:PLUSCSUMEU>
      <max:PLUSCSUMREAD changed="false">string</max:PLUSCSUMREAD>
      <max:PLUSCSUMSPAN changed="true">string</max:PLUSCSUMSPAN>
      <max:PLUSCSUMURV changed="false">string</max:PLUSCSUMURV>
      <max:PLUSCVENDOR changed="false">string</max:PLUSCVENDOR>
      <max:PLUSPCOSTCENTER changed="false">string</max:PLUSPCOSTCENTER>
      <max:PLUSPCUSTCHACCT changed="true">string</max:PLUSPCUSTCHACCT>
      <max:PLUSPCUSTOMER changed="false">string</max:PLUSPCUSTOMER>
      <max:PRIORITY changed="true">10</max:PRIORITY>
      <max:PURCHASEPRICE changed="false">1.051732E7</max:PURCHASEPRICE>
      <max:REPLACECOST changed="true">1.051732E7</max:REPLACECOST>
      <max:RETURNEDTOVENDOR changed="true">true</max:RETURNEDTOVENDOR>
      <max:ROTSUSPACCT changed="true">
        <max:VALUE>string</max:VALUE>
        <max:GLCOMP glorder="3">string</max:GLCOMP>
      </max:ROTSUSPACCT>
      <max:SADDRESSCODE changed="true">string</max:SADDRESSCODE>
      <max:SENDERSYSID changed="true">string</max:SENDERSYSID>
      <max:SERIALNUM changed="false">string</max:SERIALNUM>
      <max:SHIFTNUM changed="false">string</max:SHIFTNUM>
      <max:SITEID changed="true">string</max:SITEID>
      <max:SOURCESYSID changed="false">string</max:SOURCESYSID>
      <max:STARTDESCRIPTION changed="true">string</max:STARTDESCRIPTION>
      <max:STARTMEASURE changed="true">1.051732E7</max:STARTMEASURE>
      <max:STATUS maxvalue="string" changed="true">string</max:STATUS>
      <max:STATUSDATE changed="true">2010-06-27T01:27:51+05:30</max:STATUSDATE>
      <max:TEMPLATEID changed="false">string</max:TEMPLATEID>
      <max:TLOAMHASH changed="true">string</max:TLOAMHASH>
      <max:TLOAMPARTITION changed="false">false</max:TLOAMPARTITION>
      <max:TOOLCONTROLACCOUNT changed="false">
        <max:VALUE>string</max:VALUE>
        <max:GLCOMP glorder="3">string</max:GLCOMP>
      </max:TOOLCONTROLACCOUNT>
      <max:TOOLRATE changed="false">1.051732E7</max:TOOLRATE>
      <max:TOTALCOST changed="false">1.051732E7</max:TOTALCOST>
      <max:TOTDOWNTIME changed="true">1.051732E7</max:TOTDOWNTIME>
      <max:TOTUNCHARGEDCOST changed="true">1.051732E7</max:TOTUNCHARGEDCOST>
      <max:UNCHARGEDCOST changed="true">1.051732E7</max:UNCHARGEDCOST>
      <max:USAGE changed="true">string</max:USAGE>
      <max:VENDOR changed="false">string</max:VENDOR>
      <max:WARRANTYEXPDATE changed="false">2012-11-05T05:54:55+05:30</max:WARRANTYEXPDATE>
      <max:YTDCOST changed="false">1.051732E7</max:YTDCOST>
      <max:SPAREPART action="Replace" relationship="string" deleteForInsert="string">
        <max:DESCRIPTION changed="false">string</max:DESCRIPTION>
        <max:ISSUEDQTY changed="false">1.051732E7</max:ISSUEDQTY>
        <max:ITEMNUM changed="false">string</max:ITEMNUM>
        <max:ITEMSETID changed="true">string</max:ITEMSETID>
        <max:ORGID changed="true">string</max:ORGID>
        <max:QUANTITY changed="true">1.051732E7</max:QUANTITY>
        <max:SPAREPARTID changed="false">10</max:SPAREPARTID>
      </max:SPAREPART>
    </max:ASSET>
  </max:BOSASSETSet>
</max:CreateBOSASSET>


No uncheck this checkbox

XML after this

p\__edp_clip__825eaafe-4180-43a1-945d-088f0ea4a820

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

<?xml version="1.0" encoding="UTF-8"?>

<max:CreateBOSASSET xmlns:max="http://www.ibm.com/maximo" creationDateTime="2008-09-29T07:19:45" baseLanguage="string" transLanguage="string" messageID="string" maximoVersion="string">

  <max:BOSASSETSet>

    <max:ASSET action="Delete" relationship="string" deleteForInsert="string" transLanguage="string">

      <max:MAXINTERRORMSG>string</max:MAXINTERRORMSG>

      <max:AMCREW changed="true">string</max:AMCREW>

      <max:ANCESTOR changed="true">string</max:ANCESTOR>

      <max:ASSETID changed="true">10</max:ASSETID>

      <max:ASSETNUM changed="false">string</max:ASSETNUM>

      <max:ASSETTAG changed="false">string</max:ASSETTAG>

      <max:ASSETTYPE maxvalue="string" changed="false">string</max:ASSETTYPE>

      <max:ASSETUID changed="true">10</max:ASSETUID>

      <max:AUTOWOGEN changed="true">false</max:AUTOWOGEN>

      <max:BINNUM changed="true">string</max:BINNUM>

      <max:BUDGETCOST changed="false">1.051732E7</max:BUDGETCOST>

      <max:CALNUM changed="false">string</max:CALNUM>

      <max:CHANGEBY changed="false">string</max:CHANGEBY>

      <max:CHANGEDATE changed="false">2009-10-14T12:46:36</max:CHANGEDATE>

      <max:CHILDREN changed="false">true</max:CHILDREN>

      <max:CLASSSTRUCTUREID changed="true">string</max:CLASSSTRUCTUREID>

      <max:CONDITIONCODE changed="true">string</max:CONDITIONCODE>

      <max:DEFAULTREPFAC changed="true">string</max:DEFAULTREPFAC>

      <max:DEFAULTREPFACSITEID changed="false">string</max:DEFAULTREPFACSITEID>

      <max:DESCRIPTION changed="false">string</max:DESCRIPTION>

      <max:DIRECTION maxvalue="string" changed="true">string</max:DIRECTION>

      <max:DISABLED changed="false">false</max:DISABLED>

      <max:ENDDESCRIPTION changed="false">string</max:ENDDESCRIPTION>

      <max:ENDMEASURE changed="false">1.051732E7</max:ENDMEASURE>

      <max:EQ1 changed="true">string</max:EQ1>

      <max:EQ10 changed="true">string</max:EQ10>

      <max:EQ11 changed="false">string</max:EQ11>

      <max:EQ12 changed="true">1.051732E7</max:EQ12>

      <max:EQ2 changed="false">string</max:EQ2>

      <max:EQ23 changed="true">2015-11-05T10:17:14</max:EQ23>

      <max:EQ24 changed="false">1.051732E7</max:EQ24>

      <max:EQ3 changed="true">string</max:EQ3>

      <max:EQ4 changed="true">string</max:EQ4>

      <max:EQ5 changed="false">1.051732E7</max:EQ5>

      <max:EQ6 changed="false">2000-07-29T06:54:48+05:30</max:EQ6>

      <max:EQ7 changed="true">1.051732E7</max:EQ7>

      <max:EQ8 changed="true">string</max:EQ8>

      <max:EQ9 changed="true">string</max:EQ9>

      <max:EXTERNALREFID changed="true">string</max:EXTERNALREFID>

      <max:FAILURECODE changed="false">string</max:FAILURECODE>

      <max:GLACCOUNT changed="false">

        <max:VALUE>string</max:VALUE>

        <max:GLCOMP glorder="3">string</max:GLCOMP>

      </max:GLACCOUNT>

      <max:GROUPNAME changed="false">string</max:GROUPNAME>

      <max:INSTALLDATE changed="false">2004-12-06T09:11:44+05:30</max:INSTALLDATE>

      <max:INVCOST changed="true">1.051732E7</max:INVCOST>

      <max:ISCALIBRATION changed="true">true</max:ISCALIBRATION>

      <max:ISLINEAR changed="true">false</max:ISLINEAR>

      <max:ISRUNNING changed="true">true</max:ISRUNNING>

      <max:ITEMNUM changed="true">string</max:ITEMNUM>

      <max:ITEMSETID changed="true">string</max:ITEMSETID>

      <max:ITEMTYPE changed="false">string</max:ITEMTYPE>

      <max:LOCATION changed="true">string</max:LOCATION>

      <max:LRM changed="false">string</max:LRM>

      <max:MAINTHIERCHY changed="true">true</max:MAINTHIERCHY>

      <max:MANUFACTURER changed="true">string</max:MANUFACTURER>

      <max:MOVED changed="true">false</max:MOVED>

      <max:ORGID changed="true">string</max:ORGID>

      <max:OWNERSYSID changed="true">string</max:OWNERSYSID>

      <max:PARENT changed="true">string</max:PARENT>

      <max:PLUSCASSETDEPT changed="false">string</max:PLUSCASSETDEPT>

      <max:PLUSCCLASS changed="true">string</max:PLUSCCLASS>

      <max:PLUSCDUEDATE changed="false">2009-07-29T00:44:45</max:PLUSCDUEDATE>

      <max:PLUSCISCONDESC changed="true">string</max:PLUSCISCONDESC>

      <max:PLUSCISCONTAM changed="false">true</max:PLUSCISCONTAM>

      <max:PLUSCISINHOUSECAL changed="false">true</max:PLUSCISINHOUSECAL>

      <max:PLUSCISMTE changed="true">false</max:PLUSCISMTE>

      <max:PLUSCISMTECLASS changed="false">string</max:PLUSCISMTECLASS>

      <max:PLUSCLOOPNUM changed="false">string</max:PLUSCLOOPNUM>

      <max:PLUSCLPLOC changed="false">string</max:PLUSCLPLOC>

      <max:PLUSCMODELNUM changed="false">string</max:PLUSCMODELNUM>

      <max:PLUSCOPRGEEU changed="true">string</max:PLUSCOPRGEEU>

      <max:PLUSCOPRGEFROM changed="true">string</max:PLUSCOPRGEFROM>

      <max:PLUSCOPRGETO changed="true">string</max:PLUSCOPRGETO>

      <max:PLUSCPHYLOC changed="true">string</max:PLUSCPHYLOC>

      <max:PLUSCPMEXTDATE changed="true">false</max:PLUSCPMEXTDATE>

      <max:PLUSCSOLUTION changed="true">true</max:PLUSCSOLUTION>

      <max:PLUSCSUMDIR maxvalue="string" changed="true">string</max:PLUSCSUMDIR>

      <max:PLUSCSUMEU changed="true">string</max:PLUSCSUMEU>

      <max:PLUSCSUMREAD changed="false">string</max:PLUSCSUMREAD>

      <max:PLUSCSUMSPAN changed="true">string</max:PLUSCSUMSPAN>

      <max:PLUSCSUMURV changed="false">string</max:PLUSCSUMURV>

      <max:PLUSCVENDOR changed="false">string</max:PLUSCVENDOR>

      <max:PLUSPCOSTCENTER changed="false">string</max:PLUSPCOSTCENTER>

      <max:PLUSPCUSTCHACCT changed="true">string</max:PLUSPCUSTCHACCT>

      <max:PLUSPCUSTOMER changed="false">string</max:PLUSPCUSTOMER>

      <max:PRIORITY changed="true">10</max:PRIORITY>

      <max:PURCHASEPRICE changed="false">1.051732E7</max:PURCHASEPRICE>

      <max:REPLACECOST changed="true">1.051732E7</max:REPLACECOST>

      <max:RETURNEDTOVENDOR changed="true">true</max:RETURNEDTOVENDOR>

      <max:ROTSUSPACCT changed="true">

        <max:VALUE>string</max:VALUE>

        <max:GLCOMP glorder="3">string</max:GLCOMP>

      </max:ROTSUSPACCT>

      <max:SADDRESSCODE changed="true">string</max:SADDRESSCODE>

      <max:SENDERSYSID changed="true">string</max:SENDERSYSID>

      <max:SERIALNUM changed="false">string</max:SERIALNUM>

      <max:SHIFTNUM changed="false">string</max:SHIFTNUM>

      <max:SITEID changed="true">string</max:SITEID>

      <max:SOURCESYSID changed="false">string</max:SOURCESYSID>

      <max:STARTDESCRIPTION changed="true">string</max:STARTDESCRIPTION>

      <max:STARTMEASURE changed="true">1.051732E7</max:STARTMEASURE>

      <max:STATUS maxvalue="string" changed="true">string</max:STATUS>

      <max:STATUSDATE changed="true">2010-06-27T01:27:51+05:30</max:STATUSDATE>

      <max:TEMPLATEID changed="false">string</max:TEMPLATEID>

      <max:TLOAMHASH changed="true">string</max:TLOAMHASH>

      <max:TLOAMPARTITION changed="false">false</max:TLOAMPARTITION>

      <max:TOOLCONTROLACCOUNT changed="false">

        <max:VALUE>string</max:VALUE>

        <max:GLCOMP glorder="3">string</max:GLCOMP>

      </max:TOOLCONTROLACCOUNT>

      <max:TOOLRATE changed="false">1.051732E7</max:TOOLRATE>

      <max:TOTALCOST changed="false">1.051732E7</max:TOTALCOST>

      <max:TOTDOWNTIME changed="true">1.051732E7</max:TOTDOWNTIME>

      <max:TOTUNCHARGEDCOST changed="true">1.051732E7</max:TOTUNCHARGEDCOST>

      <max:UNCHARGEDCOST changed="true">1.051732E7</max:UNCHARGEDCOST>

      <max:USAGE changed="true">string</max:USAGE>

      <max:VENDOR changed="false">string</max:VENDOR>

      <max:WARRANTYEXPDATE changed="false">2012-11-05T05:54:55+05:30</max:WARRANTYEXPDATE>

      <max:YTDCOST changed="false">1.051732E7</max:YTDCOST>

      <max:SPAREPART action="Replace" relationship="string" deleteForInsert="string">

        <max:ASSETNUM changed="false">string</max:ASSETNUM>

        <max:DESCRIPTION changed="false">string</max:DESCRIPTION>

        <max:ISSUEDQTY changed="false">1.051732E7</max:ISSUEDQTY>

        <max:ITEMNUM changed="true">string</max:ITEMNUM>

        <max:ITEMSETID changed="true">string</max:ITEMSETID>

        <max:ORGID changed="true">string</max:ORGID>

        <max:QUANTITY changed="false">1.051732E7</max:QUANTITY>

        <max:SITEID changed="true">string</max:SITEID>

        <max:SPAREPARTID changed="true">10</max:SPAREPARTID>

      </max:SPAREPART>

    </max:ASSET>

  </max:BOSASSETSet>

</max:CreateBOSASSET>

Difference 

Propogate Event :- No transaction happen when a child object is created in case we uncheck propogate Event.

Uncheck propogate event option and create a sparepart and you will not get messages in global directory.

How to connect to cognos with oracle database

Step 1. Create new databasource

Give this details

connection name : test

SID : database name
servername : localhost
PORT : 1521


Define userid and password by checking signon check box.

Click next

Define descriptor like

(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracledb)
    )
  )


Click text connection.

What is location of Oracle tnsname file

To connect with oracle database we may require tnsname.ora file present in this location
%User%virtual\product\12.2.0\dbhome_1\network\admin.......................


It has connection string like

ORACLEDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracledb)
    )
  )