Versions Compared

Old Version 6

changes.mady.by.user Karl Henselin

Saved on

compared with

New Version 7

changes.mady.by.user Tristan Butzine

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Builds an APEX application artifact, sourcing from an SCM or Oracle APEX Application Builder in a development environment. This operation can be used in conjunction with FlexDeploy's Full and Partial deployment models.

...

Artifact generated by this operation is zip file containing split application sql files. For APEX versions 4.x, no split is done hence artifact will be entire application sql file.

Target Properties

Property Name

Property Code

Required

Description

Oracle SQLcl Home

FD_SQLCL_HOME

Yes1

Folder where SQLcl is installed. Only required if sourcing from App Builder.

Use JDK 8 for Endpoint Java due to SQLcl requirements.

APEX User

FDAPEX_USER

Yes1

Provide database user APEX_xxxxx or owner (parsing schema) of the application for export and import operations. You can use system user as well. Only required if sourcing from App Builder.

APEX Password

FDAPEX_PASSWORD

Yes1

Password for APEX User.  Only required if sourcing from App Builder.

Oracle Database URL

FDORA_URL

Yes1

JDBC URL for Oracle database. For example:

  • jdbc:oracle:thin:@HOSTNAME:PORT:SID or

  • jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME

Only required if sourcing from App Builder.

Include Page
Using wallet with oracle database
Using wallet with oracle database

1 - Required only if sourcing from App Builder.

Project Properties

Property Name

Property Code

Required

Description

Workspace Name

FDAPEX_WORKSPACE_NAME

Yes

APEX Workspace Name. Provide uppercase name. This defaults to FD_INSTANCE_CODE expression, so if you keep instance code same as your workspace, you will not need to change default value.

Parsing Schema

FDAPEX_DB_SCHEMA

No

Used to set the parsing (owner) schema of the APEX application. Provide uppercase schema name.

Application ID

FDAPEX_APPLICATION_ID

No

APEX Application ID

Application Name

FDAPEX_APPLICATION_NAME

No

APEX Application Name

Application Alias

FDAPEX_ALIAS

No

APEX alphanumeric identifier unique within a workspace and page.

Export Supporting Object Definitions

FDAPEX_EXPORT_SUPPORTING_OBJECTS

No

Specify whether to export supporting object definitions with your application.

Export Public Reports

FDAPEX_EXPORT_PUBLIC_REPORTS

No

Specify whether to include public reports with your application.

Export Report Subscriptions

FDAPEX_EXPORT_REPORT_SUBSCRIPTIONS

No

Specify whether to include interactive report or interactive grid subscription settings with your application.

Export Developer Comments

FDAPEX_EXPORT_DEV_COMMENTS

No

Specify whether to include Developer Comments in your application export.

Export Translations

FDAPEX_INCLUDE_TRANSLATION

No

Check to include Translations with your application export.

Use Offset

FDAPEX_USE_OFFSET

No

Detemines if the plugin will attempt to set the Offset.

Offset value

FDAPEX_OFFSET

No

APEX Offset value

Tip

FlexDeploy needs to identify the application id.  This can be provided by either entering the application id directly or by entering the associated application name. If the application name is not unique across workspaces, you must provide the workspace name in addition to the application name.

Inputs

...

Input Name

...

Input Code

...

Required

...

Description

Outputs

...

Output Name

...

Required

...

Artifacts

Artifact generated by this operation is zip file containing split application sql files. For APEX versions 4.x, no split is done hence artifact will be entire application sql file.

...