I have around 4 years of experience in Oracle Apps (11i) Technical Consultant

I involved projects like Implementation upport and maintained and mi!ration In that I
involved module like "O# A"# $%# O&# I'( 'O) I am familiar in "O# A"# I'(
technical as *ell as functional
+ere I developed ,eports# forms# interfaces as *ell as customi-ations of reports and
interfaces
STERIS is the worlds pre-eminent infection prevention, decontamination and critical and surgical
care company, with thousands of customers in more than 60 countries. While the corporation was
founded in 1987, our history dates back to the founding of The American Sterilizer Company in
1894, a long-time, globally leading innovator of sterilization products.
Today, through a series of strategic acquisitions and continual innovation of new products,
STERIS holds one of the broadest portfolios of products in the industry.
It stands at the forefront of efforts to prevent infection and contamination in healthcare and
pharmaceutical environments, and is broadening its reach with products to meet the needs of
defense, and industrial markets.
AIM Mythologies
Get the MD50 from the reporting person or functional consultant
Read the documentation and raise the Issues, if I am not able to understand some where , once
the issues are clear then go for developing of components, once the development is over we will
be sending this one to reviewer He will check the coding standards and he will mention defaults
Once the code is over we will be sending the object to the testing these will do the testing and
once it is passed they will send to production instance
./) ys Admin &odule0
a) 1efine Custom 2sers# 3) 1efine %o!in 2sers# c) ,e!ister oracle 14 users#
d) 1efine Concurrent "ro!rams# e) ,e!ister Concurrent 5xecuta3les# f) ettin! "rofile
Option (alues# !)
1efine ,e6uest Types7
.8) AO%0
a) ,e!isterin! ta3les7 3) ,e!isterin! vie*s c) ,e!isterin! d3 se6uences
d) ,e!isterin! profile options e) ,e!isterin! lookups and lookup codes
f) ,e!isterin! forms !) ,e!isterin! 9orm and 'on:9orm functions i) re!isterin!
&enus and su3:menus7 j) ,e!isterin! 199 and ;997 k) %i3raries
<)&aster 1etails Tri!!ers
179orm level tri!!ers:On=clear=details
>74lack level tri!!ersOn=populate=details# on=check=delete=master
.7Item level tri!!ers
<))t r the tri!!ers fire *hen u open 9orm
"re=form
"re=3lack
"re=record
"re=textitem
)hen=ne*form=instance
)hen=ne*3lack=instance
)hen=ne* record=instance
)hen=ne*=item=instance
<)*t r the tri!!ers fire *hen close a 9orm
"ost=textitem
"ost=record
"ost=3lack
"ost=form
1)Wr r the DDL statements
1)Create >)alter .)1rop 4)Truncate /),ename
Create?:Create Oracle 1ata3ase O3ject such as Ta3les#(ie*es#ynonyms#Index#Cluster
Create Ta3le @Ta3le'ameAColums@1atatype)
Alter ta3le @Ta3le'ameAA11 Colums@1atatype)
Alter ta3le @Ta3le'ameA&odify Colums@1atatype)
Alter ta3le @Ta3le'ameA1rop Colums'ame
1rop Ta3le @Ta3le'ameA
Truncate Ta3le @Ta3le'ameA
,eanme@OldTa3lenameAto@'e*ta3le'ameA
5xplain?:It !enerate access path for the 6uery Optimi-ation level
2)Wt r the DML Statements
ItBs used to feed values modify values in data3ase O3jects
1)elect >)Insert .)2pdate 4)1elete /)&er!e
elect Cfrom 5mp
Insert into@Ta3le'ameA(Colimn%ist)(alues((alues%ist)
Insert into @Ta3le'ameA(aluies@(alues%istA
Insert into @Ta3le'ameA(alues(DColumns)
2pdate@Ta3le'ameA et Column'ameE(alues
1elete from @Ta3le'ameA *here Condition
3)wt r the DCL Statements
1)$ranr >),evoke
$rant is one of the permission access to 2ser
,evoke is used to cancel the "riville!es on 1ata3ase o3ject to other users
$rant@"rivilla!eAon @Ta3le'ameAto 2ser
,evoke@"rivilla!eAon @Ta3le'ameA 9rom 2ser
4 )Wt r the TCL statements
1)Commit?:To make the chan!es "ermanent
>),oll3ack?:To cancel the chan!es
.)ave"oint?:To set mar!in for commit or roll3ack
Transaction?: A transaction is a lo!ic unit of *ork
WT IS Constraints?:CO'T,AI'T are a set of predefined rules *hich can 3e defined
on ta3le and activated automatically *hen ever 1&% statements are performed
1)'OT '2%%?:2sed to suppress 'ull values
>)Check?:used to suppress supplicate values
.)"rimary key?:"rimary key column canBt contain 'ull values and duplicate values only
once it can 3e used
4)2ni6ue?:used to suppress duplicate values
/)9orei!n key?:reference the primary key
8),eferience key?:itBs used to define relationship 3et*een ta3les
SET OPERATORS?:com3ine the result of t*o 6ueries in to sin!le one
2nion?:ro*s of first 6uery plus ro*s of second 6uery less duplicate ro*s
2nionAll?: ro*s of first 6uery plus ro*s of second 6uery *ith duplicate ro*s
&inus?:ro*s uni6ue to the first 6uery
Intersect?:Common ro*s from all the 6ueries
JOIS?:used to retrive date from more than one ta3le
1)56ualjoin?:4ased on e6uaty condition ta3les are joined
elect dname#loc#ename #jo3#sal from emp# dept *here enp7deptnoEdept7deptno
'on56ualjoin?:if *e just remove the *here statement then itBs non:e6ual join
Outer Foin?:itBs used to retrive the missin! ro*s# 5xtend the result of simple join as *ell
as those records *hich r not match another ta3le
elect dname#loc#ename #jo3#sal from emp# dept *here enp7deptno(G)Edept7deptno
elfjoin?:joinin! the ta3le to it self similier column must 3e repeted in the same
Cartesion?: *ith out any joinin! condition
+avin! class?:itBs used to filter the !rouped records
1istanct ?:used to suppers duplicate values in specific column
$roup 3y clause?:itBs used to devide the ro*s onto smaller !roups in a ta3le
)here clause?:used to filter the records in for the specified conditions
Order 3y clause?:to list the details in accendin! order decendin! order
S!"#!er$%:6uery *ith a 6uey is nothin! 3ut su36uery is used to find out unkno*n value
elect av!(sal) #deptno# fom emp havin! av!(sal)A(select av!(sal) from emp *here
deptnoE>H) !roup 3y deptnoI
elect Cfrom emp e *here salADn(select count(C) from emp *here salAe7sal
Correlated <uery?:
Data"ase O"&e'ts?: permanently re!istered in oracle server
Ta3les?:used to store information and manipulate 3asic stora!e unit
(ie*?:com3ination of one or more ta3les *ith select statements itBs used to reduce
redundancy and fast retrival of the data
"rovide security *hile sharin! data *ith other users
Create (ie*@vie*nameA as select statement
In line (ie*?:
&ateriali-e vie*?:
9orce (ie*?:
ynonum?: are alies name itBs used to hide ori!inal name and o*ner of the data3ase
o3ject > type private?:created 3y user
"u3lic?:created 3y 14A
Create synonym @synonymnameA for @o3jectnameA
ynonym is useful for administrator more than other users
e6uence?: used to to !enerate 2ni6 num3ers# itBs not relaBed to any ta3le#itBs a shara3le
o3ject# itBhas >seudo columns
'extval?:holds the next value of se6uence
Currval?:holds the previous value of the se6uence
Initially it *ill -ero
Create se6uence @se6uencenameAincrement 3y 1 start *ith 1I
Index?:is a fast retrival of the record# itBs pointer locates the address of data
Create index @indexnameA on emp(sal)
Clusters?:used to improve performance of oracle
"sudo Column?:itBs additional function that can called from only select statement they r
treated like colums in a ta3le that is not stored in a ta3le
ysdate# se67nextval#se67currval
,o*id?:it returns the ro* identifier of that particular ro* the extranal format of ,o* id is
character strin!
,o*'um?:*ill return the current ro* num3er in a 6uery
De'o(e%:converts the values of the !iven columns to other !iven mappin! values excutes
as in If else loop or 9or loop
)L?:Convert 'ull to specified values
elect alG'(%(comm7#H) from dual
1ynamic <%?:1ynamic s6l in "%J<% support 11% for this *e use 14& s6l packa!e
5xcute immediately to run dyanamic <%
PL*S#+ Ta"+e?:holds a list of elements under a name *hich are similar datatype similar C
Arry# it *ill not hold any data
Type@Ta3lenameA is ta3le of @datatypeAIndex 3y 3inary Inte!er
PL*S,L Re'or(s?: holds a list of ements under a name *hich are deferent datatype
similar C tructure# it *ill not hold any data
Type@,ecordnameAis record
este( Ta"+e?:'ested ta3le is nothin! data3ase *hich have t*o columns ;5K and
(A%257 It allo* 1&% statements
Type @Ta3le'ameA is ta3le of @Ta3leatypeA('OT'2%%)
)ARRA-?:(array is nothin! 3ut "%J<% Ta3le 3ut it has fixed upper 3ound on it si-e7
It not allo*ed 1&% statements
Type @TypenameA is ((array)
Co++e'tions Metho(s?:Count# 5xit# first# last# 'ext
(aria3le Attri3ute?:
LType?:used to declare column type vendor# it represent only one column structure
v7ename emp7enameLtype
L,o*Tye?: used to declare ro* type vendor# itBs represent entire ta3le structure
IempLro*type
Anon$mo!s .+a'/?:*hich has no name itBs used in 1>k
ame( .+a'/?:itBs "%J<% 3lack *hich has !iven name#
"rocedure#function#"acka!e#tri!!er
E0CEPTIOS ?:5xceptions are errors run time errors *e can catch 3y usin! exception
they are > types
1)Pre(e1ine( E2'e3tion?:Automatically reco!ni-ed and raised 3y Oracle
'O=1ATA=9O2'1# TOO=&A'K=,O)# (A%25=5,,O,# OT+5,#
",A$&A=5,,O,#(A%25=5,,O,# I'(A%I1='2&45,#
C2,O,=A%,5A1K=O"5'51# I'(A%I1=C2,O,
2)4ser (e1ine( E2'e3tions?:2ser defined exceptions are errors that is defined 3y the
pro!rammer
PRA5MA%:pra!ma is directive of compiler to !ive the instruction to the compilier at
compiler time
"ra!rama 5xceptions=Init?:This is a named exception *ith a particular error *e trap this
error specifically rather than via other handler
"ra!ma 5xception=Init (errorname# Oracle errorcode)
,aise=Application=error?: to create your o*n error messa!e this is user defined exception
,aise=applicatio=error(errornum3er#errormessa!e)
S,LERROR?:itBs return the current error messa!e
S,LCODE?:itBs return the current error code
C2,O,?:a cursor is handle# or pointer to the context area or lo!ical memory structure
or A private 6lJ4uffer or memory
> type of cursers
1)Im3+i'it C!rsor?:created 3y oracle *here 1&% is performed
2)E23+i'it C!rsor?:created 3y pro!rammer valid in plJs6l script
Cursor cur1 is select Cfrom emp
Cursor name must 3e 2ni6ue
1eclare Cursor# Open cursor# fetch cursor name in to varia3les# close cursor
C4RSOR ATTRI.4TE%6$ive the state of the cursor
L 9O2'1?:return true fetch is uccessful
L'OT 9O2'1?:return true fetch is 'OT uccessful
LIO"5'?:return true if cursor is opened
L,O)CO2'T?:!ive no of records fetched from the cursor
COSTRAIED C4RSOR?:this is a return type of cursor
4COSTRAIED C4RSOR?:this is not a turn type of cursor
RE7 C4RSOR?:,ef cursor is used to chan!e the <% 6uery 1ynamically or *e can
pass different values at run time
Cursor C1 is select Cfrom emp for update of empno#ename
[Link] TRI55ERS?:A set of "%J<% statements Automatically executed *hen
ever an event is fired
Tri!!er 5vents?:4efore# after# insert# update# delete# ro* level# statement level
Ti!!er Type?
,o* %evel?:it *ill fired only once for one 1&% statement
&ax 1> Tri!!ers can 3e created on a ta3le
1&% tri!!er are defined on 1&% statements it *ill 3e fired 3efore# after
Create or replace tri!!er@tri!!er'ameA3eforeJafter insertJupdate7delete(Columns) on
@Ta3le'ameA for each ro* *hen (condition) Tri!!er 4ody 5ndI
ISTEAD O7 TRI55ERS?:I'T5A1 O9 T,I$$5, CA' 45 159I'51 O'
(I5)
Instead of tri!!er fired 3y instead of 1&% statements# it must 3e ,o* level tri!!er# &ax
8 tri!!ers can 3e created on a ta3le 3
Create or replace (ie* Tri!!er@Tri!!er'ameA Instead of 1elete on vie* for each ro*
3e!inM75ndI
S$stem Tri88ers?:fires on t*o different kinds of events 1)11% 5vents >)1ata3ase
5vents
Tri!!er "redicatefor ?:Insertin!# 2pdatin!# 1eletein!
?O%1?:itBs undefined for Insert statement
?'5)?:itBs undefined for 1elete statement
PROCED4RE?:A set of "%J<% statement "erform a task it may or may not return
value 3ut "rocedure are not used in <%
Create or replace procedure@pro'ameA(ar!ement&ode)@datatypeA is varia3le
declarations 3e!in@excuta3le statementsAexceptions# handle exceptions 5'1 "ro'ameI
74CTIO?: A set of "%J<% statement "erform a task it &ust return sin!le value
)e can use function in <% and "%J<%
Create or replace 9unction@9un'ameA(ar!ement&ode)@datatypeA return datatype I
varia3le declarations 3e!in@excuta3le statementsA 5'1 9un'ameI
PAC9A5E?:ItBs collection of related varia3les Cursors and u3pro!rams# it consist of >
part
1)Pa'/a8e S3e'i1i'ations?:holds the declaration of varia3les cursors and su3pro!rams
2)Pa'/a8e .o($?:holds a 3ody of procedures and functions
O:erLoa(in8?:Oracle permits to call the same procedure name in a packa!e *ith
different ar!uments this is kno*n as Overloadin!
OCOP-?:ItBs compiler hint for the parameter to pass the value as reference it used
only O2T and I'O2T parameters it donBt used I' parameter
Parameters Mo(e?:I' #O2T# I'O2T
A4TOOMO4S TRASACTIO?:*e canBt use TC%(Commit#,oll3ack) in Tri!!er
*e can use this pra!ma at 3est in the tri!!er
A transaction *ith in the transaction is called autonomous transaction itBs
"arent transaction 3ut itBs independent *ith out commit or roll3ack *e canBt perform
Autonomous
Create or replace "rocedure "ro'ame as pra!ma Autonomous=transaction
Oracle Ni havin! the extended futures as compare to oracle Oi they are 'ative
compilation# Case statement# 1ate and timestamp type# "ipelined and ta3le 9unction
9or*ard 1eclararion?:itBs used *hen you *ant to call procedure *ith in another
procedure I
9ITAA?:I 4AICA%%K TOO% TO &I$,AT5 T+5 CO'C2,5'T
",O$,A&#5P5C2TA4%5#,5"O'I4I%ITI5# (A%255T 9,O& O%1
(5,IO' TO '5) (5,IO'
REPORTS%:The process of the data extraction and its display is called ,eport
CO&"O'5'T O9 ,5"O,T?:1)1ata model >)%ayout &odel .)parameter form
4),eport tri!!ers
REPORT ST-LES%6
1)Ta3ular 9ormate
>)$roup left
.) $roup A3ove
4)9orm like
/)9orm letter
8)&atrix
Q)&atrix *ith !roup
O)&ailin! la3el
REPORTS TRI55ERS%6
1)4efore parameters form
>)After parameters form
.)4efore ,eport
4)4et*een ,eport
/)After ,eport
7ORM4LA COL4M?:ItBs user defined calculation on that column
S4MMAR- COL4M?:ItBs pre:defined a!!re!ate function
PLACE ;OLDER COL4M?:ItBs holds a calculated value at specified place
;IDDE COL4M?:ItBs used to *are a column as to 3e em3edded in a 3oiler plate text
7OTMATE TRI55ER?:ItBs "%J<% 9unction executed 3efore o3ject is formatted
dynamically chan!ed
)ALIDATIO TRI55ER?:ItBs "%J<% 9unction# itBs 4oolean value it *ill check true
or false
ACTIO TRI55ER?:Action tri!!er are "%J<% procedures *hen you press the 3utton
that can 3e executed dynamically to call another report
SRW Pa'/a8e?:This packa!e consist of "%J<% includes functions# procedures#
5xceptions *e can refer this packa!e in our ,eports or li3rary (pre:defined packa!e)
DATA LI9?:1ata link are used to esta3lish parent:child relationship 3et*een <uery
and $roups (ia column matches
CO7IE MODE?: If confine mode is O' child o3jects canBt moved from parent
o3ject
7LE0 MODE?:If flex mode is O99 child o3jects can moved from the parent o3ject
AC;OR?:Anchor fasten an ed!e of one o3ject to another o3ject ensurin! that there
maintain their relative positions7
7RAME%: A frame is collection of 9ields
REPETI5 7RAME?:ItBs used to display multiple records
7IELD?: 9ield act as a placeholder for text
.ID PARAMETERS?:ItBs used to replace sin!le value in "%J<% statements
LE0ICAL PARAMETERS?:ItBs place holder for text# it replace strin!# ItBs used to
accept more than one value 3ased on condition at run time7
S-STEM PARAMETERS?:These parameters are used to send output report any flat file
4ack!round# Copies# Currency# 1ecimal# 1esformate# 1esname# 1estype# &ode#
Orientations# "rint jo3# Thousand
4SER E0IT?:Control transfer from the report to .
rd
!eneration lan!ua!e and 3ack to
oracle report
DATA MODEL?: To specifies the data for the report from select statement
LA-O4T MODEL?:ItBs desi!ned system automatically for the every report !enerated
*hich can do 3e desi!n manually
.E7ORE PARAMETER 7ORM?:To display an error messa!e and then returns to
place from *hich you ran the report
A7TER PARAMETER 7ORM?: ,eturn to the runtime parameter form
7ORM%:A form is po*erful development tool for the 3uildin! a client server application
or a form is collection of o3jects and code
7ORM COMPOETS?:9orm 4uilder# 9orm compiler# 9orm ,untime
PROPERT- CLA4SE?: A property clause is named o3ject that contain a list of o3ject
and there values once the property is created other o3ject can 3e used
)IS4LA ATTRI.4TE?:are colour and pattern properties and font properties # it *ill
chan!e dynamically at runtime
,)Master Detai+s Tri88ers
179orm level tri!!ers:On=clear=details
>74lack level tri!!ersOn=populate=details# on=check=delete=master
.7Item level tri!!ers
,)Wt r the tri88ers 1ire when ! o3en 7orm
"re=form
"re=3lack
"re=record
"re=textitem
)hen=ne*form=instance
)hen=ne*3lack=instance
)hen=ne* record=instance
)hen=ne*=item=instance
<)*t r the tri!!ers fire *hen close a 9orm
"ost=textitem
"ost=record
"ost=3lack
"ost=form
[Link] 5RO4PS?: ItBs a lo!ical container *hich is used to keep o3ject
[Link]?: "%J<% li3rary is collection of pro!ram units includin! usednamed #
procedures# functions and packa!es they are . li3rary formate "%%7"%P#"%1
%O(?:%ist of values
RECORD 5RO4PS?:COLLECTION OF RECORDS
ERP
1ifferent "rojects that are in 5,"
1)Implementation ?:'e* project startin! from crunch
>) Customi-ation ?:5xtend the functionality(editin! or modifyin!)
.)up!radin! D &i!ration?:version chan!e from lo*er version to hi!her version
4)upport D maintain
(ersions are?:1H7Q# 117H7.# 117/7N# 117/71H
Architecture of Apps packa!e
1)9inancial >)manufacturin! .)+,& 4)C,&
A"#A,# $%#9A#C& these are the 9inancial &odules
I'(# O&# "O#)I"#4O& these are &anufacturin! &odules
Oracle Apps file Architecture
OracleJprodapplJ$%J,eportsJ2Jfilename7rdf
AisinJOracleJprodapplJPPC2JformsJ2Jfilename7fm3
AisinJOracleJprodapplJPPC2JreportsJ2Jfilename7rdf
AisinJOracleJprodapplJPPC2J3inJfilename7ctl
AisinJOracleJprodapplJPPC2Js6lJfilename7s6l
AisinJOracleJprodapplJPPC2JplJs6lJfilename7pk3 or pks
5very module consists of Ta3les# se6uences# indexes# vie*s
Apps data3ase does not contain any ta3le of any module# ItBs contains only synonym of
all modules
Oracle Apps chema consists only synonyms
<%Aconnect appaJappsJprod
2se of Apps?:ecurity# 1ata inte!rity# modularity# multi:or!# flex fields
Interface??:Interfaces are used to transfer data from flat file to oracle ta3les or vice versa
(flat file Oracle ta3les)
There are > types of interfaces 1)In3ound >)out 3ond
9lat filesta!in! ta3leInterface ta3les4ase ta3les
Open interface?: *hen oracle provide concurrent pro!ram then itBs kno* as Open
interface
If oracle do not provide concurrent pro!ram D *hen *e create a concurrent pro!ram 3y
pro!rammer it self itBs kno* as Custom interface7
<%Cloder?:
9lat file?:7txt# 7dat# 7csv
Control file?:7ctl(codin!)
%oad data
Infile C1IR
Insert into ta3le aaa
9ield terminated 3y SBT
('o#'ame#A!e)
There are 4 control types in control file
1)Insert >),eplace .)Append 4)Truncate
1iscord file?:usin! conditional like *here or *hen
4ad file?:usin! any syntax error or declarations error
%o! file?:ummary Information
5xecuta3les?:there are 11 types of executa3le methods
1)2nix shell script(+ost)
>)C pro!rammin!
.)Fava concurrent pro!rams
4)Fava stored procedures
/)Oracle ,eports
8)plJs6l stored procedures
Q)s6lCplus
O)s6lCloder
N)multi lan!ua!e function
1H)Immediate
11)re6uest set
,eport re!istration steps
1)1evelop a ,eport as per client re6uirements usin! ,eport 8i
>)*e *ill transfer 7rdf into ,espective folder in server
AisinJOracleJprodapplJPPC2JreportsJ2Jfilename7rdf
.)loin to Oracle Appellations a)create 5xecuta3le 3)*here is the report c)*hat type of
executa3le method d)'ame of the 5xecuta3le
4)Create Concurrent pro!ram add executa3le and add any parameters D incompati3ility
/)attach this concurrent pro!rams to ,e6uest !roup
8)attach this ,e6uest !roup to ,esponsi3ility
Q)attach this ,esponsi3ility to particular 2ser
)hat is Concurrent "ro!ram?: A concurrent pro!ram is nothin! 3ut an instance of
execution file alon! *ith parameters
)hat are the mandatory parameters in Apps
5,,O, 429?:It return the error messa!e to the lo! file
,5TCO15?:return the states of the re6uest *arnin! or error H#1#>
14&=O2T"2T7"2T=%I'5(U9'1=9I%57lo!B# &essa!eB)
14&=O2T"2T7"2T=%I'5(U9'1=9I%57outputB# &essa!eB)
(alue ets?%ist of values and validationsis kno* as value sets
(alidation Types?:
1)'one?:not validate at all# allo* the user to enter any value
>)Independent?:its not depend any other value sets
.)1ependent?:4ased independent values# 1ependent value *ill set and it *ill depend on
Independent value set
4)Ta3le?:It *ill come from data3ase 3y select statements
/)Translated Independent?:
8) Translated Independent?:3oth are multi lan!ua!e
Q)pecial?:
O)"air?:3oth are used to display flex field data
"rofile?:A "rofile is set of chan!ea3le options that effect *ay our applications runs
1)2ser level?:Only for specific users
>),esponsi3ility level?:*ho are havin! responsi3ility
.)Applications level?:it *ill applica3le to particular Applications like "O#A"#O&#I'(
4)ite level?:it *ill *ork for all users
"rofile Options?:1)&O Operatin! 2nit >)et of 3ook id .)4usiness $roups 4)Application
to +T&% /)Application to "19 8)Application to 5xcel
9'1=",O9I%5 or 25, ",O9I%5 A"TBs
1)9nd=profile7!et(U2ser=idB#user=id)?:It *ill !et the current value of the specified user
profile options itBs procedure
>)9nd=profile7value(profile'um3er#x)?:It return the value of the specified user profile
option itBs function
.)9nd=profile7put(profile'ame#profile(alue)?:put the value to specified user profile
option itBs function
9nd=pro!ram7executa3le()
9nd=pro!ram7re!ister()
9nd=pro!ram7parameter()
9nd=pro!ram7re6uest=!roup()
9nd=pro!ram7delete=pro!ram()
9nd=pro!ram7su3mit=re6uest()
)hat is responsi3ility?:A ,esponsi3ility is authori-ation states one of the user can restrict
or collection of 1ata !roups# re6uests and menus
)hat is data !roup?:collection of Oracle users
)hat is ,e6uest !roup?:Collection of concurrent pro!rams and Oracle ,eports# it can
su3mit re6uest indusial
)hat is re6uest 5T?: Collection of concurrent pro!rams and Oracle ,eports# it can
su3mit re6uest imultaneously
)hat is &enu?:Collections of 9orms and 9unctions
)hat is token?:A token is !ate*ay in 3et*een Apps and ,eports# it pass the parameters
from Apps to ,eport
1efault parameters in A""?:
1)Constant?:The default value can 3e any literal value
>)"rofile?:The default value is the value # ItBs current value in the user profile option
.)<% tatement?:The default value is determined 3y the 6l statement
4)e!ments?:The default value is a value entered in a prior se!ment of the parameter
*indo*
'% Complaint?:It support multi lan!ua!e and tertiary
,un alone?:
,e6uest for system failure?:
2se in ,?:
1ifferent types of output formats?:+T&%# "C%# "19# "# T5PT
2ser=5xits in Oracle ,eports O, Apps tandards in ,eport
1)'eed to create 4ind varia3le "=CO'C=,5<25T=I1 ItBs used to !et re6uest I1
>)'eed to raise 2ser 5xit on 4efore ,eport Tri!!er
,)725,=5PIT(U9'1 ,)I'ITB) ItBs used to !et profile of the user
.) 'eed to raise 2ser 5xit on After ,eport Tri!!er
,)725,=5PIT(U9'1 ,5PITB) ItBs used to free-e the memory *hich *ill occupied
4) ,)725,=5PIT(U9'1 9%5P<%B)
/) ,)725,=5PIT(U9'1 I1(A%B)
8)9'1 9O,&AT5=C2,,5'CK?: print the currency in varies formats 3y usin! formula
column
V9%5PV?:ItBs special 3ind varia3le *e used in )here clause
1)Ta3le (alue set()here clause 4ox)
>)"arameter )indo*(1efault value set 4ox)
&2%TI O,$?:2nder one Implementation to maintain &ultiple Or!ani-ations and
&ultiple et of 3ooks# every multi or! ta3le end *ith =A%% and every multi or! ta3le
*ill have O,$=I1 column
4usiness $roup?:Al*ays on top level# 4usiness !roup=Id
et of 4ooks?: . cBs Currency# Calender# Chart of Account
%e!al 5ntity?:+ere *e are !oin! to tax to the $O(T
Operatin! 2nitOr!=Id)*e *ill doin! all operations like A"#A,#$%
Inventory Or!ani-ation?:(Or!ani-ation=Id)?: ItBs just like )are house
u3 Inventorytock %ocationItem
Or!=id can retrive the Or!ani-ation=id of particular Or!ani-ation# every user havin! one
profile option called &O?Operatin! unit
Or!ani-ation=id comes under Inventory Or!ani-ation 4ut Or!=Id comes under
&O?operatin! unit
)e can find out all Or!ani-ation in Or!=or!ani-ation=definitions
elect &ulti=or!=fla! from 9nd=product=!roups it returns UKB uccess U'B 'ot success
elect ,elease=name from 9nd=product=!roups *e can find (ersion
Clint:info is ,14& varia3le it contains the Or!=Id
+,& contains 4usiness!roup=Id
+o* to implement )+O Columns
+o* to update )ho Columns?:9nd=tandard7et=)ho()
+o* to print the messa!e in Apps?:9nd=&essa!e7sho*()
9lex9ield?:A 9lexfield is made up of se!ments each se!ment has a name
199?:*ith out chan!in! the pro!ram code to extend the form functionality # Add# &odify
199 *ill 3e stored in Attri3ute
;99?:;ey flex field is nothin! 3ut an Intelli!ent code *hich stores valid code
com3inations ;99 is a one of the 9uture in Accountin! "urpose ;99 stores in e!ments#
there is no ;99 for "O#A"#O&
'e* 9orm ,e!istration teps?:
1)1o*nload the T5&"%57fm3 from A2=TO" ,esource # template contain all menu and
li3raries and controls
>)*e *ill rename the form name in local machine
.)chan!e the code in follo*in! areas
a)",5=9O,& Tri!!er
3))+5'='5)9O,&=I'TA'C5
c)Apps=Custom "acka!e
4)Assi!n "roperty clauses to our Items
/)1evelop the ,eport as per Client ,e6uirement Transfer the 7fm3 in to server
8)$enerate 5xecuta3les 7fmx usin! the command A98H !en &oduleEfilename7fm3
2ser'ame and "ass*ord
AisinJOracleJprodapplJPPC2JformsJ2Jfilename7fm3
Q)%on! in to Oracle Apps and !o to Application ,esponsi3ility
a)Create 9orm 3)Create 9unction c)Attach 9orm to 9unction d)attach 9unction to &enu
e)attach &enu to ,esponsi3ility f)attach ,esponsi3ility to 2ser
PO 7LOW
PO is one of the &odule *e de3t *ith . persons 1)"reparer >)4uyer .),e6uester
4efore !oin! to raise ,e6uisition *e need to 5T2" 4uyer
,e6uisition?:one of the document raisin! here > types of re6uisitions 1)Internal and
>)"urchasin!
Interna+?:They o*nBt 3e invoice and upplier
P!r'hasin8?:there *ill 3e a supplier
If you have more lines in re6uisition *e !o for A2TO Create
R,7?:,e6uest for <uatation 1)4id >)Catelo! .)standard ?:for any item can 3e 3ase
,!atation?: )4id >)Catelo! .)standard ?:for any item can 3e 3ase
9or catalo!# standard level <uotations *e can also specify effective dates and for
individual "rice 3reaks for 4id level *e canBt specify effective dates at shipment level
PO?:out of all 6uotations one 6uotation *ill short listed that can 3e converted in to "O
Stan(ar( PO?:*e purchase Items only one not for the often
P+anne( PO?:This is lon! term a!reement committin! to 3uy items
.+an/et PO?:*e kno* the details of !ood 3ut *e donBt kno* the delivery details and
5very 4lancket "O there *ill 3e a ,eleases
Contra't A88rement?: upplier to a!ree on specific terms and conditions
Re'ei3t?:,eceipt is nothin! 3ut lip and total num3er of Items to 3e received from all
receipts
Re'ei:in8?:1eference 3et*een ordered items and supplied Items
After that !oods are !oin! to the Inventory and "ayments are !oin! to A" Interface
"ayments?:after receivin! !oods ho* your payin! the money
9ri!ht terms?:for transportation *ho *ill pay
Carrier?:!oods are comin! *hat transport usin!(shipin!)
9ree on 3oard?:if some thin! happened *hile transaction *ho *ill responsi3le
&atch approval?:+o* ur !oin! to retrive !oods
> *ay?: "O:Invoice
.*hy?: "O:,eceipt:Invoice
4*hy?: "O,eceiptInspectionInvoice
ACCO4T [Link]
4efore !oin! to A" you must kno* the upplier or "o num3er
Thum3 ,ules?:*ith out supplier they *onBt 3e any Invoice(4ill)# *ith out invoice they
*onBt 3e any "ayment
Invoices?:there are different types of Invoices most some of Important invoice types are
TA'1A,1?:standard invoice contain t*o thin!s 1)invoice and 1istri3ution
",5"AK&5'T?:*e are !oin! to pay advance to the supplier
C,51IT &5&O#154IT&5&O?: these invoices must 3e 'e!ative amount
Company !oin! to ask discount to the supplier and supplier is !oin! to !ive discount to
the company
)IT++O%1I'$ TAP?:this invoice is raised *hen *e *ant to deals *ith 2nre!istered
suppliers
"O 159A2%T?:*e have po num3er *e can match *ith invoice
<2IC; &ATC+5?:3ased on match approval these invoice are !enerated
"AK&5'T TK"5?:<2IC; # &A2A%# ,592'1
"ayment &ethods?:Check# 51I# Cash
In:entor$
1< Item Master Maintenan'e
W Creatin8 Items in Master Or8ani=ation
W Co3$ the Tem3+ates
W Assi8nin8 Cate8ories to Items
W Assi8nin8 Item to Chi+( Or8ani=ation
W Mo(i1$in8 Master Item Attri"!te
W Mo(i1$in8 Chi+( Item Attri"!te
2< 9its Maintenan'e
W Creatin8 .i++ o1 Materia+s 1or 9its
W Creatin8 Common .i++
3< S!33+$ .ase Maintenan'e
W A33ro:e( S!33+ier List Creation >ASL)
W So!r'in8 R!+es Creation
W Assi8nment Set Creation
4< PO Do'!ments Maintenan'e
W .+an/et A8reement Creation ? Maintenan'e
W Re#!isition Creation ? Maintenan'e
W Stan(ar( PO Creation ? Maintenan'e
W Creatin8 P!r'hase Or(ers 1rom Re#!isitions !sin8 A!to Create
W P!r'hasin8 Do'!ment Contro+s
/7 &aterial ,eceipt "rocess
W 1irect ,eceivin!
W "erformin! Inspections
W ,eturnin! &aterial to (endors
W &akin! Corrections in ,eceipt
W (ie*in! ,eceivin! Transactions
W 1rop hip ,eceipts
87 (ie*in! On +and Availa3ility
W On +and Availa3ility
W Item upply 1emand
W %ot $enealo!y
Q7 (ie*in! &aterial Transactions
W &aterial Transactions
W u3 inventory Transaction
W Inter or!ani-ation Transaction
W Account Alies Issues
W Account Alies ,eceipt
W &islenious Transaction
W &aterial Transactions
W &aterial 1istri3utions
O7 &in &ax "lannin!
W ,unnin! &in &ax "lan
W ,evie*in! &in &ax "lan Output
O&
Order5ntryOrder4ookin!"ick,elease"ickConformTriphip
ConformOrder line closedOrder closed
Registering Discoverer Report in Oracle Applications
The following are the setups required for registering the report in Oracle Applications:
Admin Edition SetUps
In the Discoverer Admin Edition a Business Area corresponding to the report is
created. The folders for the said report are pulled into the Business area either
from the Database or from the sql quer defined on a custom folder. The !olders
are based on the tables and views of the Oracle Applications data and items are
based on the columns in these tables and views.
The "rivileges in the Admin Edition are set to define what a user can do # access
in the user Edition#Admin Edition for a defined Business Area.
The last mandator step in Business Area creation is to administer securit. !rom
the Tools$%ecurit menu in the Administration edition invo&e the Discoverer
securit manager. !rom here ou can grant access to Business Areas to different
Applications responsibilities. A common approach is to create a new set of
Applications responsibilities 'i.e. discoverer(gl) discoverer(po* and grant
business area access to each of these responsibilities. +hen ou create these
new responsibilities) ensure that the Applications securit profile options for that
responsibilit is set. ,e-t) from within the Discoverer Administration edition)
chec& that these new responsibilities also have the privilege to use the
Discoverer .ser Edition. To chec& this) use the Tools$"rivileges menu and
ensure that the given responsibilities have the .ser Edition privilege chec&ed off.
Desktop Edition Setups
In the Discoverer Des&top Edition the user creates a wor&boo& from the Business
Area after defining the required folders and items within them. The conditions
and formatting options are set to create the report in the wor&boo&. One
wor&boo& ma consist of multiple wor&sheets each defining different aspects of a
particular report.
The wor&boo& is now saved to the Database.
The wor&boo& is shared to the users to whom it is to be made available.
A unique identifier is defined for this wor&boo& and this is the identifier for
configuring the report in Oracle Applications.
Oracle Applications SetUps
/o to the %stem Administrator#Application Developer responsibilit in Oracle
Applications. In case of Application Developer the menu to which the function
should be added should be &nown.
0reate a !unction for e-ecuting the report. %elect the tpe of function as %%+A
"1 %21 function.
The parameter for the function is selected as wor&boo&3 4,ame of Identifier in
Discoverer5.
In the +eb 6T71 tab enter the 6T71 0all as OracleOasis.8unDiscoverer
against the respective !unction name.
Add the !unction to a menu that has to %%+A responsibilit.
,ow use the apps url for home page and there under the %%+A 7enu the lin&
for the registered Discoverer report can be seen. On clic&ing the Discoverer
report lin& the browser opens a new window for Oracle 9iewer where the report
parameters can be entered in te-tbo-es. On the left side) the navigation bar
displas all the sheets in the wor&boo& of the said Discoverer report. On entering
the parameters and submitting it the specified report is displaed based on the
entered parameters.
Registering Discoverer Report in Oracle Applications
The following are the setups required for registering the report in Oracle Applications:
Admin Edition SetUps
In the Discoverer Admin Edition a Business Area corresponding to the report is
created. The folders for the said report are pulled into the Business area either
from the Database or from the sql quer defined on a custom folder. The !olders
are based on the tables and views of the Oracle Applications data and items are
based on the columns in these tables and views.
The "rivileges in the Admin Edition are set to define what a user can do # access
in the user Edition#Admin Edition for a defined Business Area.
The last mandator step in Business Area creation is to administer securit. !rom
the Tools$%ecurit menu in the Administration edition invo&e the Discoverer
securit manager. !rom here ou can grant access to Business Areas to different
Applications responsibilities. A common approach is to create a new set of
Applications responsibilities 'i.e. discoverer(gl) discoverer(po* and grant
business area access to each of these responsibilities. +hen ou create these
new responsibilities) ensure that the Applications securit profile options for that
responsibilit is set. ,e-t) from within the Discoverer Administration edition)
chec& that these new responsibilities also have the privilege to use the
Discoverer .ser Edition. To chec& this) use the Tools$"rivileges menu and
ensure that the given responsibilities have the .ser Edition privilege chec&ed off.
Desktop Edition Setups
In the Discoverer Des&top Edition the user creates a wor&boo& from the Business
Area after defining the required folders and items within them. The conditions
and formatting options are set to create the report in the wor&boo&. One
wor&boo& ma consist of multiple wor&sheets each defining different aspects of a
particular report.
The wor&boo& is now saved to the Database.
The wor&boo& is shared to the users to whom it is to be made available.
A unique identifier is defined for this wor&boo& and this is the identifier for
configuring the report in Oracle Applications.
Oracle Applications SetUps
/o to the %stem Administrator#Application Developer responsibilit in Oracle
Applications. In case of Application Developer the menu to which the function
should be added should be &nown.
0reate a !unction for e-ecuting the report. %elect the tpe of function as %%+A
"1 %21 function.
The parameter for the function is selected as wor&boo&3 4,ame of Identifier in
Discoverer5.
In the +eb 6T71 tab enter the 6T71 0all as OracleOasis.8unDiscoverer
against the respective !unction name.
Add the !unction to a menu that has to %%+A responsibilit.
,ow use the apps url for home page and there under the %%+A 7enu the lin&
for the registered Discoverer report can be seen. On clic&ing the Discoverer
report lin& the browser opens a new window for Oracle 9iewer where the report
parameters can be entered in te-tbo-es. On the left side) the navigation bar
displas all the sheets in the wor&boo& of the said Discoverer report. On entering
the parameters and submitting it the specified report is displaed based on the
entered parameters.
Oracle apps technical document
1. What is ERP? Architecture of apps?
A packaged business software system that lets a company automate and
integrate the majority of its business processes; share common data and
practices across the enterprise; [and] produce and access information in a real-
time environment.
2. Tell me some thing about !"#"OA$ER.
Sl ! loader is a bulk loader utility used for moving data from e"ternal files
into the oracle database.
Sl ! loader supports various load formats# selective loading# and multi-tables
loads.
1% &on'entional
The conventional path loader essentially loads the data 3y usin! standard UinsertB
statement7
2% $irect
The direct path loader (direct E true) 3y possesses of lo!ic involved *ith that# and
loads directly in to the oracle data files7
$%& -
'y [Link] file
())(# *scott tiger+#()))#,)
())-#+gvreddy+#-.,/#/)
0oad data
1nfile 2c&3data3mydata.csv4
1nto table emp
5ields terminated by *#+ optionally enclosed by 2+4
6empno# empname#sal#deptno7
8sqlldr scott/tiger@vis
control=[Link] log= [Link] bad=[Link] discard=[Link] .
(. )o* do u dump data from pl+s,l bloc- to flat files?
9sing utl:file package# we can dump data from pl;sl block to flat file.
PRE#RE!./RE0E1T for 9<0:510$ is specify the accessible directories for
the 9<0:510$ function in the initiali=ation file 61>1<.?@A7 9sing the
9<0:510$:A1@ parameters.
$"& 9<0:510$:A1@ B CAirectory name8
E23#
--remember to update 1>1<S1A.?@A#
--utl:file:dir B 2c&3oradata4
Aeclare
5p utl:[Link]:type;
Degin
5p &B utl:file.fopen6c&3oradata4#tab(.t"t4#4w47;
9tl:file.putf6fp#4Es Es 3n 2te"t field4# //7;
9tl:file.fclose6fp7;
$nd;
4. What is ET#O5#6OO7?
Follection of Fhat of Accounts and Furrency and Falendars is called S?D
8. What is the interface table?
1nterface <able is a table# which is used as medium for transfer of data
between two systems.
9. What is in'oice?
Send you a reuest for payment
:. What is /16O.1$ and O.T 6O.1$? ;$ifferent t<pes of interfaces%
1nbound 1nterface&
9or in3ound interfaces# *here these products are the destination# interface ta3les as
*ell as supportin! validation# processin!# and maintenance pro!rams are provided7
?utbound 1nterface&
9or out3ound interfaces# *here these products are the source# data3ase vie*s are
provided and the destination application should provide the validation# processin!#
and maintenance pro!rams
=. Tell me *hat r the 6ase tables in the AR?
)>?PART/E 6GA@<H:1A7
+X="A,TI5 stores information a3out parties such as or!ani-ations# people# and
!roups# includin! the identifyin! address information for the party7
)>?&.T?A&&O.1T 6F9S<:AFF?9><:1A7
+X=C2T=ACCO2'T stores information a3out customer relationships7 If a party
3ecomes a customer# information a3out the customer account is stored in this ta3le7
Kou can esta3lish multiple customer relationships *ith a sin!le party# so each party
can have multiple customer account records in this ta3le7
)>?&.T?A&&T?/TE?A"" 6F9S<:AFF<:S1<$:1A7
+X=C2T=ACCT=IT5=A%% stores information a3out customer sites7 One
customer account can have multiple sites7 The address is maintained in
+X=%OCATIO'7
)>?&.T?/TE?.E?A"" 6S1<$:9S$:1A7
+X=C2T=IT5=25=A%% stores information a3out site uses or 3usiness
purposes7 A sin!le customer site can have multiple site uses# such as 3ill to or ship to#
and each site use is stored as a record in this ta3le7
)>?PART@?/TE 6GA@<H:S1<$:1A7
+X="A,TK=IT5 stores information a3out the relationship 3et*een "arties and
%ocations7 The same party can have multiple party sites7 "hysical addresses are stored
in +X=%OCATIO'7
)>?"O&AT/O1 60?FA<1?>:1A7
+X=%OCATIO' stores information a3out physical locations7
)>?PERO1?PRO5/"E 6G$@S?>:G@?510$:1A7
+X="5,O'=",O9I%5 stores detail information a3out people7
)>?ORAA1/>AT/O1?PRO5/"E 6?@IA>1JA<1?>:G@?510$:1A7
+X=O,$A'IXATIO'=",O9I%5 stores credit ratin!# financial statistics#
socioeconomic and corporate linka!e information for 3usiness sites7 The primary key
for this ta3le is O,$A'IXATIO'=",O9I%5=I17
B. What r the tables interface tables in the customer interface tables?
1% Ra?customers?interface?all
<his table stores customer# address# and business purpose information.
Hou do not have to enter values in this table if you do not want to import customers#
addresses# or business purposes.
A$$RE1 through 4
$nter the address for your customer in these four columns. Hou can
enter up to four lines of an address.
Calidation3
1f you enter a value in ?@1I:SHS<$':AAA@$SS:@$5# you must enter a value in
AAA@$SS(. 5or multiple rows with the same address reference# insert values in
address (K,.
$estination3 LJ:0?FA<1?>[Link]@$SS(#
LJ:0?FA<1?>[Link]@$SS-#
LJ:0?FA<1?>[Link]@$SS.#
LJ:0?FA<1?>[Link]@$SS,
2% Ra?customer?profile?int?all
A customer level profile must e"ist in A:F9S<?'$@:G@?510$S:1><$@5AF$ for new
customers and each billKto business purpose.
(% Ra?contact?phones?int?all
<his table stores telephone numbers for customers# addresses and contacts as well
as contacts for customers and addresses.
4% Ra?customer?ban-s?int?all
<his table stores bank information for a customer or for a specific DillK<o address#
you must enter a bank account for this customer#
8% Ra?cust?pa<method?int?all
<o import payment methods for customers and billKto business purposes#
[Link] r the staging tables in the customer interface?
@a:customers:stg
@a:customers:address:stg
@a:customers:point:stg
@a:customers:contact points:stg
@a:customers:relate:stg
@a:customer:error.
[Link] me some mandator< columns in the customer interface tables?
a7 Ra?customers?interface?all
(7 ?rig:system:customer:ref
-7 insert:update:flag
.7 customer:number
,7 customer:status
/7last:updated:by

M7 last:updated:date
N7created:by
O7 creation:date.
b% Ra?customer?profile?int?all
(7 customer:profile:class:name
c% Ra?contact?phones?int?all
(7orig:system:telephone:ref
-7telephone
.7 telephone:type
d% Ra?customer?ban-s?int?all
(7 bank:a;c:name
-7bank:a;c:no
.7bank:a;c:currency:code
e% Ra?cust?pa<method?int?all
(7 payment:method:name
[Link] me the 1a'igation for customer interface?
@eceivables 1nterface Fustomers
1. What tables cannot be updated through customer interface?
>o updates will be allowed to be made through customer interface for
5ollowing tables
@A:S1<$:9S$S:A00
@A:F9S<?'$@:@$0A<1?>SL1GS:A00
@A:F9S<:@$F$1G<:'$<L?AS
AG:DA>P:D@A>FL$S
AG:DA>P:AFF?9><S:A00
AG:DA>P:AFF?9><:9S$S:A00
2. )o* to send additional customer and address information
through customer interafce
Lere is where attribute columns are used.
! Additional Fustomer data can be populated in
@A:F9S<?'$@S:1><$@5AF$:[Link]:attribute( to (/
<his will go into @A:F9S<?'$@[Link]( to (/
! Additional address information can be populated in
@A:F9S<?'$@S:1><$@5AF$:[Link]:attribute( to (/
<his will go into @A:AAA@$SS$S:[Link]( to (/
And so on.
8. What should be the batch siEe ;number of customer records% general
guidelines for optimal performance
About ()#))) records per bacth is ideal# it is suggested to keep the batch
si=e small.
9. Wh< does customer interface error out if there is mismatch in
address information?
Decause the code validates against these mismatches.
arplscin.s,l and arplbcin.s,l
1t validates the address being inserted or updated with respect to the ta"
location fle"field structure. 5or each row being inserted or updated in
@A:F9S<?'$@S:1><$@5AF$# and that has not already been marked in error#
the set:location:ccid function is called to return either an e"isting ccid
for the address entered or to create a new entry in A@:0?FA<1?>:QA09$S for
this new address. <he @A:F9S<?'$@S:1><$@5AF$ record is then updated with the
value of the ccid returned.
:. )o* do <ou send records at customer le'el profile and address+site
le'el profile?
5or every customer record in @A:F9S<?'$@S:1><$@5AF$:A00# insert two records
in table @A:F9S<?'$@:G@?510$S:1><:A00. 6@efer >ote& ()N)O)).M 7
B. $oes &ustomer /nterface import salesperson dataR
>o# @efer $nhancement Dug& (,N,S/
11. &ustomer /nterface process can be used for updating the customer
information )o* does the .P$ATE *or-?
Furrent functionality of Fustomer 1nterface is to update all the data. Hou cannot run
Fustomer 1nterface to update only changed data. 6@efer Dug& ONS(-( for the
intended functinality7
12. What are some of the important fields that &ustomer /nterface does not
load?
>ot all fields in @A:F9S<?'$@S are being loaded by the interface.
S1F:F?A$
ISA:1>A1FA<?@
5?D:G?1><
SA0$S:FLA>>$0:F?A$
5@$1IL<:<$@'
TA@$L?9S$:1A
G@1F$ 01S<
SL1G:GA@<1A0
GAH'$><:<$@':1A in @A:S1<$:9S$[Link]'$><:<$@':1A
6@efer $nhancement @euest Dug& -,/.))7
1(. 1e* T&A+&ustomer 0odelF ho* to load customer as PERO1 or
ORAA1/>AT/O1 through &ustomer /nterface?
a7 Gopulate ra:customers:interface:all . person:flag B UHU
@un Fustomer 1nterface process will load this record as G$@S?>
b7 Gopulate ra:customers:interface:all . person:flag B U>U 6 or >900 7
@un Fustomer 1nterface process will load this record as ?@IA>1JA<1?>
8% Tell me *hat is the procedure to de'elop an interface?
a. 5irst we will get the @euirement document.
b. Te will create control file based on that plot file.
c. <hen the control files which loads the data into staging tables.
d. <hrough pl;sl programs we will mapping and validate the data and then
dump into the interface tables.
e. <hrough the standard programs we will push the data from interface
tables to Dase tables.
9% What 'alidations u did in the customer interface?
a. customer name & the same customer reference can4t have different
customer names with in this table
LJ:GA@<1$[Link]@<H:>A'$
b. customer number & must be null if your r using automatic customer
numbering# must e"it if you are not using automatic customer
numbering. <his value much be uniue with in LJ:GA@<1$S
c. customer status & must be 2A4 for active or 214 for inactive
LJ:GA@<1$S:S<A<9S
d. ban- account num or ban- account currenc< code &
if the bank a;c already e"ist do not enter a value
if the bank a;c does not e"ist you must enter a value
e. ban- a+c name & it must e"ist in AG:DA>P:AFF?9><S or if it does not
e"ist values must e"ist for DA>P:A;F:F9@@$>FH:F?A$
DA>P:A;F:>9'
DA>P:>A'$
DA>P:D@A>FL:>A'$
>ote & every interface table has two error msg
(7 $rror code.
-7 $rror msg.
:% )o* can u call a standard interface program from s,l or pl+s,l code?
5>A:@$V9$S<.S9D'1<:@$V9$S< 62G?4#4$%$F9<AD0$ >A'$4####GA@A'$<$@S7
=% AP/s 5OR &.TO0ER /1TER5A&E?
LJ:F9S<:A;F:QJG9D.9GAA<$:F9S<:A;F
LJ:F9S<:A;F:QJG9D.F@$A<$:F9S<:A;F
5>A:G@?510$S
5>A:AGG01FA<1?>S
5>A:I0?DA0
5>A-510$
5>A:F?>FS9D6can submit conc program in host invironment7
B% Tell me some AP/?
5>A:510$.G9<01>$65>A:510$.0?I7
5>A:510$.G9<01>$65>A:510$.?9<G9<7
/s the Program eGitsF delete conc program and its eGecutables.
15 5>A:G@?I@A'.G@?I@A':$%1<S62$'G4#AGG01FA<1?>:>A'$:1>7 <L$>
5>A:G@?I@A'.A$0$<$:G@?I@A'62$'G4#AGG01FA<1?>:>A'$:1>7
5>A:G@?I@A'.A$0$<$:$%$F9<AD0$62$'G4#AGG01FA<1?>:>A'$:1>7
$>A;
1D% What are profile options?
1s the 5unctional and <echnical behavior of ?racle Applications Gackage.
$%& - 1 want to assign the user. responsibility to p, printer then
<stem Administrator Profile <stem
(FND_PROFILE_OPION!"
11% Oracle E#6usiness suite?
Oracle a##s $ anal%tical co&#onents so't(are.
6?racle discover7
6?racle sales analy=er7
6?racle financial analy=er7
6?racle marketing analy=er7
24% What is multi org?
H"egal entit< has more than one operating unit is called as multi orgI
a7 Dusiness group --- Luman resources information is secured by
Dusiness group
b7 0egal entity. --- inter-company and fiscal;ta" reporting.
ecurit< responsibilit< operating unit.
c7 ?perating unit --- secures A@# ?$# AG# GA and G? 1nformation.
d7 ?rgani=ations --- is a speciali=e unit of work at particular locations
28% What are the .ser PARA0ETER in the Reports?
P?&O1&?RE!.ET?/$
P?5"E2?CA".E
29% 51$ .ER E2/T3#
5>A S@T1>1< sets your profile option values# multiple organi=ations and allows
?racle Application ?bject 0ibrary user e"its to detect that they have been called by
an ?racle @eports program.
5>A S@T$%1< ensures that all the memory allocated for A?0 user e"its have
been freed up properly.
5>A 50$%1AQA0 are used to display fle" field information like prompt# value etc
5>A 50$%SV0 these user e"its allow you to use fle" fields in your reports
5>A 5?@'A<:F9@@$>FH is used to print currency in various formats by using
formula column
29% P"+!" stored procedure parameters?
or *hat are the t*o parameters that are mandator< for pl+s,l t<pe
concurrent program?
Grocedure;function 6$@@D95 ?9<
@$<F?A$ ?9<
WWWWWWW.7
$@@D95 &- 9sed to write the error message to log or reuest file.
@$<F?A$ &- Gopulate log reuest file with program submission details info.
2:% What is Calue et?
--<he value set is a collection 6or7 container of values.
--Then ever the value set associated with any report parameters. 1t provides
list of values to the end user to accept one of the values as report parameter value.
-- 1f the list of values needed to be dynamic and ever changing and define a
table based values set.
2:% What r the 'alidation t<pes?
(7 >one -------- validation is minimal.
-7 1ndependent ------input must e"ist on previously defined list of values
.7 Aependent ------input is checked against a subset of values based on a
prior value.
.7 <able ----- input is checked against values in an application table
,7 Special ------values set uses a fle" field itself.
/7 Gair ------ two fle" fields together specify a range of valid values.
M7 <ranslatable independent ----- input must e"ist on previously defined list
of values; translated values can be used.
N7 <ranslatable dependent ------- input is checked against a subset of values
based on a prior values; translated value can be
used.
2=% 5orm de'elopment process?
a7 open template form
b7 Save as Cyour [Link]
c7 Fhange the form module name as form name.
d7 Aelete the default blocks# window# and canvas
e7 Freate a window.
f7 Assign the window property class to window
g7 Freate a canvas 6subclass info7
h7 Assign canvas property class to the canvas
17 assign the window to the canvas and canvas to the window
j7 Freate a data block
k7 'odify the form level properties. 6sub class item <e"t item7
l7 'odify the app:cusom package. 1n the program unit.
m7 'odify the pre-form trigger 6form level7
n7 'odify the module level properties 66console window# 5irst navigation
p7 Save and compile the form.
Glace the .fm" in the server directory.
V7 @egister in the A?0
APP"/&AT/O1 5OR0
APP"/&AT/O1 5.1&T/O1
APP"/&AT/O1 0E1.
2B% )o* do u customiEe the Reports?
a. 1dentify the Short name of the standard report in which module we
have to customi=e
E)* + i' , (ant to c,sto&i-e in t.e /R &od,le #at. is
/##l to#0ar011.2.30re#orts04!0 .rd'
b. ?pen the .rdf file in @eport builder and change the name of the
module.
c. ?pen the data module and modify the uery 6what is client
reuirements7 assign the columns to the attrib,tes.
d. Io to report wi=ard and select# what r the newly created columns.
e. <hen Fompile it. <hen u will get a .rep file in the specified module. 1f
it is not in the specified directory then we have to put in the server
directory.
f7 <hen @egister in the A?0 &oncurrent eGecutable.
&oncurrent program.
!7 go to system administrator ecurit<Responsibilit<re,uest
h7 Add and assign a concurrent program to a reuest group
(D% Registering parametric report?
Any applications will have two parameters#
(7 from-period -7 to-period
a7 Io to object navigator and create the parameters.
.ser parameters from?noF to?no ;data t<pe char and *idth (D%
b7 ?pen the report layout and write the uery6we have to reg the table in A?07
!elect e&#no5ena&e5'ro& g_e&# (.ere e&#no bet(een *'ro&_no and to_no
c7 Fompile and put the .@AG file in the server directory.
d7 @egistering in A?0.
&oncurrent eGecutable
&oncurrent program then go to *PARA0ETERI
e% Io to Application 'alidation set. then go to HE$/T /1TOI
After entering the 6/L4E !E! 6(7 And O7EN! 6-7
f% Io to Administrations
e,urit< responsibilit< Re,uest
h7 Add and assign a concurrent program to a reuest group
(1% Tell me some report names and their table names in A"F APF ARF and
PO?
(7 ra?customer?trG?all
c,sto&er_tr)_id
tr)_n,&ber (invoice no5 debit &e&o no5 credit &e&o no"
c,st_tr)_t%#e_id
-7 ra?customer?lines?all ;details of in'oice%
c,to&er_tr)_id
(% ar?pa<ment?schdules?all
c.ec8_id
<his table stores all transactions e"cept adjustments and
miscellaneous cash receipts. ?racle @eceivables updates this table when activity
occurs against an invoice# debit memo# chargeback# credit memo# on account credit#
or receipt.
4% ra?cust?trG?t<pes?all ;in'oice t<pes%
c,st_tr)_t%#e_id
8% ra?batches?all
Datch:id
<his table stores information about each receipt batch that you
create in
?racle @eceivables. $ach row includes information about a specific batch such as
batch source# status# batch type# control count# and control amount
9% ra?recei'able?application?all
:% ra?adJustments?all
<his table stores information about your invoice adjustments. $ach row
includes general information about the adjustment you are making such as activity
name# amount# accounting information# reason# and type of adjustment. Hou need
one row for each adjustment you are making to an invoice.

O7 ra?cash?receiots?all
Fash:receipt:id
<his table stores one record for each receipt that you enter. ?racle
@eceivables creates records concurrently in the A@:FASL:@$F$1G<:L1S<?@H:A00#
A@:GAH'$><:SFL$A90$S:A00# and A@:@$F$1QAD0$:AGG01FA<1?>S tables for
invoiceKrelated receipts.

(7 ap:invoice:all
invoice:amount# base:amount# payment:status:flag62y4 Kfully paid
2n4X
unpaid
2p4 K
partially paid7
-7 ap:invoice:payments:all
invoice:id#
.7 ap:invoice:distibutions:All
amount# base:amount# dist:code:combination:id#
line:type:lookup:code
,7 ap:payment:schdules
payment:status:flag6* 24444+7
/7 ap:payment:dustributions:all
M7 ap:checks:all
check:id#
AG:FL$FPS:A00 stores information about payments issued to suppliers
or refunds received from suppliers. Hou need one row for each payment you issue to
a supplier or refund received from a supplier. Hour ?racle Gayables application uses
this information to record payments you make to suppliers or refunds you receive
from suppliers.
N7 ap:accounting:events:all
O7 ap:bank:accounts:all
AG:DA>P:AFF?9><S:A00 contains information about your bank
accounts. Hou need one row for each bank account you define. $ach bank account
must be affiliated with one bank branch. Then you initiate an automatic payment
batch# enter a manual check# or create a Vuick payment# you can select a bank
account that you define in this table.
S7 ap:bank:accounts:uses:all
AG:DA>P:AFF?9><:9S$S:A00 stores information for the internal and
e"ternal bank accounts you define in ?racle Gayables and ?racle
@eceivables applications.

(7 po:vendors:all
-7 po:vendors:sites:all
.7 po:headers:all
po:header:id
,7 po:lines:all
po:line:id
/7 po:line:locations:All
M7 po:distributions:all
po:distribution:id#

1% Al?code?combinations
I0:F?A$:F?'D1>A<1?>S stores valid account combinations for each
Accounting 5le"field structure within your ?racle Ieneral 0edger application.
Associated with each account are certain codes and flags# including whether the
account is enabled# whether detail posting or detail budgeting is allowed# and others.
2% Al?Je?batches.
I0:Y$:DA<FL$S stores journal entry batches.
(% Al?Je?headers
I0:Y$:L$AA$@S stores journal entries. <here is a oneKtoKmany relationship
between journal entry batches and journal entries. $ach row in this table includes the
associated batch 1A# the journal entry name and description# and other information
about the journal entry. <his table corresponds to the Yournals window of the $nter
Yournals form. S<A<9S is 494 for unposted# 4G4 for posted. ?ther statuses indicate that
an error condition was found. A complete list is below.
4% Al?Je?lines.
I0:Y$:01>$S stores the journal entry lines that you enter in the $nter
Yournals form. <here is a oneKtoKmany relationship between journal entries and
journal entry lines. $ach row in this table stores the associated journal entry header
1A# the line number# the associated code combination 1A# and the debits or credits
associated with the journal line. S<A<9S is 494 for unposted or 4G4 for posted
8% Al?set of boo-s
I0:S$<S:?5:D??PS stores information about the sets of books you define in
your ?racle Ieneral 0edger application. $ach row includes the set of books name#
description# functional currency# and other information. <his table corresponds to the
Set of Dooks form.
9% Al?periods
I0:G$@1?AS stores information about the accounting periods you define
using the Accounting Falendar form. $ach row includes the start date and end date
of the period# the period type# the fiscal year# the period number# and other
information. <here is a oneKtoKmany relationship between a row in the
I0:G$@1?A:S$<S table and rows in this table.
1% OPE1#$E6/T 0E0O REPORT?
<his report shows all the open-debit memo transactions# based on customer
number and dates.
Folumns &- type# customer:no# tr":no# amt:due# remaining.
Garameter &- type# customer# from:date# to:date.
2% AE1ERAT/1A PO/T/CE PA@ 5/"E 5OR 6A17 REPORT?
Dasically this report generates a flat file of all the payments in order to send
in to the bank.
(% .P$ATE PO/T/CEPA@ &)E&7 REPORT?
<his report which updates the data into the 6AG7 account payables system
from the plot file# the file which is sent by bank
4% .P$ATE PO/T/CEPA@ O.T TA1$/1A &)E&7?
<his report which shows the out standing checks
8% &.TO0ER PA@0E1T $ETA/" REPORT?
Thich shows each customer original amount# amount pay and due amount
based on transaction type 6books# pens7
Transaction t<pes in AR
Fredit memo transaction types
1nvoice# debit memo# and charge back transaction types
Fommitment transaction types
!% )OW $O @O. RE&T/5@ T)E ERROR /1 /1TER5A&E TA6"E?
Aepending on the naming convention used# errors appear in either alphabetical order
or by error code number.
(1% )o* do u identit< its name of report?
<stem administrator concurrent program define
<stem administrator concurrent program eGecutable
(2% Who informations?
(7 Freated by
-7 Freation date
.7 0ast :updated by
,7 last:update:date
/7 last:update:value
((% 5"E2 5/E"$?
.sed to capture the additional business information.
$55 755
Additional 9niue 1nfo# 'andatory
Faptured in attribute prefi"ed columns Segment prefi"ed
>ot reported on standard reports 1s reported on standard reports
<o provide e"pansion space on your form
Tith the help of []. [] @epresents
descriptive 5le" field.
50$% 510$A & A$SF@1G<1Q$ & @$I1IS<$@
9sed for entering and displaying key
information
5or e"ample ?racle Ieneral uses a key 5le"
field called Accounting 5le" field to
uniuely identifies a general account.
50$% 510$A & P$H & @$I1IS<$@
Oracle Applications 7E@ 5"E2 5/E"$
(7 I0 &- AFF?9><1>I
-7 A@ &- SA0$S <A% 0?FA<1?># <$@@1<?@H#
.7 AG &- DA>P A$<A10S# F?S< A00?FA<1?># G$?G0$ I@?9G
Oracle Applications $E&R/PT/CE 5"E2 5/E"$ ;Partial%
(7 I0 &- daily rates
-7 A@ &- credit history# information
.7 GA &- bank branch# payment terms# site address#

(4% What are the re,uests groups?
a7 Single reuest& - this allows you to submit an individual reuest.
b7 @euest set & - this allows you to submit a pre-defined set of reuests.
(8% <s Admin 0odule?
a% Aefine Fustom 9sers# b% Aefine 0ogin 9sers# c% @egister oracle AD users#
d7 Aefine Foncurrent Grograms# e% @egister Foncurrent $"ecutables# f% Setting
Grofile ?ption Qalues# g% Aefine @euest <ypes.
(9% AO"?
a% @egistering tables. b% @egistering views c% @egistering db seuences
d7 @egistering profile options e% @egistering lookups and lookup codes
f% @egistering forms g7 @egistering 5orm and >on-5orm functions i% registering
'enus and sub-menus. J% @egistering A55 and P55. -% 0ibraries
(:% What r the t<pe 0odels in the system parameters of the report?
(7 Dit map -7 Fharacter mode
(=% .What is RW Pac-age? 6!ql Re#ort 9riter"
<he @eport builder Duilt in package know as S@T Gackage <his package e"tends
reports #Fontrol report e"ecution# output message at runtime# 1nitiali=e layout fields#
Gerform AA0 statements used to create or Arop temporary table# Fall 9ser $"ist#
to format width of the columns# to page break the column# to set the colors
$"& S@T.A?:SV0# 1t4s like AA0 command# we can create table# views # etc.#
S@T.S$<:51$0A:>9'
S@T. S$<:510$A:FLA@
S@T. S$< 510$A :AA<$
(:% $ifference bet*een 6ind and "eGical parameters?
6/1$ CAR/A6"E 3
-- are used to replace a single value in sl# pl;sl
-- bind variable may be used to replace e"pressions in select# where# group# order
by# having# connect by# start with cause of ueries.
-- bind reference may not be referenced in 5@?' clause 6or7 in place of
reserved words or clauses.
"E2/&A" RE5ERE1&E3
-- you can use le"ical reference to replace the clauses appearing A5<$@ select#
from# group by# having# connect by# start with.
-- you can4t make le"ical reference in a pl;sl statmetns.
(=% 0atriG Report3 Simple# Iroup above# >ested
imple 0atriG Report & , groups
(.Fross Groduct Iroup
-. @ow and Folumn Iroup
.. Fell Iroup
,. Fell column is the source of a cross product summary that
becomes the cell content.
5rames& (.@epeating frame for rows6down direction7
-.@epeating frame for columns6Across 7
..'atri" object the intersection of the two repeating frames
(B% *hat is 5leG mode and &onfine mode?
&onfine mode
?n& child objects cannot be moved outside their enclosing parent objects.
?ff& child objects can be moved outside their enclosing parent objects.
5leG mode3
?n& parent borders ZstretchZ when child objects are moved against them.
?ff& parent borders remain fi"ed when child objects are moved against
them.
4D% What is Place holder &olumns?
A placeholder is a column is an empty container at design time. <he placeholder
can hold a value at run time has been calculated and placed in to 1t by pl;sl code
from anther object.
Hou can set the value of a placeholder column is in a Defore @eport trigger.
Store a <emporary value for future reference. $%. Store the current ma" salary as
records are retrieved.
2(% What is 5ormula &olumn?
A formula column performs a user-defined computation on another column6s7 data#
including placeholder columns.
24% What is ummar< columns?
A summary column performs a computation on another columnUs data. 9sing the
@eport Ti=ard or Aata Ti=ard# you can create the following summaries& sum#
average# count# minimum# ma"imum# E total. Hou can also create a summary
column manually in the Aata 'odel view# and use the Groperty Galette to create the
following additional summaries& first# last# standard deviation# variance.
8D% What is cursor?
A Fursor is a pointer# which works on active set# 1.e. which points to only one
row at a time in the conte"t area4s AF<1Q$ S$<. A cursor is a construct of pl;sl#
used to process multiple rows using a pl;sl block.
2=% T<pes of cursors?
(7 /mplicit& declared for all A'0 and pl;sl statements.
Dy default it selects one row only.
-7 EGplicit& Aeclared and named by the programmer.
9se e"plicit cursor to individually process each row returned by a
'ultiple statements# is called AF<1Q$ S$<.
Allows the programmer to manually control e"plicit cursor in the
Gl;sl block
a7declare& create a named sl area
b7Open& identify the active set.
c7 5etch3 load the current row in to variables.
d7&lose& release the active set.

F9@S?@ A<<@1D9<$S
a7 Kis open& evaluates to true if the cursor is open.
b7 Knot found& evaluates to true if the most recent fetch does not return a
row
c7 Kfound& evaluates to true if the most recent fetch returns a row.
d7 Kro* count& evaluates to the total number of rows returned to far.
EGample for cursor3
(7 Aeclare
Qno [Link];
Qname [Link] Etype;
Fursor emp:cursor is
Select empno#ename
5rom emp;
Degin
?pen cursor;
5or 1 in (..() loop
5etch emp:cursor into vno#vname;
Abms:output.putline6to:char6vno7 [[4 2[[vname7;
$nd if;
$ nd;

-7 Degin
?pen emp:cursor;
0oop
5etch when emp:cursor E rowcount 8() or
$mp:curor E not found;
Ddms:output:put:line6to:char6vno7[[4 2[[ vname7;
$nd loop;
Flose emp:cursor;
$nd;
&.ROR 5OR "OOP
A7 cursor for loop is a short cut to process e"plicit cursors
D7 it has higher performance
F7 cursor for loop reuires only the declaration of the cursor# remaining things
like opening# fetching and close are automatically take by the cursor for loop

EGample3
(7 Aeclare
Fursor emp:cursor is
Select empno#ename
5rom emp;
Degin
5or emp:record in emp:cursor loop
Abms:output.putline6emp:record.empno7;
Abms:output.putline6emp:record.ename7
$nd loop
$nd;

&an *e create a cursor *ithout declaring it?
Hes K by using cursor for loop using subueries.
D$I1>
5?@ emp:record 1> 6 S$0$F< empno# ename
5@?' emp7 0??G
-- implicit open and implicit fetch occur
15 emp:[Link] B NO.S <L$>
...
$>A 0??G; -- implicit close occurs
$>A;
a% for update clause3
(7 use e"plicit locking to deny access for the duration of a transaction
-7 lock the rows before update or delete
$" & select WW.
5romWW.
5or update[ of column ref] [no:wait]

b% *here current of clause?
(7 use cursor to update or delete the current row
There current of C column ref8
2B% Attribute data t<pes?
(7 Etype -7 Erow type.
(D% EGception )andilings?
1s a mechanism provided by pl;sl to detect runtime errors and process them
with out halting the program abnormally
(7 pre-defined
-7 user-defined.
PRE#$E5/1E$3
(7 cursor:already:open--------attempted to open an already open cursor.
-7 Aup:val:on:inde" --------attempted to insert a duplicate values.
.7 1nvalid:cursor -------- illegal cursor operation occurred.
,7 1nvalid:number -------- conversion of character string to number fails.
/7 0ogin:denied ---------loging on to oracle with an invalid user name
and password.
M7 program:error -------- pl;sl has an internal problem.
N7 storage:error -------- pl;sl ran out of memory or memory is
corrupted.
O7 to:many:row ---------single row select returned more than one row.
S7 value:error -------- arithmetic#conversion#truncation or si=e
constraint error occurred.
()7 =ero:devided -------- attempted to divided by =ero.
.ER#$E5/1E$3
Aeclare & name the e"ception
@aise & e"plicitly raise the e"ception by using the raise statements
@eference& e"ception handing section.
The Raise?Application?Error?Procedure3
Hou can use this procedure to issue user-defined error messages from stored
sub programs.
Hou can report errors to your applications and avoid returning unhandled
e"ceptions.
Raise_Application_Error(error_number,message[,{true/false}]
$rror number between --)))) to --)SSS
pragma eGception?init?
1t tells the compiler to associate an e"ception with an oracle error. <o get an
error message of a specific oracle error.
$"& pragma e"ception:init6e"ception name# oracle error number7
EGample for EGceptions?
1% &hec- the record is eGist or not?
Aeclare
$ empE rowtype
Degin
[Link] &B \empno;
select ! into e from emp where empno [Link];
Abms:output.putline62empno4 [[ e.empno7;
$"ception
Then no:data:found then
Abms:[Link] [[4doest e"ist47;
$nd;
2% .ser defined eGceptions?
Aefine p:dept:desc B4gvreddy4
Aefine p:dept:number B(-.M
Aeclare
$:invalid:dept e"ception;
Degin
9pdate departments
Set dept:nameB4\p:dept:desc4
There dept:id B4\p:dept:number4;
1f slE not found then
@aise e:invalid:departments;
$nd if;
Fommit;
$"ception
Then e:invalid:departments then
Abms:output.putline62no such dept47;
$nd;

82% *hat is RE5 &ursor?
<o e"ecute a multi-row uery# oracle opens an unnamed work area that stores
processing information# to access the information# an e"plicit# which names the work
area or# a cursor variable# which points to the work area.
where as a cursor always refers to the same uery work area# a cursor variable can
refer to a different work areas# cursor variable area like 2c4 or 2pascal4 pointers# which
hold the memory location6address7 of some object instead of the object itself.
So# declaring a cursor variable creates a pointers# not an object.
(2% &an u define eGceptions t*ice in same bloc-?
>o
((% &an <ou ha'e t*o functions *ith the same name in a pl+s,l bloc-?
Hes
(4% &an <ou ha'e t*o stored functions *ith in the same name?
Hes
(8% &an function be o'erload?
Hes
(9% What is the maGimum number of statements that can be specified in a
trigger statement?
?ne.
(2% tored procedure?
Stored procedure is a seuence of statements that perform specific function.
8(% What is procedure?
---- is a named pl;sl block to perform a specific task.
---- A procedure may have A'0 statements.
---- 1t may or may not return a value.
---- Grocedure can return more than one value.
EGample for procedure
(7 <o accept the year as a parameter and list emp belong to the yearR
Freate or replace
Grocedure empy6y number7 is
Fursor emp:cursor is
Select ! from emp where
to:char6hiredate#4yyyy47B4y4;
$mp:record empErowtype;
Degin
5or emp:record in emp:cursor loop
Grint 6emp:record.empno7;
Grint 6emp:record.ename7;
Grint 6emp:record.sal7;
$nd loop;
$nd;
Output 3
var emp" number;
Degin
&emp" &B 2(-.,4;
$nd;
$"ec empy6&emp"7;
Grint empy;
84% What is function?
---- is a named pl;sl block to perform a specific task# is mainly used for
calculation purpose.
---- A function is called as part of an e"ception.
---- $very function should return a value
EGample for function
Freate or replace
5unction get:sal6p:id in [Link]:noE type7
@eturn number
1s
v:sal [Link] &B);
Degin
Select salary into v:salary
5rom emp
There emp:no B p:id;
@eturn v:salary
$nd get:sal;
$nd;
Output 3
var g:sal number;
$"ec &g:sal &B get:sal6SS7;
Grint g:salary;
B.&an functions be o'erloaded ?
@es.
1D.&an 2 functions ha'e same name L input parameters but differ onl< b<
return datat<pe
1o.
88% What is the pac-age?
---- Iroup logically related pl;sl types# items and subprograms.
(7 package specification
-7 package body
Ad'antages of a pac-age3
'odularity
$asier Application Aesign
1nformation Liding
?verloading
@ou cannot o'erload3
]<wo subprograms if their formal parameters differ only in name or
parameter mode. 6datatype and their total number is same7.
]<wo subprograms if their formal parameters differ only in datatype
and the different datatypes are in the same family 6number and
decimal belong to the same family7
]<wo subprograms if their formal parameters differ only in subtype
and the different subtypes are based on types in the same family
6QA@FLA@ and S<@1>I are subtypes of QA@FLA@-7
]<wo functions that differ only in return type# even if the types are in different
families.
89% What is 5ORWAR$ $E&"ARAT/O1 in Pac-ages?
G0;SV0 allows for a special subprogram declaration called a forward
declaration. 1t consists of the subprogram specification in the package body
terminated by a semicolon. Hou can use forward declarations to do the
following&
] Aefine subprograms in logical or alphabetical order.
] Aefine mutually recursive subprograms.6both calling each other7.
] Iroup subprograms in a package
EGample of for*ard $eclaration3
F@$A<$ ?@ @$G0AF$ GAFPAI$ D?AH forward:pack
1S
G@?F$A9@$ calc:rating6. . .7; -- forward declaration
G@?F$A9@$ award:bonus6. . .7
1S -- subprograms defined
D$I1> -- in alphabetical order
calc:rating6. . .7;
. . .
$>A;

G@?F$A9@$ calc:rating6. . .7
1S
D$I1>
. . .
$>A;

$>A forward:pack;
89% What are triggers?
---- triggers are similar to procedures# in that they are the named pl;sl blocks with
declarative# e"ecutable and e"ception-handling sections# how ever a procedure is
e"ecuted e"plicitly from another block via a procedure call# which can also pass
arguments.
---- A trigger is e"ecuted implicitly when ever a particular event task places. And is
nothing but a event.
---- <he triggering event is a A'0 6insert# update# delete7 operations on a data base
table
##### fires *hene'er a data e'ent;such as $0"% or s<stem e'ent;such as
login or shutdo*n% occurs on a schema or database
Trigger timing 3 (7 before
-7 after
.7 instead of 6 this is used for views7
Triggering e'ents & (7 insert
-7update
.7 delete
Trigger t<pe 3 (7 statement level
-7 row level.
5iring se,uence of database triggers
(7 before statement trigger
-7 before row trigger
.7 after row trigger
,7 after statement trigger
EG3
1% &reate or replace trigger secure?emp
Defore
1nsert on emp
Degin
1f 6to:char6sysdate#4dy47 in62sat4#4sun477 or
<o:char6sysdate#4hh-,&mi47
>ot between 4)O&))4 and 4(O&))47
<hen raise:application:error6--)/))#4u can insert in the office timings47
$nd if;
$nd;
EG 3# 2% *rite a program to all transitions *ith name smith?
Freate or replace
<rigger trigger:name
Defore insert or update or delete
?n emp
5or each row
Then [Link] B4smith4 or
>[Link] B4smith47
Degin
@aise:application:error6--))).#4smith47;
$nd;
8:% $ifference bet*een triggers and procedures?
Aefined with create trigger Aefined with create procedure
<he data dictionary contains source
code in the user:triggers.
Aata dictionary contains source code in
user:source
1mplicitly invoked $"plicitly invoked
Fommit# save point and rollback are not
allowed6<F07
<hose are allowed
8=% "O&7?
-- 1s to reduce concurrency
(7 share loc-
---it allows the other users for only reading not to insert or update or
delete.
-7 eGclusi'e loc-
--- only one user can have the privileges of insert or update and delete of
particular object
--- others can only read.
.7 update loc-
----multiple user can read# update delete
"oc- le'els 3
(7 table level -7 table space .7 data base level.

8=% What is template?
a7 <he <$'G0A<$ form is the reuired starting point for all development of new
5orms.
b7 <he <$'G0A<$ form includes platformKindependent attachments of several
0ibraries.
APP&ORE 3# 1t contains package and procedures that are reuired of all forms
to support the '$>9S #<??0DA@S.
APP$A@P7 3# 1t contains packages that control the oracle applications
FA0$>A$@ 5$A<9@$S.
51$!5 3# it contains packages and procedures for '$SSAI$ A1F<?>A@H#
50$% 51$0AS# G@?510$S A>A F?>F9@@$>< G@?F$SS1>I.
&.TO0 3# it allows e"tension of oracle applications forms with out modification
of oracle application code# you can use the custom library for customi=ation such as
Eoom 6 such as moving to another form and uerying up specific records7
8B% What are ad#hoc reports?
Ans.& Ad-hoc @eport is made to meet one-time reporting needs. Foncerned with or
formed for a
particular purpose. 5or e"ample# ad hoc ta" codes or an ad hoc database
uery
9D% What is responsibilit<?
1s collection of menus# reuest security groups and data groups
0enus& collection of forms is nothing but menus
Re,uest securit< groups& collection of programs.
$ata groups& is a group of modules to be made accessible by the user through
@esponsibility
<stem adminsecurit<define
ecurit<userdefine
91% What are different eGecution methods of eGecutabls?

5le"@pt <he e"ecution file is wrnitten using the 5le"@eport
AG1.
5le"Sl <he e"ecution file is written using the 5le"Sl
AG1.
Lost <he e"ecution file is a host script.
?racle @eports <he e"ecution file is an ?racle @eports file.
G0;SV0 Stored Grocedure <he e"ecution file is a stored procedure.
SV0!0oader <he e"ecution file is a SV0 script.
SV0!Glus <he e"ecution file is a SV0!Glus script.
SV0!@eport <he e"ecution file is a SV0!@eport script.
Spawned <he e"ecution file is a F or Gro!F program.
1mmediate <he e"ecution file is a program written to run as a
subroutine of the concurrent manager. Te recommend
against defining new immediate concurrent programs#
and suggest you use either a G0;SV0 Stored Grocedure
or a Spawned F Grogram instead.
&omposite $atat<pes &
K G0;SV0 <AD0$S
K G0;SV0 @$F?@AS
: >ested <AD0$
: QA@@AH
What is the se,uence of functions M group b<Fha'ingForderb< in a select
statements ?
SelectW..
Iroup byW
LavingW
?rderby..
$ifference bet*een .ser and uper .ser?
9ser & login user or front end user
Super user & it has full access of particular module
O'er'ie* of Oracle Application $e'elopment 5rame*or-
<he ?racle Application Aevelopment 5ramework builds on Y-$$ standards and open-
source technologies to implementing service-oriented applications.
1f you develop enterprise solutions that search# display# create# modify# and validate
data using web ?racle AA5 can simplify your job. 9sed in tandem# ?racle YAeveloper
()g and ?racle AA5 give you an environment that covers the full development
lifecycle from design to deployment.
5rame*or- Architecture and upported Technologies
modelF 'ie*F controller architecture
0odel "a<er
<he core module in the framework is ?racle AA5 'odel# <he ?racle AA5 'odel layer
enables a unified approach to bind any user interface to any business service with no
code.
Cie* "a<er
1n the view layer of your application# where you design the web user interface# you
can develop using either classic YavaServer Gages 6YSG7 or the latest YavaServer
5aces 6YS57 standard.
&ontroller "a<er
1n the controller layer# where handling page flow of your web applications.
YAeveloper offers visual page flow diagrammers to design your page flow# and the
AA5 Fontroller module provides appropriate plug-ins to integrate the AA5 'odel data
binding facility with the controller layer4s page processing lifecycle.