Inventory Maintenance Pack 11.5.5

1. Inventory Maintenance Pack 11.5.5 • Technology stack • Oracle 8i Enterprise Edition 8.1.7.1 • Oracle 9i Application Server 1.0.2 • Developer 6i Domestic w/patch 5 6.0.8.14.2 pr latest patch set • JInitiaor 1.1.8.13 • JDK (web-tier) 1.3 • OJSP 1.1.2 • JDBC 8.1.7.16 • Client Library (RSF) 8.0.6.3

2. Inventory Maintenance Pack 11.5.5 • Discrete Manufacturing SuiteFamily Pack E • Process Manufacturing SuiteFamily Pack F • Supply Chain Planning SuiteFamily Pack E

3. Inventory Maintenance Pack 11.5.5 • Mobile Materials Management • Supports RF and PDA devices • Utilizes standard API’s, supports field level validation • User access/security controlled using functional security and responsibility access • Receiving transaction support • Receipt, inspect and delivery of material • Receipt of inventory and expense items • Receive purchase orders, internal requisitions, inter-organization transfers and customer returns • Inventory transaction support • Miscellaneous receipts / issues • Subinventory transfers

4. Inventory Maintenance Pack 11.5.5 • Move order subinventory transfers • Move order issues • Cycle count entry • Physical inventory entry • Shipping transactions • Pick confirmation • Ship confirmation • Inquiries • Item on hand & availability • Kanban inquiry

5. Inventory Maintenance Pack 11.5.5 • Enhancements for Large Organization Structures • Organization Hierarchy Enhancements • Create any number of hierarchies to perform tasks within the structure. • Item – Organization Assignment • With a single submission of a concurrent request, assign an item, range of items, or category of items to all organizations in the selected hierarchy. • Global Transaction Purge • Purge transactions from closed periods in multiple organization. • Open / Close Period Enhancements • Open or closed periods for all organization within the specified hierarchy. • Transaction Open Interface Enhancements • Query records in the open interface for all organizations in the specified hierarchy.

6. Inventory Maintenance Pack 11.5.5 • Inventory Position View / Export • Query item on-hand balances for the specified hierarchy and see results in daily, weekly, or monthly time buckets. Also, drill down from parent to child organizations in the hierarchy. • Item Attribute Maintenance • A new form (Item Attribute Copy) allows you to examine item attributes across organizations in a hierarchy. Also, change item attributes in one or more organization. • Copy Organization • Copy an organization to a new organization, optionally selecting entities such as items, sub-inventories, departments, resources, BOMs, routings, WIP parameters and other setups via a new concurrent program.(Prerequisite: Copy Organization Interface table populated as a result of the Copy Organization Interface form.)

7. Inventory Maintenance Pack 11.5.5 • Item Enhancements • Item Category Assignment Import • Import category assignments for items being imported using the Open Interface. • Webstore support • Declare whether an item can be financed or not via the Financed Item attribute. • Equipment Item Template • Assign an Equipment template (seed data) to equipment items. • Manufacturing Scheduling support • Inventory Carry Penalty Item attribute – specify the inventory carry penalty per day for jobs completed before their scheduled completion. • Operation Slack Penalty Item attribute – specify the operation slack penalty for items having time between operations.

8. Inventory Maintenance Pack 11.5.5 • Cartonization Groups • An item may be assigned to many cartonization groups (category codes).

9. Inventory Maintenance Pack 11.5.6 • Technology stack • Oracle 8i Enterprise Edition 8.1.7.2 • Oracle 9i Application Server 1.0.2 • Developer 6i Domestic w/patch 5 6.0.8.14.2 or latest patch set • JInitiaor 1.1.8.13 • JDK (web-tier) 1.3 • OJSP 1.1.2 • JDBC 8.1.7.16 • Client Library (RSF) 8.0.6.3

10. Inventory Maintenance Pack 11.5.6 • Discrete Manufacturing SuiteFamily Pack F • Process Manufacturing SuiteFamily Pack G • Supply Chain Planning SuiteFamily Pack F

11. Inventory Maintenance Pack 11.5.6 • Support for Oracle Process Manufacturing • Dual Control Item Attribute • Non-Dual – Inventory is stored in only one unit of measure • Fixed – Inventory is stored in Primary & secondary unit of measure. Enter the item quantity in one unit and the system converts and displays both quantities. • Default – Inventory is stored in Primary & Secondary UOM. Enter the item quantity in the primary UOM, system calculates secondary UOM quantity. Can change quantity in secondary UOM w/o changing quantity in primary UOM. • No Default – Inventory stored in Primary & Secondary UOM. Used when the default conversion between the two UOMs is not the same.The system dose not display the secondary UOM when you specify the primary UOM. Allows you to calculate and enter the secondary quantity before transacting. The secondary quantity can fluctuate from the default conversion by the factors specified in the Deviation+ and Deviation- fields.

12. Inventory Maintenance Pack 11.5.6 • Secondary Unit of Measure Item Attribute • The secondary unit of measure if the item is Dual Controlled. • Deviation+ and Deviation- Item Attribute • Specify the acceptable deviations as a decimal value, defining a range of acceptability when either Fixed, Default, or No Default is chosen for the Dual Control Item attribute. • Support for iStore • Item Long Description • Enter long descriptions for an item, supported in multiple languages.

13. Inventory Maintenance Pack 11.5.6 • Support for CRM applications(Service for Communications XNC, Oracle Contracts for Subscriptions OKB) • Contract Item Type • You can specify a contract item type such as Subscription, Service, Usage, Warranty and null. The Support Service flag will automatically be set if you select the value Subscription. • Subscription Dependency Flag • You can specify whether a subscription is dependent on a prerequisite grouping of parts or services. Available only if Service for Communications product is installed.

14. Inventory Maintenance Pack 11.5.7 • Technology stack • Oracle 8i Enterprise Edition 8.1.7.3 • Oracle 9i Application Server 1.0.2.2.2 • Developer 6i Domestic w/patch 5 6.0.8.18 or latest patch set • JInitiaor 1.1.8.16 • JDK (web-tier) 1.3.1_02 • OJSP 1.1.2 • JDBC 8.1.7.16 • Client Library (RSF) 8.0.6.3

15. Inventory Maintenance Pack 11.5.7 • Discrete Manufacturing SuiteFamily Pack G • Process Manufacturing SuiteFamily Pack H • Supply Chain Planning SuiteFamily Pack G

16. Inventory Maintenance Pack 11.5.7 • Purchase Order Reservations • You can now reserve material that is expected to be received from a purchase order or approved purchase requisition to a sale order or other demand source. The supply source on these reservations will be transferred to the on hand inventory when the material is received into inventory. You can query and cancel the reservations through the Inventory Reservations form. However, you can only create them for ATO items for a sales order or internal order has been created fulfilled by a PO through the auto-create requisition process.

17. Inventory Maintenance Pack 11.5.7 • Picking for Manufacturing • With Picking for Manufacturing, move orders will be created for all component requirements for discrete and lot based jobs, flow and repetitive schedules. Operation or assembly pull material can be excluded. The standard picking rules are used to tracking and transacting. • Changes made to the data model • To support consigned and process inventory in a future release • MTL_ONHAND_QUANTITIES table replaced with the MTL_ONHAND_QUANTITIES_DETAILS table • The view MTL_ONHAND_QANTITIES was created • The column QUANTITY was replaced by PRIMARY_QUANTITY

18. Inventory Maintenance Pack 11.5.7 • QUANTITY is defaulted into the TRANSACTION_QUANTITY • PRIMARY_UOM_CODE from MTL_SYSTEM_ITEMS is stored in the TRANSACTION_UOM_CODE • Mobile Receiving for Items w/o Item Setup • Oracle WMS can now receive against a purchase order items through RF devices even though no item was set up.

19. Inventory Maintenance Pack 11.5.7 • Configurable Barcode Delimiter for selected fields • Users can specify a character to serve as a delimiter between certain pairs of fields that are often bar coded together. The fields are: Item/Revision, Purchase Order Number/ Purchase Order Line, and Subinventory/Locator. The delimiter character will be interpreted as a carriage return, allowing a single scan to populate two different fields on the mobile device. • Oracle Process Manufacturing • Items can be Synchronized to specific Organization • For process-enabled organizations only, add or delete inventory organization associations • Inventory Close now a Concurrent Program • Now runs a preliminary or final close as a concurrent program. Review each step and display the individual warehouse results.

