File Types | Description | Special Considerations |
---|---|---|
SQL & PLSQLs | SQL, PL/SQL files | Executes all files with DB user configured on environment instances properties sections (apps). Make sure you have schema qualified your objects like |
Concurrent Program SQLs | SQL and PL/SQL files which are not executed during deploy time. | Moves files to target. |
AOL / Generic Loader (FNDLOAD) files | LDT files and iLDT files. | |
Java and OAF | Java files, Server XML files | |
Oracle Application Framework-related XML files | JRAD/MDS files | |
Forms | FMB files | |
Reports | RDF files | |
XML files containing object definitions | XDF files | For XDF files which need to be executed with Schema user, create properties at your workflow as below and provide values in Env Instance section: |
Workflows | WFT/WFX files | |
XML Publisher templates | XML Publisher templates | Use |
Prog files | PROG files for CP | |
Java Stored Procedures | Java Stored Procedures to load to DB using loadjava | |
Web files | HTML and style sheets | JSP files will be compiled if the project property FDEBS_JSP_COMPILE set to Compile or Compile with Flush option. |
Image files | GIF/JPG/PNG, etc. | |
Fonts | TTF/OTF/WOFF, etc. | |
Compiled Forms and reports | PLL/PLX files | |
Uncompiled Forms and reports | PLD files | |
Java Loader Text | JLT files |
|
Scripts | SH/PL/BAT files | |
Perl Modules | PM files | |
Archive files | JAR/EAR files | |
BIP files | RTF.PDF.XML/XSL, etc. | |
Mobile web application files | MWA files |
This table also includes the properties that are available to override.
File Types | Default Source | Default Target | Properties | |
---|---|---|---|---|
AOL (LDT File) | import | /patch/115/import | ||
Forms | forms | Stage (fmb): $AU_TOP/forms Output (fmx): $PROD_TOP/forms | Source: EBS Forms Source Directory Destination: EBS Forms Root Stage Directory EBS Forms Root Destination Directory EBS Forms Classpath | |
Reports | reports | $PROD_TOP/$APPLREP | Source: EBS Reports Root Destination Directory Destination: EBS Reports Root Source Directory | |
Concurrent Program SQLs | cp_sql | $PROD_TOP/sql | Source: EBS Concurrent Program SQL Root Source Directory Destination: EBS Concurrent Program SQL Root Destination Directory | |
SQL File & PL/SQLs | sql | $PROD_TOP/patch/115/sql | Source: EBS SQL Root Source Directory EBS SQL Extensions Destination: EBS SQL Root Destination Directory EBS Ignore Errors File List EBS SQL Ignore Compile Errors EBS SQL Retry Count | |
Java | java | $JAVA_TOP | Source: EBS Java Root Source Directory Destination: EBS Java Root Destination Directory EBS Java Classpath | |
OAF Components | java XML JPX | $JAVA_TOP $PROD_TOP/mds $PROD_TOP/mds | Source: EBS Java Root Source Directory Destination: EBS Java Root Destination Directory EBS Java Classpath | |
XDF- XML files containing object definitions | xdf | $PROD_TOP/patch/115/xdf | ||
Workflows (wft & wfx) | workflows | patch/115/import | Source: EBS Workflows Root Source Directory Destination: EBS Workflow Classpath | |
Compiled Forms and reports (pll) | forms | Stage: $AU_TOP/forms Output: $PROD_TOP/forms | Source: EBS Forms Root Source Directory Destination: EBS Forms Root Destination Directory EBS Forms Classpath | |
Uncompiled Forms and reports (pld) | forms | Stage: $AU_TOP/$APPLFRM Output: $PROD_FORMS$AU_TOP/$APPLFRM | Source: EBS Forms Root Source Directory Destination: EBS Forms Root Destination Directory EBS Forms Classpath | |
XML/BI Publisher Files | publisher | $PROD_TOP/patch/115/publisher/templates or def | Source: EBS Publisher Root Source Directory Destination: EBS Publisher Root Destination Directory | |
Prog files | prog | $PROD_TOP/bin | Source: EBS Prog Root Source Directory Destination: None (No override) | |
Image files | media | $OA_MEDIA | Source: EBS Media Root Source Directory Destination: EBS Media Root Destination Directory | |
HTML files | html | $OA_HTML | Source: EBS HTML Root Source Directory Destination: EBS HTML Root Destination Directory | |
Java Loader Text (jlt) | jlt or import | $PROD_TOP/patch/115/import | ||
Font files | fonts | $AF_JRE_TOP/lib/fonts | Source: EBS Fonts Root Source Directory Destination: EBS Fonts Root Destination Directory | |
Scripts (sh & pl) | scripts | $PROD_TOP/bin | Source: EBS Scripts Root Source Directory Destination: EBS Scripts Root Destination Directory | |
Perl Modules | perl | $PROD_TOP/perl | Source: EBS Perl Root Source Directory Destination: EBS Perl Root Destination Directory | |
Archive files (jar & ear) | jar ear | $PROD_TOP/patch/115/jar $PROD_TOP/patch/115/ear | Source: EBS Jar Root Source Directory Destination: EBS Jar Root Destination Directory EBS Ear Root Destination Directory | |
Mobile Web Application | java | $JAVA_TOP | Source: EBS Java Root Source Directory Destination: EBS Java Root Destination Directory EBS Java Classpath | |
SQL*Loader | sqlldr | $PROD_TOP/admin/bin | Source: EBS SQL LDR Root Source Directory Destination: EBS SQL LDR Root Source Directory EBS Data Root Destination Directory | |
Java Stored Procedures | loadjava | $JAVA_TOP | Source: EBS Load Java Root Source Directory Destination: EBS Load Java Root Destination Directory EBS Java Classpath |