My Oracle Support Banner

Direct Item Entry Error: "Item Not Set Up For Purchase Through This Store" After Upgrade (Doc ID 2187335.1)

Last updated on MAY 10, 2022

Applies to:

Oracle iStore - Version 12.0.6 to 12.2.9 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On Test:  12.2.5 version, Direct Item

Direct Item Entry Errors after upgrade from 11i.
Adding item via Admin UI resolves the issue, but item from 11i should already exist and no need to add again.

ERROR
-----------------------
Invalid Item number or Item not set up for purchase through this store

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to iStore
2. Carts > Direct Item Entry
3. Enter Inventory product number
4. Click Fill details

 

Changes

 In order for item to be added via direct item entry page, it must be associated to a section and a minisite.
While item was associated to a section, section-minisite association was missing.

Custom program was used to populate the items in Admin UI.
So, this issue is caused by custom batch program since it was not populating all required tables.
 

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