Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



re: Need Help on Maximo 6.2 interface tables

From: ewald caspari 2 (2013-01-07 15:19)

Hi,
if I understand your mail right, you have your SR exported after the import of
your data. And now you want the user changes reflected on your exported SR.
Maximo will not do this. A record which is exported will never be changed by
maximo, instead a new record with the changed data is exported. Your destination
system (external system) is responsible to update the received data with the
second record.
hth
Ewald
-----------------------------
Hi All,
I need help on my user requirement for interface tables.
Did below successfully (done).
- Insert the data into Maximo.MXIN_INTER_TRANS & Maximo.MISR_IFACE tables
- Maximo will run cron job and create SRs in the system, at the same time data
will be deleted from Maximo.MXIN_INTER_TRANS table
- Once SRs created, a reference data row (new row) will be added to
Maximo.MXOUT_INTER_TRANS table with unique transid and the same time a new row
will be added to Maximo.MISR_IFACE table with SR Status and Status Date.
- For Each status change on SR, a new row will be added to iface and out bound
the tables.
Now Users will create workorder manually for respective SR.
Requirement is : update workorder number, wo# status and wo# status date to SR
in the interface table or outbound table.
this one we need to update in MISR_Iface table or MXOUT_Inter_trans table?
in both the tables no fields are available.
We need to create new fields for wo#, wo# status?
is there any way to update without any custom class file or what is the best way
to update?
Basically I never worked on integration interface table.
we working on Maximo 6.2
Thanks in advance for your kind info
Regards