FlexDeploy has support for commonly used EBS customizations and functional setups. This page provides a detailed summary of the behaviors, configuration, and customization features for each EBS object type. The attributes and build/deploy commands are generated by FlexDeploy automatically, following Oracle standards, and using related project files. However, these commands can be overridden, if desired, to perform non-standard actions. Build commands are used for object types which support sourcing the object from the EBS build instance. Sample build/deploy commands are provided for each EBS object type to help you understand how the objects are migrated across EBS instances.
...
Oracle Application Framework (OAF) JAVA
A framework for application development within E-Business Suite. The framework is also available for personalizations, customizations and custom-application development.
File Extensions
| Name | Description |
|---|---|
| .java | Java programming language source file containing Java classes. |
| .class | Compiled Java class |
| .xml | Extensible Markup Language file format used to create common information formats and share both the format and the data using standard ASCII text. |
Attributes
| Name | Code | Description | Default Value | Supported Values |
|---|---|---|---|---|
| Source | SOURCE | Object Source Location Type | SCM | SCM |
| Target Location | Path to where the file should be deployed to. | $<PROD_TOP>/ $<PROD_TOP>/mds (**XML files) | ||
| Java Classpath | Location of user-defined classes and packages. | $CLASSPATH |
Related Project Properties
...
Oracle Application Framework (OAF) MDS
A framework for application development within E-Business Suite. The framework is also available for personalizations, customizations and custom-application development.
File Extensions
| Name | Description |
|---|---|
| .xml | Extensible Markup Language file format used to create common information formats and share both the format and the data using standard ASCII text. |
| .jpx | Jbo project metadata file |
...
| Name | Description | Default Value | Supported Values |
|---|---|---|---|
| Source | Object Source Location Type | SCM (**populating from SCM) EBS (**manual creation) | SCM | EBS |
| Target Location | Path to where the file should be deployed to. | $<PROD_TOP>/mds | |
| Root Directory | Location of user-defined classes and packages. | $<PROD_TOP>/mds |
...
All OAF MDS related files must be sourced controlled under a directory structure matching the Java package structure. This is a requirement to ensure the generated deploy commands copy them to the correct location under the $JAVA_TOP. If this requirement is not met, you will need to modify each of the target location paths and re-evaluate the commands.
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
| Name | Description |
|---|---|
| .sql | Structure 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). |
...
None
Java Stored Procedures
A collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.
File Extensions
| Name | Description |
|---|---|
| .java | Java programming language source files. |
...
Considerations
None
DB Objects (SQLs)
A collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.
File Extensions
| Name | Description |
|---|---|
| .sql | A file containing sql statements. Extensions may be customized using EBS SQL Extensions project property. |
...
XML Definition Files (XDF)
XDF is used to store high-dimensional data and information related to it in compact XML format. The purpose is to have interchangeable and high quality format that can be used as a main archive format for this kind of data.
File Extensions
| Name | Description |
|---|---|
| .xdf | XML Definition File for storing high-dimensional data and related information. |
...
| Name | Description | Default Value |
|---|---|---|
| N/A | N/A | N/A |
Sample Build Commands
...
Considerations
None
SQL*Loader
Loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile.
File Extensions
| Name | Description |
|---|---|
| .sqlldr | SQL*Loader is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database. |
...
None
Java Loader Text (JLT)
Loads data from a text file back into the upgraded AK tables. AKLOAD is used during an upgrade to unload Web Applications Dictionary data from the Common Modules tables to a text file.
File Extensions
| Name | Description |
|---|---|
| .jlt | Java Loader Text - used by AKLOAD.java |
...
| Name | Description | Default Value |
|---|---|---|
| N/A | N/A | N/A |
Sample Build Commands
...
Application Object Library (AOL)
A collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.
File Extensions
| Name | Description |
|---|---|
| .ldt | Loader Data files containing entity definitions, parent-child relationships, input parameters and data. |
...
| Name | Description | Default Value | Supported Values |
|---|---|---|---|
| Source | Object Source Location Type | SCM (**populating from SCM) EBS (**manual creation) | SCM | EBS |
| Type | AOL Object Type | PROGRAM (derived when populating from SCM) | PROGRAM | FND_LOOKUP_TYPE | REQUEST_GROUP | REQ_SET | REQ_SET_LINKS | DESC_FLEX | KEY_FLEX | MENU | PRINTER | PRINTER_STYLE | PROFILE | FND_USER | FND_RESPONSIBILITY | FND_NEW_MESSAGES | FND_ATTACHMENT_FUNCTIONS | FND_CURRENCY | FND_LANGUAGE | FND_TERRITORY | FND_TABLE | FND_VIEW | GRANT | FND_SEQUENCE | FND_DOC_SEQUENCE_CATEGORIES | VALUE_SET | VALUE_SET_VALUE | VALUE_SECURITY_RULE | VALUE_ROLLUP_GROUP | SCHEDULE | FND_FORM_CUSTOM_RULES | FORM | FUNCTION | ALR_ALERTS | WF_ROLE | XDO_DS_DEFINITIONS | JTF_GRID_DATASOURCES | AME_CONDITIONS | AME_APPROVAL_GROUPS | AME_APPROVAL_GROUP_CONFIG | AME_RULES | AME_ACTION_USAGES | AME_CALLING_APPS | AME_ATTRIBUTES | AME_ATTRIBUTE_USAGES | OTHER |
| Name | AOL Object Name |
| |
| Target Location | Path to where the file should be deployed to. | $<PROD_TOP>/patch/115/import/ | |
| Control File | Configuration file used to download/upload data. | $FND_TOP/patch/115/import/afcpprog.lct | |
| NLS Language | Specifies the current language of the session. | AMERICAN_AMERICA.US7ASCII | Any valid language name using the OLAP DML syntax. |
| Upload Mode | NLS data uploads for translated columns are supported - use UPLOAD_MODE= NLS. | REPLACE | REPLACE | NLS |
| Custom Mode | To override Oracle’s upload algorithm and update the custom AOL data regardless - use CUSTOM_MODE= FORCE. | FORCE | NONE | FORCE |
| Additional Parameters | Optional parameters to supply to the FNDLOAD command. |
...
A component of Oracle Fusion Middleware used to develop and deploy Forms applications. The Forms applications provide a user interface to access Oracle Database in an efficient and tightly-coupled way. The applications can be integrated with Java and web services to take advantage of service oriented architectures (SOA).
File Extensions
| Name | Description |
|---|---|
| .fmb | A module, specifically, a Forms module binary file, created by Forms Builder. It uses Oracle for its back-end database |
| .fmx | A compiled form. |
...
Considerations
None
Reports
A tool for developing reports against data stored in an Oracle database, consisting of Oracle Reports Developer and Oracle Application Server Reports Services.
File Extensions
| Name | Description |
|---|---|
| .rdf | Report Definition File, used to convert Oracle Reports into BI Publisher Reports to get to XML format. |
...
File Extensions
| Name | Description |
|---|---|
| .wfx | Workflow XML loader files. |
Attributes
| Name | Description | Default Value | Supported Values |
|---|---|---|---|
| Source | Object Source Location Type | SCM (**populating from SCM) EBS (**manual creation) | SCM | EBS |
| Target Location | Path to where the file should be deployed to. | $<PROD_TOP>/patch/115/xml/ | |
| Force | Overwrites any existing definitions. | true | true | false |
| JDBC Protocol | DB connection protocol for JDBC | thin | thin|oci8 |
| Language | Specifies the current language of the session. | US | |
| Classpath for Workflow | Classpath to add dependent jars files used in workflows. | ||
| Exact Download Mode | To download exactly as they are specified in the database. In this mode, the Workflow XML Loader does not convert any data to tokens; instead, all values, including system-specific values, are copied to the XML file. | false | true | false |
| Object Type | Workflow type | EVENTS | AGENTS | EVENTS | EVENT_GROUPS | SUBSCRIPTIONS |
| Object Key | Workflow Key |
...
| Name | Description | Default Value | Supported Values |
|---|---|---|---|
| Source | Object Source Location Type | SCM (**populating from SCM) EBS (**manual creation) | SCM | EBS |
| Stage Location | Path to where the source file (pll) should be staged. | $AU_TOP/forms/ | |
| Target Location | Path to where the compiled file should be deployed to. | $AU_TOP/forms/ | |
| Module Type | Specifies the type of module to make from the Form. | LIBRARY | LIBRARY |
| Compile All | Package compile preference. | special | special | YES | NO |
...
| Name | Description | Default Value | Supported Values |
|---|---|---|---|
| Source | Object Source Location Type | SCM (**populating from SCM) EBS (**manual creation) | SCM | EBS |
App Short Name | Application Short Name | XXHR | |
| LOB Code | XDO LOB code. Enter either the Template Code or the Data Definition Code. | <file name>(**without path/extension) | |
| XDO File Type | XDO File type | ||
| LOB Type | XDO LOB type | XML_SAMPLE | BURSTING_FILE | DATA_TEMPLATE | TEMPLATE | TEMPLATE_SOURCE | XML_SCHEMA | XML_SAMPLE |
| Target Location | Path to where the file should be deployed to. | $<PROD_TOP>/patch/115/publisher/defs/ | |
| Territory Code | ISO two-letter territory code. | US | |
| Language | ISO two-letter language code. | en | |
| Custom Mode | To override Oracle’s upload algorithm and update the custom AOL data regardless - use CUSTOM_MODE= FORCE. | NOFORCE | NOFORCE | FORCE |
| NLS Lang | NLS_LANG environment variable | $NLS_LANG |
...
Considerations
None
Scripts
A shell script is a computer program designed to be run by the Unix shell command-line interpreter.
File Extensions
| Name | Description |
|---|---|
| .sh | Shell script |
| .pl | Perl script |
...
Considerations
None
Perl Modules
A discrete component of software for the Perl programming language. A particular set of conventions for using Perl's package mechanism that has become universally adopted.
File Extensions
| Name | Description |
|---|---|
| .pm | A Perl Module is a self-contained piece of Perl code that can be used by a Perl program or by other Perl modules. |
...
Used for the display of text and graphics on the desktop client.
File Extensions
| Name | Description |
|---|---|
| .jpg | Joint Photographic Experts Group, used interchangeably with JPEG file. |
| .png | Portable Network Graphics is a graphics file format that supports lossless data compression. |
| .gif | Graphic Interchange Format for often animated raster graphics. |
...
Used for tagging text files to achieve font, color, graphic, and hyperlink effects on web pages.
File Extensions
| Name | Description |
|---|---|
| .html | Hypertext Markup Language is a standardized system for tagging text files. |
...
Considerations
None
Functional Setups
A collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.
File Extensions
| Name | Description |
|---|---|
| .ldt | Loader Data files containing entity definitions, parent-child relationships, input parameters and data. |
...
| Name | Description | Default Value | Supported Values |
|---|---|---|---|
| Source | Object Source Location Type | SCM (**populating from SCM) EBS (**manual creation) | SCM | EBS |
| Module | EBS Module Name | AP - Oracle Payables | See Setup Types by Module |
| Type | Setup Object Type | ||
| Name | Key Attribute Name for Object | derived by Module and Type | |
| Value | Key Attribute Value | ||
| Additional Parameters | Optional parameters to supply to the FNDLOAD command | ||
| Target Location | Path to where the file should be deployed to. | $AP_TOP/patch/115/import/ | |
| Control File | Configuration file used to download/upload data. | ||
| Upload Mode | NLS data uploads for translated columns are supported - use UPLOAD_MODE= NLS | REPLACE | REPLACE | NLS |
| Custom Mode | To override Oracle’s upload algorithm and update the custom AOL data regardless - use CUSTOM_MODE= FORCE | FORCE | NONE | FORCE |
...