Our Maximo

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"

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

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

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 Specify reciept tolerance for an item and vendor details for example 10. Create a PO and select vendor specified above, select vendor items to create POLINE with central as storeroom.Specify quantity as 100 Approve PO and Go to recieving application and select above and recieve those items.  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. Go ahead and Create an invoice on this PO an approve it with quantity 110 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 tolera

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

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

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 a

steps Open SQL PLUS and run below commands logon as sysdba/admin shutdown immediate startup recover database alter database open

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 consigmen

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

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.

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.

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 ch

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.

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