My Oracle Support Banner

SIOCS: Generate Unit Stock Count Job Is Failing (Doc ID 3026724.1)

Last updated on JUNE 05, 2024

Applies to:

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

Symptoms

Generate Unit Stock count Job is failing with error:

ERROR
-----------------------
Error executing stored procedure. SQLSyntaxErrorException(936): ORA-00936: missing expression
ORA-06512: at "SIM01.PROD_GROUP_STOCKCOUNT_PKG", line 389
ORA-06512: at "SIM01.PROD_GROUP_STOCKCOUNT_PKG", line 389
ORA-06512: at "SIM01.PROD_GROUP_STOCKCOUNT_PKG", line 504
ORA-06512: at "SIM01.PROD_GROUP_STOCKCOUNT_PKG", line 504
ORA-06512: at "SIM01.STOCK_COUNT_PKG", line 578
ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Unit Stock count for a future date
2. On Job Admin screen - Run the Generate Unit Stock Count job

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.