My Oracle Support Banner

R12.2 Error 400 Bad Request After Performing Search In iProcurement ECC (Doc ID 2694351.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Oracle Enterprise Command Center Framework - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Following error occurs after performing a search in iProcurement pages

Error

400 error bad request

400 Bad Request: {"title":"Field ITEM_RATING$ doesn't exist for collection icx-catalog","errorKey":"oracle.ecc.index.retrieve.exceptions.FieldNotFoundException","stackTraceStr":"oracle.ecc.index.retrieve.exceptions.FieldNotFoundException: Field ITEM_RATING$ doesn't exist for collection icx-catalog\n\tat oracle.ecc.index.tools.SchemaHelper.getAttributes(SchemaHelper.java:341)\n\tat oracle.ecc.index.tools.SchemaHelper.getFacetOrCalculatedAttributes(SchemaHelper.java:352)\n\tat oracle.ecc.index.retrieve.services.impl.IRDataServiceImpl.getQuery(IRDataServiceImpl.java:118)\n\tat oracle.ecc.index.retrieve.services.impl.IRDataServiceImpl.getRecords(IRDataServiceImpl.java:205)\n\tat oracle.ecc.index.tools.cache.impl.CacheManager.getRecords(CacheManager.java:230)\n\tat oracle.ecc.web.controller.ir.data.IRController.getRecords(IRController.java:206)\n\tat sun.reflect.GeneratedMethodAccessor948.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm



Errors in the Incremental load may also appears, such as:

Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ECC.ECC_AUDIT_REQUEST_PK) violated\n\nError Code: 1\nCall: INSERT INTO ECC_AUDIT_REQUEST (AUDIT_REQUEST_ID, CONCURRENT_REQUEST_ID, END_TIME, EXTERNAL_REQUEST_ID, FORCE_CREATE_FLAG, PARAM_LANGUAGES, LOG_LEVEL, PARAM_RUN_LOAD_TYPE, SQL_TRACE_FLAG, START_TIME, STATUS, STATUS_MESSAGE, TIMESTAMP_UPDATED, PARAM_APPLICATION_ID, PARAM_DATASET_ID)  

 

Steps to Reproduce

1. Navigate to iProcurement  responsibility and execute any search that will error

2. Open the page the refinement part of the page is shown an error:
"Error loading guided discovery". After selecting the dataset iProcurement catalog and performing a search we get back an error which is saying "Bad request".
 

Changes

 Upgraded from Enterprise Command Center Framework (ECC) V3 to ECC V4.

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.