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

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...