Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.
Eg: /u1/apps/apps_st/appl/APPSorcl_ebs01.env
For R 12.2+ environments, by default it connects to patch edition.

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.

...

Input Name

Input Code

Required

Description





Outputs

Output Name

Required

Description

FDEBS_OUT_INVALID_OBJECTS_COUNT

YesNo

The count of the invalid objects after completion of recompile.

...