Unable To Search and Add any Responsibility in iStore Merchant UI for Sites

(Doc ID 2317646.1)

Last updated on OCTOBER 17, 2017

Applies to:

Oracle iStore - Version 12.2.5 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

12.2.5 version, Merchant UI

ACTUAL BEHAVIOR
---------------
Unable to Add Responsibility to iStore Site.
You are trying add a responsibility to an iStore site, but search does not return any resps.

EXPECTED BEHAVIOR
-----------------------
Expect responsibility LOV to show available responsibilities

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to EBS as the iStore Administrator responsibility
2. Sites > Summary > Responsibility > Add Responsibility
3.Select Search By as Responsibility Name or Key and click Go button

Returns message:  "No records found matching the given criteria" on the result list.



LOG
------
The iStore java log file shows the exception

15:31:57:265 [ResponsibilityListBean.loadResponsibility] START
15:31:57:265 [ResponsibilityListBean.loadResponsibility] START
15:31:57:266 [ResponsibilityListBean.loadResponsibility] the seatch_by = respKey search_value = OBE%
15:31:57:267 [Core.getSearchString] START
15:31:57:268 [Core.getSearchString] the searchBy = R.responsibility_keythe searchValue = OBE% columnAttribute = -1
15:31:57:268 [Core.getSearchString] the searchStr = R.responsibility_key LIKE NLS_UPPER( :core1 )
15:31:57:269 [Core.getBindVarCounts] START
15:31:57:270 [Core.getBindVarCounts] the searchValue = OBE% columnAttribute = -1
15:31:57:271 [ResponsibilityListBean.loadResponsibility] An exception occurs when retrieving data from DB.
15:31:57:272 [ResponsibilityListBean.loadResponsibility] END

Changes

Applied Patch 21912617:R12.IBE.C ISTORE - DEFAULT ORDER TYPES BASED ON SITE RESPONSIBILITIES PHASE 2 - P1

 

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