Inventory Configuration Guide

Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
INV-1 Set Up System Administrator Additional Configuration Needed

This setup involves setting up system security, user names, and printers. User IDs need to be defined for all users.
R2i comes configured with several responsibilities defined. These Printers need to be set up.
responsibilities all have “R2I” after the responsibility name Additional responsibilities may be defined.
INV-2 Financial Calendars, Currencies, and Set of Books Usable – Review On Site

Set up Calendars: Review the Calendar – “R2I C001”

The Accounting and Transaction calendars are defined in the General
Ledger Setup and Configuration. Review SOB structure and accounts

Define Currencies, Conversion Rate Types, and Currency Rates: The inventory organization is tied to the
These are all defined in the General Ledger Setup and Configuration. “R2I US Client” Set of Books.

Define and Assign a Primary GL Set of Books:

Set of Books is defined in the General Ledger Setup and Configuration.
The inventory organization is assigned the “R2I US Client” Set of Books

INV-3 INV-1 Systems Items Flexfield Complete in Base R2I – Do Not Change
Setup> .
Flexfields> The Systems Items Flexfield “R2I System Items” is the field structure and
Key> Segments length for the part number field. R2i defined and compiled a single segment
15 alpha/numeric character field. Value set is “15 Characters”. Longer part
Modify System Item numbers will require scrolling within the field to see the entire number.
Key Flexfield Setup Longer segments and/or Multi -segmented item number fields are possible
but not advisable.
INV-4 INV-2 Item Categories Flexfield Useable – Review On-Site

Setup> Item Categories are item classification schemes. R2i has defined and Review Category segments, segment names,
Flexfields> compiled an Item Category Flex structure called “R2i Item Categories”. segment descriptions and segment prompts.
Key> Segments The structure consists of two segments displaying up to 15 characters each.
Segment 1 is labeled Product Family, segment 2 Item Type. R 2I further Segment Value Sets are defined as:
INV Item Category defines a Category Set called Inventory. This category set is used as the 1- R2I_INVFAMILY_CTG
Flexfield Setup default category set for all functional areas except purchasing. 2- R2I_INVTYPE_CTG

Page 1 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
INV-5 INV-3 Item Catalog Group Flexfield Complete in Base R2I – Do Not Change

Setup> Item Catalogs are used to group items by descriptive elements. Catalogs Item Catalogs are not used in R 2i.
Flexfields> may also be used as standard industry catalogs. Catalog descriptive element
Key> Segments entries may be used for building item descriptions as well as for item
searches. Although catalogs are not used in base R2i, the key flexfield has
been defined and compiled with a single segment, 15 alpha / numeric
character Item Catalog Flexfield structure.
INV-6 INV-4 Stock Locator Flexfield Usable – Review On Site

Setup> Locators are indicators for locations of items. Companies with extensive Review the Locator segment, segment
Flexfields> inventory and large warehouses use locator Control to pinpoint the material name, segment description and prompt.
Key> Segments location within a stockroom. Some sites may need a multi-segment
locator. May want to remove validation
INV Stock Locator R2i has defined and compiled a single segment, 10 alpha/numeric character against a flexfield value set.
Flexfiled Setup Stock Locators Flexfield structure. Value Set is R2I_STK_LOCATOR.
Project and Task are also available segments but are not enabled. .

Note that a single Flexfield is defined per install, so each stockroom using
locator control must use the same structure. Note too that locators must be
unique within an inventory organization.
INV-7 INV-5 Setup> Account Aliases Flexfield Complete in Base R2I – Do Not Change
Flexfields>
Key> Segments Account Aliases are shorthand designations for frequently used account
number combinations. R2i has defined and compiled a single segment, 15
INV Account Alias alpha/numeric character Account Alias Flexfield structure.
Key Flexfield Setup
INV-8 PO-6 Sales Order Flexfield Complete in Base R2I – Do Not Change
Please refer to Order Entry Set Up for
Setup> Sales Orders is the only key flexfield that is required for Order Entry. It is Details.
Flexfields> the key flexfield used by Oracle Inventory to uniquely identify sales orders
Key> Segments that are interfaced to Oracle Inventory. This flexfield must be defined
before placing demand or making reservations in Oracle Order Entry.
Refer to Order For R2i, the Sales Orders Flexfield has been defined with segments: Order
Management Set Up Number / Order Type / Order Source

