Algorithm Types and Algorithms

New algorithm types and algorithms can be created during implementation using Scripts. Custom Java-based algorithm types are NOT permitted.

Write custom algorithm types using either Groovy or Oracle Utilities Application Framework's XML-based scripting. Refer to Defining Algorithms, Plug-In Scripts, and Using Groovy within Scripts in the Administrative User Guide or online help for information about creating algorithms using Groovy.

Key Guidelines of Groovy scripting are:

• Review the third party groovy allowlist (available within the application)

• Be careful with goto statements - it is easy to create endless loops

• Review SQL Function Allowlist (Refer to F1-SQLFunctionWhiteList Managed Content)

• Update/Delete SQL Statements are not allowed

• Explain Plan of the query(s) needs to be examined for all SQLs written in custom code.

When crafting custom SQL queries, you must consider performance. Run explain on all of your SQLs using rule hint before delivering code range scans and nested loops only. Plans with 'table access' are not acceptable. Use the Oracle Database Actions toolset to check SQL.