Oracle Inventory (INV)

This chapter covers the following topics:

Create, Update and Delete Locator

This flow is used to create, update and delete a locator.

Flow Type

PLSQL

Technical Name

Create_Update_Delete_Locator_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name MFG
Responsibility Responsibility Manufacturing and Distribution Manager
Organization Inventory Organization M1- Seattle Manufacturing
Subinventory Subinventories FGI

Setup Data

Not Applicable

Description of the Scenarios in the Flow (Inventory)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Create_Inventory_Locator This scenario creates a new locator - - INV_LOC_WMS_PUB_CREATE_LOCATOR_Main
Retrive_Locator     - SELECT
Update_Inventory_Locator This scenario updates the created locator - - INV_LOC_WMS_PUB_UPDATE_LOCATOR_Main
Delete_Inventory_Locator This scenario deletes the created locator - - INV_LOC_WMS_PUB_DELETE_LOCATOR_Main

Generate Serial Numbers Using PLSQL API

This flow generates the serial numbers for the item with pre-defined serial control.

Flow Type

PLSQL

Technical Name

Generate_Serials_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name MFG
Responsibility Responsibility Manufacturing and Distribution Manager
Organization Inventory Organization M1- Seattle Manufacturing
Item Item AS62444

Setup Data

Not Applicable

Description of the Scenarios in the Flow (Inventory)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Generate_Serials This scenario is to generate the serial numbers for the item with pre-defined serial control. - - INV_SERIAL_NUMBER_PUB_GENERATE_SERIALS_Main