A 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.
...
| Name | Description | Default Value |
|---|---|---|
| EBS SQL Root Source Directory | Source folder for sql and pls files (e.g. db). | sql |
| EBS SQL Root Destination Directory | Target directory for SQL and PLS files (e.g. XXHR_TOP/admin/sql). | $<PROD_TOP>/patch/115/sql |
| EBS SQL Extensions | SQL 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 List | List of files to ignore errors (e.g. DropHRTables.sql,*_ddl.sql). | |
| EBS SQL Ignore Compile Errors | Ignore SQL compilation errors. | false |
| EBS SQL Retry Count | Retry count for SQLs and PL/SQLs. | 5 |
...