Reader small image

You're reading from  Oracle E-Business Suite 12 Financials Cookbook

Product typeBook
Published inAug 2011
PublisherPackt
ISBN-139781849683104
Edition1st Edition
Right arrow
Author (1)
Yemi Onigbode
Yemi Onigbode
author image
Yemi Onigbode

Yemi has over a decade of experience in ERP systems development and maintenance. He has progressed from the early days of the IBM mainframe-based systems to the present day of web-based distributed systems. He has worked with large multinational consulting firms including Oracle Corporation, Accenture, Deloitte, Fujitsu Consulting, IBM, Sun Microsystems, and CSC. Yemi is a hybrid techno-functional expert. He is a hands-on Project Manager, Business Architect and Instructor, specialized mainly in Financials, Human Resources, and Supply Chain models. He has assisted a number of businesses to find solutions to complex business issues using various technologies. Yemi is also a keen believer in self-development and research; he is at par with the current developments in the IT and communications industry. He is currently developing and implementing e-business solutions for large and medium sized companies, fully integrating their business applications with the Internet and providing a totally integrated solution. He has been developing in Java since 1996 and implementing Oracle Applications since 1997. Yemi is an Oracle Financials Certified Trainer, Sun Certified Instructor, and a Fellow of the Association of Chartered Certified Accountants. He has a Bachelor of Science (Honors) degree in Pure and Applied Mathematics. Yemi is also a technical writer on Accountancy and IT issues, and presents at Accounting and IT seminars. He also motivates and mentors young adults on career management and planning. In his spare time Yemi loves to write and play musical instruments.
Read more about Yemi Onigbode

Right arrow

Creating Items


Oracle Inventory provides us with the functionality to create Items. Sets of attributes are assigned to an Item. The attributes define the characteristics of the Item. A group of attributes values defines a template, and a template can be assigned to an Item to automatically define the set of attribute values.

An Item template defines the Item Type. For example, a Finished Good template will identify certain characteristics that define the Item as a finished good, with attributes such as "Inventory Item" and "Stockable" with a value of "Yes". Let's look at how to create an Item in Oracle Inventory. We will also assign a Finished Good template to the Item.

Getting ready

Log in to Oracle E-Business Suite R12 with the username and password assigned to you by the System Administrator. If you are working on the Vision demonstration database, you can use OPERATIONS/WELCOME as the USERNAME/PASSWORD:

  1. 1. Select the Inventory Responsibility.

  2. 2. Select the V1 Inventory Organization.

How to do it...

Let's list the steps required to create an Item:

  1. 1. Navigate to Items | Master Items. Please note that Items are defined in the Master Organization.

  2. 2. Enter the Item code, for example, PRD20001.

  3. 3. Enter a description for the Item:

  4. 4. Select Copy From from the tools menu (or press Alt+T). We are going to copy the attributes from the Finished Good template:

  5. 5. We can also copy attributes from an existing Item.

  6. 6. Enter Finished Good and click on the Apply button (or press Alt+A) and click on the Done button.

  7. 7. Save the Item definition by clicking on the Save icon (or press Ctrl+S).

How it works...

Items contain attributes and attributes contain information about an Item. Attributes can be controlled centrally at the Master Organization level or at the Inventory Organization level.

There's more...

Once the Item is created, we need to assign it to a category and an inventory organization.

Assigning Items to inventory organizations

For us to be able to perform transactions with the Item in the inventory, we need to assign the Item to an inventory organization. We can also use the organization Item form to change the attributes at the organization level. For example, an Item may be classified as raw materials in one organization and finished goods in another organization.

  1. 1. From the Tools menu, select Organization Assignment.

  2. 2. Select the inventory organization for the Item. For example, A1 ACME Corporation. Click on the Assigned checkbox.

  3. 3. Save the assignment.

Assigning Items to categories

When an Item is created, it is assigned to a default category. However, you may want to perform transactions with the Item in more than one functional area, such as Inventory, Purchasing, Cost Management, Service, Engineering, and so on. You need to assign the Item to the relevant functional area. A category within a functional area is a logical classification of Items with similar characteristics.

  1. 1. From the Tools menu, select Categories.

  2. 2. Select the Categories Set, Control Level, and the Category combination to assign to the Item:

  3. 3. Save the assignment.

See also

Classifying Items recipe in this chapter

Previous PageNext Page
You have been reading a chapter from
Oracle E-Business Suite 12 Financials Cookbook
Published in: Aug 2011Publisher: PacktISBN-13: 9781849683104
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
undefined
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime

Author (1)

author image
Yemi Onigbode

Yemi has over a decade of experience in ERP systems development and maintenance. He has progressed from the early days of the IBM mainframe-based systems to the present day of web-based distributed systems. He has worked with large multinational consulting firms including Oracle Corporation, Accenture, Deloitte, Fujitsu Consulting, IBM, Sun Microsystems, and CSC. Yemi is a hybrid techno-functional expert. He is a hands-on Project Manager, Business Architect and Instructor, specialized mainly in Financials, Human Resources, and Supply Chain models. He has assisted a number of businesses to find solutions to complex business issues using various technologies. Yemi is also a keen believer in self-development and research; he is at par with the current developments in the IT and communications industry. He is currently developing and implementing e-business solutions for large and medium sized companies, fully integrating their business applications with the Internet and providing a totally integrated solution. He has been developing in Java since 1996 and implementing Oracle Applications since 1997. Yemi is an Oracle Financials Certified Trainer, Sun Certified Instructor, and a Fellow of the Association of Chartered Certified Accountants. He has a Bachelor of Science (Honors) degree in Pure and Applied Mathematics. Yemi is also a technical writer on Accountancy and IT issues, and presents at Accounting and IT seminars. He also motivates and mentors young adults on career management and planning. In his spare time Yemi loves to write and play musical instruments.
Read more about Yemi Onigbode