Question & Answer
Question
1. Can we have delta level column (selective column) from the tables to extract the data from table in Data Extract tool?
2. Can we have Order event XML which has Order Level details , Order Line Level Details, Item Details, Charges details in one event xml.
Similarly as part of data extract process can we have one CSV with joint tables (combination of related tables) which can be extracted in Data Extract tool?
Answer
1. Yes, Extract selective columns (delta level columns) from tables using the data extract process in Sterling Order Management System (OMS). Refer to data extract documentation for instructions.
2. No it is not possible. Data extract works very different from application components like events, It works entity by entity, and has no understanding relationship of entities.
So this is not possible as all related records would not likely be added/modified in the same extract window
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSGTJF","label":"IBM Sterling Order Management System"},"ARM Category":[{"code":"a8m0z000000cxzSAAQ","label":"Orders"},{"code":"a8m0z000000cxzbAAA","label":"SaaS Components"}],"ARM Case Number":"TS019565957","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":""}]
Was this topic helpful?
Document Information
More support for:
IBM Sterling Order Management System
Component:
Orders, SaaS Components
Document number:
7238864
Modified date:
03 July 2025
UID
ibm17238864
Manage My Notification Subscriptions