Apps on 640 x 480 VGA monitor
Date: Fri, 27 Aug 1999 17:41:44 +0500
From: "M. Armaghan Saqib" armaghan@yahoo.com
Subject: GEN: Can APPS run on 640 x 480 (all modules) comfortably?
Hi all,
One of my clients is moving to Oracle APPS from his Forms4.5 custom
application. He has old VGAs which cannot go above 640x480.
Has anybody run APPS (SC and NCA) on this configuration comfortably?
Should he upgrade hardware or not? What should I recommend?
regards,
M. Armaghan Saqib
Date: Fri, 27 Aug 1999 08:00:21 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: Can APPS run on 640 x 480 (all modules) comfortably?
this is not comfortable. When we originally installed 10.7NCA, our users
had 14" and 15" monitors. Many running 640 x 480. Now almost all users
have 17" monitors. With the smaller monitors, the user needs to move the
forms around on the screen to get to buttons on the bottom of the form. It
is very time consuming and cumbersome.
HTH
Date: Fri, 27 Aug 1999 11:07:12 -0500
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: RE: Can APPS run on 640 x 480 (all modules) comfortably?
I would add that it makes training very difficult because users have to
remember what buttons, columns, etc. are on the part of the screen that they
cannot see. This is very confusing for new users, who are generally
confused enough already.
Kathy Farmer
Date: Fri, 27 Aug 1999 14:30:59 -0500
From: "Dan Depies" Tpsd032@shopko.com
Subject: Re: GEN: Can APPS run on 640 x 480 (all modules) comfortably?
We resolved a similar issue at my client. The development team had 14
inch monitors and a max resolution of 800 x 600 while we were using
SmartDB that had a minimum requirement of 1024 x 800. Instead of buying
new hardware for all the developers, we changed the Windows Hardware
Settings to make it think we had a different monitor that could handle the
higher resolution (Dell Super VGA). We were then able to increase the
resolution and use SmartDB without losing any of the buttons. A word of
caution, the fonts are much smaller than normal for the user.
Dan
MLS - performance
Date: Fri, 27 Aug 1999 10:47:46 -0400
From: "ClinTrials BioResearch, Ltd." it@ctbr.com
Subject: MLS installed
Hi,
Is there anybody has MLS installed on Oracle Appl 11.0.3 and NT
platform?
When MLS is installed, can we have access in different languages into
the same instance, that means English people can have English form with
English information AND somewhere French people can have French form
with French info simutanous?
Do you know if it is supported by Oracle Support?
Thank you very much.
Kim-Chau Pham
Date: Fri, 27 Aug 1999 16:59:42 +0200
From: Gorre Richard GorreR@fnherstal.com
Subject: RE: MLS installed
Hi Kim
Yes it is supported by Oracle application but :
You have to think a lot about it before implementing;=20
It will increase patch load you have to patch each language
Available version are not at the same level from one language to another
To support your users, you have to know each field promt in any language
etc...
We tryed with Portuguese language, then we decided to force user to use
English in all contries
Richard
Date: Fri, 27 Aug 1999 19:06:34 +0200
From: Jean-Guy_Duba@ernst-young.fr
Subject: RE: MLS installed
Kim, for sure increased headaches for patch application.....etc. If you can
avoid it and go only for an NLS, do it.
For a good overview, please try to read the OAUG 99 (San Diego) paper
called "understanding MLS in R11).
Date: Mon, 30 Aug 1999 20:11:29 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: MLS installed
Hi,
We are on 11.0.2 and are implementing MLS (NLS!) for the French users.
In Release 11 MLS(NLS!) is supported in the base product for a level 1
implementation.
Level 1 implementation means that all boilerplate text, AOL (FND) objects
and reports (all or some I am not sure still testing) are in the two
languages that you install .
Two languages mneans (English for example) is the base Language and French
NLS support is installed on top of it.
We did get a lot of push back from Support that this is a Consulting
solution but it is actually supported for this level only and possibly you
will get a run around before you find an analyst who has enough idea about
it to help you.
We are in the testing stage and things look fine and french enough.
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Date: Thu, 2 Sep 1999 02:27:56 -0400
From: fushan@gamma.aei.ca
To: oraapps-l@cpa.qc.ca
Subject: Re: MLS installed
HI Kam-chu:
I am in MLS environment. My application is 10.7 SC 16.1 only.
We support English and Canada French for our North American
database. MLS is "sort of" supported by Oracle. It is very hard to
explain. As you know, MLS is a customation from Oracle.
However, the customation did not done by Oracle. In stead, the
whole customation is done by Oracle consultant. Don't ask me
what are the different. The only thing I know.... Everytime when I
apply a patch, I have to get the NLS for my English and French but
I also have to ask Oracle support to call Oracle consultant to
check for related MLS patches. Of course, it delay the whole
process to request a patch. If I have a choice, I will not go for
MLS. Also, sometime a MLS patches will update the french data
to become english data. It is hard for me to explain in email. (
need to draw some graphic ). We have manual update back to
french. It also tell me that NLS and MLS are not 100% work
together very well.......
Just a little tip. We applied AOL patchset C recently and it
caused a lot of trouble for the MLS issue. For some reason, the
AOL patchset C get ride of French and replaced by English. So
watch out for that!!!
Fu-shan Louisa Leong
Oracle DBA, Oracle Financial Application
Andersen Consulting
Date: Thu, 2 Sep 1999 09:50:28 -0400
From: steve_veilleux@canammanac.com
To: OraApps-L@cpa.qc.ca
Subject: Re: MLS installed
Hi Fu-shan,
you mention in your answer to Kam-chu that you are using MLS and that you
had some problem with AOL Patchset C... We are in a MLS environment (English
and
Canadian French) too,
application version 10.7 SC 16.1 and we have applied the AOL Patchset C
in a test environment... Our Applications Specialists from US are testing
now
this
Patchset and other Patchset (Testing AP patchset Q I think and AOL patchset
C...) in English environment
only. French Applications Specialists don't have the time now to test
it.(Hope
they will test it before
our DBA implement it in Production )... You say "the AOL patchset C get ride
of
French and replaced by English"
This happen where in the application ? In wich module ... ? We are using AP,
PO,
INV, GL, FA, AR and Projects ...
Your answers will be very appreciate.
Thanks a lot and have a great day!
Regards,
Steve Veilleux
Developper
Le Groupe Canam Manac
Canada
Date: Thu, 2 Sep 1999 18:51:49 -0400
From: fushan@gamma.aei.ca
To: oraapps-l@cpa.qc.ca
Subject: Re: MLS installed
Hi Steve :
Up to now, we only have a big problem in AOL patchset C.
Unfortunately I am not the person to install the patch. I will try
to get some information for you tomorrow. Other than AOL ,
AP, GL.. etc are ok for me.
Fu-shan Louisa Leong
Oracle DBA, Oracle Financial Application
Andersen Consulting
MLS Flag
Date: Tue, 31 Aug 1999 07:02:13 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Multi-Language Support--Technical Question!
Hi All,
I had couple of questions on Multi-Language Support--
1. We are not sure whether the MLS flag was turned on
or not at the time of Apps installation. Which
directory/file do we check to see whether the MLS
option was turned on or not?
2. If not, is there a way to turn the flag at a later
stage. If not possible, what is the best workaround.
3. We are on 10.7 Some modules are in character mode
and some in GUI. Would there any affect on MLS?
Your guidance in this matter would help us a great
deal.
Thank you in advance.
Siddharth Shah
Date: Tue, 31 Aug 1999 09:33:07 -0500
From: Michael S Barone Michael.S.Barone@Cummins.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Multi-Language Support--Technical Question!
Siddharth:
The Oracle Applications AD (Utility) Product Directory contains
some very useful scripts. One of these scripts (report)
$AD_TOP/sql/adutconf.sql ... will tell you if Multi-Language
has been installed:
From UNIX you can merely execute: sqlplus apps/passwd
@$AD_TOP/sql/adutconf.sql
Please see the following heading in the output produced by
adutconf.sql
Multi-Lingual installed?
INSTALLED Code NLS_LANGUAGE
Michael
Date: Tue, 31 Aug 1999 09:23:59 -0500
From: Michael S Barone Michael.S.Barone@Cummins.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Multi-Language Support--Technical Question!
Siddharth:
The Oracle Applications AD (Utilities) Product Directory contains some
very useful scripts. One of these scripts ($AD_TOP/sql/adutconf.sql)
will display the following:
Oracle Application Product Group
Sequence Nos. - link to Field and cache issues
For another thread on general discussion on caching and sequence numbers
Please click here
Date: Sun, 5 Sep 1999 09:05:29 +0400
From: "Mehul Zaveri" mehulapps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Identifying the map between the actual sequence number used and the
field name ? and impact of disabling sequence caching?
Hi friends,
Is there any way to identify which sequences are used to update/insert
in which table's field? Any help would be greatly appreciated.
Platform :- AIX 4.3 , Oracle Apps 11.0.3
Can we disable caching option for all sequences in apps database??. This
is creating jumps some times (default cache of 20).
Will this change have any additional impact apart of some performance issue?
Any ideas?
Mehul Zaveri
Oracle DBA
EPPCO-DUBAI
+971-4-3031557
Date: Sun, 5 Sep 1999 09:07:11 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: Identifying the map between the actual sequence number used and
Alter sequence sequence_name no cache;
Do for all jumping will die.
Check data dictionary tables, I donot remeber or no body remebers ..
for sequence and there column, table name .. it should be in
all_sequences .. or some thing line that .. all_sequences_cols etc.
Madhu Sudan Dada
Date: Sun, 5 Sep 1999 19:07:02 MYT-8
From: philip@aleytys.pc.my
To: "Mehul Zaveri" mehulapps@hotmail.com, oraapps-l@cpa.qc.ca
Subject: Re: Identifying the map between the actual sequence number
The technical reference manuals are invaluable in identifying sequences
used by each table. Not all the sequences are documented in 10.7 though.
I had to do some detective work to identify the sequence used to generate
the AR invoice numbers.
Yes, you can manually change all the cache settings to 0, but you really
don't want to.
Yes this will definitely have a significant impact on high volume
transactions.
Yes only change those sequences that are absolutely necessary. For
example our external auditors get all het up if certain documents are
missing numbers in between. For those sequences used for surrogate
primary keys and are not user accessible, you can leave them alone.
Philip
Philip Chee: Tasek Corporation Bhd, P.O.Box 254, 30908 Ipoh, MALAYSIA
e-mail: philip@aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932
Date: Mon, 6 Sep 1999 15:49:44 +0200
From: George Fungayi Mamvura mamvura@alpha.co.zw
To: oraapps-l@cpa.qc.ca
Subject: Re: Identifying the map between the actual sequence number
Try this
select SEQUENCE_NAME,SEQUENCE_OWNER,LAST_NUMBER from dba_sequences;
you can also check for the Cache size
Oracle Public Sector Budgeting and OBIS
Date: 9 Sep 99 07:45:33 EDT
From: Thomas Matthews tjohnmatthews@netscape.net
To: OraApps-L@cpa.qc.ca
Subject: Budgeting: Public Sector
Hello,
I would like to know if anyone is using Oracle Public Sector Budgeting.
Were you required to purchase Oracle Human Resources?
Also, if you are using Oracle Discover to create custom reports, did you have
to purchase Oracle Business Intelligence System (OBIS)? According to the
User's Guide, OBIS is required if using Discover. The problem is that I
cannot find any information on OBIS. Is it a separate module? Is it a
technical tool?
Thanks,
Tom
e - business
Date: Mon, 13 Sep 1999 17:32:35 -0500
From: "Kalidindi, Shanthi" SKalidin@obiwan.Intecom.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: E-Business
Hi All,
We are currently on 10.7 character, HPUX 11 and are upgrading to 10.7 NCA.
Our company is planning to go for e-business, I am quite new to this
e-commerce/e-business area and have some questions. When we surf the Oracle
web site we get to see lot of information on e-commerce/e-business,however,
I would like to know if Oracle Applications by itself as any features to
support e-business or would we need to develop the e-commerce applications
and then integrate with Oracle Applications. At this juncture things are
unclear to me. Could someone please let me know about this subject or give
me a direction to go ahead?.
Any help/suggestions are greatly appreciated.
Thanks in advance,
Shanthi
Date: Tue, 14 Sep 1999 09:27:35 MYT-8
From: philip@aleytys.pc.my
To: oraapps-l@cpa.qc.ca
Subject: Re: E-Business
Hi!
Sometime next year we plan to go into e-business ("'cause all our
competitors are doing it"). I'm really quite blur and as Shanthi says,
there is a lot of hype and not much solid data. Can anybody point to
some basic briefing papers along the lines of E-Commerce for Dummies?
Philip
Date: Tue, 14 Sep 1999 10:38:44 -0700
From: Ye He yhe@us.oracle.com
To: oraapps-l@cpa.qc.ca
Subject: Re: E-Business
I guess first of all you need to define "e-business" for your business. You
are
right, there is a lot of hype, and many think doing transactions on the Web
does
it. Oracle calls that "E-Commerce" and considers it a subset of
"E-Business."
E-Business by Oracle's definition includes optimizing your supply chain
(Supply
Chain Management), reaching out to your customers (Customer Relationship
Management), automating your operations (ERP), better decision support
(Business
Intelligence, Data Warehousing), etc. And of course, the Web/Internet is the
most popular medium for conducting e-business. Oracle does offer a full
suite of software that supports the whole cycle. To name a few, ERP (NCA,
or Internet Computing as it is termed now), CRM 3i, Supply Chain Management,
OFA, Express, Discoverer, sell-side e-commerce apps such as
iBill/iPayment/iStore/Web Customers, etc.
Hope this helps.
Ye
EBCDIC - Oracle Number conversion To
Date: Tue, 14 Sep 1999 15:45:50 -0700 (PDT)
From: Rajesh TL priyarajesh@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Oracle Number To EBCDIC.
Hi All
I am writing a script that writes data into
a file from Oracle HRMS.
The data file is being fed back into a mainframe
based System.
Mainframe understands dollar amounts in
EBCDIC format.
How do I convert Oracle Numbers into
EBCDIC format
Please note that EBCDIC formats use the last
right most decimal value to indicate both the
sign and the value.
I looked at CONVERT function and tried a few
examples . They all gave wierd answers
If you want an example then it is
Oracle Number +12.31 Or +1231 (99v99)
EBCDIC Number 123A
Oracle Number -12.31 Or -1231 (99v99)
EBCDIC Number 123I
Where A denotes (+ 1)
and I denotes (-1)
Please throw some light on how I can use
CONVERT or any other function
to get the right format.
Thanks
Rajesh
Interface Development
Date: Fri, 15 Oct 1999 15:38:14 -0400
From: "Bartoletti, Mike" BartolMi@rf.suny.edu
Subject: Interface: Development
We are in the beginnning stages of designing interfaces to and from Oracle
Applications release 11.03. I have done a lot of development in the past
into oracle databases and just had cron kickoff sqlloader scripts that
loaded the data into temporary tables and then kickoff sqlplus scripts to
load the data into the productions tables using business logic. I used
developed message tables to log errors that occur. Is there any other
process to be used for Oracle applications that is already defined. I am
trying to figure out the fnd_message package and see if it is something I
want to use. Any information would be helpful.
Michael Bartoletti
Applications Development Project Leader
Research Foundation of SUNY
(518)434-7204
work - mailto:bartolmi@rfsuny.org
home - mailto:barto@nycap.rr.com
Date: Sat, 16 Oct 1999 10:03:21 -0400
From: kewishls@mindspring.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Interface: Development
Michael,
Oracle Applications have standard API (Application programmable interfaces)
which allow you to populate an interface table, then run a concurrent
process to bring the data into Oralce. You should at least look at the
Oracle Financials Interface manual to see if there are some interface tables
that already exists for import.
For example :-
Item interface to bring part numbers into the item master and organizations.
Bill and routing interface
Customer interface to bring in customer and site information.
Autoinvoice to bring invoice information into Recievables.
Transactions interface to bring any inventory transactions into Inventory.
WIP mass load interface to import work orders
These are just a few............the great thing about these interface tables
is that the application actually does the error checking and reporting for
you on import and most of the Inventory, receivables functions actually
allow you to view the errors (and in some cases change the data) on-line
through the applications.
I have used these interfaces numerous times to bring in legacy data as a
one-time deal, but also to bring in data (invoices from an external billing
system) once a day.
In all cases, as you mentioned, I used a temporary tables to sql load and
store the data and then fetch ids from Oracle before loading the interface
tables and importing the data.
Hope this helps, as I say the Interface manual is very helpful.
Louise Kewish
Senior Principal - Manufacturing and Distribution Apps
TSC
Dallas, TX
Date: Sun, 17 Oct 1999 15:13:48 -0400
From: Steve Harper steve.harper@pragmatek.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Interface: Development
Michael,
It depends on what apps you are interfacing to. A number of the apps have
standard API's (GL, AP, AR, Purchasing, Order Entry, etc.) with their own
interface tables and import programs. These are all documented in the
Oracle Open Interfaces Manual.
Steve Harper
PRAGMATEK Consulting Group, Ltd.