Object Types
Learn about all object types that can be associated with your uploaded files.
You must select the correct object type. Otherwise you may not see the expected result following deployment of the patch.
File extension naming conventions for SQL scripts are provided as guidelines only, and you are not required to create SQL scripts with these particular extensions. By default, the object type is assigned based on the file extension. Therefore, it is faster to upload customized files with file extension.
Object Type | File Extension | Description | Execution Phase(1) | Default Sequence | Alternative Method |
---|---|---|---|---|---|
APPS Package Body | pkb | Custom package body to be installed in APPS schema | plb | 3 | Include in APPS Package Spec script |
APPS Package Spec | pks | Custom package spec to be installed in APPS schema | pls | 3 | Not applicable |
APPS Synonym | syn | Create synonyms for custom objects | en | 50 | Include in SQL File Copy and Execute as APPS |
APPS View | vw | Custom views to be created in APPS schema | vw | 3 | Include in SQL File Copy and Execute as APPS |
BC4J Substitution | bc4j_jpx | Customization of Business Components for Java | dat | 25 | Not applicable |
Bitmap Image | bmp | Bitmap image file | Not applicable | Not applicable | Not applicable |
Compressed File | zip | Zip file | Not applicable | Not applicable | Not applicable |
Configuration File | cfg | Configuration file | Not applicable | Not applicable | Not applicable |
Copy and deploy Java classes and BC4J XML objects | oa_java_type | Copy and deploy Java classes and BC4J XML | last | 3 | Not applicable |
Copy and load an OAF Page into DB | oaf_page | Copy and load an OAF Page into DB | dat | 24 | Not applicable |
Copy and load an OAF Translations into DB | oaf_translation | Copy and load an OAF Translations into DB | dat | 25 | Not applicable |
Copy and load XML Gateway DTD into DB | ecx_dtd | Copy and load XML Gateway DTD into DB | Not applicable | Not applicable | Not applicable |
Copy and load XML Gateway mapping into DB | ecx_mapping | Copy and load XML Gateway mapping into DB | Not applicable | Not applicable | Not applicable |
Copy Java class | oa_java_class | Copy Java class | last | 3 | |
Custom Index | c_idx | Index on custom table | dfr | 3 | Include in Custom Table script |
Custom Package Body | c_pkb | Package body to be installed in custom schema | plb | 3 | Include in Package Spec script |
Custom Package Spec | c_pks | Package spec to be installed in custom schema. Include DDL for grants to APPS schema. | pls | 3 | Not applicable |
Custom Patch | c_patch | Cemli Patch file built from EM | Not applicable | Not applicable | Not applicable |
Custom Sequence | c_seq | Custom sequence | seq | 3 | Not applicable |
Custom SQL File Copy and Execute | c_sql_exec | Any valid SQL script including DDL. Can be used to produce spool output. | dfr | 99 | Not applicable |
Custom Table | c_tbl | Custom table. Include DDL for grants to APPS schema. | tab | 3 | Not applicable |
Custom Trigger | c_trg | Custom trigger | en | 3 | Custom Table script |
Custom View | c_vw | View to be created in custom schema. Include DDL for grants to APPS schema. | vw | 3 | Not applicable |
Discoverer Export | dis | Oracle Discoverer | Not applicable | Not applicable | Not applicable |
Discoverer File | eex | Oracle Discoverer | Not applicable | Not applicable | Not applicable |
Driver File | drv | EBSO Patch Driver file | Not applicable | Not applicable | Not applicable |
Dump File | dmp | Oracle Database dump file | Not applicable | Not applicable | Not applicable |
Excel File | xls | Microsoft Excel file | Not applicable | Not applicable | Not applicable |
FDI File | fdi | Disk image file | Not applicable | Not applicable | Not applicable |
FDO File | fdo | Form definition operator script | Not applicable | Not applicable | Not applicable |
FND Message Loader Text | msg | FND Loader message file | daa | 3 | Not applicable |
FNDLOAD Control File | lct | FND Loader control file | Not applicable | Not applicable | Not applicable |
FNDLOAD Data File | ldt | FND Loader data file | daa | 52 | Not applicable |
Forms Compiled | fmx | Oracle compiled form | Not applicable | Not applicable | Not applicable |
Forms Library Source and Runtime | pll | Custom library attached to forms | Not applicable | Not applicable | Not applicable |
Forms Menu File | mmb | Forms menu file | Not applicable | Not applicable | Not applicable |
Forms Source and Text | fmb | Forms source file | Not applicable | Not applicable | Not applicable |
Generic File Copy to Deployment Path | gen_cp | Generic File Copy to specified location | first | 3 | Not applicable |
Graphic Interchange Format File | gif | Gif image file | upg | 3 | Not applicable |
Help File | hlp | Help file | Not applicable | Not applicable | Not applicable |
Hypertext File | htm | HTML file | upg | 3 | Not applicable |
Hypertext Markup | html | HTML file | Not applicable | Not applicable | Not applicable |
Image Files | img | Standard image file | Not applicable | Not applicable | Not applicable |
JPEG Image | jpg | JPEG image file | Not applicable | Not applicable | Not applicable |
Java Archive File | jar | Java archive | Not applicable | Not applicable | Not applicable |
Java File | java | Java file | Not applicable | Not applicable | Not applicable |
Java Loader Text | jlt | Java loader file | dat | 4 | Not applicable |
Javascript File | js | JavaScript file | Not applicable | Not applicable | Not applicable |
Java Server Page | jsp | Java Server Page file | Not applicable | Not applicable | Not applicable |
MAC File | mac | Macro file | Not applicable | Not applicable | Not applicable |
Message File | msb | Message file | Not applicable | Not applicable | Not applicable |
OAF zip file | oaf_zip | Oracle Application Framework zip file | Not applicable | Not applicable | Not applicable |
ODF File | odf | Object definition file | seq | 3 | Not applicable |
Office Binder Document File | obd | Online help file | Not applicable | Not applicable | Not applicable |
Oracle Graphs File | ogd | Oracle Graphics file | Not applicable | Not applicable | Not applicable |
OWB Text File | mdl | Text file created by Oracle Warehouse Builder (OWB) metadata loader file for data import | Not applicable | Not applicable | Not applicable |
PDF Documents | pdfh | Adobe Acrobat document | Not applicable | Not applicable | Not applicable |
PDF Templates | pdft | PDF template file | Not applicable | Not applicable | Not applicable |
Perl Module | pm | Perl module file | Not applicable | Not applicable | Not applicable |
Perl Script | pl | Perl script file | Not applicable | Not applicable | Not applicable |
Portable Document Format File | Adobe Acrobat document | Not applicable | Not applicable | Not applicable | |
Portable Network Graphic File | png | Portable network graphics file | Not applicable | Not applicable | Not applicable |
PRT File | prt | Oracle Reports driver file | Not applicable | Not applicable | Not applicable |
Rapid Install Response | rsp | Rapid Install Response file | Not applicable | Not applicable | Not applicable |
Reports Library Source and Runtime | rpll | Custom library attached to reports | Not applicable | Not applicable | Not applicable |
Reports Source and Runtime | rdf | Custom report | Not applicable | Not applicable | Not applicable |
RTF File | rtf | Rich Text Format file | Not applicable | Not applicable | Not applicable |
Shell Script Copy and Execute at End | shell_exec_last | Copy and execute Shell script at end of patching | last | 98 | Not applicable |
Shell Script Copy and Execute at Start | shell_exec_first | Copy and execute Shell script at start of patching | first | 3 | Not applicable |
Shell Script Copy Only | shell | Shell script copy to CUSTOM_TOP | Not applicable | Not applicable | Not applicable |
SQL File Copy and Execute as APPS | sql_exec | Any valid SQL script including DDL. Can be used to produce spool output. | last | 3 | Not applicable |
SQL File Copy Only | sql | SQL file copied to CUSTOM_TOP | Not applicable | Not applicable | Not applicable |
SQL Loader Control File | ctl | SQL Loader Control file | Not applicable | Not applicable | Not applicable |
SQL Loader Data File | dat | SQL Loader Data file | Not applicable | Not applicable | Not applicable |
Standard XML File | amx | Standard XML file | Not applicable | Not applicable | Not applicable |
Style Sheets (css) | css | Style sheet | upg | 3 | Not applicable |
Symbols File | sym | Always accompanies a dll | Not applicable | Not applicable | Not applicable |
TAG File | tag | Query tag name file | Not applicable | Not applicable | Not applicable |
Tagged Image Format File | tif | TIFF image file | Not applicable | Not applicable | Not applicable |
Unix Shared Library | so | Shared library file | Not applicable | Not applicable | Not applicable |
WF Business Event/Subscription | wfx | Workflow Business Event XML Loader file | daa | 3 | Not applicable |
WF Msg Resource File | res | Resource file to store WF messages and used by WF Resource Generator | Not applicable | Not applicable | Not applicable |
Workflow Data File | wft | Workflow text file | daa | 38 | Not applicable |
XML File | xml | File in standard extensible markup language (.xml) format | Not applicable | Not applicable | Not applicable |
XML Publisher Bursting File | xmlp_bf | XML Publisher Bursting file | dat | 3 | Not applicable |
XML Publisher Data Template | xmlp_dt | XML Publisher data template | dat | 3 | Not applicable |
XML Publisher RTF/XLS file | xmlp_rtf | XML Publisher RTF file | dat | 3 | Not applicable |
XML Publisher XLF file | xmlp_xlf | XML Publisher XLF file | last | 3 | Not applicable |
XML Publisher XSL file | xmlp_xsl | XML Publisher XSL file | dat | 3 | Not applicable |
Footnote 1 For information on the order in which phases are executed during patching, please see Patch Phases.
Patch Phases
The following table contains a list of phases and the order in which phases are executed during patching.
Execution Sequence | Phase | Description |
---|---|---|
1 | first | This is the very first phase, which runs before all other phases. |
2 | seq | In this phase sequences are created. |
3 | tab | In this phase tables are created. |
4 | pls | In this phase package specifications are created. This phase should be used for all package specifications. The corresponding package body, if delivered, should be phased in plb. |
5 | vw | In this phase views are created. |
6 | plb | In this phase package bodies are created. This phase should be used for all package bodies. The corresponding package specification should be phased in pls. |
7 | daa | In this phase AOL data is added or modified. This phase is used for files loading or modifying AOL data (in FND tables). |
8 | dat | In this phase seed data is added or modified. |
9 | upg | In this phase transaction data is added or modified. |
10 | dfr | In this phase indexes (Deferred) and any other Deffered objects are created. |
11 | en | In this phase triggers and constraints are created. |
12 | last | This is the very last phase, which runs after all other phases. |