My Oracle Support Banner

STKDLY Batch Is Failing For Stock Counts That Are Marked For Delete (stake_head.delete_ind='Y') (Doc ID 2847152.1)

Last updated on JUNE 22, 2023

Applies to:

Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.


STKDLY batch is failing for stock counts that are marked for deletion (stake_head.delete_ind='Y').

When there are stock counts which are scheduled with future date and due to business requirements the stock count date needs to change. The users are marking the stock count to delete and scheduling new stock count for same dept/class/subclass/location with new stock count date.
However STKDLY job is considering the old stock count (stake_head.delete_ind='Y') as Unprocessed (stake_prod_loc.processed='N') and its failing due to old unprocessed counts for same dept/class/location combination.

stkdly_11~20211115235323~process~stake_prod_loc, stake_head~0~ORA-0000: normal, successful completion~APPLICATION ERROR: An unprocessed stock count for dept=10 class=1 subclass=1 location=10663 loc_type=S was scheduled before cycle count 2860159.


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.