Wednesday 3 June 2015

Oracle Apps Object File Type its Extension and Location on Server

File Type
File Extension
Location on Server
Create DB Object as
Tables/Indexes/Grants/Syns/Seqs
.tab
XX_TOP/install
APPS
Sequences (not table)
.seq
XX_TOP/ install
APPS
Views
.vie
XX_TOP/ install
APPS
Triggers
.trg
XX_TOP/ install
APPS
Forms
.fmb, .fmx
XX_TOP/forms/US
N/A
Reports
.rdf
XX_TOP/reports/US
N/A
Workflow
.wft
XX_TOP/wft
APPS
Package Specification
.pks
XX_TOP/sql
APPS
Package Body
.pkb
XX_TOP/sql
APPS
SQL*Plus Program
.sql
XX_TOP/sql
N/A
Index on Native Oracle Table
.idx
XX_TOP/ install
XXX
Function
.fnc
XX_TOP/sql
APPS
Procedure
.pro
XX_TOP/sql
APPS
Shell Program
No extension
XX_TOP/bin
N/A
SQL*Loader Control File
.ctl
XX_TOP/bin
N/A
One Time DML Scripts
.see
XX_TOP/install
N/A
PL*SQL Libraries
.pll, .plx
XX_AU_TOP/resource
N/A
Help File
.htm
XX_TOP/help/US
N/A

No comments:

Post a Comment

How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>

 How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>  Sometime these xml data tags automatically chang...