R12 Feature Document - Item Attributes Simulation Sets (Mass Maintenance) [ID 39 3631.

1] -----------------------------------------------------------------------R12_ASCP_Item_Mass_Maintenance Advanced Supply Chain Planning Support Feature Document For Item Attribute Simulation Sets (aka Item Mass Maint enance) 1. Introduction

The objective of the Support Feature Document is to provide information on the new feature, Item Attribute Mass Maintenance, introduced in a Release 12 from a technical and functional perspective so that customers and support has the necessary information to implement and troubleshoot this new feature. This is release specific and not cumulative. For information on prior releases, please see previous Oracle Documentation.

Disclaimer: This document is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

Due to the nature of the product architecture, it may not be possible to safely include all features described in this document without risking significant destabilization of the code.

2.

Feature Descriptions

Item Attribute Mass Maintenance is a powerful new tool to select and change item attributes that can influence the plan results. This new feature allows the creation of Simulation Sets that can be used to modify item attributes to see immediate results in plans for proposed changes. These simulation sets are stored in new tables created for Item Attribute Mass Maintenance. These tables make the changes persistent but separate so that they are not overwritten by data collections.

For example: The fixed lead time for item ZZ is ten days. There are proposed changes on the shop floor that will result in the fixed lead-time being decreased to five days. The item attribute can be changed and simulated in the plan prior to actually changing it on the source instance and re-collecting the [Link] there is substantial change in the plan results then this information can be used to justify the changes.

Another example: A machine is broken at the Mexico [Link] to this, the lead-time on item ZZ is going to be increased to twenty days. It would cost more to have item ZZ made at the Brazil plant but the lead-time would be shorter. Two simulation sets can be created and used on two test plans. These plans can then be compared to determine which is more desirable solution.

This allows the users to: *Perform simulations related to planning item attributes*

*Simulations can be rapidly performed without changing the attributes on the source system*** *Perform multiple simulations by maintaining multiple copies of the item attributes in the planning system (simulation sets)*** * * 3. Minimum Level Requirements (Product)

*Advanced Supply Chain Planning or* *Inventory Optimization or* *Distribution Planning *

4.

New or Changed Profiles, Forms and Objects

Profiles Forms New form - Item Attributes Mass Maintenance - [Link] There are no profiles that are used to control this functionality

o NAV/ Advanced Supply Chain Planner / Setup / Item Attributes Mass Maintenance

 o o

Changed Form

Plan Options

[Link]

NAV / Advanced Supply Chain Planner / Supply Chain Plan / Options Main Tab - field - Item Simulation Set

Objects MSC_ITEM_ATTRIBUTES

o This table stores the original values and the updated values of the item [Link] to this table are NOT propagated to the ODS or back to MTL_SYSTEM_ITEMS_B tables. o o MSC_ITEM_SIMULATION_SETS This table stores the information about the simulation set. MSC_ITEM_ATTRIBUTES_V This view is used by the form to display information

Files $MSC_TOP/patch/115/odf/[Link]

o Creates the tables MSC_ITEM_ATTRIBUTES and MSC_ITEM_SIMULATION_SETS and the view MSC_ITEM_ATTRIBUTES_V 5. Reports

There are no reports associated with this functionality. 6. Implementation Considerations

It is recommended that this functionality be used on test plans. This is especially true if more than one planner works off the same ASCP [Link] this will result in more plans being defined in the instance then space and partitions should be created prior to the creation of the test plans. Records released from the Item Simulation Set, will post processing lead time simulations set, the post will be three days. plan workbench that were created using the retain the changes [Link] example: If the is changed from five days to three days in the processing lead time used on the planned order

If the simulation set is removed from the plan and the plan is rerun then the lead-time of five days will be used. NOTE: Even though the setting from the simulation set is used on the

planned order, the item attribute is NOT changed on the source. There are no further implementation considerations. ** * *

7.

How To Setup and Use This Feature

Open the form - Item Attributes Mass Maintenance - [Link]

o NAV/ Advanced Supply Chain Planner / Setup / Item Attributes Mass Maintenance o o o o Create Simulation Set. Define the Set Name Find the items to be changed Select the Items to be changed Change the Item Attribute** values using options: Set Value to (explicit value) Increase Original by Value by (explicit value)

Increase Original by Percentage (Note: Zero values will not be updated) Decrease Original by Value by (explicit value)

Decrease Original by Percentage (Note: Zero values will not be updated) ** Appendix A<#_Appendix_A>shows the list of possible attributes that are available in the form o Repeat Find / Select / Change steps as needed until all changes are in the Set. o o o Save your work Add the simulation set to the plan. Changed Form - Plan Options - [Link] NAV / Advanced Supply Chain Planner / Supply Chain Plan / Options Main Tab - field - Item Simulation Set Launch the plan. Review the output.

Repeat as necessary.

