Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

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 folder1
  • 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 

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

Attribute 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

Related Project Properties

NameDescriptionDefault Value
EBS Concurrent Program SQL Root Source DirectorySub-directory within project's SCM source path which contains SQLs.cp_sql
EBS Concurrent Program SQL Root Destination DirectorySub-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/;
  • No labels