My Oracle Support Banner

Stkschedxpld.pc Batch Inserts Items In STAKE_SKU_LOC Table Without Preceding Zero (Doc ID 2379031.1)

Last updated on APRIL 02, 2018

Applies to:

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

Symptoms

Scheduled stock count explode (stkschedxpld.pc) batch inserts items in STAKE_SKU_LOC  table without preceding zero where as items are available in the system with preceding zero.

Steps To Recreate:
1. Schedule stock count with type as 'unit', data populates in STAKE_SCHEDULE table.
2. Execute the batch ‘stkschedxpld’ 1 day before stock count date.
3. Data populates in STAKE_SKU_LOC, but items are inserted without preceding zero whereas items are available in system with preceding zero (e.g. 0220000075062).

Changes

 

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!


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