Page 2 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
INV-9 INV-7 Define Locations Additional Configuration Needed

Setup> Locations are names and addresses used by the organization as well as the R2i has a location of HDQTRS (COM) and
Organizations> location you use for the organization itself. Each location is associated with WAREHOUSE (GLO). Update this
Locations only one organization but multiple locations can be associated to the same location with the client’s name and address.
organization. Use locations for requisitions, receiving, shipping, billing, and Add additional locations if necessary if you
Organization employee assignments. have different addresses for Shipping,
Structure Overview Receiving, Billing, other office sites and
R2i defined HDQTRS and WAREHOUSE but with no address information. other internal sites. At this point, use the
Define Locations Add the client’s main corporate address and name and add any other COM organization if the location is for your
Training locations as required. inventory organization and use the GLO
organization to for the expense item
organization.
INV-10 INV-8 Setup > Define Employee Refer to Purchasing Employee Set Up
Organization>
Employee Set up who will be using the inventory system for cycle count & physicals.
INV –11 INV-9 Review Organization (Workday) Calendar Additional Configuration Needed

Setup> The workday calendar represents the manufacturing work schedule and is Update calendar with client’s holidays.
Organizations> separate from the GL calendar. It provides date information for planning,
Calendar ATP calculations, forecasting and cycle counting.

Workday Calendar R2i provides 2 manufacturing calendars. R2I-C001 is a calendar month,

Training R2I-C002 is a 4/4/5 Week pattern. Select the calendar appropriate for the
client and edit the workdays.

INV-12 INV-10 Update Organizations Useable – Review and Update On-Site

Setup> Organizations describe distinct entities in a company and may include R2i has an item master organization named
Organizations> separate manufacturing facilities, warehouses, distribution centers and GLOBAL, an Inventory Organization
Organizations branch offices. Each organization is tied to a set of books and includes a named COM, a Legal Entity organization
classification such as inventory that describes the general functional named R2I LE and an Operating Unit
purpose. organization named R2I OU
Organization

Page 3 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
Structure Overview Every time you use Oracle Inventory you must choose the organization for Change Organization names and codes to
which you are entering information/data. This is called your current match the client’s name. GLOBAL may be
organization. Change your organization at any time by navigation to the left as GLOBAL. Review Inventory
INV- 12 Change Organization form. parameters such as SOB, operating unit, and
Change Organization legal entity.
Name and Code Setup Note: The COM Inventory Organization does not have the Organization
Classification: WIP Organization enabled. If this is to be a WIP
organization, check the box and then save your work.
INV –13 INV-11 Update Organization Parameters Useable – Review On Site
Setup>
Organizations> Organization parameters are the control options and defaults for the Review the account numbers. Change the
Parameters inventory/transaction Organizations. Change the COM organization code to organization code. Review other parameters
a 3-character code representing the client’s organization. The Inventory to verify settings. Change to organization
Change Organization organization parameters set organization wide controls, options and defaults. GLOBAL and update/review GLO org
Name and Code Setup
INV-14 INV-13 Setup> Define Intercompany Relations (Optional) Not Configured
Organizations>
Intercompany Intercompany relations need to be defined only in a multi-organization setup Not used in base R2i.
Relations with two or more organizations with different operating units selling goods
to one another.

INV-15 INV-14 Set up Receiving Options This step is performed in purchasing

Setup> Receiving> setup.
Receiving Define your Receiving Options: Receipt numbering is setup per inventory
R2i has receiving options setup that may be overridden. Refer to organization and should have distinct
Purchasing, Receiving Purchasing’s “Receiving Options Setup” document for more information numbering sequences. (i.e., GLO – 10000,
Option Setup on the current Receiving Option Setups. COM- 50000, etc.)

