XML files containing one or more data fix sql statements, a sql statement to back up 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 |
...