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
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface

Classifying Items


Items are grouped into logical classifications through categories. Categories can be further grouped into category sets. A default category set can be assigned to a functional area. When an Item is created, it is automatically added to the default category set.

The groupings are mainly used for reporting purposes. Let's look at how to classify Items using categories.

How to do it...

Let's list the steps required to create category codes:

  1. 1. Navigate to Setup | Items | Categories | Category Codes.

  2. 2. Click on the New button to enter the Category.

  3. 3. In the Structure Name, select Item Categories.

  4. 4. In the Category field, enter BOOKS.MISC.

  5. 5. In the Description field, enter Other Books.

  6. 6. Save the record.

Let's now create the Category Set, add the Category Codes to a new set called ACME Books, and assign it to the PRD20001 Item:

  1. 1. Navigate to Setup | Items | Categories | Category Sets.

  2. 2. Click on the New button to enter the category set.

  3. 3. In the Name field, enter ACME Books.

  4. 4. Enter a description, for example, ACME Paper Books.

  5. 5. Select Item Categories for Flex Structure.

  6. 6. Select Controlled At as the Org level.

  7. 7. Enter BOOKS.MISC as the Default Category.

  8. 8. Select the checkbox Allow Multiple Item Category Assignments.

  9. 9. Add the following Category Codes to the list:

    • BOOKS.MISC

    • BOOKS.NEW

    • BOOKS.USED

  10. 10. Save the record.

Let's now assign the categories to the PRD20001 Item:

  1. 1. Navigate to Items | Organization Items.

  2. 2. From the Menu, select Tools and then Categories.

  3. 3. Select ACME Books in the Category Set.

  4. 4. Enter BOOKS.NEW in the Category field.

  5. 5. Save the record.

How it works...

The structure of the Item category is defined in the Item Flexfield structure and the values are held in the individual Value Sets. The combination of the individual values forms the category code. For example, the structure we used previously is made of two segments, defined in the Flexfield structure. The segments are Family and Class. BOOKS is a value in Family and MISC, NEW, and USED are individual values in Class.

There's more...

Let's look at how the Item Flexfield structure is constructed and how values are added to the structure.

Viewing the Item Categories structure

  1. 1. Navigate to Setup | Flexfields | Key | Segments.

  2. 2. Search for Item Categories in the Flexfield Title field.

  3. 3. Select the ITEM_CATEGORIES code.

  4. 4. Click on the Segments button.

  5. 5. The Items Categories we have used has two segments, namely, Family and Class. The Item Category structure can be configured to have a maximum of 20 segments.

  6. 6. Click on the Value Set button to view the validation format of the data that can be stored in the Value Set. The Class Segment uses the Item Class Category value set, this segment has a Validation Type of Dependent. It is dependent on another segment for the validation of the values that can be stored.

  7. 7. Click on the Edit Information button to view the independent value set that it depends on. This is the Item Categories value set.

  8. 8. Close the forms.

Viewing the values in the structure

Let's look at the values in the structure. We are also going to add a new value for Rare Books in the Item category. We are also going to add the new code to the category codes:

  1. 1. Navigate to Setup | Flexfields | Key | Values.

  2. 2. Enter the following search criteria:

    • In the Application field, select Inventory.

    • In the Title field, enter Item Categories.

    • In the Structure, enter Item Categories.

    • In the Dependent Segment, enter Class.

    • In the Independent Value, enter Books.

  3. 3. Click on the Find button.

  4. 4. In the Value field, enter RARE, and Rare Books in the Description.

  5. 5. Save the record and click on OK in the note to compile the record.

  6. 6. Navigate to Setup | Items | Categories | Category Codes.

  7. 7. Click on the New button.

  8. 8. Search for the existing BOOKS codes by using BOOK% as the search criteria in the Category field.

  9. 9. Add a new line for BOOKS.RARE and Rare Books as the Description.

  10. 10. Save the record.

Items can also be grouped into logical catalogs. Let's look at how this is done.

Creating catalogs

Catalogs are used to add descriptive information to Items that share common characteristics. For example, paper can have size, color, and weight. Let's look at how to create Item catalogs for ACME Books, with descriptive elements for size, color, and weight:

  1. 1. Navigate to Setup | Items | Catalog Groups.

  2. 2. From the Menu, select File and then New.

  3. 3. In the Name field, enter ACME Books, and enter ACME Books in the Description.

  4. 4. Click on the Details button.

  5. 5. Enter the following Descriptive Elements:

    • Size

    • Color

    • Weight

  6. 6. Select Categories and enter the following categories for ACME Books:

    • BOOKS.NEW

    • BOOKS.USED

    • BOOKS.MISC

  7. 7. Save the record.

Assigning a catalog description to an Item

Let's find the PRD20002 Item and assign the catalog:

  1. 1. Navigate to Items | Master Items.

  2. 2. Search for the PRD20002 Item.

  3. 3. Select Catalog from the Tools menu.

  4. 4. In the Catalog Group field, select ACME Books.

  5. 5. Enter the following in the Descriptive Elements field:

    • A5 - 210 x 148 mm as the value for the Size field

    • The Color as White

    • The Weight as 80gsm

  6. 6. Select the Update Description button to change the Item description.

  7. 7. Save the record.

Searching for Items using catalog attributes

Let's search for Items using the catalog attributes:

  1. 1. Navigate to Items | Items Search.

  2. 2. In the Show region, select Item Catalog.

  3. 3. In the Catalog Group field, select ACME Books.

  4. 4. In the Size field, select A5 - 210 x 148 mm.

  5. 5. Click on the Find button.

  6. 6. The Item Search form displays the record based on the catalog attributes.