Oracle Inventory Test Details

Script: CrtItem - Define a Discrete Item

Login: mfg/welcome

Task: Define a Discrete Item

Actions:

1.         Navigate: Inventory/Items/Master Items

2.         Select Organization=M1, Seattle Manufacturing

(NOTE: Specific Items used in this test refer to Vision seeded data.)

3.         Enter information in master Item form: Key in Item: ITEMTEST1

(Note: Every Item should be unique)

Description: Discrete Test Item

4.         Enter data to the following Tab Regions: Main Tab Region:

Pri UOM: Each

User item type: Finished Good

Item Status: Active Inventory Tab Region: Inventory Item: Check Stockable: Check Reservable: Check Transactable: Check Lot - Control: No Control Serial Generation: No Control Locator control: No Control

Bills of Material Tab Region: BOM Allowed: Check BOM Item Type: Standard Effectivity control: Date

5.         Enter data for: Costing Tab Region: Costing Enabled: Check Inventory Asset Value: Check Include in Rollup: Check

Cost of Goods Sold Account: (default)

Standard Lot Size: 1

Purchasing Tab Region: Purchased: Check Purchasable: Check

Allow Description Update: Check

RFQ Required: NO

Taxable: No

List Price: 1500

Price Tolerance: 0

Expense Account: (default)

Market Price: 1500

6.         Enter data for Receiving Tab Region:

Allow Express Transactions: Yes

Receipt Routing: Direct

7.         Enter data for:

General Planning Tab Region: Inventory Planning Method: Not Planned Make or Buy: Make

Cost: Carrying: 10%

Safety Stock: Method: MRP Planned %

Safety Stock: Percent: 15

MPS/MRP PlanningTab Region: Planning Method: MPS planning Forecast Control: Consume and Derive MPS Planning: Calculate ATP: Check MPS Planning: Reduce MPS:None Planning Time Fence: User-Defined, Days: 8 Demand Time Fence: User-Defined, Days: 3

8.         Enter data for:

Lead Times Tab Region: Preprocessing: 2 Fixed: 1

Variable: .01

Lead Time Lot Size:1

Work In Process Tab Region: Build in WIP: checkbox Supply Type: Push

Order Management Tab Region: Customer Ordered: Check Internal Ordered: Check Customer Orders Enabled: Check Internal Orders Enabled: Check Shippable: Check

OE Transactable: Check

Returnable: Check

Default Shipping Organization: (default, else M1, Seattle Manufacturing)

9.         Enter data for: Invoicing Tab Region: Invoiceable Item: Check Invoice Enabled: Check Sales Account: (default) Service Tab Region:

10.       Click on Service tab.

11.       Select File/Save (stay in form for next step)

12.       Select Tools/Organization Assignment from the Menu bar. (115inv056.gif)

13.       Click Assigned check box for M1, Seattle Manufacturing and M2 Boston Manufacturing.

14.       Select File/Save.

15.       Close Organization Assignment form by using the “x” box

16.       Change ITEMTEST1, item Attribute Region: Work In Process Tab Region:

Supply Type: Operation Pull

17.       Select File/Save (stay in form for next step)

18.       Change ITEMTEST1, item attribute: Work In Process Tab Region: Supply Type: Push

19.       Select File/Save.

20.       Close Master items form by pressing F4 key

Verifications:

1.         Master Item form is displayed when Navigate: Inventory/Items/Master Items.

2.         Main Tab Region is displayed when enter data to the Tab Regions.

3.         Inventory Tab Region is displayed when enter data to the Tab Regions.

4.         Bills of Material Tab Region is displayed when enter data to the Tab Regions.

5.         Costing Tab Region is displayed when enter data to the Tab Regions.

6.         Purchasing Tab Region is displayed when enter data to the Tab Regions.

7.         Receiving Tab Region is displayed when enter data to the Tab Regions.

8.         General Planning Tab Region is displayed when enter data to the Tab Regions.

