compileInvalidSqls
- Copy Page Tree
- Chandresh Patel
- Karl Henselin
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 | FDEBS_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. e.g. /u1/apps/apps_st/appl/APPSorcl_ebs01.env run |
| EBS Database User | FDEBS_DB_USER | Yes | DB User to connect with privileges. eg: Apps. |
| EBS Database Password | FDEBS_DB_PASSWORD | Yes | DB Password to connect for FDEBS_DB_PASSWORD. |
Project Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Inputs
Input Name | Input Code | Required | Description |
|---|---|---|---|
Outputs
Output Name | Required | Description |
|---|---|---|
FDEBS_OUT_INVALID_OBJECTS_COUNT | 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