Delfi Konsult

Software is already installed, so the only steps remianing are the Apps part.

1. eulapi -CONNECT isseul/xxxxx@DEVL -AUTO_UPGRADE
-connect <**********>
-auto_upgrade
Command completed.

2. Merged all necessary patches... see ~DEVL/patches/Discoverer_10/merged_Dis(containing 5765314 6459796 3133021 6430269)
applied merged patch.

3. Failed on the icxwtab.odf driver... see Metalink note 430673.1: Icxwtab.odf Failed Applying Patch 5473858
run the script: sqlplus -s apps/xxxx @$ICX_TOP/sql/ICXDLTMP
and a recurrent program should be started at regular intervals: The name of the program is "Purge data from temporary table".

4. Needs to relink: adrelink.sh force=y "fnd f60webmx" "fnd ar60run" "fnd ar60rund"
and regenerate JAR-files.

5.

1. Patches on OA_PROD
2.1 4777762 INVTTMTX - ORG TRANSFER -TRANSIT - SERIAL TRIGGERED - FROM NON LOT TO LOT
4777762 Norwegian
1,5 hour
2.2 4719658 ONE OFF PATCH FOR MISSING RESPONSIBILITIES
4719658 Norwegian
1,5 hour

1. Ran autoconfig for the DEVL instance(was a copy of OA_PROD from 14 days ago needed for ErgoGroup)
2 hours
2. Patches on OA_TEST
2.1 4777762 INVTTMTX - ORG TRANSFER -TRANSIT - SERIAL TRIGGERED - FROM NON LOT TO LOT
4777762 Norwegian
1 hour
2.2 4719658 ONE OFF PATCH FOR MISSING RESPONSIBILITIES
4719658 Norwegian
1 hour

1. request to install patch 6272107 in OA_TEST from Runar Skjarpe .....
There was quite a number of Pre-reqs.......

5754009
5754009_N
5754117
5847634
5847634_N
5879390
5879390_N
6074164
6074164_N
6272031
6272107
6447026

1. 4755166 ONE OFF/BACKPORT REQUEST FOR BUG 4657514
1 hour for OA_TEST
1 hour for OA_PROD

1. have followed the guidelines in the "Guidelines to setup the JVM in Apps 11i " Doc ID: Note:362851.1 So from:
# orig wrapper.bin.parameters=-verbose:gc -hotspot -Xmx512M -Xms128M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB
to:
wrapper.bin.parameters=-verbose:gc -hotspot -Xmx640M -Xms256M -XX:MaxPermSize=128M -XX:NewRatio=2
-XX:+PrintGCTimeStamps -XX:+UseTLAB -XX:+UseParallelGC -XX:ParallelGCThreads=2

but there has to be more HP-UX specific parameters.....

1. There is a problem with getting "signal 10" for POXPRPOP report.. have raised SR: 6333635.994

1. to get the synchronization of userid's etc working between E-Business and 10AS, there are a number of "hoopla's" that needs to be done between the 10AS and E-Biz....

