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.
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. |
Property Name | Required | Description |
---|---|---|
|
|
|
Input Name | Required | Description |
---|---|---|
|
|
|
Output Name | Required | Description |
---|---|---|
FDEBS_OUT_INVALID_OBJECTS_COUNT | Yes | The count of the invalid objects after completion of recompile. |
This operation will not consume or produce artifacts.
This operation will run randomly on any App Tier and connects to DB Tier.
This operation will run randomly on any App Tier resource type endpoint.
This operation recompiles invalid DB objects from all the schemas except SYSTEM and SYS.