raxinv.rdf - change number of lines in
Date: Tue, 24 Aug 1999 11:26:16 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
Subject: How change Number of Lines in RAXINV.rdf.
I am trying to put more number of lines than 22 in Lines Repeating Frame
of RAXINV.rdf. It is not working. It is still giving 22 only. I changed
it to 45 in the properties of R_LINE_TOTAL, R_LINES, number of records
per page but still it is 45. May be somebody has quick answere due to
modification of this report and bumping into same thing.
Thx,
Madhu Sudan Dada
Custom Menu
Date: Thu, 26 Aug 1999 18:15:59 +0930
From: "Irani, Kermiz" Kermiz.Irani@boral.com.au
Subject: AOL: Custom Menus
Hi,
I am trying to work out what is the best way of defining a custom menu.
The two scenarios I have are:
1. Define every menu as a custom menu i.e. even a submenu which is not
changed, redefine with your custom name.
This would mean you are totally upgrade safe? I assume this means when
Oracle does add more functionality to a form or additional functions, you
would not automatically get them on the custom menus & would have to add
those in?
2. Define your custom top menu and then use Oracle std submenu's where you
have no customisations. Define further custom submenus where you have
customisations.
My gut feel is this would be safe for an upgrade but you will pick up
changes to the Oracle submenus if there are any? I assume this is a good
thing?
Any thoughts on what is a better approach & why?
Thanks,
Kermiz.
Date: Fri, 27 Aug 1999 09:16:51 +1000
From: "Bevin Watson" bevin.watson@abs.gov.au
Subject: Re: AOL: Custom Menus
For what it's worth, we use the second option - using standard submenus
wherever
appropriate. Neither option makes you "upgrade-proof" - you seem to always
need
to review your menus at each major upgrade. However, using some standard
bits
of the menus might help you through minor upgrades and patches.
Bevin Watson
Australian Bureau of Statistics
Concurrent Request Form - Keep refreshed for Payroll
From:
"Jagannathan, Ravi" RJagannathan@prcnet.com
29 Aug 1999 6:36 PM
Subject:
[orahrms-l] Refreshing the Concurrent Request Form - During Payroll run
HR/Payroll Gurus,
For some reasons client needs to keep the concurrent request Screen
refreshed (every 2 minutes), instead of using control+F11.
They need this only for payroll responsibility. We can pull the standard
form and customize it. My question is 'Will this disturb the payroll
performance?'.
Thanks
Ravi Jagannathan (MIS)
Tel : (305) 816 4831
Windows in NCA - Closing
Date: Sun, 29 Aug 1999 10:51:35 -0400
From: "McElhinny, Steve A." Steve.McElhinny@alcoa.com
To: "'OraApps Listserver (to post)'" OraApps-L@cpa.qc.ca
Subject: NCA: Closing windows
All -
10.7 NCA, HP-UX 10.20, Appletviewer.
The Alt-F4 keyboard shortcut for closing a window does not work for us.
Anyone know (a) how we can make this function properly, or (b) an
alternative shortcut that works?
Thanks!
Steve McElhinny
Steve.McElhinny@alcoa.com
Date: Mon, 30 Aug 1999 12:26:55 -0700 (PDT)
From: impact impact impact599@yahoo.com
To: oraapps-l@cpa.qc.ca
Cc: Steve.McElhinny@alcoa.com
Subject: Re: NCA: Closing windows
U can try F4. It works for closing the window.
Regards,
Alok.
IMPACT5 Group.
Folder not displaying all columns
Date: Sun, 29 Aug 1999 10:51:50 -0400
From: "McElhinny, Steve A." Steve.McElhinny@alcoa.com
To: "'OraApps Listserver (to post)'" OraApps-L@cpa.qc.ca
Subject: NCA: Folders Question
All -
10.7 NCA, HP-UX 10.20, Appletviewer.
I have created a Folder view of the Inventory sub transfer form in
Inventory. I stretched the window to its full width, hid some columns, and
modified some column widths to prevent my users from having to scroll left
to right to enter data. I have set the Folder to be Autoquery Never,
Public, Default. When I go to this function from the Navigator (after
populating the Find window), my Folder opens to its full width, but it does
not display all columns unless I reopen the same Folder. Any ideas?
Thanks!
Steve McElhinny
Steve.McElhinny@alcoa.com
Export functionality with IE4.01
Date: Mon, 26 Jul 1999 10:12:52 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: export functionality with IE 4.01
hi, guys I have a problem with export functionality using Internet explorer
4.01 (certified with Jinitiator on NT service pack 3, 4).
I have the form version 4.5.10.9.1 and oracle asking for 4.5.10.10.2(
Developer 1.6.1 with Patch set 4) to work right with it.
Is there anybody around who successfully done export with IE 4.01 and
without patch set 4.( or form version lower then 4.5.10.10.2)
Note : Right now it is not able to create a temporary.xls file in the user
profile on client machine.
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Mon, 26 Jul 1999 13:52:26 -0400
From: Steve_Deackoff@air-water.com (Steve Deackoff)
Subject: Re: export functionality with IE 4.01
Hi,
I have never had any luck using Internet Explorer and the export
functionality. Both pre and post Patch Set 4.
The underlying problem was with IE's lack of ability to graciously
handle
the "text/tab delimited" format being transferred by the PL/SQL agent.
The resolution to our problem was to standardize on Netscape Navigator
4.5
or better (some use 4.5, some use 4.6). It handles the exports easily
and
graciously. (Both pre and post patch set 4, make sure you apply server
718365, server 768058, nca 768101)
A one-time setup step is needed in order to associate Excel and
Text/Tab
delimited files during the "Pick Application" of the netscape download.
After having down this once, the rest of exports worked flawlessly.
And
Netscape 4.5 is free with no licensing issues now (I guess there may
have
been corporate licensing issues in the past, but no longer).
Sorry I couldn't help with IE, but been there, done that. Could make
it
work sometimes, but then it broke, an it wasn't worth the effort. We
had
more important issues to take care of than to make it work with IE.
Hope this helps,
Steve Deackoff
FRM - 40375 errors when I select AR menus
Date: Tue, 31 Aug 1999 10:45:01 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: FRM - 40375 errors when I select AR menus in 11.0.3..............
Hi,
I recently upgraded our DATABASE to 11.0.3 from 11.0.28
and manually entered ( COpied and Pasted ) all the menus from DEV system as
I was getting "FRM - 40375" errors in some of the menus when I used scripts.
Still I am getting the same errors even after doing manually......
( you can refer to my earlier posting saying "Script to transfer Menus
from one instance to another "..... this script contains scripts also .....)
Does anybody have idea about this.
This is occuring in Menus in AR module.....
And the instance on which I copied these menus is a blank instance.
Any feedback would be highly appreciated......
Thanks,
-chakrapani
Instance name - add on Forms
Date: Tue, 31 Aug 1999 11:56:52 -0400
From: Erik Ritters eritters@prg.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Instance Name on Forms in R11 NCA
Has anyone successfully added the instance name to forms within R11 NCA?
We have modified the app such that the toolbar includes the instance name in
the title.
This becomes very confusing when someone brings up multiple sessions of the
application (one for production, one for test, etc).
Since everything is now a floating window, is there a way to add the
instance name to every window that is brought up.
I'm sure this is a common problem for many of us running R11 NCA.
Thanks in advance for your help!
Erik Ritters
Information Technology & Strategy
Production Resource Group, L.L.C.
539 Temple Hill Rd.
New Windsor, NY 12553
Phone - (914)567-5784
Fax - (914)567-5805
Email - eritters@prg.com
Date: Tue, 31 Aug 1999 10:41:40 -0600
From: "Kossmann, Bill" BKossmann@mail.dthr.ab.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Instance Name on Forms in R11 NCA
We have 10.7 NCA, so this might not work for you--but we use the "Short
Name" field of the Set of Books form (Setup | Financials | Books) to display
the instance on most forms (i.e. "Prod. Main SoB" is the Production Main Set
of Books, as opposed to "Pyrl Test SoB" which is the Payroll Test Set of
books, for example).
Also, I've set the System profile "Site Name" to one of [Test | Training |
Production] on our three instances. That way, someone doing "Help | About
Oracle Applications" can see where they are.
HTH,
Bill
Date: Tue, 31 Aug 1999 17:33:06 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Instance Name on Forms in R11 NCA
Hi,
You can find the procedure given on OraApps archive
for showing the INSTANCE name on Oracle Apps main "Navigator" Window.
I saw this long back.
-chakrapani
Navigation to Forms - shortcut
Date: Tue, 31 Aug 1999 13:47:24 EDT
From: "Raj P" raj_orapps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Gen : Short cut entry to forms with minimum navigation
Hi
you want to go directly to the form which you are interested in with minimum
navigation....
May be many of you are aware of.... This may be useful to those who are not
aware of this functionality.
After u get into the your responsibility sign on form,
press function key F9 to get the list of values of forms functions..
Select the form function and go directly to the form with no navigation.
Rajagopalan, Panchat
Functional Consultant - Manufacturing
Kay Software Inc.,
The Robbins Co
Date: Tue, 31 Aug 1999 13:55:25 -0400
From: "Finney, Jack" jack.finney@glenayre.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Gen : Short cut entry to forms with minimum navigation
There is a drawback to this. If a form is listed more than once in your
responsibility it will be listed that many times in the pick list. Therefore
the pick list can be extremely long. This may not be problem in small
responsibilities, but large responsibilities would suffer.
Jack Finney
Date: Tue, 31 Aug 1999 16:06:21 -0400
From: "Thurm, Anita" Anita_Thurm@compuware.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Gen : Short cut entry to forms with minimum navigation
Do you have to set anything up for this to work? I tried in our environment
and it didn't work.
Release 11.0.3
RDBMS 8.0.5
Sun Solaris 2.6
Thanks!!
Anita
Date: Wed, 1 Sep 1999 08:19:08 -0400
From: "Mitesh Patel" miteshp@mastech.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Gen : Short cut entry to forms with minimum navigation
Anita,
Function key F9 is a short cut key for "List of Values". You need to use the
short cut key for List of Values in V11. In release 11, if I'm not wrong
short cut key for "List of Values" is "Ctrl + L".
The other alternate for this is that got to menu:
Help -- Keyboard Help...
Here you can look for "List of Values" and corresponding Key for it.
HTH.
Mitesh
Modify option in Autocreate PO - to remove
Date: Thu, 2 Sep 1999 16:58:52 +0930
From: "Irani, Kermiz" Kermiz.Irani@boral.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AOL: Function for PO responsibility
Hi,
I want to remove the menu option to 'Modify' (under the special menu) at the
Autocreate screen.
At the responsibility function exclusion level, I cannot seem to work out
what function name it is (none of the ones in the quickpick sound like it).
I also had a look at the menu but there was nothing there.
Please can anyone help?
Thanks,
Kermiz.
Query on Non-base Table Fields
Date: Fri, 3 Sep 1999 11:19:57 -0400
From: Linda_Ead@Millipore.com
To: oraapps-l@cpa.qc.ca
Subject: Forms 4.5 non-basetable fields
I'm designing a form in Forms 4.5 that is used to query, update and insert
records into a custom table. This custom table stores the ids for items
that exist in other tables.
Using a post-query trigger, I'm populating the fields from the other
tables. I want the user to be able to query on the non-base table fields.
I put a where statement in my post-query trigger that looks like:
and ra_customers.customer_name like :blockname.customer_name ||
'%'
but it doesn't work.
Any ideas?
Thank you in advance,
Linda
Date: Fri, 3 Sep 1999 17:00:52 +0100
From: rchalton@dunnes-stores.ie
To: oraapps-l@cpa.qc.ca
Subject: Re: Forms 4.5 non-basetable fields
You need to use a pre-query trigger.
Rob
run_product gives FRM-4o733 error
Date: Mon, 6 Sep 1999 19:30:13 +0100
From: ccasey@dunnes-stores.ie
To: OraApps-L@cpa.qc.ca
Subject: PO: Run_PRODUCT Error
Platform : Windows NT
Apps Version :11.0.2
RDBMS:8.0.5.0.0
Is it possible to use the Forms 4.5 built-in procedure Run_product in
Oracle Apps 11.0.2.
Having major problems. It works for Oracle Apps 10.7 as far as I know but I
get
FRM-40733 : PL/SQL Built in RUN_PRODUCT failed when used in 11.0.2
Query - automate on zooming to a Form
Date: Mon, 6 Sep 1999 11:50:07 -0700
From: Sharada Kondaveeti Sharada.Kondaveeti@hds.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: help in forms
All,
I have developed a custom form from which I zoom to one of the oracle
standard form. I am passing the parameters from custom form
to standard form. The standard form has a query find block as the first
block. I need to automatically query with the parameter that I am sending
and bring the result block of the standard form. Right now i have to hit
find button and enter the result block of the standard form. I should by
pass
this block. How do I achieve this?
Thanks in advance,
Sharada
Date: Mon, 06 Sep 1999 22:50:31 -0700
From: "sridharan lakshminarayanan" l.sridharan@mailcity.com
To: oraapps-l@cpa.qc.ca
Cc: Sharada.Kondaveeti@hds.com
Subject: Re: help in forms
Hi,
With respect to your query, Identify where your cursor is in standard
form while coming from custom form. In Pretext trigger, write a trigger for
Execute Query.
Sridharan.
Folder - creating default
Date: Tue, 7 Sep 1999 14:26:42 -0400
From: "Kelly.Newman" Kelly.Newman@plpit.fishersci.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AR TRansaction Summary/Adjust
We have one user, when using the transaction summary screen, and hitting
adjust, who was receiving a FRM-41045. Others with the same responsiblity
were fine. What we found was that this user had a default folder with
Autoquery set to 'NO' for the intermediate form which pops up in between
transaction summary, and the actual 'adjust' form. We removed the default,
and the process works fine. The dilemma now, of course is how do we have a
default folder set up for a form, then if the form is used by another
process -- how do we keep them from interacting with each other. I.E., we
want the best of both worlds. Any ideas or work arounds? - - thanks!!!
Date: Tue, 7 Sep 1999 16:26:29 -0400
From: Kevin Bradley kbradley@mapmobile.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Assuming that the other process accessing the form is another
responsibility, you can define a folder and assign it to a responsibility
in sysadmin. This way you have the best of both worlds.
Kevin Bradley
Map Mobile Communications Inc.
840 Greenbrier Circle
Chesapeake, VA 23320
(757)424-1191
(800)374-5423
kbradley@mapmobile.com
raise_application_error function not working
Date: Wed, 8 Sep 1999 11:51:26 -0700
From: Todd Manley tmanley@zilog.com
To: "Oracle Applications Forum (E-mail)" oraapps-l@cpa.qc.ca
Subject: RAISE_APPLICATION_ERROR Problems
Hello-
I have a trigger that needs to display information to the user through the
apps when they violate a date rule. I'm using the RAISE_APPLICATION_ERROR
function to display a customized message, but when the trigger fires, I get
an internal exception error stating the following:
APP-18309 Oracle Order Entry has detected an internal exception.
The trigger is very simple. Here's the code:
if :new.schedule_date > :new.date_requested_current then
v_error_msg := 'Schedule Date cannot be greater than Request Date.';
raise_application_error(-20500, v_error_msg);
end if;
-Thanks, Todd
Todd Manley
ZiLOG
408.558.8962
tmanley@zilog.com
Export to Excel - Forms 5.0
From: Bivens, Jerry jdbivens@sbec.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Date: Wednesday, September 08, 1999 11:39 PM
Subject: Oracle Forms 5 - Export to Excel
Does anyone have a tool to export from a standard Oracle form to an Excel
workbook? Any help would be appreciated.
Jerry Bivens
S&B Engineers and Constructors, LTD.
jdbivens@sbec.com
713-845-4439 (Office)
713-764-2127 (Pager)
Date: Thu, 9 Sep 1999 14:47:46 +0530
From: "S RAGAVENDRAN" sripadra@wipsys.soft.net
To: oraapps-l@cpa.qc.ca
Subject: Re: Oracle Forms 5 - Export to Excel
Hi Jerry,
We are on 10.7 SC GUI Prod 16.1 with
Forms 4.5.
It is possible to export from an Apps form that
has multiple rows in its layout, by selecting
Action- Export and choosing
"Export to a Text File".
After the export is complete, u can open the
Text file in Excel.
I tried exporting a batch of invoices from AP
to a text file and it came out correctly.
For exporting to Excel directly, U should open a blank
worksheet and keep Excel window maximized at the Apps
window on top of it and then try exporting from Apps forms.
I see two limitations:
1. Exporting large no. of rows to a text file may
return an error.
2. Exporting to Excel, doesn't work properly.
It gives the "F45 run" Error.
Tell me if this works with Forms 5.0
- Ragavendra.
Custom.pll and Form level Triggers
Date: Thu, 09 Sep 1999 08:53:06 -0400
From: Ranjit Basak ranjit.basak@yale.edu
To: oraapps-l@cpa.qc.ca
Subject: Custom PLL (Technical Question)
On GL Journal Post form(Seeded), the Post button is the only item in the
block. The only
trigger defined on that item is when-button-pressed. There are no block
level triggers for
that block.
I want to accomplish the following in Custom Pll.
When I press the Button, I want it to go to previous block and do some
processing within
a loop and then perform what the WBP is coded to do i.e Exit_FORM.
Is it do-able with any of the 5 triggers that we can use in Custom.pll?
Any suggestion will be appreciated.
I tried WNBI and WNII. When the button is clicked, it does a pre-commit and
submits the
posting job.
Sequence No. - reset for each Payment Batch
Date: Thu, 9 Sep 1999 14:22:33 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Locally genrated Sequence no.s in Reports 2.5
Hi All,
I want to set a sequnce no. in a repeating frame of a "PAYMENT DETAIL" and I
want it to be reset for every "PAYMENT batch".
Please let me know how to accomplish this.
Thanks in Advance,
-chakrapani
Web Forms - Navigation problem
From: Larry Scheurich [mailto:larrys@dpapplications.com]
Sent: Monday, September 27, 1999 8:48 PM
To: Multiple recipients of list
Subject: WEB forms
Folks,
I have been experimenting with the WEB forms and Vision demo
database.
Everything seems to work fine. However, when I navigate from the
menu to a
form, it flashes back and forth between the form and the menu. Is
there any
way to stop this behavior?
Thanks!
Date: Sun, 17 Oct 1999 13:42:38 +0200
From: "Lavy, Shay" Shay_lavy@icomverse.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: WEB forms
Check the version of Jinitiator you're using.
The problem is known on 1.1.7.
It was resolved here when moving BACK to 1.1.5.
Regards,
Shay Lavy
ITA Department
Comverse Network Systems
Phone no. : 972-(0)3-765-5794
Cell Phone: 972-(0)51-325794