INV-16 INV-15 Define Picking Rules (Optional) Not Configured

Setup> Rules> Picking Rules are used by inventory for prioritizing on-hand inventory for Not part of base R2i.
Picking Rules reservations. Picking rules are not used in base R 2i.

INV –17 INV-16 Define ATP Rules Useable – Review On-Site

Page 4 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
Setup> Rules> Used to check item availability based on supply and demand information Review R2i rules
Available to Promise and various accumulation and consumption criteria. May also be used for
component availability check for WIP jobs
INV –18 INV-17 Define Planners (Optional) Additional Configuration Required

Setup> Planners Planner codes are assigned to items as an organization level item attribute. Add planner codes.
Planners should be set up as employees before planner codes are created.

INV –19 INV-18 Define Unit of Measure Classes Useable – Review On Site

Setup> Units of Define unit of measure classes and a base unit. Classes represent groupings Add additional UOM classes if needed
Measure> Classes of units of measure with similar characteristics. The following classes have
been defined by R2I:
Units of Measure &  Length
Conversions Training  Quantity
 Time
 Volume
 Weight
INV –20 INV-19 Setup> Define Units of Measure Useable – Review On Site
Units of Measure>
Units of Measure Define the units of measure used for tracking, moving, storing, counting,
buying, building, and selling items. R 2i has defined some common units Add additional UOM codes if needed
Units of Measure & of measures. NO NEW UOM?
Conversions Training
INV –21 INV-20 Setup> Define Unit of Measure Conversions (optional) Useable – Review On Site
Units of Measure>
Conversions Standard-conversions defined within a class (a universal conversion Add additional UOM conversions if needed
applicable to all items, such as 12 to a dozen), Intra-class-conversions
Units of Measure & within a class for a specified item, or Inter-class-conversions across classes
Conversions Training for a specified item. R 2i includes an initial set of standard conversions.

INV –22 INV-21 Setup> Define Subinventories Useable – Review On Site

Organizations>
Subinventories A subinventory is a physical or logical grouping of inventory, such as a In the COM organization, review flags and
Page 5 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
warehouse, a stockroom, a closet, or other area for storing material. R2i has account numbers for R2i subinventories.
Subinventory the following subinventories defined in the COM organizations: Add additional subinventories as required
Definition Training  FG
 MRB An additional subinventory, SUPPLIES has
Organization  STORES been defined as an expense subinventory for
Structure Overview  WIP GLOBAL.

INV –23 INV-22 Define Locators (Optional) Not Configured

Setup>
Organizations> Stock locators may be used to specify material locations within a
Stock Locators subinventory. Stock Locator is a key flexfield. R 2i uses a single segment Stock locators are not used in a base R 2i
key flexfield with a validation set called R2I_STOCK_LOCATORS. If implementation.
Stock Locator locators are to be used, determine the number of segments required and if a
Definition Training validation set is required.

Organization
Structure Overview

INV –24 INV-23 Item Attribute Controls Complete – REVIEW ON SITE BEFORE
Setup> ANY ITEMS ARE LOADED.
Items> Most item attributes may be controlled at the master item level (attribute
Attribute Controls value for an item is consistence across all organizations) or the organization
level (item attribute value may very in each organization).
Item Setup & Controls
Overview R2i has predefined the control level for all item attributes.

Item Attributes- NOTE: Do not make changes to the Item Attribute Controls after data
Templates-Status has been entered.
Control Values

INV –25 INV-24 Define Category Codes Additional Configuration Required

Setup>
Items> Category codes are used for grouping items. R 2i uses a two-segment Add category values to the flexfield

Page 6 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
Categories> category code, with Segment 1 defined as Family and Segment 2 defined as validation value set. Define categories for
Category Code Type. Validation value sets are defined for both segments with validation item grouping and reporting
turned on. Therefore, category segment values need to be added to the [Link] are entered as default values
Category & Category validation sets before categories can be created. for the category set.
Sets Training
INV –26 INV-25 Setup> Items> Define Category Sets Useable – Review On Site
Categories>
Category Sets Item Categories are grouped by category set. R 2i provides a single category Determine if a single category set is
set called Inventory. This is the default set used in all functional areas sufficient. Determine if validation is
Category & Category required.
Sets Training
INV –27 INV-26 Set the Default Category Sets Useable – Review On Site

