My Oracle Support Banner

Columns are Not Getting Updated on CONV_PROCESS_TRACKER for ITEM_LOC_HIST ENTITY (Doc ID 2956268.1)

Last updated on JUNE 26, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Some of the columns are not getting updated on CONV_PROCESS_TRACKER for item_loc_hist entity.

EXPECTED BEHAVIOR
-----------------------
Expected below columns to get updated on the conv_process_tracker table for this job.

ROWS_FAILED_DATA_VALIDATION
ROWS_SUCCEDED_DATA_VALIDATION
ROWS_LOADED_TO_MAIN_TABLE
BUSINESS_VALIDATION_START_TIME
BUSINESS_VALIDATION_END_TIME
ROWS_FAILED_BUSS_VALIDATION

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use New API for conversion
2. Observe conv_process_tracker is showing incorrect counts


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.