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:

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

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