My Oracle Support Banner

AIF DATA - Nightly - FACT_POSFACT_VALIDATOR_JOB Failure (Doc ID 2999196.1)

Last updated on JUNE 13, 2024

Applies to:

Oracle Retail Science Platform Cloud Service - Version 23.1 and later
Oracle Retail AI Foundation Cloud Service - Version 23.2 and later
Information in this document applies to any platform.

Goal

When FACT_POSFACT_VALIDATOR_JOB fails, check the log. It might say:

Caused by: java.sql.SQLException: ORA-20001: Error occurred in RI_POS_FACT_DATA_VALIDATE.CHECK_POS_FACT_DATA_INVALID - Check BAD_INV_IT_LC_DY_FS,BAD_INVU_IT_LC_DY_FS,BAD_PRICE_IT_LC_DY_FS,BAD_NCOST_IT_LC_DY_FS,BAD_BCOST_IT_LC_DY_FS,BAD_PO_ONORD_IT_LC_DY_FS,BAD_PO_ONALC_IT_LC_DY_FS,BAD_COMP_PRICE_IT_LC_DY_FS for bad positional fact data

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.