Krishna Balan b

• May 19th, 2017

First go to Oracle Form installed directory then bin folder will be there open that folder then search ifrun60 this named file the create shortcut of that file to desktop then go to the property of t...

KULDEEP

• Mar 8th, 2017

First of all we will write the code than save after than when we will use this code before compiled, run after that this is generated .exe file.

Answer Question  Select Best Answer

Hi all,Pls answer the following questions1.what is the difference between CALL FORM,NEW FORM, & OPEN FORM?2.can a report contain more than one template?3.where will u define GLOBAL VARIABLES in Reports?

KULDEEP

• Mar 8th, 2017

Mainly Oracle forms are four types
1 Single form
2 Single with wildloop form
3 Master form
4 Master with netloop form

garimella.aditya

 Profile Answers by garimella.aditya Questions by garimella.aditya

• Apr 7th, 2009

Answer to the first Question is :CALL_FORM to run forms in modal mode. The calling form remains inactive till the called form is exited.NEW_FORM to close the calling form, and then invoke the called f...

Answer Question  Select Best Answer

In a total 5 pages report, on page 1,3,5 margin area can see the information of "Approved by xxxx", whereas on page 2,4 will not see (or hide) the same information. How will you do that with D2K report Builder 6? Since If cannot access page number as a variable?

Mayank Jain

• Jun 22nd, 2016

Write the format trigger on that particular item see example below

function F_2FormatTrigger return boolean is
page_num number;
begin
srw.get_page_num(page_num);
if page_num in (1,3,5) then
return (TRUE);
else
return false;
end if;
end;

Answer Question  Select Best Answer

sohrab hamid siddiqui

• Oct 22nd, 2015

A user profile is a collection of changeable options that affect the way your applications run. Oracle Applications establishes a value for each option in a users profile when the user logs on or changes responsibility. Types are as follow

1. Site
2. Application
3. Responsibility
4. User

ravi kumar

• Jan 10th, 2006

User Profile is a set of changeble options for change the way of running applications.we can set user profiles in four ways.They are 1.Site2.Application3.Resposibility4.User

Answer Question  Select Best Answer

What is the use of the placeholder column? Can placeholder column variable be used as global variable with in the report? Why?

Amar

• May 7th, 2012

Place Holder Column Is A Empty Container, It Holds The Value At Run Time. Place Holder Column Should Be Source From Formula Column And Before Report Trigger And Also With After Parameter Form Also.....

rajgopalmatti

• Oct 19th, 2011

Place holder is nothing but empty column it contains empty data at compilation time,after run the report it can hold the data

Answer Question  Select Best Answer

Bonthu Nagi Reddy

• Mar 8th, 2012

FND Stands for Foundation in Application Object Library Module.

Most of the tables in AOL module starts with fnd_XXXX .

utpal kumar nayak

• Apr 19th, 2006

The meaning of FND in Oracle Apps or in AOL(Application Object Library) is system name of core application object library and now it is renamed to Application Technology. The application has $FND_TOP which has all the apps related product filesRegardsUtpal Nayak

Answer Question  Select Best Answer

Explain what are program units and attached libraries? How do they differ from one another?

sowjanya_n

 Profile Answers by sowjanya_n Questions by sowjanya_n

• Jun 9th, 2009

The Difference is Program units are only to the corresponding form or report.If, you have written that code in attached library, you can use that code in multiple forms or reports - means reusability, where as you cannot reuse a program unit in multiple forms.

Answer Question  Select Best Answer

askme

 Profile Answers by askme Questions by askme

• Dec 5th, 2008

Why should we copy .fmb and why not .fmx. .fmx is the executable file so we should copy that.

ravi kumar

• Jan 10th, 2006

we will copy new custorm form to custom_top/forms.Extension of that file is .fmb

Answer Question  Select Best Answer

askme

 Profile Answers by askme Questions by askme

• Dec 5th, 2008

A flexfield, is a flexible data field that your organization can customize to your business needs without programming. It is made up of subfields, or segments. There are 2 types of flexfields ...

ravi kumar

• Jan 10th, 2006

Client can customize Descriptive Flex Fields.

Answer Question  Select Best Answer

In which circumstances you will use POST instead of commit?

krishna.jha

 Profile Answers by krishna.jha Questions by krishna.jha

• Dec 3rd, 2008

Posting is an event that writes insert update and delete in the form but not commiting these transaction to the data base. Commit is an event that attempts to make the data in the database identical to data in the form.

Answer Question  Select Best Answer

reddy81

 Profile Answers by reddy81 Questions by reddy81

• Oct 16th, 2008

