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

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

Name	Code
Concurrent Program SQLs	`CP_SQL`

Object Type Attributes

Name	Code	Description	Default Value	Supported Values

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
Rollback Source Type	`ROLLBACK_SOURCE_TYPE`	Where to retrieve file when initiating a rollback deployment.	Project Version	Project Version, SCM Revision, Backup Repository, and Rollback File SCM Revision and Rollback File options are only available when the project has SCM details configured, and Backup Repository should only be used if the FlexDeploy server and project are configured to take backups.
Rollback File	`ROLLBACK_FILE`	The associated file to deploy which will roll back this file. Only applicable when Rollback Source Type is Rollback File		Any project file sourced from SCM

Related Project Properties

Name	Code	Description	Default Value

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