My Oracle Support Banner

E1: ORCH: Database Select Statement Not Working In Orchestrator Groovy Script (Doc ID 2661763.1)

Last updated on APRIL 21, 2020

Applies to:

JD Edwards EnterpriseOne Orchestrator - Version 9.2 and later
Information in this document applies to any platform.


Select statement is not working in a groovy script in connector service request and not able to find the parameters in the log.

Customer was trying to get the Line Type(pdlnty) from F4311 by selecting DOCO and LITM and getting an error.

Below is the select statement being used in the groovy script.

F4311Data = sql.rows("select pdlnty from proddta.F4311 where pddoco = ${DOCO} and pdlitm = ${LITM}");
LNTY = F4311Data[0].pdlnty;

DOCO and LITM are the variables that are being assigned to pddoco and pdlitm.  Here is the error found in the AIS debug log indicating that the variable did not get set correctly.





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

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

In this Document

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