My Oracle Support Banner

Deleted Stock-take(s), Scheduled To Previous Month, Caused Failure To SALMTH Batch (Doc ID 2577305.1)

Last updated on JUNE 12, 2021

Applies to:

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


SALMTH fails for "deleted" unprocessed stocks with following error:

Error: salmth_4~YYYYMMDDHHMISS~init~stake_prod_loc, stake_head~0~ORA-0000: normal, successful completion~ERROR: Stocktake(s) were scheduled during the previous month and not all have been processed.

Steps to Reproduce:
1. Identify an unprocessed stock count in deleted status which is in current month.
2. Run SALMTH job.
3. Notice it fails with error stated above.


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

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