Hi Experts
One of our oil and gas clients is currently working exclusively with functional objects, without any serial objects in their system. However, they’re now interested in converting some of these objects into serial objects while preserving all past transactions linked to them. I’d like your expert feedback on the approach we're considering for this request and to know if any of these options should be reconsidered. We’re looking at around 40 objects, all of which include measurement details, PM actions, and WOs, but no financial transactions.
Here are my proposed options:
- Create manual serial objects: Reuse the same functional object ID and migrate historical transactions from functional objects via DR script.
- Scripted Conversion: Develop a script to directly convert functional objects to serial objects (uncertain about feasibility).
- Migration Script: Use a comprehensive migration script to transfer data (though I feel this could be more complex than the above options, given the multiple scripts involved).
Please feel free to add any suggestions or alternatives you think would be effective.
Thanks in advance
Kushan Jayasinghe