How to toggle Data entry property based on DFF value
Date: Mon, 19 Jul 1999 09:51:02 -0700
From: Sharada Kondaveeti Sharada.Kondaveeti@hds.com
Subject: Help on Custom library
All,
I have a problem here with the custom library. Following is the scenario
:
At the time of data entry of the sales order depending on the order type I
need to toggle between enabling or disabling the data entry in the sales
orders line detail region.
When I define the order types I have a descriptive flexfield(attribute8 of
so_order_types_all) which classifies the order type. If the attribute8 is
null then disable the data
entry in the line detail region if not enable the data entry. Since I cannot
use any SQL in custom library what are the other alternatives? Any
suggestions?
The problem is how do I pull the attribute8 information? I cannot get this
information from the Enter sales order form(OEXOEMOE).
Thanks in advance,
Sharada
Date: Mon, 19 Jul 1999 16:18:13 CDT
From: "Prodipto Mitra" pamitra@hotmail.com
Subject: Re: Help on Custom library
Hi Sharada,
We have used extensively, SQL statements in Custom.pll.
I am sure that you could do it too.
Thanks,
Prodipto
SRW.refrence
Date: Tue, 20 Jul 1999 14:04:27 -0400 (EDT)
From: gaddam naveen gaddam_naveen@yahoo.com
Subject: Re: Can any one explain SRW.reference
Hi ,
Can any one of you explain
SRW.REFERENCE in oracle 2.5 reports
Thanks in Advance
Gaddam
Date: Tue, 20 Jul 1999 11:37:22 PDT
From: "DASARI SUBRAHMANYAM" srdasari@hotmail.com
Subject: Re: Can any one explain SRW.reference
Naveen,
SRW.reference is used to add a variable to the dependency list of the plsql
block in which it is used. Following is the extract from Reports reference
manaual:
"This procedure causes Oracle Reports to add the referenced object to the
PL/SQL construct's dependency list. This causes Oracle Reports to determine
the object's value just before firing the PL/SQL construct. This useful
when you want to ensure that a column value passed to a user exit is the
most recently computed or fetched value."
dasari
Issues relating to Compilation of Forms - R11.02
From: Bartoletti, Michael [mailto:BartolMi@rf.suny.edu]
Sent: Thursday, July 22, 1999 9:51 AM
Subject: GEN:Forms In Release 11.0.2
In the APPL_TOP directories for each module (i.e.. GL_TOP), in the forms
directory the .fmx files are present. In the AU_TOP forms directory the
.fmb files are there. Can someone explain to me why the fmbs and fmxs are
needed on the server?
Thanks
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
mailto:bartolmi@rf.suny.edu
From: Logan, Ernie [mailto:Ernie_Logan@bmc.com]
Sent: Thursday, July 22, 1999 11:11 AM
Subject: RE: Forms In Release 11.0.2
FMX are needed on the server (application / web server) in order to display
them on demand. FMB are on the same server to support patching. Patches are
delivered in FMB format and compiled as required. Also, it is recommended
that all FMX be recreated each time a patchset (11.0.2, 11.0.3, etc) is
applied.
Date: Fri, 23 Jul 1999 06:33:26 PDT
From: "rashmi potdar" rashmipotdar@hotmail.com
Subject: RE: Forms In Release 11.0.2
you compile the form on the unix or forms server. Also known as middle
tier.
Thanks!
Rashmi
From: Bartoletti, Michael [mailto:BartolMi@rf.suny.edu]
Sent: Thursday, July 22, 1999 10:41 AM
Subject: RE: Forms In Release 11.0.2
Thanks for the reply, that makes complete sense. I have a follow up
question - When you develop forms in client server world it depends on the
client operating system as to where the form is compiled. How does this
work in release 11 NCA? Do I compile the fmx on Unix or NT or 98 or does it
matter?
Thanks
Michael Bartoletti
From: Logan, Ernie [mailto:Ernie_Logan@bmc.com]
Sent: Thursday, July 22, 1999 11:47 AM
Subject: RE: Forms In Release 11.0.2
It must be compiled on the application server platform, whatever that may
be. Developers may still work in their favorite Windows environment if they
like, but they must copy FMB to server and compile to FMX on that server.
The client operating system in the NCA world has no impact on the
development environment.
Date: Thu, 22 Jul 1999 15:28:39 -0400
From: "Bartoletti, Michael" BartolMi@rf.suny.edu
Subject: RE: Forms In Release 11.0.2
Thanks again for the reply. I have one last question - Do you use a Unix
version of developer 2000 because using the form45eng compiler does not give
you compile errors. What I am wondering is why it would matter what the
forms are being compiled in. My problem is that we are all developing in NT
and I this means we would have to compile again in Solaris which is where
the apps server is running. Thanks again for all the help and any clarity
would help more.
Michael Bartoletti
Date: Thu, 22 Jul 1999 14:53:11 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: Forms In Release 11.0.2
It matters. Yes, you must use the appropriate Unix version to compile your
forms. It is a detailed compiler issue which is of no interest to the
general members of this group. f45gen (on HP-UX anyway) does issue
appropriate compile time messages. I don't know what form45eng is, so I
cannot speak to it's lack of messages.
The standard process is to modify forms using either your NT tools on
Windows, or f45desm (motif) on Unix. Then during move to production those
FMB files are compiled using f45gen on the Unix server (Sun in your case).
There is no way around this to my knowledge. Anyone who knows otherwise feel
free to correct me.
Passing Parameters in a Zoom
Date: Tue, 27 Jul 1999 13:59:53 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: Passing Parameters in a zoom
Hello,
I am having trouble passing parameters in a zoom. The form will open but
none of my parameters get passed into the form. Any suggestions?
Thanks
Beth Carver
Date: 27 Jul 99 15:32:47 MDT
From: vv vv venvivek@usa.net
Subject: Re: [Passing Parameters in a zoom]
Hi
I have done this before. The following steps should be taken care while U
pass
parameters.
1. Create as many number of parameter in ur destination form.
2. The source and destination fields should be of same data type and size
3. Just follow the method which has been given in custom.pll
4. Mind that the order sequence of receiving of value to the parameter should
be the same as of from the source (Custom.pll).
Please try this out and i think it will help U. If U have any further
clarification then mail me @ dear_breeze@yahoo.com
With regards.
Vivek.
Regenerating Forms
Date: Fri, 30 Jul 1999 14:48:20 +0800
From: Stephen.Solomon@rac.com.au
Subject: Regenerating Forms for 10.7 SC
Hi all,
I was wondering whether someone could tell me the process that I would need
to go through to regenerate a form for AR. I have had a problem with the
Customer Standard form ARXCUDCI.fmb and Oracle Support have suggested to
regenerate it but not sure what I need to do.
Thanks
Stephen
Stephen Solomon
Systems Accountant
RAC Group
Phone: +61 8 9421 4394
Fax: +61 8 9421 4545
Email: Stephen.Solomon@rac.com.au
Date: Fri, 30 Jul 1999 09:27:59 +0100
From: jdstuart@globalnet.co.uk
Subject: RE: Regenerating Forms for 10.7 SC
Stephen,
Assuming you are using NCA, log in as the Applications owner, setup your
enviornment and run the following:
$ORACLE_HOME/bin/f45gen module=$AU_TOP/forms/US/ARXCUDCI.fmb
userid=APPS/APPS output_file=$AR_TOP/forms/US/ARXCUDCI.fmx module_type=form
batch=yes compile_all=special
Regards,
Jonathan.
Date: Fri, 30 Jul 1999 16:46:01 +0800
From: Stephen.Solomon@rac.com.au
Subject: RE: Regenerating Forms for 10.7 SC
Jonathon,
We are actually on 10 SC so the forms are stored locally rather than on a
server.
Form not running"
Date: Fri, 30 Jul 1999 11:35:24 -0400
From: "Robin Easterlin" rce@oew-online.com
Subject: Forms question
Hi All,
I have created a custom form using template.fmb and when trying to run the
form from Forms Designer, I get a module generated successfully message but
it never goes into the Runtime module. What am I missing here?. There must
be a path problem somewhere. We are on 10.7 SC, Forms 4.5, HPUX platform.
Any hints/suggestions are greatly appreciated.
Thanks in advance,
Robin
Date: Fri, 30 Jul 1999 11:06:24 CDT
From: "Prodipto Mitra" pamitra@hotmail.com
Subject: Re: Forms question
Hi Robin,
Due to a variety of called procedures/linked forms etc etc. it is not easy
to run any form developed using template.fmb as stand alone from the forms
runtime module.
The better approach is to register it into your apps dev instance and run
the form from within apps.
HTH
-Prodipto
Closing custom Forms
Date: Fri, 30 Jul 1999 17:27:34 -0400
From: "Venkatraman Gopalakrishnan" gvenkat@oracleassist.com
Hi
I am on R 11.02., Forms 4.5.10.6.
I have developed a custom form and registered it in oracle apps. Everything
works fine except that when I close this custom form using the close button
(X) in the right corner of the window, I get an export window :
Export to excel
- to microsoft excel
- to text file
It has three button : Cancel , Browse and Export
Nothing happens if I click on any of these buttons and the system just
hangs.
Has anyone faced similar problems and found solutions
thanks
venkat
Date: Fri, 30 Jul 1999 17:37:32 -0400
From: "Annamaneni, Hanumantha" Hanumantha.Annamaneni@alcoa.com
In forms designer, go to program units, aac_custom package. There is a
procedure close_window where you need to modify this part of the code
(atleast the first window)
if (wnd = 'first window') then
app_window.close_first_window;
elsif (wnd = 'another window') then
--defer relations
--close related windows
null;
elsif (wnd = 'yet another window') then
--defer relations
--close related windows
null;
end if;
hanumanth
Date: Fri, 30 Jul 1999 22:54:31 -0700
From: atuls@sysao.com (Atul Shah)
Hi Venkat,
As a minimum I would recommend upgrading your Forms 4.5.10.10.2 (patch set 4
for D2k). You have not mentioned which platform you are on, but I am aware
of stability issues with the base release of Forms 4.5.10.6 and R11 (whether
R11.0 or R11.02 or R11.03).
Atul
Date: Fri, 30 Jul 1999 18:01:05 -0400
From: "Venkatraman Gopalakrishnan" gvenkat@oracleassist.com
Subject: Re:custom forms
Hi Atul
Thanks for your reply. We will try upgrading to 4.5.10.10.2.
We are developing in Sun sparc 3.6
thanks
venkat
Is the Tollbar linked to a Form in version 11.0 ?
Date: Tue, 3 Aug 1999 20:48:58 -0400
From: "McElhinny, Steve A." Steve.McElhinny@alcoa.com
Does the Toolbar "problem" go away in Rel 11 (is it linked to the
appropriate form so that it becomes active when you switch to the form)?
Steve McElhinny
Steve.McElhinny@alcoa.com
Date: Wed, 4 Aug 1999 12:04:17 +0930
From: "Hayes , Kathleen" Kathleen.Hayes@boral.com.au
Subject: RE: General Question on 10.7NCA
I was advised at a training course last week that the screen is one. No
more separation. However I would like to see this in action before I can
say for 100%.
Date: Wed, 4 Aug 1999 08:27:24 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: General Question on 10.7NCA
R11 still has the detached Toolbar. Who told you it goes away in 11? I am
working on 11.0.3.
Joe Maliszewski
Consultant
Date: Wed, 04 Aug 1999 07:42:30 -0500
From: "Peter Smith" PSMIT@pcsentre.com
To: Kathleen.Hayes@boral.com.au, oraapps-l@cpa.qc.ca
Subject: Re: RE: General Question on 10.7NCA
When I was at class the toolbar still "floats" as in 10.7NCA. It is not
tied as in 10.7SC.
Pete Smith
psmit@pcsentre.com
Date: Wed, 4 Aug 1999 12:20:48 -0400
From: "Payne, Raymond R." Ray.Payne@jhuapl.edu
Subject: RE: General Question on 10.7NCA
All,
The "floating" toolbar issue is not (nor was it ever intended to be)
addressed in release 11.x as it requires new functionality from the forms
server component of the middle tier. Forms 6.0 has this capability, and
release 11i of the applications uses Forms 6.0 technology ... at that point,
the floating toolbar issue becomes history. Rel 11i will not be available
until later this year.
Regards,
Raymond R. Payne
The Johns Hopkins University Applied Physics Laboratory
http://www.jhuapl.edu http://www.jhuapl.edu
240-228-3534 Washington, DC
443-778-3534 Baltimore, MD
410-389-5126 Pager
240-228-1093 FAX
raymond.payne@jhuapl.edu mailto:raymond.payne@jhuapl.edu