My Oracle Support Banner

Error Creating Assortment With Multiple Supplier (Doc ID 2564199.1)

Last updated on OCTOBER 02, 2019

Applies to:

Oracle Retail Fiscal Management - Version 14.1.3.2 and later
Information in this document applies to any platform.

Symptoms

NEW_ITEM_LOC call fails with below error :

Loja: <Loja Identifier> | Erro: @0PACKAGE_ERROR@1ORA-00001: restrição exclusiva (PK_GTAX_ITEM_ROLLUP) violada@2TAX_SQL.WRITE_RETAIL_TAX

English:
Store: <Store Identifier> | Erro: @0PACKAGE_ERROR@1ORA-00001: exclusive restriction (PK_GTAX_ITEM_ROLLUP) violated@2TAX_SQL.WRITE_RETAIL_TAX

Steps:
1) Create item with conversion factor
2) Write data in ITEM_SUPPLIER_L10N_EXT, GROUP_ID = <Group Idenifier>, for item created with more than one supplier.
3) Call  new_item_loc_sql.NEW_ITEM_LOC with above parameters.
4) Observe error

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
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.