Q:1) totally there r 9 layouts available in reports,in that 8 are predefined another 1 is manual layout.1.tabular2.form like3.form letter4.group left5.group above6.mailing lable7.matrix8.matrix with g...

pvenkey

 Profile Answers by pvenkey Questions by pvenkey

• Jun 17th, 2008

1.Web and Paper layout2.Web layout3.Paper layoutPlease see the question b4 u r going to answer

Answer Question  Select Best Answer

raghavendrajsv

 Profile Answers by raghavendrajsv Questions by raghavendrajsv

• Aug 4th, 2008

SRW.RUN_REPORT('MonthlyCostsheet.rep PARAMFORM=NO P_BATCH='||''''||:batch_no||''''||' P_COMPANY_CODE ='||''''||:P_COMPANY_CODE||'...

arvindsharma

 Profile Answers by arvindsharma Questions by arvindsharma

• Sep 7th, 2007

SRW IS A PACKAGE WHICH IS USE IN REPORTS .HERE IS FOLLOWING PROCEDURES WHICH USE WITH SRW PACKAGE.SRW.ADD_DEFINITIONSRW.APPLY_DEFINTIONSRW.BREAKSRW.CONTEXT_FAILURESRW.DO_SQLSRW.DO_SQL_FAILURESRW.GETTE...

Answer Question  Select Best Answer

raman av

 Profile Answers by raman av Questions by raman av

• Jun 12th, 2008

Step(1): download the report(.rdf)step(2): open the report in report builderstep(3): do the modifiacation whatever you want.step(4): save the report and compile.step(5): place the .rdf into the respctive folderstep(6): run the report as well

Answer Question  Select Best Answer

mailsudhirn

 Profile Answers by mailsudhirn Questions by mailsudhirn

• Jun 4th, 2008

Lexical parameters are used to substitute multiple values at runtime. It can be used in FROM TABLE NAME and in WHERE clause. Usually the lexical parameters are defined in After Parameter Report or in...

poonamyadav

 Profile Answers by poonamyadav Questions by poonamyadav

• May 31st, 2008

Lexical Parameter is denoted by a symbol &(Amphersend) and is used in WHERE_CLAUSE.with the help of this parameter we can pass strings.

Answer Question  Select Best Answer

ramanathan_h

 Profile Answers by ramanathan_h Questions by ramanathan_h

• May 29th, 2008

        Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent.  The end of the anchor with a symbol on ...

Chandra K. Ravi

• Aug 31st, 2007

Anchor is used to make fix distance between two objects in Reports Layout.

Answer Question  Select Best Answer

sateesh.talanki

 Profile Answers by sateesh.talanki Questions by sateesh.talanki

• Apr 18th, 2008

After parameter Trigger: It will fire after the parameter form is displayed.here we can do validation on parameter valuesBefore Report Trigger: It will fire before the report is execured and after the query is parsed and date is fetched.

Arun.Gopalan

 Profile Answers by Arun.Gopalan Questions by Arun.Gopalan

• Feb 28th, 2008

Query which has to be run by the report is parsed at the end of AFTER PARAMATER TRIGGER. Hence values that need to be provided for the bind and lexical variables should be assigned in or before this t...

Answer Question  Select Best Answer

jagadeesh9

 Profile Answers by jagadeesh9 Questions by jagadeesh9

• Feb 24th, 2008

Placeholder column is a global variable for which we can set data type and data value.Format Trigger is a PL/SQL function. This trigger is going to fire before an object is printed in report output.it...

Denzy

 Profile Answers by Denzy Questions by Denzy

• Feb 14th, 2006

A placeholder column is used to hold the value of certain calculation or a variable that is being carried out in a formula column. A place holder can be defined as anumber, character or date type, dep...

Answer Question  Select Best Answer

arif_rahman

• Sep 5th, 2007

Creating Oracle Forms Developer applications using Wizards Working with the enhanced user interface Ensuring consistency across applications Representing data within your application Understanding Ora...

Answer Question  Select Best Answer

Neelkanth

• Feb 16th, 2007

When-validate-item,key-next-item ,on-error,on-message etc are the common triggers shared by form , block as well as items

saravana

• Feb 3rd, 2007

When new_ form _instance, when new_ block _instance, when new_ item_ instance are most used common trigger

Answer Question  Select Best Answer

Guest

• Jan 4th, 2007

hiwe an do ways1)creating independent valueset and based on this we can create dependent valueset .1st can select independent  then only we can chosse dependent value set 2) By usi...

Brajesh Singh Bhadoriya

• Dec 21st, 2006

create one value set. This value set will get first parameter. while creating second Value set use ":$FLEX$.<first value set name>" in the condition. for example, I m cr...

Answer Question  Select Best Answer