Upgrade 7.3.4 - Report Generator
Date: Sat, 12 Jun 1999 09:48:44 -0400
From: "Gow, Tony" GOWA@tc.gc.ca
Subject: Gen: dba upgrade 7.3.4 - Report Generator
We are on 10.7.SC. DEC UNIX OSF1. We are upgrading from 7.3.3.5 to 7.3.4 and
I am having a problem with the Interoperability patch. Specifically when I
run Step 12. Update Oracle Application Files (Task 7 Generate report files),
the adadmin utility is not updating our customized rdf files.
Our workaround is to regen the rdf's manually using the adrepgen utility.
The syntax I am using is:
adrepgen userid=APPS product="tc" filepath="srw"
The utility starts up and call the first rdf and then just hangs.
The main difference between our custom rdf and Oracle rdf directory is that
Oracle has a log and rex file for each rdf whereas we only have an rdf file.
1. Is there something wrong with my syntax???
2. Is there somewhere I can look (log file) to see what the adrepgen utility
id doing?????
3. Is there anything else I need to know to make this work???
Thanks
Date: Tue, 15 Jun 1999 08:13:35 -0700
From: "Halcyon" jimll@halcyon.com
Subject: Re: dba upgrade 7.3.4 - Report Generator
Tony,
1) I've always used something like this:
adrepgen userid=userid/userpassword product="mrp"
filepath="srw/MRPRPPIT.rdf" to compile a single report
adrepgen userid=userid/userpassword product="mrp" filepath="srw" to
compile a all reports in the product folder
2) Check $APPL_TOP/install/log/adrepgen.log for a trace of adrepgens actions
3) I would imagine that any customized reports would have to be generated
manually so I'm not surprised.
Jim Leavitt
R11 upgrade - Open orders must be closed?
Date: Mon, 14 Jun 1999 14:03:11 +0900
From: kameoka@mkb.fujikura.co.jp
Subject: R11 upgrade - Open orders must be closed?
We are planning to upgrade Oracle Manufacturing from R10.7SC Prod16.1 to
R11.02 on HP-UX as soon as possible. We are in Make-to-Order business. One
big question which has not been answered clearly by Oracle or SI vendor yet
is if all open orders (OEs, POs in particular) must be closed before
migration. If so, how can it be done? For example, if all open POs, either
not shipped at all or partially shipped, must permanently closed (that is
only way we are aware of for closing), we won't be able to upgrade for ever!
We feel this cannot be right.
Can anybody share your experience with us?
Tak Kameoka
Information Systems, Fujikura Ltd.
tkameoka@fujikura.co.jp
Phone: +81-3-5606-1243
Fax: +81-3-5635-2084
Rel. 11.02 supports Forms 6.0?
Date: Mon, 14 Jun 1999 07:39:44 EDT
From: shibu Joys shibu_joys@hotmail.com
Subject: Does ORacle Apps 11.02 support Forms 6.0 ?
Hi Guys,
Does Oracle Apps 11.02 support both forms 4.5 and FOrms 6.0 ?
TIA
Shibu
Upgrade from 10.7 SC to 11.0.2
Date: Wed, 16 Jun 1999 18:45:34 EDT
From: shibu Joys shibu_joys@hotmail.com
Subject: Upgrade from 10.7 SC to 11.0.2
Hi Guys,
We are currently on 10.7 SC and i have couple of questions for you guys.
For upgrading to 11.0.2 , do we need upgrade to 10.7 NCA first and then to
11.02 NCA ?
How much time does it take to do such an upgrade if we have just two
financials modules (GL and AP) running with just 2 yrs of data. ?
Is it possible to just bring the Vendors/Employee and Accounts info from
10.7 and import it into 11.02 (fresh installation) ?
Is it possible to convert the 10.7 transactions for GL and AP to 11.0.2 and
do not do a full upgrade?
TIA
Shibu
Date: Thu, 17 Jun 1999 12:46:23 -0500
From: "Fischer, Craig J." FischerCJ@bvsg.com
Subject: RE: Upgrade from 10.7 SC to 11.0.2
We were in the same situation (wanting to go from 10.7 SC to 11.0.2). You
do NOT need to go to 10.7 NCA first; the Release 11 upgrade process doesn't
care what type of user interface you've been using (char, SC, or NCA).
The time needed to do the upgrade can be looked at two ways: the total time
necessary to plan and schedule the upgrade, or the time needed to run
autoinstall, etc. Our upgrade took about six months of pretty dedicated
effort from the whole team. To actually perform the Production upgrade took
about 48 hours in our environment (IBM SP2 servers, ~4 GB database); this
includes all the pre- and post- upgrade manual steps, the database upgrade
(7.3.4 to 8.0.4), running autoinstall, applying 11.0.2, and re-implementing
our customizations.
It would be possible to bring the vendors/employees/accounts from 10.7 into
a new, fresh, 11.0.2 installation, but it would be like a legacy system
migration; i.e., there's no built-in way to do this. You'd either have to
re-key it all in or write customized migration programs to load the various
tables.
And if I understand the last question correctly, there's no way to upgrade
GL and AP to 11.0.2 while leaving other modules alone. All modules in the
same database must be upgraded at the same time.
I'm preparing a paper for the fall OUAG about our Release 11 upgrade
experience (we went live last February), so feel free to contact me for more
info.
Craig Fischer
BV Solutions Group
fischercj@bvsg.com
x-------------x
From: Krishna Bangalore [SMTP:vkkrish@hotmail.com]
Date: Mon, 19 Jul 1999 12:20:53 -0500
From: "Fischer, Craig J." FischerCJ@bvsg.com
Subject: RE: Reg : Migration from 10.7SC to 11.0.2 NCA
We went through this exact upgrade last February. To answer your questions,
there are two ways to judge the time involved: (1) total time for the entire
upgrade planning/testing/etc. process, or (2) time required to perform the
upgrade steps themselves. At our site, it took roughly six months of
dedicated work to get ready for Release 11; this will very greatly based on
staff size, number of modules, experience level, amount of customizations,
etc. The actual upgrade process took just over two full days to complete.
The Release 11 shipment contains many manuals that describe all the steps
necessary to upgrade. It can be sort of overwhelming, so be prepared to
spend lots of time figuring out which steps are necessary for your site and
which ones aren't.
As for a step-by-step process, I am preparing a paper for the fall OAUG that
will include a detailed task list of the steps we used. However, this is a
list for the actual production upgrade itself (scenario #2 above) and does
not address in the same detail the process necessary for the overall upgrade
(scenario #1). Even that list, though, will vary greatly from site to site
and is meant to be used as a guide.
Craig Fischer
BV Solutions Group
fischercj@bvsg.com
x-------------x
Date: Wed, 21 Jul 1999 15:30:00 -0400Populating link_to_line from a 10.7 to rel 11 conversion
Date: Fri, 18 Jun 1999 16:22:34 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: populating link_to_line from a 10.7 to rel 11 conversion
Desparate!
Hello all,
We have the unique distinction of having to migrate from 10.7 to 11
the hard way. In otherwords, we have to do a full conversion (impliment
multi-org due to merging several instances into one, etc.) This means
I have to work backwards from the 10.7 data to generate ra_interface_lines
records. The link_to_line_attribute1-15 columns are alleged to have a
destination of NONE in the oracle documentation! So I don't know where
to pull the data from. I thought, how about the attribute1-15 of the related
line in ra_customer_trx_lines as indicated by the link_to_cust_trx_line_id
column in ra_customer_trx_lines? But there is not a single value in any
of the attribute1-15 columns in ra_customer_trx_lines. So, for my tax
records, how do I get the link_to_line_id info to populate my REL 11
ra_interface_lines table?
Your help is greatly appreciated!
Tom-
9.4 to 10.7 - Modules AK & AX Fail to install
Date: Tue, 22 Jun 1999 15:19:48 +0100
From: "Maxwell, Scott" smaxwell@ordsvy.gov.uk
Subject: Financials Upgrade - 9.4 to 10.7 - Modules AK & AX Fail to instal
Hi,
Can anybody shed any light on a problem during upgrade from 9.4 to 10.7.
Having run Autoinstall the core modules "AK" & "AX" fail to install fully
(they install "shared").
We have already applied the patch 526700 & tried to install fully in release
10.7 but this didn't correct the problem.
Has anybody experienced this before and what was the solution?
(Running AP, GL & PO on Sun Solaris)
Thanks in advance for any help you can provide.
Scott
Date: Tue, 22 Jun 1999 11:51:59 -0500
From: "Wilfredo Gallegos" Wilfredo.Gallegos@Kellogg.com
Subject: Re: Financials Upgrade - 9.4 to 10.7 - Modules AK & AX Fail to
Scott,
I had same error when upgrading from 10.4.2 to 10.7 Char on a Digital
Unix environment.
it was the TAR command version. something related with the PAX version.
the 10.7 CD brings a new version of "cpio" ant "tar"... but i do not
know if
is thsame for Solaris...
you may want to check that out
Wilfredo Gallegos.
Recompiling reports after upgrade
Date: Wed, 30 Jun 1999 12:24:31 -0700
From: "McClung, Ed D." EDMCCLUNG@ESCOCORP.com
Subject: Memory Fault when re-compiling reports
We just upgraded our database from 7.3.3.4 to 7.3.4.4, and applied the
Apps. interoperability patch
which runs on DEC ALPHA UNIX. Part of the upgrade process is to
re-compile all the reports,
however the object "r25convm" which performs the compile errors out with a
"memory fault".
I have had a open tar with Oracle for over a week now and they have not
been able to come up
with a solution,,, so help,,, anyone had this,,,seen this,,,or any
ideas???
Thanks for any help in advance,,,
Ed McClung
Ed McClung
Database Administrator
ESCO Corporation
(503) 778-6275
(503) 778-6754 (Fax)
(503) 599-4813(pager)
edmcclung@escocorp.com
http://www.escocorp.com
Date: Wed, 30 Jun 1999 15:25:42 -0500
From: Jerry Hess JHess@amctheatres.com
Subject: RE: Memory Fault when re-compiling reports
Ran into the same problem. I ran the following: adrelink ranlib=y force=y
"ad all" to relink the executables and that fixed it. HTH.
Date: Wed, 30 Jun 1999 16:15:38 -0500
From: Srini Chavali Srini.Chavali@Cummins.com
Subject: Re: Memory Fault when re-compiling reports
Ed,
Before running the re-compile, set ulimit to at least 500K. Issue the
following after signing on as applmgr ulimit -d 500000
Typing just ulimit will show your current value.
This parameter governs the amount of memory allocated to processes.
HTH
Srini Chavali
Oracle DBA
Cummins Engine Co
10.7 to 11 cash receipts conversion
Date: Tue, 6 Jul 1999 09:58:25 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: 10.7 to 11 cash receipts conversion
Hello conversion specialists:
If you've seen my questions lately, then you know that I am trying
to convert receivables data from multiple 10.7 instances into a single
rel 11 instance using the multi-org feature of the application. A
requirement is that the data be converted through the interfaces, even
though it's Oracle to Oracle. In other words, I can't just go table to
table and populate the org_id as I go.
So I have come to cash receipts, and I want to capture as much of the
history as I can (since I have to bring over closed invoices etc.) The
invoices will be brought over as open, and then I will reapply the cash
receipts through autolockbox to close them out. At least this is the
theory....
In order to accomplish this, how do I pull the data from
ar_cash_receipts_all,
ar_receivables_applications and ar_cash_receipt_history in order to
get autolockbox to apply the receipts the way I want it to?
Your help is greatly appreciated!
Tom Orth
torth@sequent.com
R10.7 on Oracle 8?
Date: Wed, 7 Jul 1999 09:50:10 -0700
From: Jeff Maurer jeff.maurer@infocus.com
Subject: r10.7 on Oracle 8? Anyone? Anyone?
We're currently outlining our Oracle Applications migration plan for the
next year. One of the options we've discussed is to go to Oracle 8 RDBMS
first, retaining r10.7 of the Apps. Then migrate to r11 subsequent to that.
The rationalization is that Oracle 8 may be a more solid platform in the
interim since that's likely where the development resources are going, and
our v7 RDBMS has had a number of patches applied - increasing our level of
concern about robustness.
Is anyone running under the r10.7/Oracle 8 configuration in production? Any
notable issues?
We're on a Sun E-5000.
Thanks in advance for your time and effort!
Jeff Maurer
Mgr., Applications Development, IT
InFocus
Date: Wed, 7 Jul 1999 13:46:47 -0700
From: "Li, Qun" Qun.Li@fluke.com
Subject: RE: r10.7 on Oracle 8? Anyone? Anyone?
Jeff,
We are running in r10.7 with Oracle 8 server partitioning just over one
year. This is on HP but I think it will work for SUN as well. The only
notable issue was the OEORPC listener has to come from the 7.3.x home NOT
8.0.x. Let me know if you have further questions.
-- Qun
Date: Wed, 7 Jul 1999 20:28:51 -0400
From: tpapaleo@hearst.com (Tom Papaleo)
Subject: Re: r10.7 on Oracle 8? Anyone? Anyone?
yes, 8.0.5 server partitioned with 7.3.4 on a Sun running 10.7/16.1
for about a year or when 8 first released. no rdbms issues just the
normal problems with the applications
Date: Thu, 8 Jul 1999 08:57:33 +0100
From: Graham Duggan gjduggan@mail.com
Subject: RE: r10.7 on Oracle 8? Anyone? Anyone?
8.0.4.3 server partitioned with 10.7 NCA on E5000s. We were straight
8.0.4 for a very long time with no significant issues as most of the
patching relates to the newer functionality such as partitioning which
are not used by the applications in a standard install. We did find some
curious PL/SQL performance problems when we started using Global
Accounting Engine in anger which had everyone stumped for a while. The
upgrade to patch set 3 smoothed the way for us.
V8 with applications was a bit wobbly when we first started using it as
support/development were only just coming to terms with its
idiosyncrasies, but I have to say that I have been impressed with the
stability and stunning lack of problems associated with the RDBMS after
about August last year. I do still come across people in support who are
uncomfortable with the concept of server partitioning but this is
becoming less of an problem.
On choosing the version of 8, look at the certification matrices. I have
not looked lately, but our decision to go 8.0.4 was based on
* this being the highest version certified against 10.7
* certification was also available against 11
* the product was new enough to be supported for the next few years
* the product was old enough that we could count on a good base of
knowledge from others testing (i.e. we were not leading and bleeding)
The upgrade should be very straight forward. There are interoperability
patches you will need to apply to the application. The application will
still be compiled against your existing oracle installs for D2000 1.3.2
and 1.6.1. Take care with the configuration of the listeners and
tnsnames files. Remember you probably have other devices (i.e. PCs) that
also connect using SQL*Net. Think about how to manage the TWO_TASK
environment variable.
Don't forget to test, take a backup and give yourself plenty of time to
get the job done.
That is about all I can think about off the top of my head.
Graham.
Date: Thu, 8 Jul 1999 14:58:34 EDT
From: RBoren7458@aol.com
Subject: Re: r10.7 on Oracle 8? Anyone? Anyone?
FYI -- On June 9 Oracle issued a desupport notice for 8.0.4. Normal support
will end on March 31, 2000. This was issued in note 69788.1 on metalink.
Rickey
2-Tier to 3-Tier
Date: Wed, 07 Jul 1999 14:59:10 -0400
From: "Jim Gehl" JGehl@smtp-gw.lsuc2.lsuc.on.ca
Subject: 2-Tier to 3-Tier
We are planning to go into production with Oracle Applications 11.0.X ,
Oracle 8.X and Oracle Web Application Server 3.X this October in a "2-Tier
environment" (everything on one server) .
My question is ....
Is it easy to move from a 2-Tier environment to a 3-Tier environment in =
the future without having to re-install all the software?
Can I just move (ftp) files from the main tier to the new tier and then =
relink ??
Assumption
I would have to install the Oracle Web Application Server and Developer/200=
0 Forms on the new tier.
If anyone has actually done this or has considered this I would be =
gratetful for any input.
thanks
Jim Gehl
Database Administrator
The Law Society of Upper Canada
Barreau du Haut-Canada
(416) 947-4045
jgehl@lsuc.on.ca
Date: Wed, 7 Jul 1999 15:26:34 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: 2-Tier to 3-Tier
We are currently two tier with plans to possibly move to three tier in the
next 6 months or so. We have already written the project plan assuming ftp
of all applications files. We don't even plan to install the web server or
D2K. We would simply ftp ORACLE_HOME and APPL_TOP to the new server. This
plan has been blessed by Oracle Consulting. So, it is supposed to work, and
I see no reason it would not, as long as you aren't using NT. Our platform
is HP-UX.
Date: Wed, 7 Jul 1999 17:13:08 -0400
From: Steve_Deackoff@air-water.com (Steve Deackoff)
Subject: Re[2]: 2-Tier to 3-Tier
I have had the pleasure of doing what you are planning.
Database Tier and Middle Tier on one Sun Solaris 2.6 then
Splitting the Middle Tier onto another Sun Solaris 2.6 machine
On Sun Solaris 2.6, you cannot just copy the ORACLE_HOME of the Web
Server. I did try, but it was easier to reinstall the Web Server
portion. And re-enter the web listener stuff.
FYI, I did FTP everything and then reinstalled the Web Server in the
existing ORACLE_HOME. Everything else FTP'd fine.
There is setup stuff that is server dependent when you setup the web
listeners. (Node name to mention one).
I found it easier to reinstall than to try and find all the affected
files and vi them.
Steve Deackoff
Oracle Applications DBA
P.S. I also have had the pleasure of doing same with Windows NT as
Middle tier for grins and giggles (Actually we are in the middle of
benchmarking performance)
Date: Wed, 7 Jul 1999 15:04:50 -0700
From: skirby@bco.com
Subject: RE: Re[2]: 2-Tier to 3-Tier
Maybe I am missing something ...
Why do an ftp of all the apps files and then relink? I would rather just do
a full install of the middle tier from CD. Get everything set up and run
with both systems for a while. Switch users over as demand comes up. Leave
the middle tier on the database server for a while as a back up after you
switch everyone over to the new middle tier.
You need no downtime on the DB server. You do the install into dev, and
then 'point' the system prod when you decide to go live. There aren't any
concerns with copying 'extra' DB files out of ORACLE_HOME. And it is a good
time to put together a 'clean' system. I know our system has bits of junk
all over the place from half-done development and crisis correction scripts.
The only difficulty would be in applying all of the patches to the new
middle tier, but that is not too unreasonable. It would be a bit faster to
do an ftp transfer, but I don't think it is worth the hassle.
And on a side note:
I'd like to see your benchmarks on the NT server. Our performance on out
test NT boxes seems slow ... but we haven't tried various hardware
combinations yet or any true benchmarking. We had 256MB RAA and 2 300Mhz
processors.
Steve Kirby
skirby@bco.com
x-------------x
Date: Thu, 8 Jul 1999 00:18:17 EDT
Date: Thu, 8 Jul 1999 10:12:42 +0530
From: "Chitti Babu" cbabu@satyam.net.in
Subject: Re: 2-Tier to 3-Tier
Hi
Ye we tried the concept of Parallel Concurrent Managers by keeping APPL_TOP,
Concurrent managers in one machine, Database running in other machine. You
are likely to get some advantage especially when there are more reports
submitted. Please e-mail me directly with your configuration of nothe the
servers.
Thanks
Chitti