Oracle E-Business Suite: Adjusting Items in Inventory and Classifying Items

Oracle E-Business Suite 12 Financials Cookbook

Adjusting Items in Inventory

Item quantities can be adjusted in Inventory. In this recipe, we will use miscellaneous transactions to adjust Items. Let’s try to enter transactions on some of the controls we have set up. We will try and enter a Miscellaneous Transaction for five paper widgets into Inventory.

How to do it…

1. Navigate to Transactions | Miscellaneous Transactions.

   

2. In the Type field, select Miscellaneous receipt from the list of values.
3. Click on the Transaction Lines button to enter the receipt.
4. Search for the PRD20001 Item in the Item field.
5. Select the Subinventory list of values and the field should be automatically populated with ACME-FG.

   

6. In the Locator field, enter A1.1.2.
7. The system should display an Error message to indicate that an invalid locator has been entered.
8. Click on OK and enter A1.1.1–the system should accept this value.
9. Enter a value of 5 in the Quantity field.
10. In the account field, enter 01-000-1410-0000-000. This is the account that will be charged for the Inventory transaction.

    

11. Select the Lot / Serial button.
12. Enter the Lot number–LN10001.

    The expiration date is generated based on the setting in the Item definition.

13. Enter the quantity of 5.
14. Click on the Serial button.

    
15. Enter SN10001 in the Start Serial Number field and press Tab on the keyboard.
16. The SN10005 should be automatically populated in the End Serial Number field.
17. Click on the Done button.
18. Click on the Done button again in the next screen.
19. Save the record.

There’s more…

Let’s search for the Items in Inventory.

Searching for Items

We will use the material workbench to search for the Items:

1. Navigate to On-hand | Availability | On-hand Quantity.
2. Enter PRD20001 in the Item / Revision field.

   

3. Click on the Find button.

   

4. Expand the Organizations tree to show LN10001.
5. Review the Item details.
6. Close the form.

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. Navigate to Setup | Items | Categories | Category Codes.
2. Click on the New button to enter the Category.

   

3. In the Structure Name, select Item Categories.
4. In the Category field, enter BOOKS.MISC.
5. In the Description field, enter Other Books.
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. Navigate to Setup | Items | Categories | Category Sets.
2. Click on the New button to enter the category set.

   

3. In the Name field, enter ACME Books.
4. Enter a description, for example, ACME Paper Books.
5. Select Item Categories for Flex Structure.
6. Select Controlled At as the Org level.
7. Enter BOOKS.MISC as the Default Category.
8. Select the checkbox Allow Multiple Item Category Assignments.
9. Add the following Category Codes to the list:
   • BOOKS.MISC
   • BOOKS.NEW
   • BOOKS.USED
10. Save the record.

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

1. Navigate to Items | Organization Items.

   

2. From the Menu, select Tools and then Categories.
3. Select ACME Books in the Category Set.
4. Enter BOOKS.NEW in the Category field.
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.