Versions Compared

Key

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

collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.

  

File Extensions 

If file is not Concurrent program (indicated by parent folder), then it is considered DB Objects (SQLs). File content is also further analyzed by populate process.

NameDescription
.sqlA file containing sql statements. Extensions may be customized using EBS SQL Extensions project property.

  

Attributes

NameDescriptionDefault ValueSupported Values
SourceObject Source Location Type

SCM

SCM
Target LocationPath to where the file should be deployed to.$<PROD_TOP>/patch/115/sql/
TypeDB Object TypeGeneric SQL
DB User PropertyFlexDeploy property to use as the user to connect to the database with.FDEBS_DB_USER
DB Password PropertyFlexDeploy property to use as the password for the DB User Property.FDEBS_DB_PASSWORD

  

Related Project Properties

NameDescriptionDefault Value
EBS SQL Root Source DirectorySource folder for sql and pls files (e.g. db).sql
EBS SQL Root Destination DirectoryTarget directory for SQL and PLS files (e.g. XXHR_TOP/admin/sql).$<PROD_TOP>/patch/115/sql
EBS SQL ExtensionsSQL file extensions in their order to process.

seq,tbl,idx,typ,tps,tpb,sql,pkh,plb,pks,pkb,pls,pck,fnc,trg,spc,bdy,prc

See Database SQL file extensions and their order of process.

EBS Ignore Errors File ListList of files to ignore errors (e.g. DropHRTables.sql,*_ddl.sql).
EBS SQL Ignore Compile ErrorsIgnore SQL compilation errors.false
EBS SQL Retry CountRetry count for SQLs and PL/SQLs.5

  

Sample Build Commands 

N/A - Build commands not supported for this type.

  

Sample Deploy Commands 

Code Block
languagebash
themeRDark
cp $SOURCE_FILE $XXHR_TOP/patch/115/sql/;
sqlplus $FDEBS_DB_USER/$FDEBS_DB_PASSWORD @$XXHR_TOP/patch/115/sql/XXHR_BIPUB_REP_PKG.seq <<EOF
SHOW ERRORS
exit sql.sqlcode
EOF

Considerations

...