9.         MPS/MRP Planning Tab Region is displayed when enter data to the Tab Regions.

10.       Lead Times Tab Region is displayed when enter data to the Tab Regions.

11.       Work in Progress Tab Region is displayed when enter data to the Tab Regions.

12.       Order Entry Tab Region is displayed when enter data to the Tab Regions.

13.       Invoicing Tab Region is displayed when enter data to the Tab Regions.

14.       Service Tab Region is displayed when enter data to the Tab Regions.

15.       Organization Assignment form is displayed when select Tools/Organization Assignment.

16.       Organization Assignment form closes and focus returns to Master Items form when Close using the “x”.

17.       Work In Process Tab Region is displayed when enter data to the Tab Regions.

18.       Work In Process Tab Region is displayed when enter data to the Tab Regions.

19.       Master Items form closes and focus returns to Navigator.

Responsibility: Manufacturing & Distribution Manager Organization=M1, Seattle Manufacturing

(NOTE: Specific Items used in this test refer to Vision seeded data.)

Task: Define a discrete item

Actions:

1.         Navigate: Inventory/Items/Master Items

2.         Click Tools/Copy From Item: CM13139

3.         Click Apply

4.         Click Done

Key in Item:ITEMTEST2

(Note: Every Item should be unique)

Description: Discrete Test Item

5.         Verify Inventory Tab Region: Inventory: Check Stockable: Check Reservable: Check Transactable: Check

Lot Control: No Control

Serial Generation: No Control

Locator Control: No Control

6.         Verify MPS/MRP Planning Tab Region: Planning Method: MRP planning Forecast Control: None

Pegging: None

Planning Time Fence: User-Define

Days: 1

7.         Verify Work In Process Tab Region: Build in WIP: Check

Supply Type: Operation Pull

8.         Modify Order Management Tab Region: Check ATP: None

ATP Components: None

9.         Select File/Save (stay in form for next step)

10.       Select Tools/Organization Assignment from the Menu Bar.

11.       Click Assigned check box for: M1, Seattle Manufacturing M2, Boston Manufacturing

12.       Select File/Save from the Organization Assignment form.

13.       Close Master items form by pressing F4 key.

Verifications:

1.         Master Item form is displayed when Navigate: Inventory/Items/Master Items.

2.         Main Tab Region is displayed when enter data to the Tab Regions.

3.         Inventory Tab Region is displayed when enter data to the Tab Regions.

4.         MPS/MRP Tab Region is displayed when enter data to the Tab Regions.

5.         Work In Process Tab Region is displayed when enter data to the Tab Regions.

6.         Order Management Tab Region is displayed when enter data to the Tab Regions.

7.         Enable new item in M1, M2 when click Assigned check box.

8.         Organization Assignment form is displayed when Select File/Save.

9.         All of Master Items forms close and focus returns to Navigator when press F4.

Responsibility: Manufacturing & Distribution Manager Organization=M1, Seattle Manufacturing

(NOTE: Specific Items used in this test refer to Vision seeded data.)

Task: Define a discrete item

Actions:

1.         Navigate: Inventory/Items/Master Items

2.         Select Tools/Copy From Item: CM13139

3.         Click Apply.

4.         Press Done.

5.         Key in Item: ITEMTEST3

Description: Discrete Test Item

6.         Verify Inventory Tab Region: Inventory Item: Check Stockable: Check Reservable: Check Transactable: Check

Lot - Control: No

Serial - Generation: No Control

Locator Control: No Control

7.         Verify MPS/MRP Tab Region: Planning Method: MRP Planning

Forecast Control: None

Pegging: None

Round Order Quantities: Check

Planning Time Fence: User-Define

Days: 1

8.         Verify Work In Process Tab Region: Build in WIP: Check

Supply - type: Operation Pull

9.         Modify Order Management Tab Region: Check ATP: None

ATP Components: None

10.       Select File/Save (stay in form for next step)

11.       Select Tools/Organization Assignment.

