Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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_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