Domain Query In Otm

The domain query lets you run the agent as if it were in another domain.

Domain query in otm. The default parameter set configured for the domain in domain settings appears if a default was configured. Select an object type id from the drop down list. Below steps show how to create a simple saved query. If necessary choose a domain from the domain name drop down list.

The user query name identifies the saved query and must be unique. The object types correspond with different managers in otm. How to setup users to access multiple domains in otm through user roles doc id 2161216 1 last updated on february 28 2019. Click f inished to save the agent event.

Create the corresponding otm entries in xref manually. For example otm agents workflows with custom code can be developed specific to each domain so they they trigger only for transactions within that domain. Choose a data query type id from the data query type id drop down list. Create or modify an agent.

If you need to create a query using parameterized sql and need it to be run from a finder set the glog ui usesavedqueryparameters to true. Domains can be created in hierarchical manner like one parent domain at corporation level and child domains at business unit level under the same parent domain. Create the corresponding entries for the oracle transportation management otm in xref table. To get the domain query in the above example to work you need the saved query with the following sql script.

If you want to link the custom event to the otm notification system enter a notify subject in the notify subject id field. Agent runs as ship buy. Otm can automatically change text to upper case when processing the inbound xml by setting the below property to true. Enter a user query name.

You also configure the glog ui userlistsavedqueryparameters and glog ui savedqueryparameter properties. Choose a domain for the custom event from the domain name drop down list. They can be used in multiple other otm features like recurring processes business monitors etc. Oracle transportation management version 6 3 4 and later oracle transportation management cloud service version 6 4 1 and later information in this document applies to any platform.

Run the query in example 8 2 to insert the cross reference values for the accessorials created in otm. Saved queries in otm help to query specific records in a screen or add some conditions to your custom logic while creating an agent etc.