DC_ITEM Failures Without Any Valid Reason - But Getting Processed On Retry
(Doc ID 2877398.1)
Last updated on JUNE 17, 2022
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.
DC_ITEM Failures without any valid reason - but getting processed on retry
This behavior has been observed with DC Tool in mock conversion, mostly on pack items upload.
Even though we start uploading pack items only after conversion of the component items successfully completes, we see the below errors in our pack item upload process :
A few of the packs in the upload fail with these errors while the remaining goes through fine.
Taking an example of below pack item:
PACK_NO SEQ_NO ITEM ITEM_PARENT
10105376 3 10105206 10105343
10105376 1 10105371 10105343
10105376 2 10105372 10105343
10105376 4 10105373 10105343
10105376 5 10105374 10105343
All the component items are successfully processed in process id 2382
select process_id, PROCESS$STATUS from rdc01.svc_item_master where item in('10105206','10105371','10105372','10105373','10105374') ;
However, the pack item failed three times with the above mentioned errors before successfully being processed.
select process_id, PROCESS$STATUS from rdc01.svc_item_master where item in('10105376');
PROCESS_ID | PROCESS$STATUS
2384 | PE
2386 | PE
2388 | PE
2389 | PS
The pack item got processed fine after uploading 4 times. We need to find the reason why it was rejected multiple times before going through fine without any data change.
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