My Oracle Support Banner

Why A Store That Is already In The Store Table Is Still Showing In The Store_Add Table? (Doc ID 3052501.1)

Last updated on OCTOBER 14, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Goal

There is a store that is already in the store table, but it is still showing in the store_add table.

The async status has moved to S- completed. Still the process_status is 01STOREADD in store_add table. Team had run the stradd_batch also which failed with below error.

2024-07-01T22:45:00,987 [Thread-2816] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/rms/oracle/proc/bin/rmswrap.ksh: This file will export the variables needed to run batch.
2024-07-01T22:45:00,987 [Thread-2816] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/rms/oracle/proc/bin/rmswrap.ksh:
2024-07-01T22:45:01,019 [Thread-2816] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/rms/oracle/proc/bin/rmswrap.ksh: Process Id is : 836
2024-07-01T22:45:01,024 [Thread-2816] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/rms/oracle/proc/bin/rmswrap.ksh: Mon Jul 1 22:45:01 Program: rmswrap: PID=836: Started by default user

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
References


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