> ## Documentation Index
> Fetch the complete documentation index at: https://docs.flexagon.com/llms.txt
> Use this file to discover all available pages before exploring further.

# compileInvalidSqls

> Recompiles all invalid DB objects on an EBS Database Instance. This operation returns the count of invalid DB objects after completion of recompilatio

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.  

# Target Properties

<table><colgroup><col /><col /><col /><col /></colgroup><tbody><tr><th>**Property Name**</th><th>**Property Code**</th><th>**Required**</th><th>**Description**</th></tr><tr><td>EBS Source Script</td><td>`FDEBS_SOURCE_SCRIPT`</td><td>Yes</td><td>Source Script with full path. \
e.g. `/u1/apps/apps_st/appl/APPSorcl_ebs01.env`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. `/u1/apps/apps_st/appl/APPSorcl_ebs01.env` *run*</td></tr><tr><td>EBS Database User</td><td>`FDEBS_DB_USER`</td><td>Yes</td><td>DB User to connect with privileges. eg: Apps.\
Make sure you have permission to execute sqls with this user for all schemas.</td></tr><tr><td>EBS Database Password</td><td>`FDEBS_DB_PASSWORD`</td><td>Yes</td><td>DB Password to connect for `EBS Database User`.</td></tr></tbody></table>

#  Outputs

<table><colgroup><col /><col /><col /></colgroup><tbody><tr><th>**Output Name**</th><th>**Required**</th><th>**Description**</th></tr><tr><td>`FDEBS_OUT_INVALID_OBJECTS_COUNT`</td><td>No</td><td>The count of the invalid objects after completion of recompile.</td></tr></tbody></table>

# 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`.