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.
Object Types
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 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> /
$<PROD_TOP> /mds (**XML files)
Java Classpath Location of user-defined classes and packages. $CLASSPATH
Name Description Default Value EBS Java Root Source Directory Sub-directory within project's SCM source path which contains AOLs. java EBS Java Root Destination Directory Sub-directory within project's deploy path to contain AOLs. $JAVA_TOP EBS Java Classpath Location of user-defined classes and packages.
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $JAVA_TOP/xxt/oracle/apps/ak/xxperson/webui/;
export CLASSPATH=$CLASSPATH;
javac -Xlint:none -classpath $CLASSPATH $JAVA_TOP/xxt/oracle/apps/ak/xxperson/webui/xxPersonMainCO.java;
cp $SOURCE_FILE $JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/;
Considerations None
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
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> /mds
Root Directory Location of user-defined classes and packages. $<PROD_TOP> /mds
Name Description Default Value EBS Java Root Source Directory Sub-directory within project's SCM source path which contains AOLs. java EBS Java Root Destination Directory Sub-directory within project's deploy path to contain AOLs. $JAVA_TOP EBS Java Classpath Location of user-defined classes and packages.
Sample Build Commands
cp $SOURCE_FILE $XXHR_TOP/mds/xxt/oracle/apps/ak/xxperson/webui/;
java oracle.jrad.tools.xml.exporter.XMLExporter /xxt/oracle/apps/ak/xxperson/webui/managePersonPG -rootdir ./ -username $FDEBS_DB_USER -password $FDEBS_DB_PASSWORD -dbconnection "$AD_APPS_JDBC_URL" ;
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/mds/xxt/oracle/apps/ak/xxperson/webui/;
java oracle.jrad.tools.xml.importer.XMLImporter $XXHR_TOP/mds/xxt/oracle/apps/ak/xxperson/webui/managePersonPG.xml -rootdir $XXHR_TOP/mds/ -username $FDEBS_DB_USER -password $FDEBS_DB_PASSWORD -dbconnection "$AD_APPS_JDBC_URL";
Considerations None
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).
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> /sql
Name Description Default Value EBS Concurrent Program SQL Root Source Directory Sub-directory within project's SCM source path which contains SQLs. java EBS Concurrent Program SQL Root Destination Directory Sub-directory within project's deploy path to contain SQLs. $JAVA_TOP
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/sql/sql_execute/;
Considerations 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.
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> / Force Configuration file used to download/upload data. TRUEJava Classpath Specifies the current language of the session. $CLASSPATH Any valid language name using the OLAP DML syntax.
Name Description Default Value EBS Load Java Root Source Directory Sub-directory within project's SCM source path which contains Java files. loadjava EBS Load Java Root Destination Directory Sub-directory within project's deploy path to contain Java files. $JAVA_TOP EBS Java Classpath Location of user-defined classes and packages.
Sample Build Commands N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/;
javac -Xlint:none -classpath $CLASSPATH $JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/xxPersonDetailsEOImpl.java;
loadjava -u $FDEBS_DB_USER/$FDEBS_DB_PASSWORD@$AD_APPS_JDBC_URL $JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/xxPersonDetailsEOImpl.class -force
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.
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_USERDB Password Property FlexDeploy property to use as the password for the DB User Property. FDEBS_DB_PASSWORD
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). EBS SQL Ignore Compile Errors Ignore SQL compilation errors. false EBS SQL Retry Count Retry count for SQLs and PL/SQLs. 5
Sample Build Commands N/A - Build commands not supported for this type.
Sample Deploy Commands
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 None
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.
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/xdf/Primary Object Schema Property FlexDeploy property to use as the user to connect to the database with. FDEBS_DB_USER
Primary Object Password Property
FlexDeploy property to use as the password for the DB User Property. FDEBS_DB_PASSWORDJDBC Protocol Driver type for the database. thin thin | oci8 Object Type XDF Object Type all all | table | qtable | mview | mviewlog | sequence | type | trigger | view | policy XSL Directory Path to where the xsl folder is located.
$FND_TOP/patch/115/xdf/xsl
Name Description Default Value N/A N/A N/A
Sample Build Commands N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/patch/115/xdf/;
java oracle.apps.fnd.odf2.FndXdfCmp $FDEBS_DB_USER $FDEBS_DB_PASSWORD $FDEBS_DB_USER $FDEBS_DB_PASSWORD thin $AD_APPS_JDBC_URL all $XXHR_TOP/patch/115/xdf/POS_BANK_PAYEE_BO.xdf $FND_TOP/patch/115/xdf/xsl
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.
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> /bin/ Log File Configuration file used to download/upload data. loader.log
Name Description Default Value EBS SQL LDR Root Source Directory Source folder for control (ctl) files (e.g. control). sqlldr EBS SQL LDR Root Destination Directory Target directory for control (ctl) files (e.g. $XXHR_TOP/admin/bin). $<PROD_TOP> /admin/binEBS Data Root Destination Directory Target directory for Dat files (e.g. $XXHR_TOP/admin/import). $<PROD_TOP> /patch/115/import
Sample Build Commands N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/bin/;
sqlldr userid=$FDEBS_DB_USER/$FDEBS_DB_PASSWORD control=$XXHR_TOP/bin/sqlloader. log=loader.log
Considerations 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
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/import/ JDBC Protocol Driver type for the database. thin thin | oci8 Upload Mode NLS data uploads for translated columns are supported.
UPDATE UPDATE | NOUPDATE Language Specifies the current language of the session.
$NLS_LANG
Name Description Default Value N/A N/A N/A
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/patch/115/import/;
java oracle.apps.ak.akload $FDEBS_DB_USER $FDEBS_DB_PASSWORD thin "$AD_APPS_JDBC_URL" UPLOAD $XXHR_TOP/patch/115/import/pos_reg_summary.jlt UPDATE $NLS_LANG
Considerations None
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.
Attributes 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 <File Name> (**without path/extension)
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.
Name Description Default Value EBS AOL Root Destination Directory Sub-directory within project's SCM source path which contains AOLs. $<PROD_TOP> /patch/115/import
FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct $SOURCE_FILE PROGRAM APPLICATION_SHORT_NAME=XXHR CONCURRENT_PROGRAM_NAME=XXHRCP01
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/patch/115/import/;
FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $XXHR_TOP/patch/115/import/XXHR_Second_CP.ldt - UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE ;
Considerations None
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.
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> /forms/ Stage Location Path to where the file is staged. $AU_TOP/forms/ Country Specifies the current country of the session. Module Type Specifies the type of module to make from the Form.
FORM FORM | LIBRARY | MENU Compile All Package compile preference.
special special | YES | NO Additional Parameters Optional parameters to supply to the FNDLOAD command. Classpath Specifies the location of classes and packages. $FORMS_PATH:$AU_TOP/forms/:$XXHR_TOP/forms/:$AU_TOP/resource/:
Name Description Default Value EBS Forms Root Source Directory Source folder for Forms (e.g. Form). forms EBS Forms Root Stage Directory Stage directory for form files (fmb). (e.g. $XXAR_TOP/forms). $AU_TOP/forms EBS Forms Root Destination Directory Target directory for form files (fmx). (e.g. $XXAR_TOP/forms). $<PROD_TOP> /forms EBS Forms Classpath Set the classpath if needed for Forms compilation.
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $AU_TOP/forms/US/;
export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US/:$XXHR_TOP/forms/US/:$AU_TOP/resource/:;
frmcmp_batch $AU_TOP/forms/US/AKDATTRS.fmb $FDEBS_DB_USER/$FDEBS_DB_PASSWORD output_file=$XXHR_TOP/forms/US/AKDATTRS.fmx compile_all=special
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.
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> /reports/ Country Specifies the current country of the session.
Name Description Default Value EBS Reports Root Source Directory Source folder for Reports (e.g. report). report EBS Reports Root Destination Directory Target directory for report files (e.g. $XXAR_TOP/reports). $<PROD_TOP> /reports
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/reports/;
Considerations None
Workflow Definitions A complete workflow management system that supports business process based integration. Its technology enables modeling, automation, and continuous improvement of business processes, routing information of any type according to user-defined business rules.
File Extensions Name Description .wft Workflow Text definition file.
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/import/ Upload Mode NLS data uploads for translated columns are supported - use UPLOAD_MODE= NLS.
UPLOAD UPLOAD | UPGRADE | FORCE
Name Description Default Value EBS Workflows Root Source Directory Source folder for workflow files.(e.g. wf). workflows EBS Workflows Root Destination Directory Target directory for Workflow files (e.g. $XXHR_TOP/workflow). $<PROD_TOP> /patch/115/import or xml EBS Workflows Upload Mode Upload Mode for WFLOAD (e.g. FORCE). UPLOAD EBS Workflow Classpath Set the classpath if needed for Workflow Load (WFXLoad).
Sample Build Commands N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/patch/115/import/US/;
WFLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y UPLOAD $XXHR_TOP/patch/115/import/US/POSORDNT.wft
None
Workflow XMLs XML definitions for Business Event System objects between a database and a flat file.
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 EBS Workflows Root Source Directory Source folder for workflow files.(e.g. wf). workflows EBS Workflows Root Destination Directory Target directory for Workflow files (e.g. $XXHR_TOP/workflow). $<PROD_TOP> /patch/115/import or xml EBS Workflows Upload Mode Upload Mode for WFLOAD (e.g. FORCE). UPLOAD EBS Workflow Classpath Set the classpath if needed for Workflow Load (WFXLoad).
Sample Build Commands
java oracle.apps.fnd.wf.WFXLoad -de $FDEBS_DB_USER $FDEBS_DB_PASSWORD "$AD_APPS_JDBC_URL" thin US $SOURCE_FILE EVENTS
cp $SOURCE_FILE $XXHR_TOP/patch/115/xml/;
java oracle.apps.fnd.wf.WFXLoad -uf $FDEBS_DB_USER $FDEBS_DB_PASSWORD "$AD_APPS_JDBC_URL" thin US $XXHR_TOP/patch/115/xml/asn_event.wfx
None
Libraries Forms libraries used within Oracle E-Business Suite.
File Extensions Name Description .pll PreLinked Library used for custom libraries.
Attributes 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 EBS Forms Root Source Directory Source folder for Forms (e.g. Form). forms EBS Forms Root Destination Directory Target directory for form files (fmx). (e.g. $XXAR_TOP/forms). $<PROD_TOP> /forms EBS Forms Classpath Set the classpath if needed for Forms compilation. EBS Forms Root Stage Directory Stage directory for form files (fmb). (e.g. $XXAR_TOP/forms). $AU_TOP/forms
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $AU_TOP/forms/;
frmcmp_batch module=$AU_TOP/forms/FABAL.pll userid=$FDEBS_DB_USER/$FDEBS_DB_PASSWORD module_type=LIBRARY compile_all=special
None
Publisher Files BI publisher reporting product from Oracle that provides the ability to create and manage highly formatted reports from a wide range of data sources.
File Extensions Name Description .xml XML Publisher (XDO) non-translatable XML templates. .xsl XML Publisher (XDO) non-translatable XSL templates. .rtf XML Publisher (XDO) translatable templates and non-translatable RTF templates. .pdf XML Publisher (XDO) PDF templates. .xsd XML Publisher (XDO) non-translatable XML Schema.
Attributes 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
Name Description Default Value EBS Publisher Root Source Directory Source folder for publisher files (e.g. xmlpub). publisher EBS Publisher Root Destination Directory
Target directory for Publisher files (e.g. $XXHR_TOP/publisher). $<PROD_TOP> /patch/115/publisher
Sample Build Commands
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME $FDEBS_DB_USER -DB_PASSWORD $FDEBS_DB_PASSWORD -JDBC_CONNECTION "$AD_APPS_JDBC_URL" -LOB_TYPE XML_SAMPLE -APPS_SHORT_NAME XXHR -LOB_CODE XXHR_BIP_ROSTER -LANGUAGE en -TERRITORY US -NLS_LANG $NLS_LANG -XDO_FILE_TYPE XML
mv XML_SAMPLE_XXHR_XXHR_BIP_ROSTER_en_US.xml ./publisher/XXHR_BIP_ROSTER.xml
cp $SOURCE_FILE $XXHR_TOP/patch/115/publisher/defs/;
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME $FDEBS_DB_USER -DB_PASSWORD $FDEBS_DB_PASSWORD -JDBC_CONNECTION "$AD_APPS_JDBC_URL" -LOB_TYPE XML_SAMPLE -APPS_SHORT_NAME XXHR -LOB_CODE XXHR_BIP_ROSTER -LANGUAGE en -TERRITORY US -NLS_LANG $NLS_LANG -XDO_FILE_TYPE XML -FILE_NAME "$XXHR_TOP/patch/115/publisher/defs/XXHR_BIP_ROSTER.xml" -CUSTOM_MODE NOFORCE
Considerations None
Program Files A shell script which is callable by an EBS Concurrent Program.
File Extensions Name Description .prog A shell script which is callable by a Concurrent Program.
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> /bin/
Name Description Default Value EBS Prog Root Source Directory Source folder for Prog files (e.g. cm). prog
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/bin/;
ln -sf $FND_TOP/bin/fndcpesr $XXHR_TOP/bin/programFile
Considerations None
Font Files Font files contining font definitions for reports.
File Extensions Name Description .ttf Font files contain one or more fonts
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. $OA_JRE_TOP/lib/fonts/
Name Description Default Value EBS Fonts Root Source Directory Source folder for font files (e.g. font). fonts EBS Fonts Root Destination Directory Target directory for font files (e.g. $XXAR_TOP/fonts). $OA_JRE_TOP/lib/fonts
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $OA_JRE_TOP/lib/fonts/;
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
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> /bin/
Name Description Default Value EBS Scripts Root Source Directory Source folder for scripts files (e.g. scripting). scripts EBS Scripts Root Destination Directory Target directory for script files (e.g. $FND_TOP/bin). $<PROD_TOP> /bin
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/bin/;
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.
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> /perl/
Name Description Default Value EBS Perl Root Source Directory Source folder for perl modules (e.g. pm). perl EBS Perl Root Destination Directory Target directory for perl modules (e.g. $FND_TOP/perl). $<PROD_TOP> /perl
Sample Build Commands N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/perl/;
None
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.
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. $OA_MEDIA/
Name Description Default Value EBS Media Root Source Directory Source folder for image files (e.g. oa_media). media EBS Media Root Destination Directory Target directory for image files (e.g. $XXAR_TOP/media). $OA_MEDIA
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $OA_MEDIA/;
None
HTML (Web) Files 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.
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. $OA_HTML/
Name Description Default Value EBS HTML Root Source Directory Source folder for web files (e.g. web). html EBS HTML Root Destination Directory Target directory for html files (e.g. $XXAR_TOP/html). $OA_HTML
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $OA_HTML/;
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.
Attributes 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 See Setup Types by Module
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
Setup Types by Module
Listing of supported Functional Setup types by EBS Module.
A - C
AHL - Complex Maintenance Repair and Overhaul
AHL_API
AK - Oracle Common Modules
LOOKUP_CODE
ALR - Oracle Alert
ALR_ACTION_GROUP_MEMBERS
AME - Approvals Management
AME_APP_CONFIG_VARS
AMS - Oracle Marketing
AMS_MET_DETAILS
AMV - Marketing Encyclopedia System
AMV_CATEGORY
AMW - Internal Controls Manager
AMW_PARAMETERS
AP - Oracle Payables
AP_HOLD_CODES
AR - Oracle Receivables
RA_TERMS
ASG - Oracle CRM Gateway for Mobile Services
ASG_PROD_INFO
ASO - Oracle Order Capture
ASO_SUP_COMPONENT
AS - Oracle Sales
INTEREST_TYPE_CODE_DTL
AZ - Application Implementation
AZ_SELECTION_SET_ENTITIES
BEN - Oracle Advanced Benefits
BEN_EXT_FLD
BIC - Customer Intelligence
BIC_PROFILE_VALUES_ALL
BIS - Oracle Applications BIS
BIS_PARAM_DIMENSION_MAP
BIX - Call Center Intelligence
BIX_PERFORMANCE_MEASURE
BNE - Oracle Web ADI
BNE_INTERFACES
BOM - Oracle Bills of Material
CST_COST_GROUP
BSC - Balanced Scorecard
BSC_SYS_PERIODICITIES
CCT - Oracle Call Center and Telephony
CCT_ROUTE_PARAMS
CE - Oracle Cash Management
CE_BANK_STMT_INT_MAP
CLN - Supply Chain Trading Connector for RosettaNet
ELEMENT_MAPPING
CN - Oracle Sales Compensation
CN_OBJECTS
CSC - Customer Care
CSC_PROF_BLOCKS
CSD - Depot Repair
CSD_REPAIR_TYPES
CSF - Field Service
CSF_GANTT_CHART_SETUP
CSI - Install Base
CSI_INSTANCE_STATUSES
CSM - Oracle Field Service Palm
CSM_CUSTOMIZATION_VIEWS
CS - Oracle Service
CS_SR_ACTION_DETAILS
CSP - Oracle Spares Management
CSP_LOOP_CALC_RULES
CSR - Oracle Scheduler
CSR_COSTS_ALL
CUG - Oracle Citizen Interaction Center
CZ - Oracle Configurator
CZ_EXT_APPLICATIONS
D - G
DDD - CADView-3D
AMC
DDR - Demand Signal Repository
DOM - Document Management and Collaboration
DOM_REPOSITORIES
DPP - Price Protection
DPP_TRANSACTION_STATUS_MAP
DT - DateTrack
DT_COLUMN_PROMPTS_TYPE
EAM - Oracle Enterprise Asset Management
EAM_SAFETY_STATUSES
ECX - Oracle XML Gateway
ECX_EXT_PROCESSES
EDR - Oracle E Records
TRANSACTION_INPUT_VAR
EGO - Advanced Product Catalog
EGO_FND_OBJECTS_EXT
ENG - Oracle Engineering
CHANGE_ENTITIES
FA - Assets
FA_CATEGORIES
FEM - Enterprise Performance Foundation
FEM_CREDIT_STATUS_ATTR
FF - FastFormula
FF_FORMULAS_F
FII - Financials Intelligence
FII_AR_DBI_REC_SETUP
FLM - Oracle Flow Manufacturing
FLM_SEQ_ATTRIBUTES
FPA - Project Portfolio Analysis
FPA_OBJECTS_TL
FRM - Report Manager
FRM_XML_ADAPTORS
FTE - Oracle Transportation Hub
FTE_TOKENS
FTP - Transfer Pricing
FTP_COND_DATA_TYPE_ASSIGN
FUN - Financials Common Modules
FUN_CONTACTUS_SETUP
FV - Oracle Federal Financials
FV_FCT_ATT_SEED
GCS - Financial Consolidation Hub
GCS_FORMULA_VARIABLES
GHR - Oracle Federal HR
ghr_duty_stations_f
GL - Oracle General Ledger
GL_ENCUMBRANCE_TYPES
GMD - Oracle Process Manufacturing Product Development
GMD_STATUS_TL
GMO - Manufacturing Execution System for Process Manufacturing
GMO_INSTR_TASK_ATTR_COLS
GMS - Oracle Grants Accounting
GMS-FND_LOOKUP_TYPE
GR - Oracle Process Regulatory Mgmt
GR_EUROHAZARDS
H - N
HRI - Human Resources Intelligence
HRI_AGE_BANDS
HXC - Oracle Time and Labor
_LAYOUT_COMP_PROMPTS
IBC - Oracle iContent
IBC_CTYPE_GROUP_NODES
IBE - iStore
IBE_DSP_SECTION
IBW - Oracle Web Analytics
IBY - iPayment
IBY_UPG_PPP
ICX - Oracle Self-Service Web Applications
POR_FEED_FIELD_FORMATS
IEB - Oracle Interaction Blending
IEB_INBOUND_SERVICE_PLANS
IEC - Oracle Campaign Plus
IEC_G_CPN_PERSONALIZE_ENT
IEO - Call Center Technology
IEO_USER_PARAMETERS
IES - Scripting
IES_META_LIBRARY
IEU - Oracle Universal Work Queue
IEU_UWQ_NODE_DS
IEX - Oracle Collections
IEX_OBJECT_FILTERS
IGF - Student Systems Fin Aid
IGF_FC_EFC_FRM_B
IGI - Oracle International Public Sector Financials
IGI-GL_JE_SOURCES
IGS - Oracle Student Sytems
IGS_AD_SS_APPL_CONF
IMC - Customers Online
IMC_REPORTS_SUMMARY
INV - Oracle Inventory
MTL_DEFAULT_CATEGORY_SETS
ITA - Information Technology Audit
SETUP_GROUP
ITG - Internet Procurement Enterprise Connector
JA - Asia/Pacific Localizations
JAI_PA_SETUP_PREFERENCES
JE - European Localizations
JE-ZX_FC_CODES_B
JL - Latin America Localizations
JL_ZZ_AR_TX_ATT_CLS_ALL
JTF - CRM Foundation
JTF_FM_SERVICE
JTM - Oracle CRM Mobile Foundation
JTM_CON_REQUEST_DATA
LNS - Loans
LNS_EVENT_ACTIONS
MRP - Oracle Master Scheduling
MSC - Oracle Advanced Supply Chain Planning
MSC_PROCESS_FLOWS
MSD - Oracle Demand Planning
MSD_CS_CLMN_DIM_DTLS
MST - Transportation Planning
MST_SELECTION
O - Z
OKC - Oracle Contracts Core
OKC_ACTION_ATTRIBUTES
OKE - Project Contracts
OKE_TERMS
OKL - Oracle Lease Management
OKL_STRM_TYPE
ONT - Oracle Order Management
OE_PC_VTMPLTS
OZF - Funds & Budgets
OZF_SD_STATUS_TRANSITIONS
PA - Oracle Projects
PA_SYSTEM_LINKAGES
PAY - Oracle Payroll
PAY_USER_COLUMN_INSTANCES_F
PER - Oracle Human Resources
PER-AME_CALLING_APPS
PJI - Project Intelligence
PJI_SYSTEM_SETTINGS
PJM - Oracle Project Manufacturing
PON - Sourcing
PON_NOTIF_GROUP_MEMBERS
PO - Oracle Purchasing
PO_DOCUMENT_TYPES
PQH - Oracle Public Sector HR
PQH_ATTRIBUTES
PQP - Public Sector Payroll
pqp_alien_state_treaties
PRP - Proposals
PRP_GROUPS
PSP - Oracle Labor Distribution
PSP_EFFORT_MESSAGES
PV - Partner Relationship Management
PV_BENFT_USER_ROLE_MAPS
QA - Oracle Quality
QA_CHARS
QP - Oracle Pricing
PARAMETER
QPR - Oracle Deal Management
QPR_LOAD_MENU
QRM - Oracle Risk Management
QRM_ANA_ATTS_LOOKUPS
RG - Application Report Generator
RG_REPORT_AXES
VEA - Oracle Automotive
TPA
WIP - Oracle Work in Process
WIP_PREFERENCE_DEFINITIONS
WMS - Oracle Warehouse Management System
WMS_LABEL_FIELDS
WSH - Oracle Shipping
WSH_ITM_ADAPTER_STATUS
XDO - XML Publisher
XDO_CONFIG_PROPERTIES
XDP - Oracle Provisioning
XDP_ACTION_CODES
XLA - Subledger Accounting
XLA_ACCT_ATTRIBUTES
XLE - Legal Entity Configurator
XLE_JURISDICTIONS_VL
XNP - Oracle Number Portability
XNP_EVENT_SUBSCRIBERS
XTR - Oracle Treasury
XTR_AMOUNT_ACTIONS
ZX - E-Business Tax
zx_party_tax_profile
Name Description Default Value N/A N/A N/A
FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y DOWNLOAD $SOURCE_FILE APPLICATION_SHORT_NAME=AP
Sample Deploy Commands
cp $SOURCE_FILE $AP_TOP/patch/115/import/;
FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y UPLOAD $AP_TOP/patch/115/import/sadf - UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE;
Considerations None
Other Files A "catch all" for object types which are not natively recognized by FlexDeploy. These files can be used in conjunction with custom deploy commands to accomplish any task.
File Extensions Name Description any Any file which is not recognized by FlexDeploy within any other object type.
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
Name Description Default Value N/A N/A N/A
N/A - Build commands not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/patch/115;
Considerations None
Territory Code