The following macros are not currently supported in the header:
  • style

deploy (EBS)

Owned by Kari Draheim (Unlicensed)
Last updated: Sept 23, 2016 by Rama Rimmalapudi

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.


Sql files will be deployed in the order given in the SQL_ORDER.seq file. If the SQL_ORDER.seq file is not available, files will be executed based on the extension of the files (typ, tps, tpb, sql, pkh, plb, pkb, pks, pls, pck, fnc, trg, spc, bdy, prc). If you have multiple files in the SQL_ORDER.seq file, those sqls will be executed first and rest will be executed as per their extension.


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_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.

Environment/Instance Properties

Property Name

Required

Description

FDEBS_SOURCE_SCRIPT

Yes

Source Script with full path.
Eg: /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 to the script.
Eg: /u1/apps/apps_st/appl/APPSorcl_ebs01.env run

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 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.
Added along with the default classpath while compiling java files.

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.
Eg: $XXHR_TOP/admin/sql.
Default is PROD_TOP/patch/115/sql.

FDEBS_CP_SQL_ROOT_DESTINATION_DIR

No

Target directory for Concurrent Prorgram's SQLs (Not executed after deploy).
Eg: $XXHR_TOP/admin/sql.
Default is PROD_TOP/sql.

FDEBS_JAVA_ROOT_DESTINATION_DIR

No

Target directory for java,class,xml files.
Eg: $JAVA_TOP/MyCompany
Default is $JAVA_TOP

FDEBS_FORMS_ROOT_DESTINATION_DIR

No

Target directory for form files (fmx).
Eg: $XXAR_TOP/forms
Default is $PROD_TOP/forms

FDEBS_FORMS_ROOT_STAGE_DIR

No

Stage directory for form files (fmb).
Eg: $XXAR_TOP/forms.
Default is AU_TOP/forms.

FDEBS_REPORTS_ROOT_DESTINATION_DIR

No

Target directory for report files.
Eg: $XXAR_TOP/reports
Default is $PROD_TOP/reports

FDEBS_MEDIA_ROOT_DESTINATION_DIR

No

Target directory for image files.
Eg: $XXAR_TOP/media
Default is $OA_MEDIA

FDEBS_HTML_ROOT_DESTINATION_DIR

No

Target directory for html files.
Eg: $XXAR_TOP/html
Default is $OA_HTML.

FDEBS_FONTS_ROOT_DESTINATION_DIR

No

Target directory for font files.
Eg: $XXAR_TOP/fonts
Default is $OA_JRE_TOP/lib/fonts

FDEBS_SCRIPTS_ROOT_DESTINATION_DIR

No

Target directory for script files.
Eg: $FND_TOP/bin.
Default is PROD_TOP/bin.

FDEBS_PERL_ROOT_DESTINATION_DIR

No

Target directory for perl modules.
Eg: $FND_TOP/perl.
Default is PROD_TOP/perl.

FDEBS_JAR_ROOT_DESTINATION_DIR

No

Target directory for JAR files.
Eg: $JAVA_TOP/jar.
Default is PROD_TOP/patch/115/jar.

FDEBS_EAR_ROOT_DESTINATION_DIR

No

Target directory for ear files.
Eg: $JAVA_TOP/ear.
Default is PROD_TOP/patch/115/ear.

FDEBS_DAT_ROOT_DESTINATION_DIR

No

Target directory for Dat files.
Eg: $XXHR_TOP/admin/import.
Default is PROD_TOP/patch/115/import.

FDEBS_SQL_LDR_ROOT_DESTINATION_DIR

No

Target directory for control (ctl) files.
Eg: $XXHR_TOP/admin/bin.
Default is PROD_TOP/bin.

FDEBS_LOAD_JAVA_ROOT_DESTINATION_DIR

No

Target directory for Java Stored Procedure files.
Eg: $XXHR_TOP/java.
Default is JAVA_TOP.

FDEBS_ PUBLISHER_ROOT_DESTINATION_DIR

No

Target directory for Publisher files.
Eg: $XXHR_TOP/publisher.
Default is PROD_TOP/patch/115/publisher.

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)
During the deployment, only changed artifacts will be get deployed. If you would like to force any artifacts, use this input. Separate files with comma.

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.

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 will select all available App Tier (EBS Web Server/EBS Forms Service/ EBS MWA Server) resource type endpoints associated to the environment instance.

Endpoint Execution

This operation will run randomly on any App Tier (EBS Web Server/EBS Forms Service/ EBS MWA Server) resource type endpoint.

Special Considerations

See Supported EBS Object Types at the end of this document for supported objects and considerations.

The following macros are not currently supported in the footer:
  • style