- style
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 | Required | Description |
|---|---|---|
FDEBS_SOURCE_SCRIPT | Yes | Source Script with full path. |
FDEBS_DB_USER | Yes | DB User to connect with privileges. eg: Apps. |
FDEBS_DB_PASSWORD | Yes | DB Password to connect for FDEBS_DB_PASSWORD. |
Project Properties
Property Name | Required | Description |
|---|---|---|
|
|
|
Inputs
Input Name | Required | Description |
|---|---|---|
|
|
|
Outputs
Output Name | Required | Description |
|---|---|---|
FDEBS_OUT_INVALID_OBJECTS_COUNT | Yes | 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