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
thethe cp_sql folder
1Files with .sql extension that do not qualify for Concurrent Program SQL will be considered DB Objects.
| Tip |
|---|
...
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 |
|
Object Type Attributes
Name | Code | Description | Default Value | Supported Values |
|---|---|---|---|---|
Source |
| Object Source Location Type | SCM | SCM |
Target Location |
| Path to where the file should be deployed to. | $<PROD_TOP>/sql | |
Target 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 |
| Sub-directory within project's SCM source path which contains SQLs. | cp_sql |
Concurrent Program SQL Root Destination Directory |
| Sub-directory within project's deploy path to contain SQLs. |
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
| Code Block | ||||
|---|---|---|---|---|
| ||||
cp $SOURCE_FILE $XXHR_TOP/sql/sql_execute/; |