My Oracle Support Banner

[E] Erro ORA-20001 Error While Creating Catch-Weight Item Using XItem API (Doc ID 2810616.1)

Last updated on SEPTEMBER 30, 2021

Applies to:

Oracle Retail Merchandising System - Version 14.1.3 and later
Information in this document applies to any platform.

Symptoms

In Brazil localized version 14.1.3.2

When creating a Catch-Weight (CW) item using the XItem API, with two dimensions:
Each (EA) as dimension in its XISCDimDesc structure and Box (CA) as dimension in its XISCDimDesc structure

the following error is returned:
[E] Erro ORA-20001: [],ITEM:xxxxxxxx,SUPPLIER:xxxxxxxx,COUNTRY:BR retornado pela unidade de programa CORESVC_ITEM.PROCESS_ISC.

Steps To Recreate:
1. Create an item through the XItem API
1a. Note, it uses EA and CA as DIM_OBJECT in RIB_XISCDIMDESCREC.
2. The error "[E] Erro ORA-20001: [],ITEM:xxxxxxxx,SUPPLIER:xxxxxxxx,COUNTRY:BR retornado pela unidade de programa CORESVC_ITEM.PROCESS_ISC.". will occur.



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.