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

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle iStore - Version 12.2.5 and later
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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to test upgraded instance.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms