Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

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 Code

CP_SQL

Attributes

Name
DescriptionDefault 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

...

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

$<PROD_TOP>/sql

e.g. $XXHR_TOP/admin/sql

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.

...