ISSUE 0
Description :
ERROR IN LOG FILE
==================
The below error were getting repeated in logfile : -
***********************************************************************************************************
Process monitor session ended : 23-APR-2011 13:55:58
: Migration of ICM has completed.
Shutting down Internal Concurrent Manager : 23-APR-2011 13:56:28
The PRODEUR_0423@PRODEUR internal concurrent manager has terminated successfully - exiting.
Process monitor session started : 23-APR-2011 13:57:01
Could not contact Service Manager FNDSM_AIXSPROD_PRODEUR. The TNS alias could not be located, the listener process on AIXSPROD could not be contacted, or the listener failed to spawn the Service Manager process.
Starting Internal Concurrent Manager Concurrent Manager : 23-APR-2011 13:57:02
: Started ICM on Target PRODAPP.
Solution :
The problem was happening because in our system we are using virtual node and we are using that virtual node to configure ICM, which according to Oracle is not supported. So the solution was to remove virtual node from the concurrent>manager>define for ICM only ( let other managers run on virtual nodes) and keep it blank.
1) Remove hardcoded node name fro the ICM. In the application choose:
System Admninistrator -> Concurrent -> Manager -> Define
Query for the "Internal manager" and remove the entry for Primary Node as shown below (Primary and Secondary node should be blank). Then save the record.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 1
Description :
The MWA dispatcher port used to run on port 10305 in existing environments, but running on a different port 10316 after AIX migration.10316 is the default port of MWA dispatcher and can be easily reconfigured.
Solution :
Reconfigured the custom template under $MWA_TOP/admin/template/custom.
Modified the Context_file following the same standard as the current system on Linux. Restarted and checked ports OK.
The mwa runs on port 10200 and the Dispatcher on port 10305.
MWA Settings in Contextfile:
<mwaPortNo oa_var="s_mwaPortNo" oa_type="PORT">10200,10202</mwaPortNo>
<mwaTelnetPortNo oa_var="s_mwaTelnetPortNo" oa_type="PORT">10224,10226,10228</mwaTelnetPortNo>
<mwaDispatcherPort oa_var="s_mwaDispatcherPort" oa_type="PORT">10305</mwaDispatcherPort>
<mwaActivateLOVByEnter oa_var="s_mwaActivateLOVByEnter">TRUE</mwaActivateLOVByEnter>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 2
Description :
Custom Form "Demand Class Parameter Setup" under responsibility AEP_ADVANCED_SUPPLY_CHAIN_PLANNER errors out with “Function Not available to this responsibility” when being launched.
Solution :
Copy from the existing environments the customizations section (XX TOPs) in $IAS_ORACLE_HOME/Apache/Jserv/etc/formservlet.ini and add it in new AIX then bouncing Apache.
Also found and corrected a typo in XXDATA.
Also Checked concerned form XXMSCDC.fmx under /QATapps/QATNOAappl/xxmsc/1.0.0/forms/US/ and found .err file with below error
FRM-18108: Failed to load the following objects.
Source Module:APPSTAND
Source Object: STANDARD_PC_AND_VA ..
Recompiling the form corrected the problem.
Steps :
1) cd $AU_TOP/forms/US
2) f60gen module=/QATapps/QATNOAappl/xxmsc/1.0.0/forms/US/XXMSCDC.fmb userid=apps/g00dw1ll output_file=/QATapps/QATNOAappl/xxmsc/1.0.0/forms/US/XXMSCDC.fmx module_type=form
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 3
Description :
Discoverer is using JRE 1.4.2_06, while it should be using JRE 1.6.0_17 which is the version used in existing instances.
Solution :
1) source env file $HOME/bitier
2) copy $ORACLE_HOME/jpi/bin/j2se16017.exe from earlier instance to new AIX instance
3) backup $ORACLE_HOME/discoverer/config/configuration.xml to configuration.xml.20110126
4) edit configuration.xml and change <jvm name="sun"> section as below:
<jvm name="sun" classid="clsid:CAFEEFAC-0016-0000-FFFF-ABCDEFFEDCBA" plugin_setup="http://QATdiscoverer.global.to:7778/jpi/j2se16017.exe" version="1.6.0" versionie="1,6,0,mn" type="application/x-java-applet" plugin_page="http://java.sun.com/javase/downloads/index.jsp" disco_archive="disco5i.jarjar" d4o_archive="d4o_double.jarjar"/>
5) log in to new AIX Discoverer Plus and verify the JRE used is now 1.6.0_17
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 4
Description :
The 'Planning Data Pull' concurrent request errored out with 'ORACLE error 20100 in FDPSTP'.
Cause: FDPSTP failed due to ORA-20100: File o*****.tmp creation for FND_FILE failed.
Solution :
1) Shutdown apps then db
2) backup $ORACLE_HOME/dbs/QATNOA_qatpocdb_ifile.ora to QATNOA_qatpocdb_ifile.ora.20110127
3) edit QATNOA_qatpocdb_ifile.ora and make sure the directory pointed by APPLPTMP is the first entry on the utl_file_dir:
utl_file_dir = /QATapps/QATNOAcomn/temp,* (do not place the path listing in quotes)
4) change the directory pointed by APPLPTMP from mode 755 to 775
[oraqat@test2:/QATdb/oraqat/scripts] ls -ld /QATapps/QATNOAcomn/temp
drwxr-xr-x 4 appqat dba 8192 Jan 28 2011 /QATapps/QATNOAcomn/temp
[test2:appqat:/QATapps/appqat:] chmod 775 /QATapps/QATNOAcomn/temp
[oraqat@test2:/QATdb/oraqat/scripts] ls -ld /QATapps/QATNOAcomn/temp
drwxrwxr-x 4 appqat dba 8192 Jan 28 01:07 /QATapps/QATNOAcomn/temp
5) start up db then apps
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 5
Description :
Advanced Supply Chain Planning: Version : 11.5.0
MSCNSW module: Memory-Based Snapshot Worker
Memory Error by running concurrent request.
Concurrent request is 3185717
Error message:
/QATapps/QATNOAappl/msc/11.5.0/bin/MSCNSP
Program was terminated by signal 11
When Memory Based Planner is running, click on 'View Log' and it shows 'An error occurred while attempting to receive the output arguments of the remote procedure. Function ncrorou returned error code 3010. The Applications File Server process may have exited abnormally. Please contact your system administrator'. Check the request log on the server and it is 0 byte.
Solution :
we have received a patch from Oracle to fix the adrelinknew.sh, we used that which solved the issue.
(Oracle bug: IN ADRELINKNEW.SH AIX_LARGE_MAXDATA WAS NOT SET FOR AIX 6.1 SYSTEMS).
1) Back up $AD_TOP/bin/adrelinknew.sh
2) Apply patch 10032528 (/staging/patches/AIX/10032528)
3) Back up $AD_TOP/bin/adrelinknew.sh
4) Edit $AD_TOP/bin/adrelinknew.sh
Find line that says
AIX_MAXDATA='-bmaxdata:0x20000000'
Change it to
#the change on the following two lines are per SR 3-2907795341
#AIX_MAXDATA='-bmaxdata:0x20000000'
AIX_MAXDATA='-bmaxdata:0xafffffff/dsa'
Save the change
5) Stop applications tier
6) Use adadmin to relink all executables for all modules
7) Start applicaitons tier
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
ISSUE 6
Description :
Memory Based Planner (request id 3185919) is running forever. This job runs 5-10 mins in existing Linux instances.
Solution :
Ask UNIX to adjust all resource limits for app*/ora* user in AIX to the same as existing P environments. AIX applications/db is bounced to make the OS resource limits change effective.
Ask user/functional team to run/schedule 'Gather Schema Statistics'.
Log SR 3-2907795341 with Oracle and the final solution is:
1) Apply the solution (Oracle bug: IN ADRELINKNEW.SH AIX_LARGE_MAXDATA WAS NOT SET FOR AIX 6.1 SYSTEMS).
1) Back up $AD_TOP/bin/adrelinknew.sh
2) Apply patch 10032528
3) Back up $AD_TOP/bin/adrelinknew.sh
4) Edit $AD_TOP/bin/adrelinknew.sh
Find line that says
AIX_MAXDATA='-bmaxdata:0x20000000'
Change it to
#the change on the following two lines are per SR 3-2907795341
#AIX_MAXDATA='-bmaxdata:0x20000000'
AIX_MAXDATA='-bmaxdata:0xafffffff/dsa'
Save the change
5) Stop applications tier
6) Use adadmin to relink all executables for all modules
7) Start applicaitons tier
2) Do the following per Oracle Note 254810.1 "ASCP Memory Based Planner MSC: 64-bit Planner Platform - Additional setups" to set up the 64 bit Memory Based Planner:
1. In unix/linux, run SQL file $MSC_TOP/patch/115/sql/upd_64ex.sql as the APPS user.
2. Set profile MSC: 64-bit Planner Platform = AIX 64-bit
3. Download ora9204.tar from this document using the link below.
Copy the tar file ora9204.tar to $MSO_TOP/bin
Untar the file using tar -xvf ora9204.tar
4. Set the following environment variables for applmgr user in $APPL_TOP env file ($APPL_TOP/admin/adovars.env)
# The following two lines are added for the 64 bit planner per SR 3-2907795341
export APS64_USE_EXPORT=No
export APS64_ORACLE_HOME=$MSO_TOP/bin/ora9204
#
# End customizations
5. After changing the env file, please bounce the concurrent managers.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 7
Description :
In AIX file .ebssecure and .ftpsecure is missing under $APPL_TOP which causes some concurrent requests to fail.
Solution :
.ebssecure and .ftpsecure(including file permission) needs to be the same as the one on corresponding earlier system.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 8
Description :
Request 20986350 (XXAR: Load Forward Bookings File) fails with:
ORACLE error 20003 in FDPSTP
Cause: FDPSTP failed due to ORA-20003: Invalid operation
Request 21003085 (EDI Outbound Program) fails with:
ECE_UTIL_INVALID_OPERATION
SQL error message ORA-29283: invalid file operation
Request 20996459 (OUT: Invoice (810/INVOIC)) fails with:
ECE_UTIL_INVALID_OPERATION
SQL error message ORA-29283: invalid file operation
Solution :
Folders under $XXDATA such as $XXDATA/ar/work is not writable for db user ora*****.
Include orax510 users in group ftpuser. Include orax510 in group NOA.
Include orax710 users in group ftpuser. Include orax710 in group EUR
Also in DEV db parameter utl_file_dir does not include $XXDATA and it is fixed.
Alternative solution for this issue in AIX after closer examination of the XXDATA directory access permissions. We can run into too many security issues if we change general permissions to 777. To change the ora-users group memberships is also a simpler solution.
The db needs to be bounced after the user/group change.
The folder permission of $COMMON_TOP is also need to be checked.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 9
Description :
Request 20986679 (Corp Customer Extract and Insert Element Mapping) fails with:
ORACLE error 29283 in FDPSTP
Cause: FDPSTP failed due to ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 239
ORA-06512: at "SYS.UTL_FILE", line 1154
ORA-06512: at "APPS.XXAR_CUSTOMER_MAP_EXTRACT", line 482
Solution :
This was a custom program and problem was happening because of hard-coded value of utl_file in he code as per old environment settings
Choose concurrent -> program
Query: “Corp Customer Extract and Insert Element Mapping”
Click Parameters
Then modify value in seq. 20
Change the SQL Default Value from
SELECT SUBSTR(value,1,INSTR(value,',',1)-1)||'/data/ar/work' FROM v$parameter WHERE name = 'utl_file_dir'
To:
select SUBSTR(value,1,21)||'/data/ar/work' from v$parameter where name = 'utl_file_dir'
D only:
select SUBSTR(value,1,17)||'/data/ar/work' from v$parameter where name = 'utl_file_dir'
Also there was a ';' at the end of the select statement which caused errors when users submit the request. Fixed.
The above select should return /QATapps/QATNOAcomn/data/ar/work for example in AIX QAT.
Bounce concurrent managers.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 10
Description :
Using responsibility 'Desktop Integrator', selecting any of the seeded menu options produces the error: 'BNE_UIX_PHYSICAL_DIRECTORY is not configured'.
Solution :
Change system profile BNE UIX Physical Directory with correct value as /QATapps/QATNOAcomn/html/cabo . After that bounce the whole system. Choose profile --> system Query " BNE UIX Physical Directory" modify correct value and SAVE.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 11
Description :
Few PDF concurrent reports like
" Reprint Invoice and Credit Memo (Custom)" are giving junk characters in the output.
Solution :
There were some missing font information in the uifont.ali file lying under $ORACLE_HOME/guicommon6/tk60/admin/ . Added below fonts information and reports started giving correct output.
[ PDF ]
"Times New Roman" = Times
"Courier New" = Courier
"Times Roman" = Times
Symbol = helvetica
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 12
Description :
Users were not able to receive WF notification emails.
Trying to send notification mail through server was giving Relay Error :
RCPT TO: a.g@ Corpgroup.com
550 5.7.1 Unable to relay for a.g@ Corpgroup.com
--Same error was coming in WF log files
Solution :
Mail Outbound Server was wrongly configured as appl-smtp.global.to instead of mx0.global.to. Corrected from UNIX side also.
1) Changed appl-smtp.global.to by mx0.global.to in Workflow notification mailer configuration and also in instance context file.
2) Bounced Notification Mailers
3) Confirmed that Notification_Prefrence is MAILHTML in FND_USER_PREFERENCES and WF_LOCAL_ROLES
3) Sent Test notification which went fine.
Also
Notifications are hit and miss. Some notifications are received by users while others are not. Some notifications are processed by the mailer after quite some hours delay. In the mailer log it gives the following timeout error: oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.send(Message)]:Problem encountered when sending to {[["N, T" <T.N@ Corpgroup.com>]]} -> javax.mail.MessagingException: 421 4.4.2 mx0. Corpgroup.com Error: timeout exceeded
FOR HIS WE FOUND THAT >>>>>>
Find Processor Close on Read Timeout set to N in the mailer configuration. It is set to Y in the existing Linux instances. Change it to Y and bounce the mailer.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 13
Description :
After PO has been approved it remains in Incomplete status.
Solution :
Very specific issue. Not a general one.
XXPO invalids were there in database, which were not getting compiled
On checking the codes it was found that xxpo_accr_reco_nonzero_trans table did not exist . We created the table using following scripts.
Create table xxpo.xxpo_accr_reco_nonzero_trans as
(SELECT * FROM PO.PO_ACCRUAL_RECONCILE_TEMP_ALL A
WHERE 1=0);
Re-compliled the invalid object releated to XXPO schema and it got compiled.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 14
Description :
Could not open the 'Customers: Standard' form.
Error message:
ORA-00600: internal error code, arguments: [skkxerrp], [skkxdllload], [SlfFopen], [/QATdb/QATEURdb/10.2.0/plsql/nativelib/d77/ARP_STAX_113__APPS__S__285456.so], [No such file or directory], [], [], []
ORA-06508: PL/SQL: could not find program unit being called: "APPS.ARP_STAX_113"
ORA-06512: at "APPS.ARP_STAX", line 371
Solution :
It is caused by wrong db parameter plsql_native_library_dir Tino fixed in POC QAT on Feb 10th (received an email from Tino with subject Re: POC QATEUR ORA-00600). User may be testing before the fix thus encountered the error.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 15
Description :
Request 21034247 ( Corp Custom FTP Script to ISOM/PPC) fails with:
ar_xx_legacy_so_rlse_
Checking for ar_xx_legacy_so_rlse_ files
ar_xx_legacy_so_rlse_110211_153237.data
OracleTEST_IFS/CC_In
Login failed.
********************************************************************
FTP of ar_xx_legacy_so_rlse_ unsuccessful or No data files found - see for details
********************************************************************
Solution :
The issue is with the ftp command syntax that is coded in the concurrent program /QATapps/QATNOAappl/xxar/1.0.0/bin/XXARFTPCUST.prog. The syntax works in Linux but does not work in AIX which causes the Login failed error. It is required to change the program code.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 16
Description :
Corp customizations were not getting applied because of missing custom class path in Jserv.properties file
Solution :
Another specific issue to this client
Below custom class path was placed before the apps.zip in Jserv.properties and Apache bounced
# Corp Custom classpath
wrapper.classpath=/Dev/DevNOAappl/xxpo/1.0.0/java/ Corp.zip
NB: Changed Contextfile accordingly:
From:
<jserv_classpath_begin oa_var="s_jserv_classpath_begin"># wrapper.classpath=</jserv_classpath_end></jserv_classpath_begin>
<jserv_classpath_end oa_var="s_jserv_classpath_end">wrapper.classpath=/Dev/DevNOAappl/xxpo/1.0.0/java/ Corp.zip</jserv_classpath_end>
To:
<jserv_classpath_begin oa_var="s_jserv_classpath_begin">wrapper.classpath=/Dev/DevNOAappl/xxpo/1.0.0/java/ Corp .zip</jserv_classpath_end></jserv_classpath_begin>
<jserv_classpath_end oa_var="s_jserv_classpath_end"># wrapper.classpath=</jserv_classpath_end>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 17
Description :
XXGL Balance Details - Balances IQY went on error in case of high number of rows.
"The application encountered an invalid state.
OracleBI Discoverer Viewer was unable to find the necessary data for displaying the results of this event. "
- java.lang.OutOfMemoryError"
Solution :
1) Backup opmn.xml under $ORACLE_HOME/opmn/conf
2) Log in iAS Admin Console as ias_admin
3) Go to System Components -> OC4J_BI_Forms -> Administration -> Server Properties -> Java Options -> change -Xmx512M to -Xmx1024M -> Apply -> select 'No' when being asked whether to restart the "OC4J_BI_Forms" OC4J server now
4) Check the new opmn.xml
[test2:appqat:/QATdiscoverer/BI10g/opmn/conf:] diff opmn.xml.20110221 opmn.xml
155c155
< <data id="java-options" value="-Djava.security.policy=/QATdiscoverer/BI10g/j2ee/OC4J_BI_Forms/config/java2.policy -Djava.awt.headless=true -Xmx512M -Xms128M -Djava.io.tmpdir=/QATdiscoverer/temp"/>
---
> <data id="java-options" value="-Djava.security.policy=/QATdiscoverer/BI10g/j2ee/OC4J_BI_Forms/config/java2.policy -Djava.awt.headless=true -Xmx1024M -Xms128M -Djava.io.tmpdir=/QATdiscoverer/temp"/>
5) Bounce BI (Discoverer) tier
Note: the change must be made via iAS Admin Console. Do not manually update opmn.xml.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 18
Description :
Request “XXAU: PGP Encrypt / Decrypt File” program was completed with status Error on Dev.
This program is related to Concur.
Solution :
There is a program which uses encryption/decryption by using a piece of software called GPG
refer to gpg doc here to know more :
https://sites.google.com/site/oracledb009/gpg
So you need to export those required keys from old environments and import it here in new AIX.
1) CHECK WHICH GPG public and private keys are present in production
gpg --list-keys
gpg --list-secret-keys
2) Take Export of keys in Production instance in ascii format
public
=======
gpg -a --export sft > sft.asc
gpg -a --export StandardRegister2005-Q1 > StandardRegister2005-Q1.asc
gpg -a --export DTS 24X7 support @ 888-269-5266 > BOAD092013.asc
gpg -a --export pmiranda@issimage.com > Patrick_Miranda.asc
private
=========
gpg -a --export DL-Lockbox@ Corpgroup.com > Corp_LB.asc
gpg -a --export DL-STANDARDREGISTER@Corpgroup.com > Corp_STANDARD_REGISTER.asc
gpg -a --export DL-MEXMassPayments@Corpgroup.com > Corp_PROD.asc
3) FTP the generated file to new 510 instance
4) Import keys in new 510 instance by
gpg --import <keyname>.asc
5) Check
gpg --list-keys
gpg --list-secret-keys
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 19
Description :
Tax calculation and Invoice validation was not working fine in 510 and 710 instances.
Solution :
ISSUE : The patch 3801440 applied for one AP-PO issue has changed the view AP_TAX_LINES_SUMMARY_V definition.
One column ASSETS_TRACKING_FLAG was missing from this view AP_TAX_LINES_SUMMARY_V causing package AP_TAX_ENGINE_PKG to be invalid.
STEPS :
1) Take the view definition code form Production instance and create in new 510/710 instance.
2) Compile the package body AP_TAX_ENGINE_PKG. It should then get compiled to VALID state.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 20
Description :
Test scenario: set up new Task owning Organization
The new organization can be created and saved, but when attempting to assign classification: "Project Task Owning Organization" getting error message: ORA-01403: no data found
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1) Inventory responsibility
2) Setup>Organizations>Organizations
3) Find Operating Unit
4) Add Operating Unit classification
5) Save
Solution :
1) Please manually recompile HRLOCAL.pll
2) check .plx file permissions and make as it were before
3) Retest the issue.
4) Migrate the solution as appropriate to other environments
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 21
Description :
XXPO: European Purchase Order NLS Print concurrent request output was not coming correct. Euro symbol and few other special characters were showing as '? '
Solution :
This concurrent request with pdf output requires Albany fonts.
Copy Albany font files from $FND_TOP/resource to $OA_JRE_TOP/jre/lib/fonts.
1) cp /DEV/DEVEURappl/fnd/11.5.0/resource/ALB* /usr/java14/jre/lib/fonts/
2) [aixsd:appdev:/usr/java14/jre/lib/fonts:] ls -ltr
-r--r--r-- 1 bin bin 18473477 Mar 15 17:01 ALBANWTJ.ttf
-r--r--r-- 1 bin bin 265689 Mar 15 17:01 ALBANYWT.ttf
-r--r--r-- 1 bin bin 18788733 Mar 15 17:01 ALBANWTT.ttf
-r--r--r-- 1 bin bin 18676217 Mar 15 17:01 ALBANWTS.ttf
-r--r--r-- 1 bin bin 18777269 Mar 15 17:01 ALBANWTK.ttf
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 22
Description :
Request id 23327744 on the new QAT instance. Looking at the log file (attached) it looks like there is an installation of acroread missing.
looking for acroread on the old instances it is installed under /usr/bin.
[v-g@qat ~]$ which acroread
/usr/bin/acroread
Solution :
Here the problem which was ecountered was acroread can not be installed on AIX 6.1 OS.
> Acroread is not supported at all on AIX 6.1 platform.
> installed xpdf convertor instead of Acroread -> /usr/bin/pdftops is the path
> Testing is going on.
> Also installed the pdf2ps software on Dev AIX.
> Changed the printer style and printer driver from front end EBS to PDF PUBLISHER and PASTA_PDF respectively.
Refer to >>
How To Print XML Publisher PDF Reports Via The Concurrent Manager [ID 338990.1]
> Also change the pasta_pdf.cfg file under $FND_TOP/resource so that there is only one uncommented line
preprocess=pdf2ps {infile} {outfile}
Note that in 710 instances we are not getting this error as in 710 instance only 1 concurrent program is using CorpPDFDYNAMIC print style
> In 510 instance we have around 100 concurrent program linked to CorpPDFDYNAMIC style.
select a.CONCURRENT_PROGRAM_NAME,b.USER_CONCURRENT_PROGRAM_NAME,ENABLED_FLAG,PRINT_FLAG,OUTPUT_PRINT_STYLE from
fnd_concurrent_programs a,
fnd_concurrent_programs_tl b
where a.OUTPUT_PRINT_STYLE='CorpPDFDYNAMIC' and a.CONCURRENT_PROGRAM_ID=b.CONCURRENT_PROGRAM_ID
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 23
Description :
Invalid objects were found starting with EDW%
Solution :
All the invalid objects related to EDW were using dblinks APPS_TO_APPS or EDW_APPS_TO_WH in their codes. Post migration dblink APPS_TO_APPS was not working which caused the EDW packages to become invalid.
In the old HP db, there were three APPS_TO_APPS dblinks as below, and none of them was working. It is because they were old dblinks created when the db had a different global name from today. The EDW packages still showed as valid in the old db because they were never touched/re-complied.
APPS_TO_APPS (pointing to PROD)
APPS_TO_APPS.US.ORACLE.COM (pointing to PRODPACK)
APPS_TO_APPS.GLOBAL.TO (pointing to QATEUR)
In order to have a working APPS_TO_APPS dblink in the new AIX db, we must create one called APPS_TO_APPS.Corp.COM pointing to the same host like the old APPS_TO_APPS.GLOBAL.TO one (QATEUR).
Steps :
> Created APPS_TO_APPS.Corp.COM dblink pointing to QATEUR for the EDW packages to work
> A re-compile was done which made all EDW objects valid.
There were three dblinks found post the migration, while client only requested one dblink to be left (EDW_APPS_TO_WH.Corp.COM). The other two were APPS_TO_APPS and EDW_APPS_TO_WH.
Those two dblinks are seeded dblinks from oracle side. The db setup (global name) was different at that time, and that is why they cannot be easily dropped like other dblinks.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 24
Description :
XXAR: Invoice Outbound Interface
( request id: 9092824) was failing:
Cause: FDPSTP failed due to ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 488
ORA-29283: invalid file operation
ORA-06512: at "APPS.XXAR_OPENINV_PKG", line 315
ORA-29283: invalid file operation
Also below two programs were also failing
XXAR: Custom Direct Debit Format
XXAR: Intercompany Invoices
Solution :
On checking inside the code it was found that program tries to write a file called it_ite_openinv.dat under directory
/PRODapps/PRODEURcomn/data/ar/outbound
It was found that a file with that name already existed in that directory from Apr 22th. It could be from some old run from Linux PROD:
[aixsprod:oraprod:/PRODapps/PRODEURcomn/data/ar/outbound:] ls -l it_ite_openinv.dat
-rw-r--r-- 1 appprod dba 378584 Apr 22 05:00 it_ite_openinv.dat
The file was renamed to it_ite_openinv.dat.2011apr22 and this concurrent program was run again and it went successful.
The other two programs also completed successfully after that
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ISSUE 25
Description :
XXAU: Copy Inbound to Work does not copy
the files from AR/oraout to AR/outbound
request id: 9092756
ar/oraout/ar_nl_dex_so_rlse_110424_092302.data:
******************************************************
**********Unable to read file ar/oraout/ar_nl_dex_so_rlse_110424_092302.data*****
**********Check the file Permissions*****************
Solution :
The Concurrent program XXAR: Create Order File by Location
Which runs the pl/sql xxar_rls_ord_file.create_rls_file was creating .data files under below directory with 600 permissions
/PRODapps/PRODEURcomn/data/ar/oraout
While if we manually create from UNIX side with oraprod user it was creating with correct permissions
aixkprod:oraprod:/orautil/PRODEUR/data/ar/oraout:] touch test
[aixkprod:oraprod:/orautil/PRODEUR/data/ar/oraout:] ls -ltr
total 64
-rw------- 1 oraprod dba 249 Apr 24 11:12 ar_nl_dex_so_rlse_110424_111249.data
-rw-r--r-- 1 oraprod dba 0 Apr 24 11:31 test
On checking further it was found that utl_file.fopen was creating the files with wrong permissions.
Note id How To Set the Permission of the Files Created Using UTL_FILE ? [ID 463312.1] was followed to change umask 022 and bounce Application-DB-Listeners and it corrected the problem. Files then afterwards were getting created with 644 default permissions and 'XXAU: Copy Inbound to Work' was able to pick up the files from oraout directory.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++