Deploys EBS Artifacts to the specified EBS server. This operation checks each file for changes and deploys the file if it has changed. This operation is equal to apply phase if you are using adop phases for applying manual changes.
...
If you need to execute the SQL files other than the default user (FDEBS_DB_USER), you need to prefix the file name with SCHEMAXXX_. Eg: SCHEMAPOS_PER_SQF.sql and define pair of environment instance properties on your workflow as below:
FDEBS_DB_SCHEMAPOS_DB_USER
FDEBS_DB_SCHEMAPOS_DB_PASSWORD
If you need to execute the XDF files other than default user, please create the pair of properties for primary schema as above.
Environment/Instance Properties
Property Name | Required | Description |
---|---|---|
FDEBS_SOURCE_SCRIPT | Yes | Source Script with full path. |
FDEBS_DB_USER | Yes | DB User to connect with privileges. |
FDEBS_DB_PASSWORD | Yes | Password to connect for FDEBS_DB_USER. |
FDEBS_SYSTEM_PASSWORD | For ADOP | SYSTEM Password for AD Online Patching. |
Project Properties
Property Name | Required | Description |
---|---|---|
FDEBS_STOP_ON_ERROR | No | Stop deploying, if any error occurs. If false or not specified, deploying of other files will be continued. |
FDEBS_JAVA_CLASSPATH | No | Set the classpath, if needed for Java Compilation. |
FDEBS_WORKFLOW_CLASSPATH | No | Set the classpath, if needed for Workflow Load (WFXLoad). |
FDEBS_FORMS_CLASSPATH | No | Set the classpath, if needed for Forms compilation. |
FDEBS_SCHEMA_DB_USER | No | ORACLE schema name in which the objects should be created for XDF. Eg: pos |
FDEBS_SCHEMA_DB_PASSWORD | No | ORACLE schema password for FDEBS_SCHEMA_DB_USER. |
FDEBS_SQL_RETRY_COUNT | No | Retry count for SQLs and PL/SQLs. Default is 5 |
FDEBS_SQL_ROOT_DESTINATION_DIR | No | Target directory for SQL and PLS files. |
FDEBS_CP_SQL_ROOT_DESTINATION_DIR | No | Target directory for Concurrent Prorgram's SQLs (Not executed after deploy). |
FDEBS_JAVA_ROOT_DESTINATION_DIR | No | Target directory for java,class,xml files. |
FDEBS_FORMS_ROOT_DESTINATION_DIR | No | Target directory for form files (fmx). |
FDEBS_FORMS_ROOT_STAGE_DIR | No | Stage directory for form files (fmb). |
FDEBS_REPORTS_ROOT_DESTINATION_DIR | No | Target directory for report files. |
FDEBS_MEDIA_ROOT_DESTINATION_DIR | No | Target directory for image files. |
FDEBS_HTML_ROOT_DESTINATION_DIR | No | Target directory for html files. |
FDEBS_FONTS_ROOT_DESTINATION_DIR | No | Target directory for font files. |
FDEBS_SCRIPTS_ROOT_DESTINATION_DIR | No | Target directory for script files. |
FDEBS_PERL_ROOT_DESTINATION_DIR | No | Target directory for perl modules. |
FDEBS_JAR_ROOT_DESTINATION_DIR | No | Target directory for JAR files. |
FDEBS_EAR_ROOT_DESTINATION_DIR | No | Target directory for ear files. |
FDEBS_DAT_ROOT_DESTINATION_DIR | No | Target directory for Dat files. |
FDEBS_SQL_LDR_ROOT_DESTINATION_DIR | No | Target directory for control (ctl) files. |
FDEBS_LOAD_JAVA_ROOT_DESTINATION_DIR | No | Target directory for Java Stored Procedure files. |
FDEBS_ PUBLISHER_ROOT_DESTINATION_DIR | No | Target directory for Publisher files. |
FDEBS_IGNORE_ERRORS_FILE_LIST | No | List of files to ignore errors. (e.g: DropHRTables.sql, CreateTables.sql) |
Inputs
Input Name | Required | Description |
---|---|---|
FDEBS_INP_FORCE_FILES | No | List of files to ignore errors. (e.g: DropHRTables.sql) |
Outputs
Output Name | Description |
---|---|
FDEBS_OUT_DEPLOYED_FILES_LIST | List of files which were deployed. |
FDEBS_OUT_SKIPPED_FILES_LIST | List of files which were skipped. |
...