Oracle E-Business Suite 12 Financials Cookbook: Take the hard work out of your daily interactions with E-Business Suite financials by using the 50+ recipes from this cookbook

1. From the Tools menu, select Organization Assignment.

2. Select the inventory organization for the Item. For example, A1 ACME Corporation. Click on the Assigned checkbox.

3. Save the assignment.

1. From the Tools menu, select Categories.

2. Select the Categories Set, Control Level, and the Category combination to assign to the Item:

3. Save the assignment.

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

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

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

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

5. Save the template.

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

7. Save the template.

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

9. Save the template.

1. Navigate to Items | Master Items.

2. Enter the Item code and description.

3. Select Copy From in the Tools menu.

4. Click on the Apply button.

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

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

7. Save the Item.

1. Navigate to Setup | Organizations | Subinventories.

2. Click on the New button.

3. In the Name field, enter ACME-FG.

4. In the Description, enter ACME Finished Goods.

5. In the Locator Control field, select Item level. This will enable the Inventory transactions for this Subinventory to use locator control, which we define at the Item level.

6. Save the record.

1. Navigate to Items | Organization Items.

2. Search for the PRD20001 Item.

3. Select the Inventory tab and select the Restrict Subinventories checkbox.

4. Save the record.

5. In the Tools menu, select Items Subinventories.

6. Select ACME-FG in the Subinventory field.

7. Save the record.

1. Navigate to Setup | Organizations | Subinventories.

2. Search for the ACME-FG Subinventory (press F11 on the keyboard, and enter the search mask ACME%, then press Ctrl+F11 on the keyboard).

3. Click on the Locator button to enter the locator details.

4. Enter A1.1.1 in the Locator field.

5. In the Description field, enter ACME FG 1.

6. In the Type field, select Storage Locator.

7. Enter another row for A1.1.2, ACME FG 2, with Storage Locator in the Type field.

8. Repeat for A1.1.3, ACME FG 3, with Storage Locator in the Type field.

9. Save the record.

1. Navigate to Items | Organization Items.

2. Search for the PRD20001 Item.

3. Select the Inventory tab, select the Restrict Locators checkbox, and then select the Locator Control as Prespecified.

4. Save the record.

5. In the Tools menu, select Items Subinventories.

6. Select A1.1.1 in the Locator field.

7. Save the record.

1. Navigate to Items | Organization Items.

2. Search for the PRD20001 Item.

3. Select the Inventory tab.

4. In the Lot Expiration (Shelf Life) region, select the Control field and select Shelf Life Days.

5. Enter 30 as the number of days.

6. In the Lot region, select Full Control in the Control field.

7. Save the record.

1. Navigate to Items | Organization Items.

2. Search for the PRD20001 Item.

3. Select the Inventory tab.

4. In the Serial region, select the Generation field, and select At Receipt. This will allow us to specify the format of the serial numbers at the time of receipt.

5. Save the record.

1. Navigate to Items | Organization Items.

2. Search for the Item PRD20002.

3. In the Inventory tab, enable the Revision Control checkbox.

4. In the displayed message, select OK.

5. Save the Item.

6. From the Tools menu, select Revisions.

7. Add a line for Revision B of the Item with the description Revised Widget.

8. Save the record.

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.

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

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

3. Select the ITEM_CATEGORIES code.

4. Click on the Segments button.

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. 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. Click on the Edit Information button to view the independent value set that it depends on. This is the Item Categories value set.

8. Close the forms.

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

2. Enter the following search criteria:

3. Click on the Find button.

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

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

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

7. Click on the New button.

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

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

10. Save the record.

1. Navigate to Setup | Items | Catalog Groups.

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

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

4. Click on the Details button.

5. Enter the following Descriptive Elements:

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

7. Save the record.

1. Navigate to Items | Master Items.

2. Search for the PRD20002 Item.

3. Select Catalog from the Tools menu.

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

5. Enter the following in the Descriptive Elements field:

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

7. Save the record.

1. Navigate to Items | Items Search.

2. In the Show region, select Item Catalog.

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

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

5. Click on the Find button.

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