My Oracle Support Banner

Items Not Getting Created When Running The Batch For Item Creation (Doc ID 2860373.1)

Last updated on APRIL 04, 2022

Applies to:

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

Goal

When trying to create items from backend but it is failing with various error messages (example):
@0NO_VIS_HIER@1@MH4@2999
@0INV_ITEM
@0NO_VIS_HIER@1supplier@29998
ISC_ITEM_SUP_REL_NO_EXIST
@0NO_VIS_HIER@1supplier@29998
INVALID_ITEM
@0INV_ITEM
PRIM_COUNTRY_REQ
@0INV_ITEM
IS_NOT_EXIST
@0INV_ITEM



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Place "Create item" file in inbound directory.
2. Run the batch tco_ld_iindfiles_wrapper.ksh from batch server.
3. File is getting successfully loaded but item is not getting created.
4. Error messages can be seen in coresvc_item_err table for that particular process id.
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.