Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle E-Business Suite 12 Financials Cookbook
  • Table Of Contents Toc
Oracle E-Business Suite 12 Financials Cookbook

Oracle E-Business Suite 12 Financials Cookbook

By : Yemi Onigbode
2.6 (5)
close
close
Oracle E-Business Suite 12 Financials Cookbook

Oracle E-Business Suite 12 Financials Cookbook

2.6 (5)
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)
close
close
Oracle E-Business Suite 12 Financials Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface

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.

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle E-Business Suite 12 Financials Cookbook
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon