Supply Chain Planning and Collaboration

Get Involved. Join the Conversation.


    Ramesh Choudhary
    Question on: 'Allow multiple item category...
    Topic posted September 6, 2019 by Ramesh ChoudharyBlue Ribbon: 750+ Points, tagged Collections, Demand Management Cloud, How-to, Planning Central Cloud, Supply Planning Cloud, Tip, User Experience, White Paper 
    79 Views, 7 Comments
    Question on: 'Allow multiple item category assignments' check box in task 'Manage Functional Area Catalogs'
    Question on: 'Allow multiple item category assignments' check box in task 'Manage Functional Area Catalogs'

    We have an requirement to assign the multiple categories (categories under same catalog) to item.

    For multiple category assignment, the check box  'Allow multiple item category assignments' should be checked while creating the catalog in the Task: Manage Functional Area Catalogs.

    But as per note from Oracle (attached screenshot), we should not enable this check box otherwise the Catalog is not collected in collections run and we cannot use it in Planning module.

    We have requirement to assign the item to two different categories which are under same catalog.

    How can we achieve this?

    Can you please help us with solution on this issue (or) provide the workaround for this issue.






    • Cherry Bruns

      As the documentation states, for the catalog to be collected, an item cannot belong to more than one category. There is no workaround from a planning perspective. You can always create another catalog that is not used by planning that allows multiple item category assignments.

      Regards, Cherry

      • Ramesh Choudhary

        Hi Cherry,

        Did you mean that we should create the catalog without assigning it to 'Planning Functional area'?

        If Yes, We tried creating a catalog without associating it to 'Planning Functional Area' and by checking the check box 'Allow multiple item category assignments'.

        Still the catalog was not collected in the collections run. Can you please let us know what we are missing.




    • Cherry Bruns

      You cannot use a catalog in Supply Chain Planning that has the checkbox "Allow multiple item Category Assignments" checked. SCP doesn't support that type of catalog, we only support an item belonging to one parent category, which is why that type of catalog doesn't get collected. There is no work around for that.

      If you want use a catalog in another product area (for example, Procurement) that has the checkbox "Allow multiple item Category Assignments" checked, then you need to confirm with that product area on what is supported or not.

      Regards, Cherry

      • Paul Keating

        Hi there

        Now that is one large demand model you have. I believe you are tackling this the wrong way as from a demand perspective an item can/should only exist in one sales category. For example, and item called pipe, can only every be either concrete, plastic, or copper.

        What you are after is an attribute of an item - planned/unplanned. This way you can filter your plan based on the attribute(s). This is also how you would look at a forecast based on ABC classifications as this would be an attribute of an item.

        Using attributes means you can maintain the correct hierarchy  levels month on month and just update the attribute depending on whether or not it is to be planned.

        Regards Paul


        • Ramesh Choudhary

          Hi Paul,

          Thanks for the information.

          Actually we had thought in same direction what you described above.

          One issues we found is with catalog .  'Planning Functional Area' catalog needs to be controlled at 'Master' control and in order to control it at 'Master' level, 
          the Attribute 'Planning Method' also needs to be controlled at 'Master level'.
          Hence we will not be able to assign the item with different planning method in different organizations.

          In our business case, we might plan item in one organization (MRP Planned) and might not plan (Not Planned) in other organization in a particular month.

          So how will achieve our requirement if we follow 'Planning Method' attribute approach.

          Can you please help us if you have an idea to tackle this situation.

          Please let me know if i am missing anything.



      • Cherry Bruns
        You can create a 2 level user defined hierarchy on Item dimension say 
        Item -> Planning Status (Planned/Non Planned), Planning Status is a 
        parent level to Item and include that hierarchy in the plan dimension 
        catalog. User defined hierarchy is loaded through a corresponding User 
        Defined Hierarchy FBDI template. You have to load this file whenever you 
        change the planning status of the Items most probably once in a planning 
        cycle. You can create a analysis set using this Planning Status level 
        set to "Planned" and select that analysis set in the DM Forecasting 
        Profile analysis set selection. This will filter out the Non Planned 
        Items during forecasting.
        • Ramesh Choudhary

          Hi Cherry,

          Thanks for your suggestion on this matter.

          We are internally discussing on this and shall update in case we have further doubts or questions.