compileInvalidSqls
Recompiles all invalid DB objects on an EBS Database Instance. This operation returns the count of invalid DB objects after completion of recompilation. This count can be used to fail the deployment, if desired.
Environment/Instance Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
EBS Source Script |
| Yes | Source Script with full path. If you would like to apply changes directly to run edition for EBS R 12.2+, specify the run param after the script. By default it connects to patch edition when performing the deploy operation. All other operations are sourced from run by default. e.g. |
EBS Database User |
| Yes | DB User to connect with privileges. eg: Apps. |
EBS Database Password |
| Yes | DB Password to connect for |
Project Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
Inputs
Input Name | Input Code | Required | Description |
---|---|---|---|
Outputs
Output Name | Required | Description |
---|---|---|
| No | The count of the invalid objects after completion of recompile. |
Artifacts
This operation will not consume or produce artifacts.
Endpoint Selection
This operation will run randomly on any App Tier and connects to DB Tier.
Endpoint Execution
This operation will run randomly on any App Tier resource type endpoint.
Special Considerations
This operation recompiles invalid DB objects from all the schemas except SYSTEM
and SYS
.
- style