Setup> Each Functional Area must have a specified category set as its default. R2i uses a single category set which is used
Items> Functional areas are Inventory, Purchasing, Planning, Service, Cost, as the default for all functional areas.
Categories> Engineering, Order Entry and Product Line Accounting. In the Define Item Unless additional category sets are added,
Default Category Sets form, Oracle Inventory automatically assigns the item to the default no update is necessary.
category of the default category set if the functional defining attribute is set
to Yes.
R2i uses the Inventory category set as the default for all the functional areas
except purchasing.

Setup > Items > Define Category Accounts Not Configured

Categories > Category This functionality is used for Product Line Accounting. You can assign
Accounting account numbers to a default category. This accounting information will
supercede organization or sub-inventory levels accounts.
INV –28 INV-27 Define Item Status Codes Useable – Review On Site

Setup> Item Status Codes may be used to set the functional attributes of items. Review the existing status codes
Items> These functional attributes turn items on or off for Stocking, Purchasing,
Status Codes Costing, Work in Process, Customer Orders, Internal Orders, Bills of
Material, Invoicing, and Transacting. R 2i status codes include>
Item Status Control  Active – All functions enabled
Training  Active-NS – Non-stock active item
 Inactive – All functions disabled

Page 7 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
 PreRelease – Pre-production release
INV –29 INV-28 Define Catalog Groups (Optional) Not Configured

Setup> Catalog Groups support assigning items to catalogs. Users my search for Catalog groups are not used in base R 2i.
Items> items based on catalog entries. Catalog descriptive elements entries may
Catalog Groups also be used for building item descriptions. Cataloging is not included in
standard R2i implementations.
Define Catalogs
Training

INV –30 INV-29 Define Item Types Useable – Review On Site

Setup> Item Type is a Quick Code assigned to the User Item Type attribute. R 2i Review existing item types. If additional
Items> uses item type to identify the item template last used for updating an item. item templates are added, add corresponding
Item Types As R2i templates are defined based on a common grouping of items, Item item types as well.
Type also serves as a user defined item grouping. R 2i includes the following
item types:
Item Type Definition
Training  R2I-FG -DIST for stocked, salable product
 R2I-NSFG-DIST for non stocked sellable items (e.g. training)
 R2I–PO-CAP for purchased capital goods
 R2I-PO-EXP for purchased expensed items
 R2I-STK-BUY for purchased stock items
 R2I-STK-MAKE for make stock items
 R2I-SVCPRM for service program items

INV –31 INV-30 Define Item Templates Useable – Review On Site

Setup>
Items> An item template specifies a standard set of attribute values that you use to Review R2i templates and attribute settings
Templates quickly define or update items. Overlaying a template on a new or existing
item assigns the templates attribute value settings to the item. All R 2i
templates assign a User Item Type value with the template name.
Page 8 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes

Item Templates R2i includes the following templates:

Training
 R2I-FG -DIST for stocked, salable product
Item Attributes-  R2I-NSFG-DIST for non stocked sellable items (e.g. service)
Templates-Status  R2I–PO-CAP for purchased capital goods
Control Values  R2I-PO-EXP for purchased expensed items
 R2I-STK-BUY for purchased stock items
 R2I-STK-MAKE for make stock items
 R2I-SVCPRM for service program items

INV-32 INV-31 Items: Master Items Define Items Additional Configuration Needed

Item Definition Define items and assign values to item attributes. Define in the master Create items and update item attributes,
Training organization and then enable in the working inventory organization. assign category values.

INV –33 INV-32 Define Cross Reference Types (Optional) Not Configured

