DIM_PROD_VALIDATOR_JOB Failed In LOAD_DIM_INITIAL_ADHOCPROD_R6 - NULL VALUE COUNTPROD_R3 - (Doc ID 3022726.1)

Last updated on MAY 15, 2024

Applies to:

Goal

On : 24.1 version, Batch Modules

DIM_PROD_VALIDATOR_JOB failed in LOAD_DIM_INITIAL_ADHOCPROD_R6 - NULL VALUE COUNTPROD_R3 -

DIM_PROD_VALIDATOR_JOB failed with the following error codes. The files that are being loaded are directly produced by the RDE jobs, so these errors are unexpected given the base integration between MFCS and RAP.

PROD_R3 - PROD_HIER_NO_CHILD_LEVEL - A node of the product hierarchy has no children under it. If possible, remove all cases of nodes having no children (for example, if all items are reclassed out of a subclass, delete the old subclass). Some AI Foundation functionality will fail if you attempt to run it on empty nodes.

PROD_R6 - NULL VALUE COUNT - Null or -1 dummy values are present on product attribute columns that are critical to the operation of multiple RAP applications. The warning message columns map to the item level (ATTR11), tran level (ATTR12), diff aggregate (ATTR16), and item/parent/grandparent (ATTR13,14,15) fields in the PRODUCT file. Fill in the null values on the specified columns with non-null values wherever possible and re-send the product file. If you are okay with the null values and understand the impact then this warning may be ignored.

PROD_R12 - PROD_DUP_CASE_INSENSITIVE - You have duplicate item IDs when ignoring the case, such as XYZ and xyz, which is not allowed on the platform. Item IDs are not case-sensitive. Delete duplicate items such that you only have a single ID across all lowercase/uppercase variations. ?
 

Solution

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