Retail Point-of-Service Solutions (MOSC)

MOSC Banner

Alphanumeric item ID not working in item sale

edited Nov 25, 2018 9:16AM in Retail Point-of-Service Solutions (MOSC) 9 commentsAnswered ✓

Hi All,

We are using xstore 15.0

how to sell an item with alphanumeric item id?

I have added item id like H8699486724863 when i sell the item it says " there is no items matching the entered dimensions value".

i found out that it queries the parent_item_id with the this query "

SELECT t.organization_id,

  t.item_id,

  t.dtv_class_name,

  t.create_date,

  t.create_user_id,

  t.update_date,

  t.update_user_id,

  t.org_code,

  t.org_value,

  t.description,

  t.item_lvlcode,

  t.item_typcode,

  t.merch_level_1,

  t.merch_level_2,

  t.merch_level_3,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center