Items> Define cross reference types if you need to create a reference between items Cross Reference types are generally not
Cross References and another entity, such as old part numbers. Once a cross reference type is required. Use if the customer has a specific
defined, the item cross references may be created. requirement to cross reference their working
Item Cross Reference items.
Overview Not included in base R2i.

Item Cross Reference

Training
INV-34 INV-33 Define Item Delete Constraints (Optional) Complete – Do Not Change

Setup> Oracle Inventory provides a set of constraints that conditionally prevent

Items> items from being deleted. These constraints may be updated to reflect
Delete Constraints customization requirements or requirements due to third party systems
interfaced to Oracle Inventory.

Page 9 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
No updates are required for R2i implementations.

INV-35 INV-34 Define Cost Types This step is performed in Cost Accounting
setup.
Setup> A cost type is a set of costs used for historical, current and future costs, as
Costs> well as for simulation purposes.
Cost Types
R2i Inventory is installed with two predefined cost types – Frozen and
Pending.
INV-36 INV-35 Define Cost Activities (Optional) Not Configured

Setup> Activities may be defined to represent processes or procedures that consume Not used in base R2i.
Costs> cost and time. Activities may directly relate to building items such a
Activities machine run time or they may be indirect such as purchase order generation.

Additional cost allocation method to cost items. Not used in R 2i standard

implementations

INV-37 INV-36 Define Material Sub-Elements (Required) At least one sub-element has to be defined
to complete organization definition set up.
Setup> Sub-elements may optionally be used further refine material cost
Costs> management. If you set up Material sub-elements, be sure
Sub-elements> to add a default material sub-element to the
Material Not used in standard R2 implementation. organization parameters for your inventory
organization. Refer to step INV-9.
INV-38 INV-37 Define Material Overheads (Optional) Not Configured
Setup>
Costs> You can define any number of material overheads such as for freight, Define overheads as necessary.
Sub-elements> customs, and purchasing. Overheads have not been defined in R2i
Overhead

INV-39 INV-38 Setup> Define Material Default Material Overhead Rates (Optional) Not Configured
Costs> If overheads are used, set defaults

Page 10 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
Sub-elements> Specifies default material overheads by item type, activity, and cost basis.
Defaults Not included in standard R2i implementation.

INV-40 INV-39 Define Freight Carriers Please refer to Purchasing Set Up for Freight
Carriers.
Setup> Freight Carrier codes are used by Purchasing and Order Entry. R 2i has
Freight Carriers defined several common carriers:
 Airborne – Airborne Express
 DHL – DHL
OE, Freight Carriers  Fed EX – Federal Express
Setup  UPS – United Parcel Service

INV-41 INV-40 Define Organization Shipping Network (Optional) Not Configured

Setup> Used in multiple inventory organization environments where goods are Not used in base R2i.
Organization> shipped between inventory organizations. R2i assumes no inter-organization
Shipping Networks shipping.

INV-42 INV-41 Define Shipping Methods (Optional) Not Configured.

Setup> Shipping method codes are used to specify differing shipping options for Not used in base R2i.
Organizations> inter-organization shipments. Generally only used if multi-organization
Shipping Methods supply chain planning is used. Examples might be ground, air, and rail.

INV-43 INV-42 Define Movement Parameters (Optional) Not Configured

Setup> Movement parameters must be set if movement statistics reporting is

Transactions> required. Movement Statistics reporting is used to report the movement of Not used in base R2i
Movement Parameters goods in to, out of, and between European Union countries. Base R 2i does
not include movement statistics reporting.
INV-44 INV- 43 Setup > Transactions Define Economic Zone (Optional) Not Configured
>
Movement Statistics > This is necessary when you need reporting on movement statistics.
Economic Zone
INV-45 INV-44 Define Account Aliases (Optional) Additional Configuration Needed
Page 11 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
Setup>
Account Aliases An account alias is a logical reference to a frequently used account number Define account aliases as required. Note
combination. It may be used as a short cut in miscellaneous transactions. that Account Aliases are optional.
Account Alias
Training R2i has a single segment, 15 character key flexfield for Account Alias with
one account alias defined, “SCRAP”. Define Account Aliases as required.
INV-46 INV-45 Define Transaction Source Types (Optional) Not Configured

