My Oracle Support Banner

DUPLICATE UPN IDS ARE ALLOWED WHEN CREATED MULTIPLE ITEMS THROUGH EXCEL TO CI (Doc ID 2466925.1)

Last updated on JULY 21, 2020

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Define Items and Attributes

ACTUAL BEHAVIOR
---------------
Duplicate UPN IDs are allowed when created multiple items through Excel to CI
But when creating an Item online and if we assign same upn id it gives
following error message.
The UPN codes assigned to this item have been assigned elsewhere (11350,59) "

REPLICATION STEPS
=================
1.Create a new item using Excel to CI. Assign xyz upn id
2.submit data
3.Create another item using excel to ci and assign xyz upn id
4.submit data
5.Now run Item load process for both the item
6.Same UPN ID is assigned to both the items with out any errors.



Changes

 Code is modified in following objects to do UPN ID duplicates verification.
SQL
IN_ITMLOADV_ITMUPN_DUP_STG_1 Normal

PeopleCode (ApplEng)
IN_ITMLOADV.ValidateGBLdefault  1900-01-01.ItmUPN.OnExecute


Cause

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
Symptoms
Changes
Cause
Solution
References


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