A specialization rule associates an action with a type of request. There are two kinds of actions: Include and Exclude.
Include defines a manager to only read requests of the type specified.
Exclude defines a manager to read all requests except the type specified.
Requests to run concurrent programs may be allowed or disallowed on the basis of:
the ORACLE ID of the request's Set of Books (for multiple installs) or Organization if you are using multiple organizations.
the program itself or the program's application
the request type of the program
the user who submitted the request
a combined rule, which combines more than one action to generate a single rule. The combined rule applies its actions to one or more types of request.
For example, a combined rule can exclude an action from an Oracle ID and exclude another action from a specific program.
Each rule performs one action. When using more than one rule, the rules are evaluated as follows:
Include rules are evaluated together using 'OR' statements as the binding logic.
For example, If you use the rules:
Include X
Include Y
The result of the rules allows the manager to run either X 'OR' Y but does not require that both programs be run.
Exclude rules are evaluated together using 'AND' statements as the binding logic.
For example, If you use the rules:
Exclude 1
Exclude 2
The result of the rules prohibits the manager from running programs 1 'AND' 2 together or separately.
Include rules are evaluated first, then Exclude rules are evaluated. Include rule(s) and Exclude rule(s) are evaluated together as an AND statement. For example, (Include X OR Y) AND (Exclude 1 AND 2).
An Exclude rule overrides an Include rule.
Specialization rule actions, their binding logic, and examples are presented in the following two tables. See: Specialization Rule Logic - Examples.
| Include Rules | Result |
|---|---|
| Include X | Run only program X |
| Include X | Run program X |
| OR | ...or |
| Include User Sam | Run requests by User Sam |
| Net result: Run everyone's requests for program X, and run all of Sam's requests. |
| Exclude Rules | Result |
|---|---|
| Exclude 37 | Do not run program 37 |
| Exclude 37 | Do not run program 37 |
| AND | ...and |
| Exclude User Sam | Do not run requests by User Sam |
| Net result: Do not run anyone's requests for program 37, and do not run any of Sam's requests. |
| Include and Exclude Rules | Result |
|---|---|
| Include User Sam | Run only requests by User Sam |
| AND | ...and |
| Exclude 37 | Do not run program 37 |
| Net result: Run all of Sam's requests except requests to run program 37. | |
| Include X | ( Run program X |
| OR | ...or |
| Include User Sam | Run requests by User Sam ) |
| ---------- AND | ...and |
| Exclude 37 | ( Do not run program 37 |
| AND | ...and |
| Exclude User Mary | Do not run requests by User Mary ) |
| Net result: Run program X except when requested by Mary, and run all of Sam's requests except requests to run program 37. |
The following table gives examples of the action types associated with specialization rules.
| Rule Action | Type | Example | Explanation |
|---|---|---|---|
| INCLUDE | Combined Rule | Oracle Project Accounting - Tim's Budgets | Manager only reads requests to start programs defined by the Combined Rule "Tim's Budgets". |
| INCLUDE | ORACLE ID | APPS2 | Manager only reads requests to start programs that connect to the APPS2 (a single install in a multiple install schema) Oracle ID. |
| INCLUDE | Program | Oracle Project Accounting - Sales Forecast | Manager only reads requests to start the concurrent program named "Sales Forecast". |
| INCLUDE | Request Type | Oracle Inventory - Overnight Reports | Manager only reads requests to start programs belonging to the request type "Overnight Reports". |
| INCLUDE | User | Tim | Manager only reads requests to start programs submitted by the application user "Tim". |
| EXCLUDE | Combined Rule | Oracle General Ledger - Month End Reports | Manager reads all requests to start programs except those defined by the Combined Rule "Month End Reports". |
| EXCLUDE | ORACLE ID | APPS2 | Manager reads all requests to start programs except those that connect to the APPS2 Oracle ID. |
| EXCLUDE | Program | Application Object Library - Purge Audit Tables | Manager reads all requests to start programs except requests for the program named "Purge Audit Tables". |
| EXCLUDE | Request Type | Oracle Purchasing - Weekend Programs | Manager reads all requests to start programs except those belonging to the request type "Weekend Programs". |
| EXCLUDE | User | Margaret | Manager reads all requests to start programs except those submitted by the application user "Margaret". |