My Oracle Support Banner

AIF DATA: How to Resolve SI_W_INT_ORG_DS_JOB Failure with Error "ORA-20001: Program has already run for current business date"? (Doc ID 3040640.1)

Last updated on AUGUST 12, 2024

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 24.1 and later
Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version 24.0 and later
Oracle Retail Lifecycle Pricing Optimization Cloud Service Advanced Edition - Version 24.1 and later
Information in this document applies to any platform.

Goal

The SI_W_INT_ORG_DS_JOB failed in the Standalone schedule (and the below jobs also need to run in sequence). The failure is "ORA-20001: Program has already run for current business date". How can this be resolved?

These are the complete steps that are being executed when we encountered this failure in SI_W_INT_ORG_DS_JOB.

(1) Add previous ORGANIZATION.csv to RI_REPROCESS_DATA.zip and send the zip file to Object Storage.
(2) Run the REPROCESS_ZIP_FILE_PROCESSS_ADHOC job from POM.
(3) Run the following jobs in sequence from the Standalone schedule -
COPY_SI_ORGANIZATION_JOB
STG_SI_ORGANIZATION_JOB
SI_W_INT_ORG_DS_JOB
SI_W_INT_ORG_DS_TL_JOB
SI_W_INT_ORG_DHS_JOB
SI_W_INT_ORG_ATTR_DS_JOB
(4) Restart DIM_ORG_VALIDATOR_JOB from the nightly batch.
 

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.