E1: ORCH: How To Use the Database Connector To Point To the Correct DB Owner Based on The Login Environment Without Creating Multiple Groovy Script For Multiple Environments?
(Doc ID 2790222.1)
Last updated on SEPTEMBER 10, 2024
Applies to:
JD Edwards EnterpriseOne Orchestrator - Version 9.2 and later Information in this document applies to any platform.
Goal
Goal 1: Is there an Orchestrator Property file that is similar to BSSV Property file (P951000/F951000)?
Customer has a scenario working with a database connector and complex groovy code. Inside the groovy code, there is a sql select statement that is similar to "select * from testdta.f0101" where do not wish to hardcode testdta in the sql statement. Is there something similar to BSSV property (F951000) where user can put a key/value pair for database owner = testdta.
Goal 2: Based on the login environment, find out the DB owner and pass the value to the groovy script to form the SQL statement.
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!