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

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

Prakash

• Dec 18th, 2006

we have the following USER EXITS1.FND SRWINIT2.FND SRWEXIT3.FND FLEXIDVAL4.FND FORMAT_CURRENCY5.FND FLEXSQL

vivek

• Nov 8th, 2006

User exits are used to set profile options and are actually usedto pass the control from 4gl to 3 gl language to do complexcalculations for ex from Oracle reports to outside and return backto reports....

Answer Question  Select Best Answer

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

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

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

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

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

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

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

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

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

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

Bonthu

• Feb 11th, 2006

From 11i Oracle Apps z based on Three tier architechtecture Clinet Server-- Application Sever -- Database Server.Thanks,Bonthu.

ravi kumar

• Jan 10th, 2006

3-tier architecture is also called internet architecture of oracle applications.steps of 3-tier architecture is 1.Client Tier(i.e. Desktop)2.Middle Tier(i.e. Server)3.DataBase Tier

Answer Question  Select Best Answer

Mohana Krishnan R

• Jul 1st, 2006

There is no need of using Lexical parameter in reports Deveoper.Instead We can use bind Variables as a parameter.

TN Reddy

• Jun 6th, 2006

What is the purpose of the lexical parameters in Oracle Reports?

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

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

Rock

 Profile Answers by Rock Questions by Rock

• Dec 1st, 2005

THe extension of the Oracle report will be *.rdf (Report Definition File).You place the Oracle report on the corresponding application top in the reports folder.Eg: $XAP_TOP/../reports

Ravi Vansil

• Nov 11th, 2005

Hi.Copy new report into Custom Directory and the extension should be .rdfThanksRavi Vansil

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