12.       Click Assigned check box for: M1, Seattle Manufacturing M2, Boston Manufacturing

13.       Select File/Save.

14.       Close Master items form by pressing F4 key.

Verifications:

1.         Master Item form is displayed when Navigate: Inventory/Items/Master Items.

2.         Main Tab Region is displayed when enter data to the Tab Regions.

3.         Inventory Tab Region is displayed when enter data to the Tab Regions.

4.         MPS/MRP Tab Region is displayed when enter data to the Tab Regions.

5.         Work In Process Tab Region is displayed when enter data to the Tab Regions.

6.         Order Management Tab Region is displayed when enter data to the Tab Regions.

7.         Enable new item in M1 ,M2 when click Assigned check box.

8.         Organization Assignment form is displayed Select File/Save

9.         All of Master Items forms close and focus returns to Navigator when press F4.

Responsibility: Manufacturing & Distribution Manager Organization=M1, Seattle Manufacturing

(NOTE: Specific Items used in this test refer to Vision seeded data.)

Task: Define a discrete item

Actions:

1.         Navigate: Inventory/Items/Master Items

2.         Select Tools/Copy From. Item: CM13139

3.         Click Apply.

4.         Click Done.

5.         Key in Item: ITEMTEST4,

Description: Discrete Test Item

6.         Verify Inventory Tab Region: Inventory Item: Check Stockable: Check Reservable: Check Transactable: Check

Lot - Control: No

Serial - Generation: No Control

Locator Control: No Control

7.         Enter data for:

General Planning Tab Region:

Inventory Planning Method: Re-Order Point

Make or Buy: Buy

Order Quantity: Minimum: 5

Cost: Order: 5

Cost: Carrying: 10%

Source: Type: Supplier

Safety Stock: Method: Non MRP Planned

Safety Stock : Percent: 15

8.         Enter data for:

MPS/MRP Planning Tab Region: Planning Method: MPS planning Forecast Control: Consume and Derive Pegging: None

MPS Planning: Calculate ATP: Check

MPS Planning: Reduce MPS:None

Planning Time Fence: User-Defined, Days: 8

Demand Time Fence: User-Defined, Days: 3

9.         Verify Work In Process Tab Region: Build in WIP: Check

Supply - type: Operation Pull

10.       Select File/Save (stay in form for next step)

11.       Select Tools/Organization Assignment

12.       Click Assigned check box for:

M1, Seattle Manufacturing

M2, Boston Manufacturing

13.       Select File/Save.

14.       Close Master items form by pressing F4 key.

Verifications:

1.         Master Item form is displayed when Navigate: Inventory/Items/Master Items.

2.         Inventory Tab Region is displayed when enter data to the Tab Regions.

3.         General Planning Tab Region is displayed when enter data to the Tab Regions.

4.         MPS/MRP Tab Region is displayed when enter data to the Tab Regions.

5.         Work In Process Tab Region is displayed when enter data to the Tab Regions.

6.         Enable new item in M1, M2 when click Assigned check box.

7.         Organization form is displayed when Select File/Save.

8.         All of Master Items forms close and focus returns to Navigator when press F4.

Script: MisTrans - Miscellaneous Transaction

Responsibility: Manufacturing & Distribution Manager Organization=M1, Seattle Manufacturing

(NOTE: Specific Items used in this test refer to Vision seeded data.)

Task: Perform Miscellaneous Transactions

Responsibility: Manufacturing & Distribution Manager Organization=M1, Seattle Manufacturing

(NOTE: Specific Items used in this test refer to Vision seeded data.)

Actions:

1. Navigate: Inventory/Transactions/Miscellaneous Transaction.

2.         Enter Transaction Type: Type: Miscellaneous Receipt

3.         Enter Transaction Source: Source: blank

4.         Click Transaction Lines.

5.         Enter Line information for first item: Item: ITEMTEST1 Subinventory: Stores

UOM: Each

Quantity: 30

6.         Click on the List of Values icon for the account field.

