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_DB_SCHEMAPOS_USER and
FDEBS_DB_SCHEMAPOS_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 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:
FDEBS_DB_SCHEMAXXX{_}_USER
FDEBS_DB_SCHEMAXXX{_}_PASSWORD
Eg:
FDEBS_DB_SCHEMAPOS_USER
FDEBS_DB_SCHEMAPOS_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.

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

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


The following macros are not currently supported in the footer:
  • style