Supported EBS Object Types

File Types

Description

Special Considerations

SQL & PLSQLs

SQL, PL/SQL files
Note: SQL files will be deployed in the order given in the SQL_ORDER.seq file. If the SQL_ORDER.seq file not available, files will be executed based on the extension of the files (typ, tps, tpb, sql, pkh, plb, pkb, pks, pls, pck, fnc, trg, spc, bdy, prc). If you have few files in SLQ_ORDER.seq file, those SQLs will be executed first and rest will be executed as per their extension.

Executes all files with DB user configured on environment instances properties sections (apps). Make sure you have schema qualified your objects like CREATE TABLE XXHR.XXHR_PER_SOCIETIES ….
If you would like to execute other schema users, name the file name starting with SCHEMAXXX_
Eg: SCHEMAPOS_AAQ.sql and define the following properties on your Workfow:
FDEBS_SCHEMAPOS_DB_USER and
FDEBS_SCHEMAPOS_DB_PASSWORD

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

 

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:
FDEBS_SCHEMAXXX{_}DB_USER
FDEBS_SCHEMAXXX{_}DB_PASSWORD
Eg:
FDEBS_SCHEMAPOS{_}DB_USER
FDEBS_SCHEMAPOS{_}DB_PASSWORD

Workflows

WFT/WFX files

 

XML Publisher templates

XML Publisher templates

Use LOB_CODE as file name.

Prog files

PROG files for CP

 

Java Stored Procedures

Java Stored Procedures to load to DB using loadjava

 

Web files

HTML and style sheets
HTML/XSL/XSS/CSS/JSP, etc.

 

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

akload will be used to load.

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