Initial Price ReST Service Gives Intrnal Error (Doc ID 2990128.1)

Last updated on DECEMBER 01, 2023

Applies to:

Symptoms

On : 23.1 version, OTHER

When attempting to call the "initial" ReST service using a valid node-level/node-id combination
the following error occurs:

NOTE:
 If you use a combination without data in the table "merchapi_item_loc" or in the view "v_merchapi_initial_item_price", the service
 does not fail and returns an empty object in the response.


The issue can be reproduced at will with the following steps:
1. From SwaggerUI - PricingServices in DEV1, expand the "/services/private/omnichannel/v2/item/price/initial" service.

2. Set the Node Level and Node Id parameters.
  -- Case 1
  Node Level: STORE
  Node Id: 51082

  -- Case 2
  Node Level: COMPANY
  Node Id: 1

3. Set "Limit" parameter to 1 to so as not to impact performance.

4. Error message received.
{
  "error": "INTERNAL_SERVER_ERROR",
  "error_message": "Encountered an internal server error. Contact your system administrator."
}

Changes

Cause

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