Maximo Open Forum

We have a scenarios where inbound cost management data being sent from external system , this data wont have any specific values for orgid and sited but within maximo we maintain domain to devise siteid,orgid for this inbound data based on one value within the message being sent. But as we can map to multiple sites and organization for one inbound message how can be have 
1. insert the records multiple times for each orgid/sited
2. udpate in case recrod exists for all of them

we are trying to add this logic at Object Structure or Enterprise service layer automation scripts
Its Maximo 71.6.1.2

Kindly suggest as we are getting incorrect number of records being inserted with combination of beforeCreateMboSet(ctx) and preSaveRules methods at OS layer

Thanks in advance.
#Integrations

------------------------------
PDB
Google
------------------------------

Hi Prashant, 

This is a great question! @Alex Walter or @Steven Shull - do you have any thoughts on his question?​​

------------------------------
Annie Moncure
Projetech
------------------------------

Prashant,

I'm not exactly sure what the issue is. Can you explain what the before/after scenarios are and what the code needs to do to properly handle the org/site data?

Thanks,
Alex

------------------------------
Alex Walter
A3J Group LLC
------------------------------

Hi Alex,

SAP sends one record and it has ABC value from which we identify within maximo how many site/org combination we need add data sent by SAP 1 rwo into multiple records
and its causing some glitch in code and inconsistent

------------------------------
Prashant Bavane
CTS
------------------------------

Original Message:
Sent: 10-19-2020 18:49
From: Alex Walter
Subject: Maximo inbound integration

Prashant,

I'm not exactly sure what the issue is. Can you explain what the before/after scenarios are and what the code needs to do to properly handle the org/site data?

Thanks,
Alex

------------------------------
Alex Walter
A3J Group LLC
------------------------------

Hi Prashant.

It seems like Multiplication Control in Enterprise Services provides the functionality you are looking for. If you have a more complex logic, then Automation Scripts would likely be the best way to accomplish it.

Could you elaborate on the behaviour you are getting using automation scripts? 

Thanks,
Daniel

------------------------------
Daniel Torrescusa
Piensa en nube
------------------------------

Original Message:
Sent: 10-20-2020 02:58
From: Prashant Bavane
Subject: Maximo inbound integration

Hi Alex,

SAP sends one record and it has ABC value from which we identify within maximo how many site/org combination we need add data sent by SAP 1 rwo into multiple records
and its causing some glitch in code and inconsistent

------------------------------
Prashant Bavane
CTS
------------------------------


Original Message:
Sent: 10-19-2020 18:49
From: Alex Walter
Subject: Maximo inbound integration

Prashant,

I'm not exactly sure what the issue is. Can you explain what the before/after scenarios are and what the code needs to do to properly handle the org/site data?

Thanks,
Alex

------------------------------
Alex Walter
A3J Group LLC

Hi Daniel,

Thanks for sharing this. I didn't know about this multiplication control. 
Learnt something new! Great to see the amount knowledge that is shared in this community and IBM's Maximo community.

Thanks again!

------------------------------
Biplab Choudhury
Tata Consultancy Services
------------------------------

Original Message:
Sent: 10-20-2020 15:12
From: Daniel Torrescusa
Subject: Maximo inbound integration

Hi Prashant.

It seems like Multiplication Control in Enterprise Services provides the functionality you are looking for. If you have a more complex logic, then Automation Scripts would likely be the best way to accomplish it.

Could you elaborate on the behaviour you are getting using automation scripts? 

Thanks,
Daniel

------------------------------
Daniel Torrescusa
Piensa en nube
------------------------------


Original Message:
Sent: 10-20-2020 02:58
From: Prashant Bavane
Subject: Maximo inbound integration

Hi Alex,

SAP sends one record and it has ABC value from which we identify within maximo how many site/org combination we need add data sent by SAP 1 rwo into multiple records
and its causing some glitch in code and inconsistent

------------------------------
Prashant Bavane
CTS


Original Message:
Sent: 10-19-2020 18:49
From: Alex Walter
Subject: Maximo inbound integration

Prashant,

I'm not exactly sure what the issue is. Can you explain what the before/after scenarios are and what the code needs to do to properly handle the org/site data?

Thanks,
Alex

------------------------------
Alex Walter
A3J Group LLC

Thanks Daniel.

I have tried multiplication control but did not get successful may be i ma mission on something.

Alex to clarify  more :