see: Metalink note: `Disabling Profile With oidprovtool Fails With "Unable To Get Guid Of Entry"
Doc ID: Note:391219.1
and: Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On Doc ID: Note:261914.1 in particular pages 69- "Migrating Data between Oracle E-Business Suite Release 11i and Oracle Internet Directory"


and then do
"oidprovtool.sh" (modify the 10AS as described in the doc above)
"AppsUserExport.sh" (script to export all Apps users from the Apps user account)
"ldifmigrator.sh" (convert from exported file to a file that 10AS can read)
"opmnctl stopall" (stop all ldap processes"
"bulkload.sh" "import all APps users"
"opmnctl startall"
"provsubtool.sh"

The last step errors out.... Have raised SR: 6348905.992: Problem with Integrating Oracle Apps and Oracle 10AS

Following Doc ID: Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i, Doc ID: Note:233436.1

Opened SR: 6340810.992 as there is an error trying to apply this...
! 4775907 FND: 11i.ATG_PF.H RUP4 SSO 10g Integration

- 5589902 TXK: SSO REGISTRATION FAILS IS GOT SPACE IN COMPANY NAME

Symbol Legend
-------------
!: Unapplied prerequisite patch.

Well.. it appears that the 4775907 has to be appied although all documentation indicates otherwise.....

4775907 FND: 11i.ATG_PF.H RUP4 SSO 10g Integration
4775907 Norwegian
1 hour
5589902 TXK: SSO REGISTRATION FAILS IS GOT SPACE IN COMPANY NAME
30 minutes

run "$HOME/bin/ldapsearch.sh" in the ora10G account
run " txkrun.sh" in the Apps account(patches directory)


and after you need todo:
a) Generate message files
b) Compile APPS schema(s)
c) Compile flexfield data in AOL tables
d) Compile Menu Information
1 hour

That completes the SSO installation...

Following Doc ID: Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i, Doc ID: Note:233436.1

1. Patches on the DEVL instance:

5989593 - AD: 11i: Remove "REVOKE ALL FROM PUBLIC" from ADGRANTS.SQL
5989593 Norwegian
1 hour
4252319 LANGUAGE FILE SETUP FOR BNE.D(3218526) PATCHSET
15 minutes
3218526 BNE: Patch 11i.BNE.D - Refer to About Web Applications Desktop Integrator Mini-pack 11i.BNE.D, OracleMetaLink Note 287080.1, for installation instructions.
3218526 Norwegian
30 minutes

and Reports Manager.....

3761838 Patch 11i.FRM.G
3761838 Norwegian
30 minutes

4206794 FRM: Patch 11i.FRM.H - Refer to About Oracle Report Manager Minipack 11i.FRM.H, OracleMetaLink Note 378338.1, for installation
4206794 Norwegian
1 hour

3854951 FSG XML PUBLISHER FUNCTIONALITY FOR R11i
3854951 Norwegian
30 minutes

5473858 11i.ATG_PF.H.RUP5 (which is a MAJOR pre-req step)
6 hours
5473858 Norwegian
45 minutes

Failed on icxwtab.odf(See Note: 430673.1)
Solution
To implement the solution, please execute the following steps:
1. Please run the purge program:
a. The name of the program is "Purge data from temporary table".
b. The internal name is ICXDLTMP.
c. Also you can find this SQL script under $ICX_TOP/sql (named ICXDLTMP.sql). count of reows before run approx 224000 after: 0
d. rerun icxwtab.odf
end-of-solution.

Following Doc ID: Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i, Doc ID: Note:233436.1

1. Do "Pre-Install Task 5: Install OracleAS Identity Management Infrastructure 10g (10.1.4.0.1)"
5 hours (including download time)
2. check for creation of user "dummy_user" : all ok!
3. Do the section: "SSO Task 1: Install E-Business Suite SSO 10g Integration Patch and fix 5589902"

Following Doc ID: Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i, Doc ID: Note:233436.1

1. Check for httpd is ok within Oracle Apps:
"./httpd -v
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Mar 17 2005 16:59:19 (iAS 1.0.2.2.2 rollup 5)"
is ok
2. DBMS_LDAP is installed in the database.
3. Downloading software: Oracle Identity Management 10.1.4.1 (takes forever finding the right software.....)

1. Followup and phone-conversations with Per Christensen

1. Got a request from ISS Norway about high performance load on isspoa2... and the culprit was not Oracle processes, but two runaway "root" processes.. one "sam" process and one "midaemon" process.... Asked Per Christensen to "kill em" .....

1. Followed Metalink Note: Using J2SE Version 5.0 with Oracle E-Business Suite 11i, Doc ID: 304099.1
CSC had installed Java 1.5.0_06(SDK version)
stopped all services
2. 4372996 J2SE 5.0 consolidated patch
4372996 Norwegian
1 hour
3. All post-install steps from the Note:
2 hours

1. Followed Metalink Note: Using J2SE Version 5.0 with Oracle E-Business Suite 11i, Doc ID: 304099.1
CSC had installed Java 1.5.0_06(SDK version)
stopped all services
2. 4372996 J2SE 5.0 consolidated patch
4372996 Norwegian
1 hour
3. All post-install steps from the Note:
2 hours

and the same show all over for OA_TEST ....

1. 5389023 1OFF:5389023:11.5.10:MRUP1: CAN NOT UPDATE THE TASK PERCENT COMPLETE BY API
15 minutes
NB NB NB: This patch does not install correctly as the version already installed of the PAPMSTPB.pls statement is newer compared to the patch, so it will
have to be moved in manually.... but Runar will open a SR, and request an update to the patch.....

1. Looked throught the document "Application Server Tuning for the E-Business Suite " by Ahmed Ahlomari, Oracle, where there was a number of recommendations
that all have been implemented on the DEVL, OA_TEST and OA_PROD. Most notably is was _strongly_ recommended to upgrade to Java 1.5.0, and some suggestions from the Metalink Note: 275875.1 Oracle Application Framework Troubleshooting Release 11i (11.5.10) about raising the Java values when running into the error:

"Why am I getting java.lang.outOfMemory errors and what can I do to fix them?
OutOfMemory exceptions are thrown when the JVM runs out of heap space. Make sure that you have allocated enough memory for your JVM. Check the following entry in the jserv.properties file to make sure you the appropriate heap size range was specified. Here's an example of the how the heap size is specified in the jserv.properties file.
wrapper.bin.parameters=-Xms255m -Xmx400m
You should also make use of the AM Pool monitor to keep track of memory consumption as various applications are used. It will help you determine if the application is behaving abnormally, or if the JVM heap size needs to be adjusted."

1. 5666001 1OFF:11.5.10MRIII:5616574:BAD PERFORMANCE WHEN UPDATING TASK ON RUP3
15 minutes

1. A lot of issues with the isspoa2 system during the day....
Fixed some with patch 5258340 : Metalink: Note:377696.1 You Have Encountered An Unexpected Error Under Financial Tab Tasks Page, 15 minutes

1. 5582197 1OFF:ER:11.5.10MR3: SUPPORTING NEGATIVE QUANTITY / AMOUNTS IN BUDGETS & FORECASTS AND PROJECT PERFORMANCE REPORTING
30 minutes
2. 5662021 1OFF:5522544:11.5.10MRUP3:PROJECT PERFORMANCE SUMMARIZATION - PERFORMANCE FIXES
15 minutes
and bouncing the middle-tier

1. See "E-Business Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On"
PDF-document: from OTN
in particular pages 67 to 73... and Metalink Note: 391219.1 "Disabling Profile With oidprovtool Fails With "Unable To Get Guid Of Entry"
see the directory "~ora10G/10AS_Integration" on "isstoa1" for all scripts

1. 5612171 one-off patch for Email fixing... this patch had however a prereq 5234512, that requires Application Server 10G

1. 4554199 Import Price Catalog gives poor performance even for a small batch
15 minutes for each instance
Needs to be tested by Gerrit

1. 4905678 XDO/ORACLE XML PUBLISHER OA ROLLUP PATCH 5.6.1
4905678 Norwegian
1 hour
manual step:
cp $FND_TOP/resource/*.ttf /opt/java1.4/jre/lib/fonts/
2. 5097966 XDO/ORACLE XML PUBLISHER OA ROLLUP PATCH 5.6.2
5097966 norwegian
1 hour
3. adadmin
compile menu information, generate message files
4. restart all services....
5. Run XML Publisher Template Re-Generator concurrent program. (Required for Upgrades Only) (System Administrator)
If you are upgrading from an earlier version of XML Publisher, you must run the XML Publisher Template Re-Generator concurrent program.
Use Standard Request Submission to submit this request from the XML Publisher Administrator responsibility.
The request will prompt you for the following parameter:
Regeneration Criteria
Select "Outdated" to regenerate only outdated templates.

1. 5190472 ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR; ORA-06512: AT ''APPS.XLA_GL_TRANSFER_
5190472 Norwegian
30 minutes

1. 4905678 XDO/ORACLE XML PUBLISHER OA ROLLUP PATCH 5.6.1
4905678 Norwegian
1 hour
manual step:
cp /u01/oraTEST/appl/fnd/11.5.0/resource/*.ttf /opt/java1.4/jre/lib/fonts/
2. 5097966 XDO/ORACLE XML PUBLISHER OA ROLLUP PATCH 5.6.2
5097966 norwegian
1 hour
3. adadmin
compile menu information, generate message files
4. restart all services....
5. Run XML Publisher Template Re-Generator concurrent program. (Required for Upgrades Only) (System Administrator)
If you are upgrading from an earlier version of XML Publisher, you must run the XML Publisher Template Re-Generator concurrent program.
Use Standard Request Submission to submit this request from the XML Publisher Administrator responsibility.
The request will prompt you for the following parameter:
Regeneration Criteria
Select "Outdated" to regenerate only outdated templates.

1. 4905678 XDO/ORACLE XML PUBLISHER OA ROLLUP PATCH 5.6.1
4905678 Norwegian
1 hour
manual step:
cp /u01/oraTEST/appl/fnd/11.5.0/resource/*.ttf /opt/java1.4/jre/lib/fonts/
2. 5097966 XDO/ORACLE XML PUBLISHER OA ROLLUP PATCH 5.6.2
5097966 norwegian
1 hour
3. adadmin
compile menu information, generate message files
4. restart all services....
5. Run XML Publisher Template Re-Generator concurrent program. (Required for Upgrades Only) (System Administrator)
If you are upgrading from an earlier version of XML Publisher, you must run the XML Publisher Template Re-Generator concurrent program.
Use Standard Request Submission to submit this request from the XML Publisher Administrator responsibility.
The request will prompt you for the following parameter:
Regeneration Criteria
Select "Outdated" to regenerate only outdated templates.

In the 10G environment:
1. Applied patch 5583368Do not get confused by the README.txt... just apply the patch.. and do not mess about with the patchbundle in the subdirectory...)
opatch lsinventory:
Installed Patch List:
=====================
1) Patch 5583368 applied on Wed Nov 29 11:07:53 CET 2006
[ Base Bug(s): 5671340 ]
5 minutes ... now that I the right syntax
2. Applied patch 5583371
1) Patch 5583371 applied on Wed Nov 29 11:18:06 CET 2006
[ Base Bug(s): 5526681 ]
5 minutes
In the Apps environment:
3. 5378265 One-off for V5.7V6F to fix portlet render issues due to IAS caching
30 minutes
5378265 Norwegian
15 minutes
4. 4176598 ONE-OFF TO FIX BROKEN IMAGES IN FWK PORTLETS ON APPS 11.5.10 AND PORTAL 10g
15 minutes

1. Follow document: 305918.1
2. Upgrade Portal to version 10.1.4 (follow document B19135-01)
3. Shut down all processes: "$ORACLE_HOME/opmn/bin/opmnctl stopall" and "$ORACLE_HOME/bin/emctl stop iasconsole"
4. Upgrade using the script:
"mrua.sh -oracle_home /u02/ora10G/10G_Biz -oid_host isstoa1.csc.dk -oid_ssl_port 636
Executing mrua.pl
Running on UNIX
OracleAS Metadata Repository Upgrade Assistant 10.1.4.0.0
Enter the password for SYS:
Enter the password for SYS:
Enter the password for cn=orcladmin:
Upgrading the OracleAS Metadata Repository to release 10.1.4.0.0
Calling upgrade plugin for MRUA
Component upgraded successfully MRUA
Calling upgrade plugin for PORTAL
Component upgraded successfully PORTAL
Calling upgrade plugin for MRC
Component upgraded successfully MRC
SUCCESS: All OracleAS plug-ins report successful upgrade
Finished mrua.pl"
5. $ORACLE_HOME/opmn/bin/opmnctl startall
$ORACLE_HOME/bin/emctl start iasconsole
6. Back to document 305918.1
7. Apply JPDK One-off patch in the Apps environment: 3418272
7.1 To find the password for PORTAL see Metalink note: 198800.1

1. Have raised SR: 5961922.992 for : "ERROR WHEN TRYING TO CONNECT WEBDISCOVERER IN THE ORACLECONTEXT_E.TRC FILE"
2. Started on upgrading Portal from 10.1.2.1.2 to 10.1.4 (Follow document on Metalink: 305918.1 "Using Oracle Portal 10g with Oracle E-Business Suite 11i"
Step 1: upgrade using the "mrua.sh" ... (the services have to be running to get this working.... accdoring to the document they should be shut down)
Step 2: control the logfiles... all reporting success!
Step 3: Follow the Document

Needs a couple of patches..... that a. is obsoleted and b. is password protected... have opened SR 5980410.993 for this....
For the Apps environment:
3. 3418272: APPS: CONSOLIDATED ONEOFF PATCH FOR 30984 - VERSION 3
10 minutes
Do follow the notes for applying this.... only run the "c3418272.sh" !
4. 3615177: BUG 3615177-APPS: ONE OFF PATCH FOR XMLPARSER 904 CERT
10 minutes

1. Completed the Single Sign On part of 10G AS in connection with Oracle Apps
2. Webdiscoverer appears to function ok... there is on error with the SSL handshake for which I have opened a SR: 5961922.992
3. Portal installation... must be upgraded according to the documentation.. another 700 MB needs to downloaded.... and then follow Document: 305918.1 on Metalink.

1. Followed the document: "Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i" Note:233436.1

Ran the script: "txkrun.pl -script=SetSSOReg"
which will fail(if not precreated) on missing PORTAL tablespace: create it with the statement:
"create tablespace PORTAL datafile '/u02/oraDEVL/data/portal01.dbf' size 300M reuse extent management local uniform size 128K;"
And the output gives:

*** Log File = /u02/oraDEVL/comn/rgf/DEVL_isstoa1/sso/txkSetSSOReg_Tue_Nov_14_13_17_09_2006.log
...
...
End of /u02/oraDEVL/appl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered


2. Applied the patch 4771130:

1. We have a fix for the problem with the Framework problem after the ATG RUP patch.
Raised the SR: 5946157.992, which led to the fact that there is a known bug for this.... Bug: 5330554, and the SR refers to a fix:
"FNDLOAD apps/$appspass 0 Y UPLOAD $JTF_TOP/patch/115/import/jtfprefabcache.lct $FND_TOP/patch/115/import/US/b3664848.ldt CUSTOM_MODE=FORCE"
furthermore there are references in Metalink Notes: Note 358419.1 and Note 387061.1 After RUP4 Login Using 'Framework only' Doesn't Work

check for the values are ok after ATG RUP4:
select component_key,loader_class_name from jtf_prefab_ca_comps_b where
component_key like '%PROFILE_OPTION%';

and now finally on to the final pieces of the 10G installation......

2. Applied the Single Sign On patch
4775907 "SSO 10G Integration for 11.5.10 ATG Rollup 4 (Build 4.0)"
2 hours
pre-req for this:
5502871 afscssodmz.sql fails when SSOSDK schema absent while applying 4775907
15 minutes

1. After applying the ATG RUP 4 .... quite a number of things do not work....... most apparent are the HTML/JAVA only pages.....
It appears that there have been made changes to the installation-document after the copy that I have when installing this patch the last time....
Most notably:
having set the 9.2.0.6 Oracle_HOME run the following: @$ORACLE_HOME/appsutil/admin/adgrants.sql applsys
Apply the patch:
5452096 Re-Applying ATG RUP4 4676589 Fails on FNDDECLDIAG.LDT, OAMDIAG.LDT or EBIZSEC.LDT
5452096 Norwegian
All: 1 hour

1. Install AD I 4 (which is a prereq for ATG RUP 4, and this patch is already installed on OA_TEST and OA_PROD)
4712852 AD I 4
4712852 Norwegian
All: 1 hour
2. 4676589 11i.ATG_PF.H.RUP4
4676589 Norwegian
All: 10 hours ... have taken very long.......

1. Finally managed to get some sense out of the documentation..... the part about "Pre-Install Task 7: Test your Oracle Application Server 10g environment" finally made sense
as the port-number was 7778......
2. Created myself as a new user "neliasen" and made a successful logon.....
3. Installed the patch 4775089 "SSO 10G Integration for 11.5.10 ATG Rollup 4 (Build 4.0)"
But this requires the ATG RUP 4 patch........

1. Changed the WebDiscoverer Java engine from Java Sun 1.4.2 to Jinitiator.... but Gerrit got it fixed last night..... so no need! .. changed it back
2. Changed the postvariable as specified in the "Using Discoverer 10.1.2 with Oracle E-Business Suite 11" Metalink Note: 313418.1
3. Applied the patches:
3440628 STANDARD PATCH CONTAINING AD UTILS FOR DISCOVERER 10G MIGRATION
3133021 Latest OracleOASIS files for runDiscoverer and runReport (already applied)
3133021 Norwegian (already applied)
All: 1 hour

1. Continued on the WebDiscoverer installation... version was too new... how to back to the 10.0.2.1.2 version... sooooo.... back to downloading more than 5 Gb of data....
2. It is still very troublesome..... Errors out at the end with:

isstoa1,oraDEVL,~/10G/opmn/logs > /u02/oraDEVL/10G/dcm/bin/dcmctl createInitialBackup -v -d -o /u02/oraDEVL/10G -force
waiting for DCM daemon to start
.....
ADMN-906052
Base Exception:
The DCM Daemon has failed to initialize in the allotted time.
Resolution:
Check the opmn and dcm logs. If the cause cannot be determined, please, contact Oracle support.
oracle.ias.sysmgmt.exception.DcmCmdLineException: Base Exception:
The DCM Daemon has failed to initialize in the allotted time.
Resolution:
Check the opmn and dcm logs. If the cause cannot be determined, please, contact Oracle support.
at oracle.ias.sysmgmt.cmdline.DcmCmdLine.waitDaemonUp(Unknown Source)
at oracle.ias.sysmgmt.cmdline.DcmCmdLine.checkInit(Unknown Source)
at oracle.ias.sysmgmt.cmdline.DcmCmdLine.execute(Unknown Source)
at oracle.ias.sysmgmt.cmdline.DcmCmdLine.main(Unknown Source)

Will have to install this in an entire new user......

Have scratched the initial(second) installation..... made a new user "ora10G" from where everything will be installed.....
Installed the Oracle Applications Server 10.G release 2(10.1.2.0.2)
Had to change the listener port for OA_PROD(as 10G requires 1521), so I changed all to OA_TEST and the 8002/1523 ports
(While doing this, a problem showed for adpreclone on the dbtier: RC-40001 and RC-50409 during execution of adfcgclone.pl dbTier - Doc ID: Note:343079.1)

Installed the Oracle Applications Server 10.G release 2(10.1.2.0.2) Infrastructure.... (they have to be separate)

1. Installed the TelePay2 patch on DEVL... Following the installation documentation in the "Telepay.doc"
Prereq is the patch:
3878580 1OFF:3635616:JE.F::11.5.8:JENOPTGN.SQL GIVES WRONG OUTPUT WHEN USING NORWEGIAN C
10 minutes
Ran "./inst_telepay2.sh", and chose "Velg modul (1)Betalingsformidling " ... completed in 10 minutes

1. Followed document on Metalink: 313418.1 titled, Using Discoverer 10.1.2 with Oracle E-Business Suite 11i.
2. Downloaded the

1. WHen ISS Norway started in earnest on the PA-implementation today... a problem showed up that was quite bizarre...
They got a number of spurious errors all relating to "ORA-1801: DATE FORMAT IS TOO LONG FOR INTERNAL BUFFER"
The fix according to a number of entries on Metalink were to apply patch 3944226(which is an RDBMS patch)

1. 4712852 Minipack 11i.AD.I.4
4712852 Norwegian
All took: 30 minutes

2. 5105878 Oracle Projects Rollup Patch 3 for Oracle Projects Family Pack M (11i.PJ_PF.M) 5105878 Norwegian
see Metalink note: Note:361295.1
All: 1 hour

3. 3337098 PROJECTS ADI FUNCTIONALITY FOR 11i.PJ_PF.M
3337098 Norwegian
All 15 minutes
4. 5087961 PROJECTS ADI FUNCTIONALITY 11i.PJ_PF.M RUP3
10 minutes
5. 4609681 PERSONALIZATION PAGE ERROR OUT WHEN SELECT FUNCTION LEVEL
10 minutes
6. 4631022 UNABLE TO ADD FLEXIBLE COMPONENT TO FLEXIBLE LAYOUT
10 minutes
7. 5263859 This patch has the fix for supporting Financial Cost and Revenue Separate Plan Type in Project Performance Reporting
5263859 Norwegian
All 15 minutes
8. 5347257 1OFF:5088377:11.5.10MRI:PROJECT LIST PAGE - ERROR WHEN INCLUDING AMOUNT COLUMNS
Has to be re-installed as the RUP 3 patch have overwritten the patch 15 minutes

And....... Generate message files, Compile APPS schemas, Compile flexfield data in AOL tables, Compile menu information
restarted all services... ran "Active Users" to check everything is ok....

From the problem from last night.....
And gotten the go-ahead from Gerrit...

Have chosen the AD I 4 as there are a lot of other fixes as well.....
1. 4712852 Minipack 11i.AD.I.4
4712852 Norwegian
All took: 1 hour


1. 5105878 Oracle Projects Rollup Patch 3 for Oracle Projects Family Pack M (11i.PJ_PF.M) 5105878 Norwegian
see Metalink note: Note:361295.1
All: 1,5 hours

Update the current snapshot: 1,5 hour

2a. 3337098 PROJECTS ADI FUNCTIONALITY FOR 11i.PJ_PF.M
3337098 Norwegian
All 45 minutes
2. 5087961 PROJECTS ADI FUNCTIONALITY 11i.PJ_PF.M RUP3
required a snapshot to be taken: ran for more than 2 hours....
and then prereqs were: 3337098:
30 minutes
3. 4609681 PERSONALIZATION PAGE ERROR OUT WHEN SELECT FUNCTION LEVEL
30 minutes
4. 4631022 UNABLE TO ADD FLEXIBLE COMPONENT TO FLEXIBLE LAYOUT
30 minutes
5. 5263859 This patch has the fix for supporting Financial Cost and Revenue Separate Plan Type in Project Performance Reporting
5263859 Norwegian
All 30 minutes
6. 5347257 1OFF:5088377:11.5.10MRI:PROJECT LIST PAGE - ERROR WHEN INCLUDING AMOUNT COLUMNS
Has to be re-installed as the RUP 3 patch have overwritten the patch 15 minutes

Started on the PA RollUP 3 ... but quickly ran int a problem with "memory fault" ....
Did some research on Metalink... and it appears to be a HP-UX specific problem.... two patch options available: one specific, or going to AD I 4 minipack, which has the memory specific problem incorporated.....
Awaiting feedback from Gerrit... on when i have the system for patching....

1. 5105878: Oracle Projects Rollup Patch 3 for Oracle Projects Family Pack M (11i.PJ_PF.M) 1 hour
Norwegian, 30 minutes
see Metalink note: Note:361295.1

2a. 3337098: PROJECTS ADI FUNCTIONALITY FOR 11i.PJ_PF.M, 30 minutes
Norwegian 10 minutes

2. 5087961: PROJECTS ADI FUNCTIONALITY 11i.PJ_PF.M RUP3
required a snapshot to be taken: ran for more than 2 hours....
and then prereqs were: 3337098:
Elapsed time: 1 hour

3. 4609681: PERSONALIZATION PAGE ERROR OUT WHEN SELECT FUNCTION LEVEL
30 minutes
4. 4631022: UNABLE TO ADD FLEXIBLE COMPONENT TO FLEXIBLE LAYOUT
30 minutes

5. 5263859: This patch has the fix for supporting Financial Cost and Revenue Separate Plan Type in Project Performance Reporting
30 minutes:
Norwegian: 10 minutes
6. 5347257:
Has to be re-installed as the RUP 3 patch have overwritten the patch

1. Applied patches 5347257 4289942 ... all prerequisites were ok....

1. Applied patch for the problem with the APXTRBAL report..... patch 4468883 on all environments...

1. Applied the patch 4547182 for the production environment,as we have tested the patch on the test-environment, just recently as no adverse effects were found.....

1. We have had a problem with ARXRWMAI for quite some time..... Finally today we managed to get a proper trace-file, which have been uploaded to Oracle Support, and it appears(we still need Oracle Support to confirm this) the culprit is enqueues, which is a Unix resource... weird that this problem only appears on HP-UX and not on Solaris..... running tkprof on the trace-file as: tkprof oa_prod_ora_7537_JAHI oa_prod_ora_7537_JAHI explain=apps/xxx sort=exeela,prsela,fchela showed the problem, see SR: https://metalink.oracle.com/metalink/plsql/f?p=200:37:4645549304284338632::::p_tar_num,p_ctryCode:5343244.993,

1. A problem has arised after upgrading to 11.5.10.2:
When running Ar autoinvoice, performance crawls to a halt due to a missing index, and statistics missing.
The following needs to be done:
1. Create a index on ra_interface_lines_all(trx_number)
2. Pl. submit AutoInvoice Master with "AI Gather Stats" profile option = Yes.
3. Also make sure that "AI message level" is set to 105

1. Finally lost my confidence in the fact that the CSC India part should get the backup problems fixed.. called Thmoas Nielsen in the Storage group,
and he also confirmed that the "policies" which were a direct copy from the old isspoa1 box would never work......
2. and locks! for users MATO and CAGU... we still have the issue with the ARXRWMAI form, which is causing a lot of headache!!!
see: https://metalink.oracle.com/metalink/plsql/f?p=200:37:7254277664734253071::::p_tar_num,p_ctryCode:5343244.993,

1. Had a Prio 1 problem: 100% on the primary disks for isspoa2; problem is partly that the backup of the RDBMS has not been since the upgrade, and as such all
archivelogs remains on the system, which led to the disk being 100% full...
2. Applied patch 4901634 to the OA_PROD(isstoa1) environment; and restarted the Apache server(issue with images not being generated)

1. problem with Cost Manager in the production environment....needs testing!
2. Installed patch 4345224 on OA_PROD(isstoa1) and OA_PROD(isspoa2)

1. Started at 18:00, and cloned over the database to OA_PROD on isstoa1