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 folder1
- Files 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). |
...
| Name | Code | 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. | |
| File Permissions | FDEBS_FILE_PERMISSIONS | Target File Permission. Will be set to target file after deployment using chmod. eg: 755 |
...