Page Comparison

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_DB_USER and
FDEBS_DB_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