Leading Zeros Removed From Char Type Attribute Value During Multi Item Create

(Doc ID 2372986.1)

Last updated on MARCH 13, 2018

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Catalog items

ACTUAL BEHAVIOR
---------------
Leading zeros are removed from Char type attribute value during Multi Item Creation.

The leading zeros are removed from Character type attribute value during multi item creation and the value entered is all numeric values starting with a zero. The value entered in the 'Function' attribute value (CHAR) in the UI gets stored in the interface table without leading zeros. This is causing issues creating item numbers with dash values example xxxxx-001 becomes xxxxx-1. Also if there is a valid value set associated with the attribute and the attribute value is all numbers that start with a 0, the concurrent program gets an error saying the value is invalid.



EXPECTED BEHAVIOR
-----------------------
Expected result is if user enters 01 in a char field, the value is saved as 01.

WORK AROUND
-----------------------
The work around is to use single item create.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Navigate to Development Manager->Item Catalog->Create Production Items
2.Enter ICC and Number of Items
3.Number of items must be greater than 1
4. Enter the attribute value in 'Function' as 00 for item 1 and 01 for item 2
5.Log showing item numbers created and request id
6. Search the item 1 and open item overview details page
7.First item created with 0 for function attribute value
8. Search the item 2 and open item overview details page
9.Second item created with 1 for function attribute value
10.The data is the interface table shows leading zeros have been removed. (Table : ego_itm_usr_attr_intfc)


Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms