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.
File Extensions
Files with following extension(s) is considered if it is in cp_sql folder (or user defined folder specified by EBS Concurrent Program SQL Root Source Directory on Project Properties).
| Name | Description |
|---|---|
| .sql | Structure Query Language file format written in ASCII, used by database products.Typically contains queries to modify the structure of a relational database (insert, delete, update, or select). |
Attributes
| Name | 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 |
Related Project Properties
| Name | Description | Default Value |
|---|---|---|
| EBS Concurrent Program SQL Root Source Directory | Sub-directory within project's SCM source path which contains SQLs. | cp_sql |
| EBS Concurrent Program SQL Root Destination Directory | Sub-directory within project's deploy path to contain SQLs. | $JAVA_TOP |
Sample Build Commands
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/sql/sql_execute/;