Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Current »

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



This table also includes the properties that are available to override.

File Types

Default Source

Default Target

Properties

AOL (LDT File)

import

/patch/115/import


Forms

forms

Stage (fmb): $AU_TOP/forms

Output (fmx): $PROD_TOP/forms

Source:

EBS Forms Source Directory

Destination:

EBS Forms Root Stage Directory

EBS Forms Root Destination Directory

EBS Forms Classpath

Reports

reports

$PROD_TOP/$APPLREP

Source:

EBS Reports Root Destination Directory

Destination:

EBS Reports Root Source Directory

Concurrent Program SQLs

cp_sql

$PROD_TOP/sql

Source:

EBS Concurrent Program SQL Root Source Directory

Destination:

EBS Concurrent Program SQL Root Destination Directory

SQL File & PL/SQLs

sql

$PROD_TOP/patch/115/sql

Source:

EBS SQL Root Source Directory

EBS SQL Extensions

Destination:

EBS SQL Root Destination Directory

EBS Ignore Errors File List

EBS SQL Ignore Compile Errors

EBS SQL Retry Count

Java

java

$JAVA_TOP

Source:

EBS Java Root Source Directory

Destination:

EBS Java Root Destination Directory

EBS Java Classpath

OAF Components

java

XML

JPX

$JAVA_TOP

$PROD_TOP/mds

$PROD_TOP/mds

Source:

EBS Java Root Source Directory

Destination:

EBS Java Root Destination Directory

EBS Java Classpath

XDF- XML files containing object definitions

xdf

$PROD_TOP/patch/115/xdf


Workflows (wft & wfx)

workflows

patch/115/import

Source:

EBS Workflows Root Source Directory

Destination:

EBS Workflow Classpath

Compiled Forms and reports (pll)

forms

Stage: $AU_TOP/forms

Output: $PROD_TOP/forms

Source:

EBS Forms Root Source Directory

Destination:

EBS Forms Root Destination Directory

EBS Forms Classpath

Uncompiled Forms and reports (pld)

forms

Stage: $AU_TOP/$APPLFRM

Output: $PROD_FORMS$AU_TOP/$APPLFRM

Source:

EBS Forms Root Source Directory

Destination:

EBS Forms Root Destination Directory

EBS Forms Classpath

XML/BI Publisher Files

publisher

$PROD_TOP/patch/115/publisher/templates or def

Source:

EBS Publisher Root Source Directory

Destination:

EBS Publisher Root Destination Directory

Prog files

prog

$PROD_TOP/bin

Source:

EBS Prog Root Source Directory

Destination:

None (No override)

Image files

media

$OA_MEDIA

Source:

EBS Media Root Source Directory

Destination:

EBS Media Root Destination Directory

HTML files

html

$OA_HTML

Source:

EBS HTML Root Source Directory

Destination:

EBS HTML Root Destination Directory

Java Loader Text (jlt)

jlt or import

$PROD_TOP/patch/115/import


Font files

fonts

$AF_JRE_TOP/lib/fonts

Source:

EBS Fonts Root Source Directory

Destination:

EBS Fonts Root Destination Directory

Scripts (sh & pl)

scripts

$PROD_TOP/bin

Source:

EBS Scripts Root Source Directory

Destination:

EBS Scripts Root Destination Directory

Perl Modules

perl

$PROD_TOP/perl

Source:

EBS Perl Root Source Directory

Destination:

EBS Perl Root Destination Directory

Archive files (jar & ear)

jar

ear

$PROD_TOP/patch/115/jar

$PROD_TOP/patch/115/ear

Source:

EBS Jar Root Source Directory

Destination:

EBS Jar Root Destination Directory

EBS Ear Root Destination Directory

Mobile Web Application

java

$JAVA_TOP

Source:

EBS Java Root Source Directory

Destination:

EBS Java Root Destination Directory

EBS Java Classpath

SQL*Loader

sqlldr

$PROD_TOP/admin/bin

Source:

EBS SQL LDR Root Source Directory

Destination:

EBS SQL LDR Root Source Directory

EBS Data Root Destination Directory

Java Stored Procedures

loadjava

$JAVA_TOP

Source:

EBS Load Java Root Source Directory

Destination:

EBS Load Java Root Destination Directory

EBS Java Classpath

  • No labels