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