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