This appendix covers the following topics:
The following table lists the supported file types in Customization Manager. You can include files of only these types in your custom packages. The Object Action column lists the action that AutoPatch performs on files of the given type.
| File Type Name | Source Extension | Description | Object Action |
|---|---|---|---|
| alter_sequence | .sql | Alter Sequence Script | copy and execute as APPS |
| alter_table | .sql | Alter Table Script | copy and execute as APPS |
| alter_table_owner | .sql | Alter Table Owner Script (run as schema owner) | copy and execute as schema owner |
| amx | .amx | Standard XML file | copy |
| app | .app | Used to configure the apache single listener (modplsql) | copy |
| BC4J XML | .xml | Oracle Application Framework - BC4J XML file customizations | compile and deploy under $JAVA_TOP |
| bmp | .bmp | Bitmap image file | copy |
| cfg | .cfg | Configuration file | copy |
| class | .class | Java class file | copy |
| clx | .clx | Spell-checking dictionary file in compressed lexicon format | copy |
| cmd | .cmd | NT Command File | copy |
| conf | .conf | Configuration file to be released along the product | copy |
| coremif | .coremif | XML file that contains schematic information about graphical representation of the structure (RMIM) | copy |
| create_index | .sql | Create Index Script | copy and execute as APPS |
| create_index_owner | .sql | Create Index Owner Script | copy and execute as schema owner |
| create_sequence | .sql | Create Sequence Script | copy and execute as APPS |
| create_synonym | .sql | Create View Synonym Script | copy and execute as APPS |
| create_synonym_owner | .sql | Create Synonym Owner Script | copy and execute as schema owner |
| create_table | .sql | Create Table Script | copy and execute as APPS |
| create_table_owner | .sql | Create Table Schema Owner Script | copy and execute as schema owner |
| create_trigger | .sql | Create or Replace Trigger Script | copy and execute as APPS |
| create_type | .sql | Create or Replace Type Script | copy and execute as APPS |
| create_view | .sql | Create or Replace View Script | copy and execute as APPS |
| create_view_owner | .sql | Create View Owner Script | copy and execute as schema owner |
| csh | .csh | Shell script file | copy |
| csv | .csv | File from which user-needed data is imported | copy |
| ctl | .ctl | SQL*Loader file | copy |
| dat | .dat | Data file | copy |
| dbc | .dbc | File used for database connection | copy |
| dbt | .dbt | Database text file | copy |
| def | .def | Definition file | copy |
| dis | .dis | Discoverer Export | copy |
| dll | .dll | Dynamic link library | copy |
| dmp | .dmp | Memory dump | copy |
| doc | .doc | Microsoft Word document file | copy |
| document css | .css | Used in document patches; cascading stylesheet file | copy and execute using FNDGFU |
| document gif | .gif | Used in document patches; image files | copy |
| document htm | .htm | Used in document patches; HTML files | copy |
| document ldt | .ldt | Used in document patches; navigation library files | copy and upload using FNDLOAD |
| dot | .dot | Microsoft Word template file | copy |
| drv | .drv | Driver file | copy |
| drvx | .drvx | Database driver exception file | copy |
| dtd | .dtd | XML Document Type Definition | copy |
| ear | .ear | An EJB .jar archive with XML contents in the META-INF | copy |
| eex | .eex | Oracle Discoverer | copy |
| env | .env | Environment file | copy |
| exp | .exp | Drawing Express file format | copy |
| fdi | .fdi | Disk image file | copy |
| fdo | .fdo | Form definition operator script | copy |
| flt | .flt | Filter file | copy |
| fmb | .fmb | Oracle Forms | copy and genform |
| fmt | .fmt | Oracle Forms form source text file | copy |
| fmx | .fmx | Compiled form | copy |
| force upload | .ldt | Used in software patches | copy and upload using FNDLOAD with CUSTOM_MODE=FORCE option |
| fpp | .fpp | Fortan source code file | copy |
| frm | .frm | Database format file | copy |
| ftg | .ftg | System help file | copy |
| fxp | .fxp | Fortan compiled code file | copy |
| hct | .hct | HRMS fast formula loader control file | copy |
| hdt | .hdt | HRMS fast formula loader data file | copy |
| hlp | .hlp | Help file | copy |
| html | .html | Hypertext Markup Language | copy |
| ico | .ico | Icon file | copy |
| imp | .imp | Spreadsheet file | copy |
| inc | .inc | Include file | copy |
| inf | .inf | Used for applying updates to windows registry | copy |
| ini | .ini | Java Parameter File | copy |
| inp | .inp | Input file | copy |
| interface ldt | .n | Interface Repository loader file | copy |
| jar | .jar | Java archive file | copy |
| java | .java | Java file | compile and deploy under $JAVA_TOP |
| java_lib | .jar | Java library (for compilation only) | Use jar only for compiling; jar is not included into the patch |
| jlt | .jlt | Java Loader Text - used by AKLOAD.java | copy |
| jpg | .jpg | JPEG image file | copy |
| Jpx | .jpx | BC4J Substitution | copy |
| JRAD/MDS File | .xml | JRAD Files are xml extensions. These extensions should be used for Oracle Application Framework objects under the mds directory. | copy and load using XMLImporter |
| js | .js | Javascript file | copy |
| jsp | .jsp | Java server page | copy |
| jspx | .jspx | JSP document | copy |
| lct | .lct | Application Object Library Generic Loader control file | copy |
| llt | .llt | Digital chart file | copy |
| mac | .mac | Macro file | copy |
| mdl | .mdl | Text file created by Oracle Warehouse Builder (OWB) metadata loader file for data import | copy |
| mif | .mif | XML file that contains schematic information about graphical representation of the structure (RMIM) | copy |
| mk | .mk | Make file | copy |
| mmb | .mmb | Menu file | copy |
| mmt | .mmt | Menu text file | copy |
| mmx | .mmx | A kind of menu file | copy |
| msb | .msb | Message Dictionary file | copy |
| msg | .msg | FND Message Loader Text | copy |
| MSI | .xml | Manual Step File | copy |
| OAF Component | .java | Oracle Application Framework customizations | compile and deploy under $JAVA_TOP |
| obd | .obd | Online help file | copy |
| odb | .odb | Oracle Lite database file required from Mobile Applications | copy |
| odf | .odf | Object definition file | copy |
| ogd | .ogd | Oracle Graphics | copy |
| ora | .ora | Net8 configuration files (listener.ora, tnsnames.ora) | copy |
| package_body | .sql | Package body | copy and execute as APPS |
| package_spec | .sql | Package specification | copy and execute as APPS |
| pc | .pc | Pro*C program | copy |
| Document file (Portable Document Format (PDF) | copy | ||
| XMLP PDF notrans | copy and load using XDOLoader | ||
| pdt | .pdt | HRMS legislative loader data file | copy |
| pkb | .pkb | Package body | copy and execute as APPS |
| pkh | .pkh | Package header | copy and execute as APPS |
| pkh (no n) | .pkh | Package definition | copy |
| Pks | .pks | PL/SQL package specification | copy and execute as APPS |
| pl | .pl | Perl Scripts | copy |
| plb | .plb | Package body | copy |
| pld (Forms) | .pld | Forms Library | compile to pll; copy and genfpll |
| pld (Reports) | .pld | Reports Library | compile to pll; copy and genrpll |
| pll (Forms) | .pll | Compiled Forms library | copy and run genfpll |
| pll (Reports) | .pll | Compiled Reports library | copy and run genrpll |
| Pls | .pls | PL/SQL package specification | copy and execute as APPS |
| plx | .plx | Oracle Forms library file executable | copy |
| pm | .pm | Perl Modules | copy |
| ppp | .ppp | Page layout file | copy |
| prc | .prc | Palm Pilot application file | copy |
| prog | .prog | Host concurrent program | copy create a symbolic link using $FND_TOP/patch/115/bin |
| properties | .properties | Java Property Class | copy |
| prt | .prt | Oracle Reports driver | copy |
| ps | .ps | Postscript Pages | copy |
| rdf | .rdf | Oracle Reports | copy and genrep |
| res | .res | Resource file to store WF messages and used by WF Resource Generator | copy |
| rlt | .rlt | Data analysis uncommon file | copy |
| rpt | .rpt | Oracle Reports file | copy |
| rsp | .rsp | Rapid Install response file | copy |
| RTF File | .rtf | Rich text format | copy |
| rts | .rts | Resource bundle file for java related tool is Tecate | copy |
| Scr | .scr | Script file generated by the Oracle Scripting Script Builder" tool" | copy |
| seed_data | .sql | Custom Seeded Data SQL script | copy and execute as APPS |
| sh | .sh | Bourne or Korn shell script | copy |
| so | .so | UNIX shared library | copy |
| software css | .css | Used in software patches | copy |
| software gif | .gif | Image file (Graphics Interchange Format) | copy |
| software htm | .htm | Hypertext Markup Language | copy |
| software ldt | .ldt | Used in software patches | copy and upload using FNDLOAD |
| sql | .sql | SQL script | copy and execute as APPS |
| sql_owner | .sql | Generic SQL Owner Script (copy only) | copy and execute as schema owner |
| sqlj | .sqlj | SQLJ file | copy |
| sym | .sym | Always accompanies a dll | copy |
| tag | .tag | Query tag name | copy |
| tcl | .tcl | TCL scripts called by Oracle Enterprise Manager's Intelligent Agent for hosted Exchange products | copy |
| thtml | .thtml | Template toolkit for ISD | copy |
| tif | .tif | Image file (Tagged Image File Format) | copy |
| tld | .tld | Tag library definition file | copy |
| tlx | .tlx | Spell-checking dictionary file in text lexicon format | copy |
| tpl | .tpl | Template files | copy |
| ttf | .ttf | TrueType font definition file | copy |
| txt | .txt | Plain text file | copy |
| uit | .uit | Custom renderer for the FWK header component | copy |
| uix | .uix | User interface XML | copy |
| vsd | .vsd | Source file for gif files used in translations | copy |
| wbmp | .wbmp | Bitmap file for wireless devices | copy |
| wft | .wft | Workflow Text | copy and upload using WFLOAD |
| wfx | .wfx | Workflow XML loader files | copy and load using WFXLoader |
| wsdl | .wsdl | Web Services Description Language File | copy |
| x2h | .x2h | X2h format file for ISD | copy |
| xcfg | .xcfg | ADF XML configuration file | copy |
| xdf | .xdf | XML files containing object definitions | copy and execute using FNDXDFCMP |
| xdf(AW) xlf | .xlf | Analytic Workspaces XML files containing object definitions | copy |
| xgd | .xgd | XML Gateway Data definition file | copy |
| xgm | .xgm | XML Gateway Mapping file | copy |
| xlf | .xlf | XLF files are generated from xml files | copy |
| xls | .xls | Microsoft Excel file | copy |
| XML | .xml | Extensible Markup Language file | copy |
| XMLP PDF notrans | XML Publisher (XDO) PDF templates | copy | |
| XMLP rtf notrans | .rtf | XML Publisher (XDO) non-transferable RTF templates | copy and load using XDOLoader |
| XMLP rtf notrans | .rtf | XML Publisher (XDO) non-translatable RTF templates (recommended) | copy |
| XMLP rtf template | .rtf | XML Publisher (XDO) translatable templates | copy |
| XMLP xlf | .xlf | Xlf files generated from translatable XMLP templates | copy |
| XMLP XML notrans | .xml | XML Publisher (XDO) non-translatable XML templates | copy |
| XMLP XSD notrans | .xsd | XML Publisher (XDO) non-translatable XML templates | copy |
| XMLP XSL notrans | .xsl | XML Publisher (XDO) non-translatable XSL templates | copy |
| xsd | .xsd | XML Schema provides a means for defining the structure of XML documents | copy |
| xsl (non-dbdrv) | .xsl | XML Style Sheets (not used in database driver) | copy |
| xss | .xss | Extensible Style Sheet definition | copy |
| Z | .Z | Adaptive Lempel-Ziv compressed file | copy |
| zip | .zip | Zipped file | copy |
The following table lists recommended locations for some commonly-used file types.
| File Types | Description | Recommended Destination Path (Relative to Product Top) |
|---|---|---|
| sql, package_spec,package_body, create_table, alter_table, create_sequence,alter_sequence,create_view,create_trigger, create_type create_index,seed_data,create_synonym,pkh,plb,pls,pkb, create_table_owner,alter_table_owner,create_index_owner, sql_owner,create_view_owner ,create_synonym_owner | SQL, PL/SQL files | patch/115/sql |
| software ldt | All Generic Loader (FNDLOAD) files | patch/115/import/<LANG>; for example, 'patch/115/import/US' |
| sh | Shell script | bin |
| pl | Perl script | bin |
| prog | Host concurrent program | bin |
| xdf | XDF file | patch/115/xdf |
| fmb | Forms | forms/<LANG>; for example, forms/US |
| rdf | Report | reports/<LANG>; for example, reports/US |
| html,xsl,xss,css | HTML and style sheets | html |
| jsp | JSP | html |
| XML Publisher templates | XML Publisher templates | patch/115/publisher/templates |
| java | Java files | java/<package path>; for example, java/test for the file oracle/apps/newprod/test/hello.java |
| JRAD/MDS file | Oracle Application Framework-related XML files | mds/<path> |
| gif | Image files | media |
| pm | Perl module | perl/<path> |
| wfx | wfx file | patch/115/xml |
The following table lists the execution sequence of SQL file types.
| File Type | Description | Order Of Execution |
|---|---|---|
| create_sequence | Create sequence script | 1 |
| create_table | Create table script | 2 |
| create_table_owner | Create table in custom schema | 2 |
| alter_table | Alter table script | 3 |
| alter_sequence | Alter sequence script | 3 |
| alter_table_owner | Alter table in custom schema | 3 |
| create_type | Create or replace type script | 4 |
| package_spec | Package specification | 5 |
| create_view | Create or replace view script | 6 |
| create_synonym | Create view synonym script | 6 |
| create_view_owner | Create view in custom schema | 6 |
| create_synonym_owner | Create synonym in custom schema | 6 |
| package_body | Package body | 7 |
| seed_data | Custom seeded data SQL script | 8 |
| create_index | Create index script | 9 |
| create_index_owner | Create index in custom schema | 9 |
| create_trigger | Create or replace trigger script | 10 |
| sql | Generic | 11 |
| sql_owner | Run SQL in custom schema | 11 |
For example, the type create_sequence will execute before the type create_table or create_table_owner. The types create_table/create_table_owner will execute in parallel before the types alter_table/alter_sequence/alter_table_owner.