Deploys EBS Artifacts to the specified EBS server. This operation checks each file for changes and only deploys each file if it has changed or is set to forced. This operation is equal to apply phase if you are using adop phases for applying manual changes. The environment/instance property for the source script can be used to choose what patch mode is used. If the source script is just the path to the source script, the deployment is equivalent to apply_mode=online, and the files are applied to the patch edition. If instead, " run" is appended to the source script, the deployment can be done equivalently to either downtime or hotpatch apply_mode by either leaving the server running, or stopping it before the operation. If you do not wish to use ADOP, append the " run" to the end of the source script.
Files will be deployed in the order saved in the build step. If the order of deployment must be adjusted, perform a new build. See the build operation for more information about ordering files or search the wiki for more information.
If you need to execute the SQL files other than the default user (EBS Database User
), you need to prefix the file name with SCHEMAXXX_. Eg: SCHEMAPOS_PER_SQF.sql and define a pair of properties on your workflow as below:
- FDEBS_DB_SCHEMAPOS_USER
- FDEBS_DB_SCHEMAPOS_PASSWORD
If you need to execute the XDF files other than default user, please create the pair of properties for primary schema as above.
See also EBS Object Types Reference for a list of supported EBS object types.
Info |
---|
If performing clone operations between environments, consider using the Post Refresh utilities of flexDeploy. Read more on the Post Refresh Requests page. (new in 5.0) |
Environment/Instance Properties
...
Property Code
...
Required
...
Description
...
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 when performing the deploy operation. All other operations are sourced from run by default.
e.g. /u1/apps/apps_st/appl/APPSorcl_ebs01.env
run
Tip |
---|
If you are adding more than one endpoint for an environment/instance, this file must be same location for all endpoints. If necessary you should create symbolic links on each endpoint, so location of environment file is same. |
...
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.
...
FDEBS_DB_PASSWORD
...
Yes
...
Password to connect for EBS Database User
.
...
FDEBS_SYSTEM_PASSWORD
...
For ADOP
...
SYSTEM Password for AD Online Patching.
Project Properties
...
Property Code
...
Required
...
Description
...
FDEBS_APPLICATION_SHORT_NAME
...
Deploys EBS Artifacts to the specified EBS server. This operation checks each file for changes and only deploys each file if it has changed or is set to forced. This operation is equal to apply phase if you are using adop phases for applying manual changes. The environment/instance property for the source script can be used to choose what patch mode is used. If the source script is just the path to the source script, the deployment is equivalent to apply_mode=online, and the files are applied to the patch edition. If instead, " run" is appended to the source script, the deployment can be done equivalently to either downtime or hotpatch apply_mode by either leaving the server running, or stopping it before the operation. If you do not wish to use ADOP, append the " run" to the end of the source script.
Files will be deployed in the order saved in the build step. If the order of deployment must be adjusted, perform a new build. See the build operation for more information about ordering files or search the wiki for more information.
If you need to execute the SQL files other than the default user (EBS Database User
), you need to prefix the file name with SCHEMAXXX_. Eg: SCHEMAPOS_PER_SQF.sql and define a pair of properties on your workflow as below:
- FDEBS_DB_SCHEMAPOS_USER
- FDEBS_DB_SCHEMAPOS_PASSWORD
If you need to execute the XDF files other than default user, please create the pair of properties for primary schema as above.
See also EBS Object Types Reference for a list of supported EBS object types.
Info |
---|
If performing clone operations between environments, consider using the Post Refresh utilities of flexDeploy. Read more on the Post Refresh Requests page. (new in 5.0) |
Environment/Instance Properties
Property Name | Property Code | Required | Description | ||
---|---|---|---|---|---|
EBS Source Script |
| Yes | Source Script with full path. 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 when performing the deploy operation. All other operations are sourced from run by default. e.g. Adding patch to the end is not allowed. This is because it will be added automatically if run is not added and you are deploying.
| ||
EBS Database User |
| Yes | DB User to connect with privileges. | ||
EBS Database Password |
| Yes | Password to connect for | ||
EBS System Password |
| For ADOP | SYSTEM Password for AD Online Patching. |
Project Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
EBS Application Short Name |
| App short name (e.g. XXAR). If source includes multiple custom tops, leave it empty and make sure top directory matches top name. | |
OAF Java Root Destination Directory |
| No | Target directory for java,class,xml files. |
OAF Java Classpath |
| No | Set the classpath, if needed for Java Compilation. |
OAF MDS Root Destination Directory |
| No | Target directory for MDS files (webui xmls). Default is PROD_TOP/mds. (e.g. $XXHR_TOP/mds). |
Concurrent Program SQL Root Destination Directory |
| No | Target directory for Concurrent Program's SQLs (Not executed after deploy). |
Java Stored Procedure Root Destination Directory |
| No | Target directory for Java Stored Procedure files. |
SQL Root Destination Directory |
| No | Target directory for SQL and PLS files. |
SQL Retry Count |
| No | Retry count for SQLs and PL/SQLs. Default is 5 |
SQL Ignore Compile Errors |
| No | Ignore SQL compilation errors. |
SQL*Loader Root Destination Directory |
| No | Target directory for control (ctl) files. |
FDEBS_AOL_ROOT_DESTINATION_DIR | No | Target directory for java,class,xml AOL (ldt) files. | |
OAF Java Classpath |
| No | Set the classpath, if needed for Java Compilation. |
OAF MDS Root Destination Directory | FDEBS_MDS_ROOT_DESTINATION /patch/115/import. | ||
Forms Root Destination Directory |
| No | Target directory for form files (fmx). |
Forms Root Stage Directory |
| No | Target Stage directory for MDS form files (webui xmlsfmb). forms. |
Forms Classpath |
| No | Set the classpath, if needed for Forms compilation. |
Reports Root Destination Directory |
| No | Target directory for Concurrent Program's SQLs (Not executed after deploy)report files. reports |
Workflow Root Destination Directory |
| No | Target directory for Java Stored Procedure workflow files. |
SQL Root Destination Directory |
| No | Target directory for SQL and PLS files. |
SQL Retry Count |
| No | Retry count for SQLs and PL/SQLs. Default is 5 |
SQL Ignore Compile Errors |
| No | Ignore SQL compilation errors. |
SQL*Loader $PROD_TOP/patch/115/import | |||
Workflow Upload Mode | FDEBS_WORKFLOWS_UPLOAD_MODE | No | Upload Mode for WFLOAD. [UPLOAD, UPGRADE, FORCE] Default is UPLOAD. |
Workflow Classpath |
| No | Set the classpath, if needed for Workflow Load (WFXLoad). |
Libraries Root Destination Directory | FDEBS_LIBRARIES_ROOT_DESTINATION_DIR | No | Target directory for form library files (plx). Default is PROD_TOP/forms. (e.g. $XXAR_TOP/forms). |
Publisher Root Destination Directory |
| No | Target directory for control (ctl) files. Publisher files. |
Publisher Default Custom Mode | FDEBS_PUBLISHER_CUSTOM_MODE | No | When populating or evaluating files deployed with XDOLoader, set the CUSTOM_MODE of publisher files to this. [FORCE, NOFORCE] Default is FORCE. |
Fonts Root Destination Directory |
| No | Target directory for AOL (ldt) font files. lib/fonts |
Scripts Root Destination Directory |
| No | Target directory for form script files (fmx). |
Forms Perl Module Root Stage Destination Directory |
| No | Stage Target directory for form files (fmb)perl modules. |
Forms Classpath |
| No | Set the classpath, if needed for Forms compilation. |
Reports perl. | |||
Media Root Destination Directory |
| No | Target directory for report image files. |
Workflow HTML Root Destination Directory |
| No | Target directory for workflow html files. $OA_HTML. |
FDEBS_WORKFLOWS_UPLOAD_MODE | No | Upload Mode for WFLOAD. [UPLOAD, UPGRADE, FORCE] Default is UPLOAD. | |
Workflow Classpath |
| No | Set the classpath, if needed for Workflow Load (WFXLoad). |
Libraries Root Destination Directory | FDEBS_LIBRARIES_ROOT_DESTINATION_DIR | No | Target directory for form library files (plx). Default is PROD_TOP/forms. (e.g. $XXAR_TOP/forms). |
Publisher Root Destination Directory |
| No | Target directory for Publisher files. |
Publisher Default Custom Mode | FDEBS_PUBLISHER_CUSTOM_MODE | No | When populating or evaluating files deployed with XDOLoader, set the CUSTOM_MODE of publisher files to this. [FORCE, NOFORCE] Default is FORCE. |
Fonts Root Destination Directory |
| No | Target directory for font files. |
Scripts Root Destination Directory |
| No | Target directory for script files. |
Perl Module Root Destination Directory |
| No | Target directory for perl modules. |
Media Root Destination Directory |
| No | Target directory for image files. |
HTML Root Destination Directory |
| No | Target directory for html files. |
FDEBS_JSP_COMPILE | No | The selected option will be used while generating deploy command for JSP files. Default is No. Jsp files will not be compiled. If set to Compile, the JSP files will be compiled. The other option is Compile with Flush which will compile all deployed jsp files and their parents. | |
Stop on Error |
| No | Stop deploying, if any error occurs. If false or not specified, deploying of other files will be continued. |
Ignore Errors File List |
| No | List of files (allowing wildcards) to ignore errors. (e.g: DropHRTables.sql, CreateTables.sql, *_ddl.sql) |
| Target File Permission. The target file will be set to this permission level after deployment using chmod. eg: 755 |
Inputs
...
Input Code
...
Required
...
Description
...
FDEBS_INP_FORCE_FILES
...
No
...
List of files to force to be deployed even if they haven't changed.
During the deployment, typically only changed artifacts will be get deployed. If you would like to force any artifacts, use this input. Separate files with comma.
The value ALL
may be used to indicate that all files should be deployed even if the files exist on the file system. This is useful if the database is out of sync with the filesystem and it is desired to force all of the scripts to be run again.
This is used by Full Deployment Projects only.
...
Skip files from Package. Separate files with comma. Not applicable for Full Deployment.
Use ALL to skip all files.
...
FDEBS_INP_INCLUDE_TYPES
...
FDEBS_INP_EXCLUDE_TYPES
...
Select types that should not be deployed. Partial Deployments only. Select one or more object types. This option is useful when files are deployed selectively across application tier nodes.
Outputs
...
Output Name
...
Description
...
List of files which were deployed.
...
List of files and their revisions which were deployed.
The version is only present for Partial Deploy Projects.
...
Comma separated string of Object Type Codes deployed. For example, SQL, OAF_JAVA etc.
@Since 4.6.0.3
Artifacts
This operation consumes artifacts from artifact repository. It consumes the zip file added by the build operation to the artifact repository.
Endpoint Selection
This operation delegates the selection of endpoints to the workflow developer.
Endpoint Execution
This operation delegates the selection of any or all of the endpoints to be executed on to the workflow developer.
Special Considerations
See EBS Object Types Reference for supported objects and considerations.
Deploy operation will create ebs.deploy.processed file as a marker for completion in workflow execution folder at same level as temp folder. (@Since 4.6.0.3)
...
JSP_COMPILE | No | The selected option will be used while generating deploy command for JSP files. Default is No. Jsp files will not be compiled. If set to Compile, the JSP files will be compiled. The other option is Compile with Flush which will compile all deployed jsp files and their parents. | |
Stop on Error |
| No | Stop deploying, if any error occurs. If false or not specified, deploying of other files will be continued. |
Ignore Errors File List |
| No | List of files (allowing wildcards) to ignore errors. (e.g: DropHRTables.sql, CreateTables.sql, *_ddl.sql) |
| Target File Permission. The target file will be set to this permission level after deployment using chmod. eg: 755 |
Inputs
Input Name | Input Code | Required | Description |
---|---|---|---|
Include Object Types |
| No | Select types that should be deployed. If nothing selected, all types will be deployed. Partial Deployments only. Select one or more object types. This option is useful when files are deployed selectively across application tier nodes. |
Exclude Object Types |
| No | Select types that should not be deployed. Partial Deployments only. Select one or more object types. This option is useful when files are deployed selectively across application tier nodes. |
Include Files | FDEBS_INP_DEPLOY_INCLUDE_FILES | No | Provide comma separated list of files that should be deployed. If nothing is provided, all files will be deployed. Use * to indicate wildcard. Partial Deployments only. You can use wild card like /java/*, /java/oracle/apps/pos/* @since 5.3.0.4 |
Exclude Files | FDEBS_INP_SKIP_FILES | No | Provide comma separated list of files that should not be deployed. Use * to indicate wildcard. Partial Deployments only. Use ALL to skip all files. You can use wild card like /java/*, /java/oracle/apps/pos/* |
Force Deploy Files |
| No | List of files to force to be deployed even if they haven't changed. The value This is used by Full Deployment Projects only. |
Fail if patching in progress | FDEBS_INP_FAIL_IF_PATCH_IN_PROG | No | Fail the workflow step if a patching cycle is in progress and deploying to RUN edition (defaults to TRUE) . Applies to EBS 12.2+ only. |
Copy Files to Patch File System | FDEBS_INP_DEPLOY_OR_COPY_FILES_TO_PATCH_FILE_SYSTEM | No | Option to sync files with patch file system. If selected, Operation will use deploy command for Program Files and HTML types but others types are simply copied onto patch file system. For Java files, class files will be copied. For form files, fmb and fmx files will be copied. @Since EBS Plugin version 5.5.0.3.11 |
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. |
FDEBS_OUT_DEPLOYED_FILE_REVISIONS_LIST | List of files and their revisions which were deployed. The version is only present for Partial Deploy Projects. |
FDEBS_OUT_DEPLOYED_TYPES_LIST | Comma separated string of Object Type Codes deployed. For example, SQL, OAF_JAVA etc. @Since 4.6.0.3 |
Artifacts
This operation consumes artifacts from artifact repository. It consumes the zip file added by the build operation to the artifact repository.
Endpoint Selection
This operation delegates the selection of endpoints to the workflow developer.
Endpoint Execution
This operation delegates the selection of any or all of the endpoints to be executed on to the workflow developer.
Special Considerations
See EBS Object Types Reference for supported objects and considerations.
Deploy operation will create ebs.deploy.processed file as a marker for completion in workflow execution folder at same level as temp folder. (@Since 4.6.0.3)
If performing clone operations between environments, consider using the Post Refresh feature of FlexDeploy. Read more on the Post Refresh Requests page.
By default, FlexDeploy utilizes the Oracle client that is installed on the EBS application tier. In some cases, the database object being deployed requires a newer version of the Oracle client. In this scenario, it may be required to upgrade the Oracle database client on the application tier or deploy this object from a different server with a newer client. The same is also true for using proxy database users. In most cases, the Oracle database client installed on the application is not at the minimum level to utilize proxy users. To use proxy database users, the client must be at version 10.2 or higher.
Deployment to custom TOP on non-shared file systems
...