My Oracle Support Banner

The Items Are Not Getting Inserted/merged Into The Itm_item_options Table In XOCS (Doc ID 3049111.1)

Last updated on SEPTEMBER 22, 2024

Applies to:

Oracle Retail Xstore Office Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

The items are not getting inserted/merged into the itm_item_options table in XOCS. After file upload the files are getting successfully processed and there is not a single error.

Already raised a previous ticket for the same issue but that SR 3-37550294761 is not to be found anywhere when searched.

ERROR
-----------------------
 "404 Not Found".

Steps to Re-create :
-----------------------
1. Searched items in XOC via dtxql query but received only service items in the result set.
2. Created item loc files and uploaded via file deploy and the files got successfully uploaded.
3. When searched with the query again the uploaded items didn't reflect and gave "404 Not Found".
4. This problem is consistent only with itm item options table.

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
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.