Supported File Types in Customization Manager

This appendix covers the following topics:

Supported File Types

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.

Supported File Types in Customization Manager
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
pdf .pdf Document file (Portable Document Format (PDF) copy
pdf .pdf 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 .pdf 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

Recommended Locations for Common File Types

The following table lists recommended locations for some commonly-used file types.

Recommended Locations for 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

Execution Sequence of SQL File Types

The following table lists the execution sequence of SQL file types.

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.