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 FEBRUARY 07, 2022

Applies to:

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

Symptoms

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.

Error
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.

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.