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 Item templates


An Item template is a set of attributes that enable the 'quick' creation of an Item. In this recipe, we will create an Item template that can be used to create many similar Items. We will copy from the Finished Good template to our new template called ACME Finished Good.

Getting ready

Log in to Oracle E-Business Suite and select the Inventory responsibility.

How to do it...

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

  1. 1. Navigate to Setup | Items | Templates.

  2. 2. Select the Inventory Organization.

  3. 3. From the Find Item Templates form, click on New button or press Alt+N.

  4. 4. In the Template field, enter the name of the new template; for example, enter ACME Finished Good.

  5. 5. In the Description field, enter a suitable description, for example, enter ACME Finished Good Template.

  6. 6. Select Copy Template from the Tools menu.

  7. 7. We can use this form to select the attributes groups that we want to copy from the Finished Good template.

  8. 8. Click on the Apply button.

  9. 9. Click on the Done button.

  10. 10. In the dialog box presented to us, with the message "Do you want to save the changes you have made?", click on the Yes button.

How it works...

Item templates can be created from scratch. To make the template creation process easier, Oracle has provided us with a number of seeded templates as a starting point to copy from. We can also combine templates and manually amend the attributes to define our template. When we copy from an existing template, we have choices that determine how the copy will occur.

The three main choices are as follows:

  1. 1. Overwrite: All selected attribute values are copied to the new template and any values that we have manually created will be overwritten.

  2. 2. Append: Attributes that have no value will be copied across to our template. This mode is useful if you are using a combination of templates.

  3. 3. Overwrite Not Null: Only the selected attributes that contain values will be copied.

There's more...

Let's amend the template to allow us to automatically populate the template with some default values. Let's create an Item and apply the amended template to the Item.

Amending the template

Let's search for the template and amend the templates to include some of the default values:

  1. 1. Search for the ACME Finished Good template by navigating to Setup | Items | Templates.

  2. 2. Enter ACME Finished Good in the Template field and click on the Find button.

  3. 3. Click on the Open button to view the template.

  4. 4. In the Attributes Group region, select Purchasing and enter some default values, for example:

    • Default Buyer: Stock, Ms. Pat

    • Input Tax Classification Code: VAT-15%

    • Taxable: Yes

    • Allow Description Update: Yes

    • Receipt Required: Yes

  5. 5. Save the template.

  6. 6. In the Attributes Group region, select Receiving and enter some default values, for example:

    • Over-Receipt Qty Action: Warning

    • Receipt Routing: Direct Delivery

    • Days Early Receipt Allowed: 5

    • Days Late Receipt Allowed: 2

    • Receipt Date Action: Warning

  7. 7. Save the template.

  8. 8. In the Attributes Group region, select Invoicing and enter some default values, for example:

    • Accounting Rule: Immediate

    • Payment Terms: Immediate

  9. 9. Save the template.

Creating an Item and applying the template to the Item

Let's create an Item and apply the template to the Item:

  1. 1. Navigate to Items | Master Items.

  2. 2. Enter the Item code and description.

  3. 3. Select Copy From in the Tools menu.

  4. 4. Click on the Apply button.

  5. 5. Click on the Done button. This action will validate the template created.

  6. 6. Click on the Purchasing tab to review the default values of the attributes assigned automatically by the template.

  7. 7. Save the Item.

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