Concurrent programs are system batch jobs that retrieve and push data between Oracle applications and the database. They can be comprised of a single request or a request set containing more than one concurrent program.
Object Type Identification
...
Name | Description |
---|---|
.sql | Structure Query Language file format written in ASCII, used by database products.Typically contains queries to modify the data of a relational database (insert, delete, update, or select). |
Object Type Code
CP_SQL
Attributes
Name | Description | Default Value | Supported Values | |
---|---|---|---|---|
Source | SOURCE | Object Source Location Type | SCM | SCM |
Target Location | TARGET_LOCATION | Path to where the file should be deployed to. | $<PROD_TOP>/sql | |
Target File Permissions | FILE_PERMISSIONS | Permissions to apply to the file after it is deployed | Defaults to the project property FDEBS_FILE_PERMISSIONS |
...
Name | Description | Default Value | |
---|---|---|---|
EBS Concurrent Program SQL Root Source Directory | FDEBS_CP_SQL_ROOT_SOURCE_DIR | Sub-directory within project's SCM source path which contains SQLs. | cp_sql |
EBS Concurrent Program SQL Root Destination Directory | FDEBS_CP_SQL_ROOT_DESTINATION_DIR | Sub-directory within project's deploy path to contain SQLs. | $JAVA_TOP $<PROD_TOP>/sql e.g. $XXHR_TOP/admin/sql |
File Permissions | FDEBS_FILE_PERMISSIONS | Target File Permission. Will be set to target file after deployment using chmod. eg: 755 |
Sample Build Commands
N/A - Build commands not supported for this type.
...