Book Image

Oracle E-Business Suite 12 Financials Cookbook

By : Yemi Onigbode
Book Image

Oracle E-Business Suite 12 Financials Cookbook

By: Yemi Onigbode

Overview of this book

Oracle EBS Financials Suite is a solution that provides out-of-the-box features to meet global financial reporting and tax requirements with one accounting, tax, banking, and payments model and makes it easy to operate shared services across businesses and regions. Have you ever wondered how the EBS Financials modules integrate with each other, and do you want to know how this is done quickly? If so, this book is for you. You may have read about what EBS financials does, but with this book on your work desk you will see how to do it. The Oracle E-Business Suite 12 Financials Cookbook will enable you to taste the core functionalities of the main modules using bite size recipes. Each recipe is organized in a way that will enable you to learn the core steps to perform in a key business scenario; it then dives deeper into concepts and scenarios. Discover scenario-based recipes, designed to help you understand how the end-to-end processes within EBS R12 Financials modules are linked together, through touch points. With each chapter, this book develops a full business end-to-end scenario to cover the financial modules. You will start by creating items in Inventory, and then purchase items in Procurement. Then you will move on to entering supplier invoices and paying them in Payables and creating and managing assets. See how items are sold and shipped to customers in Order Management, and how funds are received from customer in Receivables. Manage cash and transfer transactions to General Ledger, and then close periods.
Table of Contents (15 chapters)
Oracle E-Business Suite 12 Financials Cookbook
About the Author
About the Reviewer

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.