7.         Enter “Miscellaneous” in the alias box.

8.         Click OK.

9.         Select File/Save

10.       Enter Line information for second item: Item: ITEMTEST2

Subinventory: Stores

UOM: Each

Quantity: 30

11.       Click on the List of Values icon for the account field.

12.       Enter “Miscellaneous” in the alias box.

13.       Click OK.

14.       Select File/Save.

15.       Select File/Close Form to close form.

Verifications:

1.         Miscellaneous Transaction form is displayed when Navigate: Inventory/Transactions/Miscellaneous Transaction.

Note: Make sure the Inventory accounting periods that you are transacting in are open

2.         Miscellaneous Transaction form is displayed when enter Transaction Source.

3.         Miscellaneous receipt form is displayed when click the the Transaction Lines button.

4.         Miscellaneous receipt form is displayed when enter Line information. Alias look up box results.

5.         Miscellaneous receipt form is displayed when enter Line information.

6.         All Miscellaneous Transaction forms close and focus returns to Navigator when select File/Close Form.

Task: Perform Sub-Inventory Transfer to move Responsibility: Manufacturing & Distribution Manager Organization=M1, Seattle Manufacturing

(NOTE: Specific Items used in this test refer to Vision seeded data.)

Task: Perform Sub-Inventory Transfer to move

Actions:

1.         Navigate: Inventory/Transactions/Subinventory Transfer

2.         Enter Transaction Type: Type: Subinventory Transfer

3.         Click Transaction Lines.

4.         Enter Line Information Item: ITEMTEST2 Subinventory: Stores To Subinventory: MRB

UOM: Each

Quantity: 10

5.         Select File/Save

6.         Selecting File/Close Form to close form.

Verifications:

1.         Subinventory transfer form is displayed when Navigate: Inventory/Transactions/ Subinventory Transfer.

Note: Make sure the Inventory accounting periods that you are transacting in are open

2.         Inventory sub transfer form is displayed when click Transaction Lines button.

3.         All Subinventory Transfer forms close and focus returns to Navigator when Select File/Close Form.

Responsibility: Manufacturing & Distribution Manager

(NOTE: Specific Items used in this test refer to Vision seeded data.)

Task: Verify Shipping Network

Actions:

1.         Navigate: Inventory/Setup/Organizations/Shipping Networks

M1, Seattle Manufacturing should show as the default organization when the form opens.

2.         Click Find.

3.         Verify that From M1 to M2 exists and that the Transfer Type equals Direct. Note: If Transfer Type is Intransit change to Direct and save the record

4.         Select File/Close Form to close form.

Verifications:

Shipping Networks form is displayed when Navigate: Inventory/Setup/Organizations/Shipping Networks.

Shipping Networks form is displayed when Click the Find button.

Shipping Networks form closes and focus returns to Navigator when select File/Close Form.

Responsibility: Manufacturing & Distribution Manager Organization=M1, Seattle Manufacturing

(NOTE: Specific Items used in this test refer to Vision seeded data.)

Task: Perform Inter-Org Transfer

Actions:

1.         Navigate: Inventory/Transactions/Inter-Organization Transfer

2.         Enter Header Information:

To Org: Boston Manufacturing, M2

Type: Inventory direct org transfer or Inventory in transit shipment

3.         Click Transaction Lines.

4.         Answer yes if a folder decision box is presented.

5.         Enter Line Information: Item: ITEMTEST1 Subinventory: Stores To Subinventory: Stores UOM: Each Quantity: 5

6.         Select File/Save

7.         Select File/Close Form to Close form.

Verifications:

1.         Inter-org Transfer form is displayed when Navigate: Inventory/Transactions/Inter-Organization Transfer.

Note: Make sure the Inventory accounting periods that you are transacting in are open

2.         Inventory intransit shipment form is displayed when click Transaction Lines button.

3.         All Inter-Organization Transfer forms close and focus returns to Navigator when select File/Close Form.