XML files containing one or more data fix sql statements, a sql statement to back up data, and validation statements used XML files containing one or more data fix sql statements, a sql statement to back up data, and validation statements used to determine whether the data fix should be committed or rolled back.
Object Type Identification
...
| Name | Code |
|---|---|
| Data Fix | DATA_FIX |
Object Type Attributes
| Name | Code | Description | Required | Default Value | Supported Values | ||||
|---|---|---|---|---|---|---|---|---|---|
| Source | SOURCE | Object source location type | Yes | SCM | SCM | ||||
| Target Location | TARGET_LOCATION | Path to where the file should be deployed to | No | ||||||
| Database User Property | DB_USER | Property name for database user name | No | FDEBS_DB_USER | |||||
| Database Password Property | DB_PASSWORD | Property name for database password | No | FDEBS_DB_USER | Database Password Property | DB_PASSWORD | Property name for database password | No | FDEBS_DB_PASSWORD |
Related Project Properties
| FDEBS_DB_PASSWORD |
Related Project Properties
| Name | Code | Description | Default Value |
|---|---|---|---|
| Data Fix Root Source Directory | FDEBS_DATA_FIX_ROOT_SOURCE_DIR | The source directory to recognize files as data fixes | datafix |
| Data Fix Root Destination Directory | FDEBS_DATA_FIX_DESTINATION_DIR | The destination directory to copy file to. Leave blank to not copy file anywhere |
Related Environment Instance Properties
| Name | Code | Required | Description |
|---|---|---|---|
| JDBC Driver Path | FDEBS_DRIVER_PATH | Yes | Location of JDBC driver file required only for running data fix files. For example, /u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc6.jar |
Sample Build Commands
N/A - Build commands not supported for this type.
...
| Tag Name | Required | Description |
|---|---|---|
| Description | Yes | A description for the data fix being run |
| FixSQL | Yes | The SQL which implements the data fix. It can be multiple statements delimited by a semicolon or slash |
| BackupSQL | Yes | SQL to perform necessary backup of data before executing FixSQL. This must be one valid SQL statement, not followed by a semicolon |
| ConnectStringProperty | No | The JDBC connection string for the database. The APPS_JDBC_URL environment variable will be used if property is not specified in file |
| UserProperty | No | User to connect to database with. Environment instance property FDEBS_DB_USER The object attribute will be used if property is not specified in file |
| PasswordProperty | No | Password for the database user. Environment instance property FDEBS_DB_PASSWORD The object attribute will be used if property is not specified in file |
| Validations | Yes | The rule(s) used to validate the data fix before committing changes |
| Validation | Yes | A single validation rule. See below for more details |
...