*For more information and a Quick Tour of the forms and functionality, please **R12_ASCP_Item_Attribute_Mass_Maintenance-[Link]*</epmos/main/downloadattachment processor?attachid=393631.1:FD_IMM>** *There is also a recorded Brown Bag **R12_BB_Item_Attribute_Mass_Maintenance.exe*</epmos/main/downloadattachmentproc essor?attachid=393631.1:BB_IMM>**

8.

Performance Considerations

There are no performance considerations directly related to this feature 9. Troubleshooting Tips

Be aware of the following standard functionality in the form IF simulation set name is created and user attempts to save, THEN an error will occur. At least one item must be selected and changed in order to save the simulation set. This is intended functionality. Reference Bug 5453526// Case a) items are not selected, but attributes are entered and apply button is clicked: /// "Please select Item(s) for which attributes need to be updated" / Case b) items are selected, attributes are not entered, and apply button is clicked: /"Please enter Attribute Name(s) which needs to be updated"/ Case c) Sim set name is entered, and user tries to save or click on the apply button: /"Please update Item Attribute(s) in order to save the Simulation set"/ Do not try to increase/decrease NULL values by a Percentage (%). An error message will appear and NO records will be updated (even the ones that are NOT NULL) For every attribute e.g. Processing LT there exist two columns Original Processing LT and Processing LT . Remember that the value being changed is Processing LT SO -- when you say Increase By 10%, the increase is relative to the value stored in Original Processing LT When you hit Apply the changes are being saved (no need to hit save button in the toolbar) Pay attention to the radio button setting of Included , All Items Included , Not

10.

References

*Documentation Resources* * *TOI Presentation - *R12: UI Enhancements, Simultaneous Resource scheduling and Discrete Manufacturing Enhancements <[Link] for=&rcoid=301102206>** o Powerpoint PDF File - PPT_UI_2-4_Item_Mass_Maintenance..pdf </epmos/main/downloadattachmentprocessor?attachid=414332.1:PPT_UI_2-4>** Quick Tour Flash Viewlet R12_ASCP_Item_Attribute_Mass_Maintenance-[Link] </epmos/main/downloadattachmentprocessor?attachid=393631.1:FD_IMM> Brown Bag Flash Viewlet R12_BB_Item_Attribute_Mass_Maintenance.exe </epmos/main/downloadattachmentprocessor?attachid=393631.1:BB_IMM> *Documentation /there is no documentation included in the Users Guide for this feature this is scheduled for the next release/* * Release Content Document - Support Enhanced Version - Note 414332.1 </epmos/faces/ui/km/[Link]?id=414332.1> o Release Content Document </epmos/main/downloadattachmentprocessor?attachid=414332.1:APS_RCD> - standard released version Note 412702.1 </epmos/faces/ui/km/[Link]?id=412702.1> -Getting Started With R12 - FAQ for Advanced Planning and Scheduling (APS) Suite

11.

Feedback

We welcome your comments and suggestions on the quality and usefulness of this document. Your input is an important part of the information used for revision or future Feature Document information.

Did you find any errors? Is the information clearly presented? Do you need more information? If so, what? Are the examples correct? Do you need more examples? What topics did you find most useful? What topics did you find least useful?

If you find any errors or have any suggestions for improvement, please indicate the section and page number. You can send comments to us in the following ways.

Please use the feedback button on Metalink or contact Oracle Support for more information or to register your feedback

Return to top <#_top>

12.

Appendix A

Attributes that are contained in the form

ABC Class ATP Components Flag ATP Flag Carrying Cost Continuous Inter-Org Transfers Convergent Supply Consumption Create Supply Flag Critical Component Demand Fulfillment Lead Time Demand Time Fence Days Divergent Supply Feed DRP Planned Exception Set Fixed Days Supply Fixed Lot Multiplier Fixed LT Fixed Order Qty Forecast Control

Inventory Use Up Date Make/Buy Manufacturing LT Variability Max Inventory Days of Supply Max Inventory Window Max Ord Qty Min Ord Qty Minimum Remaining Shelf Life (Days) MRP Planning Method Net Selling Price PIP Flag Planner Planning Time Fence Days Post processsing LT Preprocessing LT Processing LT Round Safety Stock Days Safety Stock Method Safety Stock Percent Selling Price Service Level Shrinkage Rate Standard Cost Substitution Window Target Inventory Days of Supply Target Inventory Window Unit Volume Unit Weight Variable LT

Vendor Managed - Fixed Quantity Vendor Managed - Maximum Days of Supply Vendor Managed - Consigned Vendor Managed - Maximum Quantity Vendor Managed - Minimum Days of Supply Vendor Managed - Minimum Quantity Volume UOM Weight UOM

InformationWarningCritical ErrorInformationCritical ErrorWarningConfirmationErrorErrorConfirmation