IBM Sterling Ideas

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

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.

Start by posting ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
1. Post an idea
2. Upvote ideas that matter most to you
3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notifications on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Duplicate order check for B2B order in Order Hub

Mattel has requirement of duplicate order check based on Ship To Customer and Customer PO number. If combination of these two attribute values is not unique when a B2B order is being entered in Order Hub, user should get a warning prompt. He can decide to continue as is or change the Customer PO number and enter the order or delete/close the order.

  • Guest
  • Jan 17 2022
  • Not under consideration
What is your industry? Retail
How will this idea be used?

To not place duplicate B2B orders.

  • Guest commented
    25 Jan 01:14pm

    Hi Aaron, we looked into your comments. We would like to have a call with you to let you know the requirements in full and get your inputs. Please suggest.

  • Admin
    Aaron Cutter commented
    24 Jan 04:02pm

    Hi Vimal, can you use a custom table or a hang-off table to store the necessary fields and use a unique index on that table? In the case of a custom table for example - before creating the customer order, attempt to add an entry to the custom table with the ship to customer and customer PO number.

  • Guest commented
    24 Jan 05:23am


    We tried putting unique DB index on the two fields in yfs_order_header but index creation failed. We found this documentation which says unique index creation is not allowed on standard tables. Please suggest options.

  • Admin
    Aaron Cutter commented
    21 Jan 09:22pm

    Hi Vimal,

    Thank you for submitting your idea. For the requirement of checking for duplicate orders, we would suggest using a unique DB index - in your case you could add one on ship to customer and customer PO number, which would prevent duplicates from being created.

    If you need to be able to override this, you could include another field in the index that the user can modify on the order to to allow it to pass the unique constraint.

    I hope this suggestion helps you find a workable solution to meet your requirement.

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.