IBM Sterling Ideas

Submit new product ideas for IBM Sterling solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed.

IBM is transforming its request for enhancement (RFE) process. The purpose of the transformation is to provide a more consistent experience for you to submit requests and to enable IBM product owners to respond to your requests more quickly. For more information click here.

Connect with IBM experts and your peers on the Supply Chain Collaboration Community and the Order Management Interest Group

Provide a way to truncate master data tables similar to how transaction data is truncated via self-serve.

Similar to the "Reset Transaction Db" process on self-serve for OMoC there should also be a reset master data which would include all of the tables classified as MASTER or MASTER and TRANSACTION such as the YFS_ITEM table. There are times when it is beneficial to completely reset the data in an environment, the current tools only get part of the way there. This would leave the CONFIGURATION tables alone.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jun 3 2019
  • Declined
How will this idea be used?

This will be used to easily truncate the MASTER data tables in OMS.

What is your industry? Retail
What is the idea priority? High
  • Attach files
  • Admin
    Manjunath Subburathinam commented
    13 Apr 07:42pm

    If the data is completely reset, the environment will be rendered useless. All the master data needs to be reloaded and synched up. Precious data like user, permissions and org relationship will also be lost. No further operations are possible on the environment.

    manageItem calls with Action="Delete" is the recommended approach to handle YFS_ITEM.

    If there are still situations that requires frequent data clean up due to data corruptions, we would suggest you to raise a support ticket for our technical teams to review this and find a permanent solution that would address root cause.

    After assessing this ask, providing a master data clean up option is currently not feasible.