Item Name Not Appearing Correctly in Oracle Product Hub(EGO) When Containing Multiple Spaces
(Doc ID 2255031.1)
Last updated on APRIL 13, 2017
Applies to:Oracle Product Hub - Version 220.127.116.11 and later
Information in this document applies to any platform.
Item name does not show multiple spaces in the name in Oracle Product Hub.
It shows as one space even when multiple space is given in the item name from PIM front-end
The item name with multiple spaces however shows correctly in Inventory front-end item form and backend table ( mtl_system_items_b) segment1.
This creates issues with user who have access only to Oracle Product Hub as they are unable to see the correct item name from front-end.
Item Name appearing correctly in Oracle Product Hub when containing multiple spaces.
Steps to Reproduce
- Item Name created "TEST ITEMSPACE" (3 spaces after TEST)
(N)PIM > Item Catalog> Create Production Item
- The spaces in the item name shows correctly in INV front end form
(N)INV > Items > Master ItemsOrg : MST
Item : TEST ITEMSPACE (3 spaces after TEST)
- The spaces in the item name shows correctly in mtl_system_items_b table - segment1
SELECT distinct INVENTORY_ITEM_ID, organization_id, ITEM_CATALOG_GROUP_ID,SEGMENT1, LENGTHB(SEGMENT1)
WHERE INVENTORY_ITEM_ID = 436755
ORDER BY 1,2;
INVENTORY_ITEM_ID : 436755
SEGMENT1 : TEST ITEMSPACE (3 spaces after TEST)
LENGTHB(SEGMENT1) : 16
- Item Name seen on EGO front-end "TEST ITEMSPACE" (1 Space after TEST)
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