My Oracle Support Banner

ORASE_START_BATCH_SET_ACTIVE_JOB Failure: b_r_job_util.get_next_period_id('quarterly') failed.: arithmetic syntax error (Doc ID 2947620.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.1 and later
Information in this document applies to any platform.

Goal

Why did ORASE_START_BATCH_SET_ACTIVE_JOB fail? Log shows:

2023-05-04T13:04:32,215 [Thread-28] WARN  AbstractShellJobExecutor - EXT_PROG_SYS_ERR:rse_batch_type_active.ksh: /u01/retail/orase/retail_home/rse-home/common/scripts/bin/rse_batch_type_active.ksh: line 44: Function call EXEC_FUNC for function: b_r_job_util.get_next_period_id('quarterly') failed.: arithmetic syntax error
 

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.