-
What triggers are activated when master detailed relationship established?
saleem
- Nov 21st, 2011
1) On-Check-Delete-Master Fires when Oracle Forms attempts to delete a record in a block that is Master block in a master-detail relation 2)On-Clear-Details Fires when Oracle Forms needs to clear rec...
shahnirav86
- Jul 2nd, 2008
1) Which trigger are created when master -detail rela?1) master delete property * NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details *...
-
How to convert a report into excel sheet
parash_3380
- Oct 19th, 2011
Hi Mr. Subrat, very good but when i set system parameters as destype=file and desformat=spreadsheet it is just showing on browser that "Successfully run" and nothing where as if i give destype=c...
subrat
- Oct 13th, 2011
Set system parameters
destype=file
and
desformat=spreadsheet
(100% tested) and secure -
What are features of 4.5,6i,9i differencekindly list them
manishks86
- Jul 25th, 2011
In 1992, Oracle version 7 was released with support for integrity constraints, stored procedures and triggers. In 1997, Oracle version 8 was released with support for object-oriented development a...
anilreddy02
- Aug 17th, 2010
In 6i -> Report6i program units, layout modules, anchors, conflex and flex modes, frames and repeated frames.
-
Which property has to be used to fill the columns created_by, updated_by etc in the table when the user uses the customized form to enter the data in the table?
kundancertain
- Jan 25th, 2011
By using FND_STANDARD.SET_WHO in PRE_INSERT and PRE_UPDATE trigger, 5 who columns can be populated. But this work in Oracle Application form customization.
nagendrap
- Jan 10th, 2011
In pre-insert trigger by using 'fnd_standard.who' package?we can insert data into these two columns in Oracle forms.
-
Which property is used to define the relative position of one field with another
sameeridol21
- Jul 21st, 2010
The property used to define the relative position of one field with another is Anchor
osden
- Oct 7th, 2007
In properties -> Record -> Distance Between Records (Default value is 0).
-
If there are 1 to 10 records, how many times between pages trigger will fire?If there are 1 to 2 records? and how many times it will fire from 10th to 1st record?
sameeridol21
- Jul 21st, 2010
Irrespective of number of records, between pages trigger will fire n-1 times.According to the Q -if it has 10 pages (1 record/page) then it will fire 9 times.If it has 5 pages (2 record/page) then it will fire 4 times.It will not fire from 10th to 1st record because it fires for 1st navigation.
Chandra K. Ravi
- Sep 6th, 2007
Mittal,? You are wrong.? Page between trigger ?Fire only 4 times. If there is? 5 pages in a report.C.K.Ravi3i-infotech
-
What is the business reason for using triggers and what sequence they get fired when control transfer from one text item to next text item ?
sameeridol21
- Jul 21st, 2010
A trigger is PL/SQL function which will fire whenever a corresponding event occures. The sequence of the triggers as follows1> When-validate-item2> Post-text-item 3>Key-Next-Item4>when-new-item-instance.
Raghu2008
- Aug 6th, 2008
A trigger is PL/SQL block which will fire whenever a corresponding event occures. The sequence of the triggers are Key-Next-Item, When_validate_item, Post_item and when-new-item-instance.Thanks,Rahgu.
-
What is the return type for oracle apps report trigger
sameeridol21
- Jul 21st, 2010
The return type for Oracle Apps report trigger is Boolean ie TRUE Or FALSE
Mital Mehta
- Sep 27th, 2007
That Will be Boolean like True or false
-
What are use of DDE package in D2K
imranbaig.geek
- Mar 23rd, 2010
Oracle Forms for Microsoft Windows supports Dynamic Data Exchange(DDE), a mechanism by which applications can communicate and exchange data. DDE client support is a procedural extension to Oracle Form...
ajay2222@gmail.com
- Dec 21st, 2006
Sir can you tell me any sites name where i can getproject in D2Kajay singh
-
What is key.next.item trigger?
zahid92005
- Feb 23rd, 2010
This trigger fires forces the cursor to be taken to the next available item or data block.
Venkata Ramana
- Sep 14th, 2006
Key-Next-item trigger will fire whenver the user try to move the control(i.e., cursor) from one item to another item in the form by pressing return key or tab key.
-
Oracle Forms Progress bar
How can i implement progress bar in form 6i.
srivnn
- Oct 24th, 2009
We can incorporate the Progress Bar(Status Bar) in the D2K(Forms) as below.1. Create static Canvas with Small Size & Place the Control item (text item) with colour or Visual attribute assign to th...
-
How do you repeat the same values to the next record from the previous record to reduce the user entry in d2k forms 4.5.
pchandna
- Jul 22nd, 2009
Use COPY & NAME_IN BUILT-IN at with the help of System.cursor.record when-New-record-Instance trigger to copy and paset value from previous to next record
najim_t
- Sep 23rd, 2007
Hi Press F3 from on copy one filed. press F4 . it will create same next recordN.TanwirsevenseasgroupDubai
-
Pre Query & Post Query
How many times pre query and post query fired when we fetch 10 record from a table ?
samareshp
- Apr 9th, 2009
Pre Query 1 Time - Before Query Post Query n Time ( n Times for n number of records fetch by this query)
-
What is the use of decode function?
samareshp
- Apr 9th, 2009
Decode(col1,value1,x, value2,y, value3,z, value4,a, Q)it serves as if.else condition ....if col1=value1 then x,elsif col1=value2 then y,elsif col1=value3 then z,elsif col1=value4 then y else Q......
Raghu2008
- Aug 6th, 2008
The decode function is used to read the value from the given column and check 'if' the given column value and given if value is same then return the value other wise return the else value. Like this i...
-
How to see the select statement when we issue execute_query
bc_sumanamara
- Jan 12th, 2009
BY USING :SYSTEM.LAST_QUERY;EXAMPLE WHEN-NEW-FORM-INSTANCEBEGIN execute_query;MESSAGE(:SYSTEM,LAST_RECORD);END;RUN THE FORM...
-
What are the different objects in oracle
samareshp
- Apr 1st, 2009
Synonym,
Table,
View,
Trigger,
Materialized Views,
Indexes,
Sequence
LOB
Package
Package Body
Function
Procedure
Type
ttparavindh
- Aug 7th, 2007
The following Objects are in OracleSequenceLOBPackagePackage BodyTriggerIndexTableSynonymFunctionViewProcedureType
-
When execute query fire for a detail block and how many times pre query fire and how many times post query fire for a detail block?
-
Lexical references
I am making an oracle 10g report and in Query Builder I tried to use lexical reference after the from clauselike SELECT ORDID, TOTALFROM &ATABLE;But it was showing me an error "invalid table name"Can't i use a lexical reference to make me enter the table name at run time?please help.
Rkhatri
- Feb 25th, 2009
It is working fine with Oracle 10g and even with 11gSQL>select &a, &b from &tablename;It will ask respective values and it work fine
jitendra_kumar
- Oct 31st, 2008
Lexical references is used to runtime dynamic where conditions. If you create query through query builder colon(:) must be used and this is used in after parameter form.
Jitendra kumar(software Engineer).
-
How add the values at run time to the report parameter ?dname:ename :Suppose i select dname(sales) , who belongs to that dname those employee name add to the ename
smithamd
- Jan 10th, 2006
By using add_parameter builtin you can add values to the report parameter at runtime
-
How do you trap default forms processing ( DML)
bc_sumanamara
- Jan 12th, 2009
ON-DELETE IS USER TO TRAP DEFAULT DML USED AT FORM LEVEL AND BLOCK LEVEL EXAMPLE : BEGIN UPDATE emp SET termination_date = SYSDATE WHERE emp...
ysumanth
- Oct 27th, 2005
Override on- triggers on insert /ondelete / on update
D2K Interview Questions
Ans