EBS Object Types - Concurrent Program SQLs

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.

1 - 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 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).

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/;