My Oracle Support Banner

AIF DATA - PRODUCT.csv Load - RI_UPDATE_TENANT_JOB Fails with "Empty or null value not allowed for the field: formatOptionsdateformat" (Doc ID 3073647.1)

Last updated on MARCH 03, 2025

Applies to:

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

Goal

While attempting to load the product.csv file, the RI_UPDATE_TENANT_JOB is failing ad the log shows:

The following errors are shown in the job log: 

"status": 400, "error": "Bad Request", "message": "Empty or null value not allowed for the field: formatOptionsdateformat"

"formatOptions": { "dateformat": ""

Looking at other parts of the log we see that the dateformat there is filled like this: "formatOptions": { "dateformat": "YYYYMMDD".

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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