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.

  

File Extensions 

Files with following extension(s) is considered if it is in cp_sql folder (or user defined folder specified by EBS Concurrent Program SQL Root Source Directory on Project Properties).

NameDescription
.sqlStructure Query Language file format written in ASCII, used by database products.Typically contains queries to modify the structure of a relational database (insert, delete, update, or select).

  

Attributes

NameDescriptionDefault ValueSupported Values
SourceObject Source Location Type

SCM

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

$<PROD_TOP>/sql


  

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


The following macros are not currently supported in the footer:
  • style