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 |
|---|---|
| .sql | A file containing sql statements. Extensions may be customized using EBS SQL Extensions project the FDEBS_SQL_EXTENSIONS project property. |
Attributes
| Name | Description | Default Value | Supported Values |
|---|---|---|---|
| Source | Object Source Location Type | SCM | SCM |
| Target Location | Path to where the file should be deployed to. | $<PROD_TOP>/patch/115/sql/ | |
| Type | DB Object Type | Generic SQL | |
| DB User Property | FlexDeploy property to use as the user to connect to the database with. | FDEBS_DB_USER | |
| DB Password Property | FlexDeploy property to use as the password for the DB User Property. | FDEBS_DB_PASSWORD |
...