Setup> In addition to the system defined Transaction Source Types, user defined Not used in base R2i.
Transactions> source types may be defined and used for an additional level of transaction
Source Types tracking. The base R2i implementation does not include user defined
transaction source types.
.
INV-46 INV-46 Define Transaction Types (Optional) Not Configured

Setup> In addition to the system defined Transaction Types, user defined types may Not used in base R2i.
Transactions> be defined and used for an additional level of transaction tracking. The base
Type R2i implementation does not include user defined transaction types

INV-47 INV-47 Define Transaction Reasons (Optional) Additional Configuration Needed

Setup> Transaction Reason Codes are user-defined codes optionally specified with Define Reason Codes if desired.
Transactions> each transaction. Reason Codes assist in reviewing and analyzing
Reasons transaction history. No Reason Codes are defined in R 2i.

INV-48 System Administrator Enable Concurrent Managers Additional Configuration Needed

The Concurrent Managers are not enabled in R2i. The two Inventory
Concurrent Managers, Inventory Manager and INV Remote Procedure
Manager, need to be configured to suit the client’s processing requirements.
Refer to AOL Configuration [Link].
INV-49 INV-48 Purchasing Define Purchasing Options Refer to Purchasing Module Setup
INV-50 INV-49 Open Accounting Periods
Accounting Close This step can be performed in Inventory
Cycle> Before you can use Oracle Inventory to enter transactions you need to define or Cost Accounting. Dependent on

Page 12 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
Inventory Accounting the inventory transaction calendar and open the current accounting period modules installed but can also be opened in
Periods for each organization. inventory.

INV-51 INV-50 Setup> Transaction Managers Additional Configuration Needed

Transactions> DO WE SPECIFY ALL THE INTERFACE
Interfaces Manager Concurrent processes are used to record material movements and update MANAGER SETTINGS.
costs. These transaction managers need to be started before transactions are Review the number of processes defined.
Transaction Managers entered. Start up Inventory transaction managers.
Training
INV-52 INV-51 System Administrator, Set Manufacturing System and User Profiles (Required) Useable – Review On Site
Profile> System
Profile options specify how your Oracle Inventory application controls Review profiles settings and update as
access to and process data. In general, profile options can be set at one or required.
more of the following levels> site, application, responsibility, and user.

Oracle Inventory application users use the Update Personal Profile Options
form to set profile options only at the user level. However, it is generally
not recommended that profiles be set at the user level. System
administrators use the Update System Profile Options form to set profile
options at the site, application, responsibility, and user levels.

Inventory Profile Options:

INV PACKSLIP: Shipper Data Profile - Null
INV: Account Category Set – Null, not used in base R 2i.
INV: Allow Expense to Asset Transaction – Null
INV: Debug Trace - No
INV: Debug File (Including the complete path) -/tmp/[Link]
INV: Default Item Status - Active
INV: Default Primary Unit of Measure – EACH
INV: Detect truncation on UOM conversion - None
INV: Dynamic Precision Option for Quantity on Reports - -
9,999,990.00

