Unable To Search and Add any Responsibility in iStore Merchant UI for Sites (Doc ID 2317646.1)

Last updated on JULY 11, 2022

Applies to:

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

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