My Oracle Support Banner

How to Process Sale Transactions in SIOCS That Are Generated in Xstore and Deleted from Retry Queue (Doc ID 3050917.1)

Last updated on OCTOBER 01, 2024

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 24.0 and later
Oracle Retail Xstore Point of Service - Version 19.0 and later
Information in this document applies to any platform.

Goal

In certain situations due to various reasons customers run into an issue whereby Sale transactions completed in Oracle Retail Xstore Point of Service are missing from SIOCS. Those transactions are also not available in the 'CTL_SERVICE_RETRY_QUEUE'. This situation would cause a SOH out of sync between SIOCS and MFCS as MFCS(RESA) would have received an RTLOG from Xstore for the sale transactions.  In addition to that SIOCS would not reflect correct SOH for items in the store.

This document provides a high level guidance on how those transactions can be processed in SIOCS to get the inventory positions updated.

NOTE: Steps mentioned in this document must only be performed after the appropriate Oracle teams have reviewed the particular situation on hand and identified that this is the appropriate work around for any particular case.

Solution

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
Goal
Solution


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