Stock Count 4731 Did Not Pull In Physical Count File (Doc ID 3072625.1)

Last updated on FEBRUARY 18, 2025

Applies to:

Goal

On : 19.3 version, Merch - Inventory Tracking

Why did the Stock Count 4731 not pull in Physical Count file , process: 1330003 on 12-Feb-25?

The file upload process seems to have failed for Stock count 4731, process 1330003.
The file in the detail table is still showing as in 'N' status, and there appears to have been 2 errors listed in the SVC_STKUPLD_STATUS, but they do not make any sense.

select * from svc_stkupld_fhead where cycle_count ='4731' -- process_id ='1330003'
select * from svc_stkupld_fdetl where process_id ='1330003'

select * from SVC_STKUPLD_STATUS where process_id = 1330003 and ERROR_MSG is not null


The stockcountupload.ksh job did not show any failures, the Job audit logs show the file as successfully validated and the status record successfully created for the STK_2_4731_20250211122601.DAT file. But then shows a possible rollback due to those two errors?
 

Solution

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