My Oracle Support Banner

Personalization Example -- Auto-populate Individual Serials During Miscellaneous Issue (Doc ID 2656912.1)

Last updated on APRIL 07, 2020

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

How do you issue non-sequential serials from onhand?  Is there a way to personalize the serial entry to enter serials automatically for the user?

Standard Behavior Example
In the standard behavior, the user must enter ranges of serials. If the serials do not follow a pattern (non-sequential), then the user must enter the serials individually. This can be time consuming for the user to choose 100s of serials to issue out of stores.

Background
We would like to issue off all of a serialized item. We have 100s of items onhand and we use a Mass Issue transaction or miscellaneous Issue transaction, we have to enter the serial numbers 1 by 1 as the serials are not sequential. To be clear, we will be issuing off all of the item in the org/subinventory/lot so all serials will be issued off in that location. Please confirm how we can issue off a lot of serialised items without entering 100s of serial numbers 1 by 1. Want to do this via the front-end form, not via SQL. This is something that users do often.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Overview
 Programmatic Entry with SQL
 Personalization Example
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.