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 

NameDescription
.sqlStructure 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

NameCode
Concurrent Program SQLsCP_SQL

Object Type Attributes

NameCodeDescriptionDefault ValueSupported Values
SourceSOURCEObject Source Location Type

SCM

SCM
Target LocationTARGET_LOCATIONPath to where the file should be deployed to.

$<PROD_TOP>/sql


Target File PermissionsFILE_PERMISSIONSPermissions to apply to the file after it is deployedDefaults to the project property FDEBS_FILE_PERMISSIONS

Related Project Properties

NameCodeDescriptionDefault Value
Concurrent Program SQL Root Source DirectoryFDEBS_CP_SQL_ROOT_SOURCE_DIRSub-directory within project's SCM source path which contains SQLs.cp_sql
Concurrent Program SQL Root Destination DirectoryFDEBS_CP_SQL_ROOT_DESTINATION_DIRSub-directory within project's deploy path to contain SQLs.


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