Page 13 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
INV: External ATP – Null, not used in base R 2I
INV: FIFO for Original Receipt Date – No
INV: Inter Organization Currency Conversion – Null, not used in base
R2I (Default is Corporate)
INV: Inter-Company Currency Conversion – Corporate
INV: Item Master Flexfield – System Items
INV: Maximum Number of Quantity Trees - 500
INV: Min-max Reorder Approval – Approved
INV: Product Family Item Template Name: - Null, not used in base R 2i
INV: Project Miscellaneous Transaction Expenditure Type – Null, not
used on base R2i
INV: RC Line Failure: - Continue Processing
INV: RC Requisition Approval – Approved
INV: Save Search Items – N
INV: Round Reorder Quantity - Null
INV: Transaction Date Validation – Provide warning when date is past
period
INV: Updateable Customer Item – Null
INV: Updateable Item Name – No
INV: Use catalog name in the item description – No
INV:CCEOI Commit point - Null
INV:CCEOI Workers – Null
INV: Capable To Promise - Null
INV: Debug Level – 0
INV: Detail Serial Number – Null (Default is Yes)
INV: Override Neg for Backflush – No
INV: Purchasing By Revision - No
TP:INV Cycle Count Approvals form – On-line processing
TP:INV Cycle Count Entries form – On-line processing
TP:INV Enter Replenishment Count form – Concurrent processing
TP:INV Inter-Organization Transfer form – On-line processing
TP:INV Miscellaneous Issue and Receipt form – On-line processing
TP: INV: Move Order Transact Form - On-line processing
TP:INV Receive Customer Returns form – On-line processing
TP:INV Return to Customer form – On-line processing

Page 14 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
TP:INV Transaction Processing Mode – Form level processing
TP:INV Transfer Between Subinventories form – On-line processing
TP:INV Update Average Cost form – On-line processing
TP: Server Side Online Processing – Yes

INV-52 INV-52 Setup: Items: Define Container Types (Optional) Not Configured
Container Types
Container Type is a quick code that may be assigned to items as an item Not used in base R2i.
attribute. It is applicable only for items defined as containers.

R2i does not support container items so container type is not applicable.
INV-53 INV-53 Setup: Items: Define Customer Item Commodity Codes (Optional) Not Configured
Customer Item
Commodity Codes Customer items may be grouped by user defined commodity codes. Codes Not used in base R2i.
need to be set up before customer items are created.

R2i does not support customer items, so customer item commodity codes are
not required.
INV-54 INV-54 Items: Customer Define Customer Items (Optional) Not Configured
Items: Customer Items
Customer items may be defined and then cross referenced to inventory Not used in base R2i.
items. However, Order Entry does not yet support customer items, so there
is little functionality for them outside of the Automotive extensions.

R2i does not support customer items.

INV-55 INV-55 Items: Customer Define Customer Item Cross References(Optional) Not Configured
Items: Customer Item
Cross Reference Customer item cross references are not supported in R 2i. Not used in base R2i.

INV-56 INV-56 Define Notification Define Notification List for Move Order (Optional) Not Configured
List
INV-57 INV-57 Define Shortage Define Shortage Parameters (Optional) Not Configured
Parameters
INV-58 INV-58 Define KANBAN Pull Sequence Not Configured
If you plan to use KANBAN system, youmust use this.

Page 15 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved
Inventory Configuration Guide
Revised 03/19/24

R2i Oracle Navigation Path Setup Explanation R2i Base Install Status
Config Guide On-Site Tasks
Step Step Setup Document On-Site Setup Changes
INV-59 Items: Manufacturer’s Set up Manufacturer’s Part Number Cross References (Optional) Not Configured
Part Number: By
Manufacturer Cross reference inventory items to manufacturer’s part numbers. Not used in base R2i

Manufacturer’s Part
Number Training

INV-60 Items: Item Set Up Related Item References (Optional) Not Configured
Relationships
Items may be cross referenced to identify substitute and related items. Not used in base R2i
Item Relationships
Training
INV-61 Items: Cross Set Up Item Cross References (Optional) Not Configured
References
Items may be cross-referenced by cross reference type. See step INV-30 for Not used in base R2i.
Item Cross Reference set up of cross reference types.
Training
INV-62 Menu Bar: Listing of Standard Oracle Reports Complete – Do Not Change
Help/Oracle
Applications Library To get a listing of the Standard Oracle Reports, log in to the applications.
From the Menu bar select Help/Oracle Applications Library. Under Product
Documentation select the application you want to see a list of reports for
(i.e. Inventory). Select Reports and Processes. A list of the standard
reports for your particular module appears. Select a report to get a list of the
parameters and other information.

Page 16 of 16
/conversion/tmp/activity_task_scratch/[Link]
Copyright  2000 KPMG Consulting, LLC
All Rights Reserved