May 2006

ARXRWMAI problem

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,
|

11.5.10.2 fix for AR Autoinvoice when more than 20000 rows

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
|

Backup issue, locks etc.

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,
|

Problem with diskspace on isspoa2

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)
|

Cost Manager

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