e.g. Asset recrod details sent by external system as one record without any siteid and orgid information.
 Now external system send one column XYZ for asset record , for which we have a domain in maximo which has combination of xYZ adn SIT ORGID.
One XYZ value can result into multiple SITID ,ORGID and hence we need to create and udpate(if already exists) asset for all eligible SITEID ,ORGID combinations.

We have done automation script on object structure and in beforeCreateMboSet handled few transformation on data sent by external system and in preSaveRules tried logic to create multiple assets using asset mbo set fetched via MXServer and filters to check if matches/exists and update else add for eligible combination.

Result is weired on some iteration when inserting new it creates accurate number of recrods on other not

------------------------------
Prashant Bavane
CTS
------------------------------

Original Message:
Sent: 10-20-2020 15:12
From: Daniel Torrescusa
Subject: Maximo inbound integration

Hi Prashant.

It seems like Multiplication Control in Enterprise Services provides the functionality you are looking for. If you have a more complex logic, then Automation Scripts would likely be the best way to accomplish it.

Could you elaborate on the behaviour you are getting using automation scripts? 

Thanks,
Daniel

------------------------------
Daniel Torrescusa
Piensa en nube
------------------------------


Original Message:
Sent: 10-20-2020 02:58
From: Prashant Bavane
Subject: Maximo inbound integration

Hi Alex,

SAP sends one record and it has ABC value from which we identify within maximo how many site/org combination we need add data sent by SAP 1 rwo into multiple records
and its causing some glitch in code and inconsistent

------------------------------
Prashant Bavane
CTS


Original Message:
Sent: 10-19-2020 18:49
From: Alex Walter
Subject: Maximo inbound integration

Prashant,

I'm not exactly sure what the issue is. Can you explain what the before/after scenarios are and what the code needs to do to properly handle the org/site data?

Thanks,
Alex

------------------------------
Alex Walter
A3J Group LLC

Hi Prashant.

I think you can do what you need with automation script in beforeCreateMboSet:

1. Get data from external system using context object to obtain XYZ column.
2. Create your MboSet with Mbos per SITEID, ORGID combinations attending to XYZ value.
3. Set that MboSet on your context object to be processed by MIF. If message type is Sync, it should update existing Mbos and create the new ones.

With this approach you wouldn't need preSaveRules function.



------------------------------
Daniel Torrescusa
Piensa en nube
------------------------------

Original Message:
Sent: 10-20-2020 22:57
From: Prashant Bavane
Subject: Maximo inbound integration

Thanks Daniel.

I have tried multiplication control but did not get successful may be i ma mission on something.

Alex to clarify  more :

e.g. Asset recrod details sent by external system as one record without any siteid and orgid information.
 Now external system send one column XYZ for asset record , for which we have a domain in maximo which has combination of xYZ adn SIT ORGID.
One XYZ value can result into multiple SITID ,ORGID and hence we need to create and udpate(if already exists) asset for all eligible SITEID ,ORGID combinations.

We have done automation script on object structure and in beforeCreateMboSet handled few transformation on data sent by external system and in preSaveRules tried logic to create multiple assets using asset mbo set fetched via MXServer and filters to check if matches/exists and update else add for eligible combination.

Result is weired on some iteration when inserting new it creates accurate number of recrods on other not

------------------------------
Prashant Bavane
CTS
------------------------------


Original Message:
Sent: 10-20-2020 15:12
From: Daniel Torrescusa
Subject: Maximo inbound integration

Hi Prashant.

It seems like Multiplication Control in Enterprise Services provides the functionality you are looking for. If you have a more complex logic, then Automation Scripts would likely be the best way to accomplish it.

Could you elaborate on the behaviour you are getting using automation scripts? 

Thanks,
Daniel

------------------------------
Daniel Torrescusa
Piensa en nube


Original Message:
Sent: 10-20-2020 02:58
From: Prashant Bavane
Subject: Maximo inbound integration

Hi Alex,

SAP sends one record and it has ABC value from which we identify within maximo how many site/org combination we need add data sent by SAP 1 rwo into multiple records
and its causing some glitch in code and inconsistent

------------------------------
Prashant Bavane
CTS


Original Message:
Sent: 10-19-2020 18:49
From: Alex Walter
Subject: Maximo inbound integration

Prashant,

I'm not exactly sure what the issue is. Can you explain what the before/after scenarios are and what the code needs to do to properly handle the org/site data?

Thanks,
Alex

------------------------------
Alex Walter
A3J Group LLC