My Oracle Support Banner

W_RTL_IT_SUPPLIER_D_JOB Failure in Version 24.2.401.0 (Doc ID 3076485.1)

Last updated on MARCH 18, 2025

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 24.1 to 25.0 [Release 24.1 to 25.0]
Information in this document applies to any platform.

Symptoms

Currently in RI, it is possible for W_RTL_IT_SUPPLIER_D table to end up with multiple primary=Y supplier records because the user in MFCS deleted the supplier immediately after updating an item with a second supplier, causing RI to never get the update. This leads to W_PDS_PRODUCT_D_JOB failing because it only filters on primary suppliers.

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.