Add or Remove Members
You can add members to or remove members from any level of your user-defined hierarchy.
Note these points about adding members to or deleting members from your user-defined hierarchy:
- At the lowest level (LEVEL_0), you can add only those members that have already
been collected from Oracle Fusion Cloud Applications or your third-party source
system. When you delete members at the lowest level of your user-defined
hierarchy, the deletion is restricted to the user-defined hierarchy, and the
members continue to exist in your source system.
If you're only adding or deleting members at Level_0, you must run the Load Planning Data from Flat Files scheduled process in the Net change mode.
In the Supply Chain Planning User-Defined Hierarchy import template (ScpUser-DefinedHierarchyImportTemplate.xlsm), you don't need to enter anything on the User-DefinedHierarchyMaster_ worksheet or generate the .csv file for this worksheet. On the User-DefinedHierarchyDetail_ worksheet, you can enter Yes in the Delete Indicator column for the members you're going to delete.
- If you're only adding members to an intermediate level or the top level of your
user-defined hierarchy, you must run the Load Planning Data from Flat
Files scheduled process in the Net change mode.
In the Supply Chain Planning User-Defined Hierarchy import template, you don't need to enter anything on the User-DefinedHierarchyMaster_ worksheet or generate the .csv file for this worksheet. On the User-DefinedHierarchyDetail_ worksheet, you need to enter only the details for the new members. If required, for the new members at intermediate levels, you can also enter child members at lower levels.
- If you're only deleting members from an intermediate level or the top level of
your user-defined hierarchy, you must run the Load Planning Data from
Flat Files scheduled process in the Targeted mode. Effectively,
you're going to delete and recreate the user-defined hierarchy.
In the Supply Chain Planning User-Defined Hierarchy import template, you must enter all the levels on the User-DefinedHierarchyMaster_ worksheet and all the level members on the User-DefinedHierarchyDetail_ worksheet and generate the .csv files for both worksheets.
You must also delete all members for which you're deleting the parent member. Otherwise, you'll have orphaned members in your user-defined hierarchy. You can delete the members by not including the applicable rows on the User-DefinedHierarchyDetail_ worksheet instead of entering Yes in the Delete Indicator column.
- If your user-defined hierarchy is configured in a planning level profile, and you've used the Load Planning Data from Flat Files scheduled process to add or delete hierarchy members for the Customer dimension, you must manually run the Aggregate Collected Planning Data scheduled process. Then, you must manually run the Create Trees for Dimensions scheduled process in the net change mode for the Customer dimension.
To add members to or remove members from levels of the user-defined hierarchy, do these steps: