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
- Files with .sql extension that are in the cp_sql folder
- Files with .sql extension that do not qualify for Concurrent Program SQL will be considered DB Objects.
EBS Concurrent Program SQL Root Source Directory on Project Properties tab defaults to cp_sql, but you can update if you are keeping Concurrent Program Files in a different folder.
File Extensions
| 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
| Name | Code |
|---|---|
| Concurrent Program SQLs | CP_SQL |
Object Type Attributes
| Name | Code | 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 |
Related Project Properties
| Name | Code | Description | Default Value |
|---|---|---|---|
| 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 |
| Concurrent Program SQL Root Destination Directory | FDEBS_CP_SQL_ROOT_DESTINATION_DIR | Sub-directory within project's deploy path to contain SQLs. | |
| 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.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/sql/sql_execute/;