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.

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