E1: ORCH: Database Connector SQL Select with Date Condition Produces an Error "Unable to parse operation" (Doc ID 2966485.1)

Last updated on AUGUST 08, 2023

Applies to:

Symptoms

A Database Connector with Groovy Script is created in Orchestrator Studio with the following SQL statement in order to retrieve records in a table (e.g. F0006) where a date field (e.g. UPMJ) is less than a particular date.

SELECT  MCU,  UPMJ AS JDEDATE  FROM  F0006 WHERE  PECC = 'N' AND MCU NOT LIKE '%MODEL%' AND UPMJ <= ${Date}"

Database Connector Groovy Script Example

This SQL Statement produces an error "Unable to parse operation" as follows when the Orchestration is run:

How to perform this Select statement in Groovy code?

Changes

Cause

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