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. 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. 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. Make sure you have permission to execute sqls with this user for all schemas.
EBS Database Password	FDEBS_DB_PASSWORD	Yes	DB Password to connect for FDEBS_DB_PASSWORD.

Property Name

Property Code

Required

Description

EBS Source Script

FDEBS_SOURCE_SCRIPT

Yes

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.

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.
Make sure you have permission to execute sqls with this user for all schemas.

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.

Browser not supported