20. Inventory Maintenance Pack 11.5.7 • Warehouses with completed PORD document type transactions can be purged • Item Lot/Sub-lot Standard Conversion window has enhanced performance • Columns retrieved in the item LOV that are not needed for display of the item Lot/Sub-lot Standard Conversion window were removed. • Inventory Final Close Procedure has enhanced performance due to the addition of an index on ic_perd_bal

21. Inventory Maintenance Pack 11.5.7 • Converted Quantities Transactions now calculate decimals properly • The Conversion UOM Type is now stored with full precision instead of the previous 12 decimal precision. • Pending Transactions can be deleted in closed Inventory periods • The transaction date validation of pending transactions is removed, and a new function is created to determine if the transaction date should be reset to the system date when the current transaction falls within a closed period. • Decimal Exceptions report available to identify residual decimal quantities

22. Inventory Maintenance Pack 11.5.7 • Warehouse Inventory report displays accurate total quantity in the secondary UOM • The formula for calculating the quantity in the secondary UOM was modified, the report now displays the actual balance. • Current Programs for the Stock Locators and Inventory Organizations function without errors. • Two concurrent programs that synchronize the Stock Locators into OPM Locations and Inventory Organizations into OPM Warehouses complete w/o errors. • Cannot cancel an Inventory Transfer after purging transactions. • Released inventory transfers not yet received cannot be cancelled.

23. Inventory Maintenance Pack 11.5.7 • Physical Inventory • Tolerance Level Warning Message displays for appropriate situations • The warning message “Input is above tolerance level” displays only when the item quantity is greater than the frozen quantity. • Entry of Count Tolerance is no longer required for Inventory Counting • An entry in the Count Entries Tolerance field is no longer required. The Variance field is no longer restricted to an integer value. • Recount quantities can be entered w/o changing the Count Person • Enter a recount of a physical inventory on the Physical Count Entry window for the same Count Person and Cycle.

24. Inventory Maintenance Pack 11.5.7 • Lot Status and Grade fields display properly for Physical Count • When posting a physical count, the Lot Status and Grade fields are included in the processing. The fields also display properly in the Transaction Details window after making a Transaction Inquiry. Transactions the reverse another transaction now display the fields. • Zero Balances no longer display when Count Class is set to exclude them • Cycle counts no longer include zero balances when the Count Class is set to exclude them.

25. Inventory Maintenance Pack 11.5.7 • Inventory Optimization Reports (Supply Chain Intelligence) • Planned Service Level vs. Profit • Planned Service Level • Planned Cost Breakdown Summary • Planned Purchasing Cost • Planned Inventory Cost • Planned Gross Profit • Cumulative Demand Distribution • Specify demand uncertainty in terms of a cumulative probability distribution. New profile option MSR:Probability Distribution Type indicates whether demand variability is in terms of forecast set probabilities or forecast set cumulative probabilities.

26. Inventory Maintenance Pack 11.5.7 • Enforce Sourcing Splits • Enforce sourcing percentages specified in sourcing rules and bills of distribution when making sourcing decisions disregarding cost considerations. • Specify a Sourcing Allocation Window in days to allow Inventory Optimization flexibility to trade off strict adherence to the allocation percentages in sourcing rules against more cost effective sourcing decisions. • Specify a global allocation percentages start date from which sourcing history is collected and accumulated for making sourcing decisions via the profile option MSC: Start Date Offset for Sourcing History.

27. Inventory Maintenance Pack 11.5.7 • Specify a tolerance band for the difference between the user-specified allocation percentages and the plan-derived allocation percentages. If the difference is greater than the tolerance, an exception will be triggered. • Inter-Organization Allocations – allocations percentages are enforced or all sourcing types: • External supplies from suppliers • Transfer supplies from internal organizations • “Make” supplies within an organization • Item Purchase Price by supplier • During the inventory planning calculations, Inventory Optimization considers item purchase prices that vary by supplier site.

28. Inventory Maintenance Packs • General Information • For the most current information, it is best to download Maintenance Packs from MetaLink verses ordering the CDs. • Maintenance Packs 11.5.5, 11.5.6, and 11.5.7 can only be applied to an existing 11i environment. For 10.7 and 11x users, utilize the Rapid Install method instead. • Maintenance Pack • Family Packs • Mini Packs • Patches