ORA-04063: rule set "APPLSYS.WF_JAVA_DEFERRED_R" has errors

Scenario:
------------

Got the Forms error while adding responsibility to a user in R12.2.5. So, I did the workflow sync validation and it does not fixed. So, I ran autoconfig in Apps tier and it end up with Error and ran in db node and that too endup with the same error.

1. Auto config in apps Node completed with the following Error:

WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
         

  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/app/DOYEN/fs2/FMW_Home/webtier/perl/bin/perl -I /u01/app/DOYEN/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/app/DOYEN/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/app/DOYEN/fs2/EBSapps/appl/au/12.0.0/perl -I /u01/app/DOYEN/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/app/DOYEN/fs2/inst/apps/DOYEN_sysapp02/admin/scripts/adexecsql.pl sqlfile=/u01/app/DOYEN/fs2/inst/apps/DOYEN_sysapp02/admin/install
      afwebprf.sql            INSTE8_PRF         1

AutoConfig is exiting with status 1

2. Autoconfig in the DB node completed with the following error:

WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
         

  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/orahome/u01db/11.2.0.4/appsutil/install/DOYEN_system01
      afdbprf.sh              INSTE8_PRF         1

AutoConfig is exiting with status 1


Now when i tried running the script (afwebprf.sql) manually which errored out in apps autoconfig and i faced the same error which we got in forms.

Now i tried running the script (afdbprf.sh) manually which errored out in db node and found the same error:

[orau01@system01:DOYEN_system01]# sh afdbprf.sh

afdbprf.sh started at Thu Jun 22 19:54:29 IDT 2017

The environment settings are as follows ...

       ORACLE_HOME : /u01/orahome/u01db/11.2.0.4
        ORACLE_SID : DOYEN
              PATH : /u01/orahome/u01db/11.2.0.4/perl/bin:/u01/orahome/u01db/11.2.0.4/perl/bin:/u01/orahome/u01db/11.2.0.4/bin:/usr/bin:/usr/sbin:/u01/orahome/u01db/11.2.0.4/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:.:.
      Library Path : /u01/orahome/u01db/11.2.0.4/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/orahome/u01db/11.2.0.4/lib:/usr/dt/lib:/u01/orahome/u01db/11.2.0.4/ctx/lib

Executable : /u01/orahome/u01db/11.2.0.4/bin/sqlplus

Enter the APPS username: apps
Enter the APPS password:
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 22 19:54:33 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ FND_DB_WALLET_DIR ]
Application Id : 0
Profile Value  : /u01/orahome/u01db/11.2.0.4/appsutil/wallet
Level Name: SITE
INFO       : Updated/created profile option value.
.
[ ECX_UTL_XSLT_DIR ]
Application Id : 174
Profile Value  : /usr/tmp
Level Name: SITE
INFO       : Updated/created profile option value.
.
[ ECX_UTL_LOG_DIR ]
Application Id : 174
Profile Value  : /usr/tmp
Level Name: SITE
INFO       : Updated/created profile option value.
.
[ BIS_DEBUG_LOG_DIRECTORY ]
Application Id : 0
Profile Value  : /usr/tmp
Level Name: SITE
INFO       : Updated/created profile option value.
.
[ UTL_FILE_LOG ]
Application Id : 1
Profile Value  : /usr/tmp, /u01/logout/tmp, /tmp/, /u01/oratmp/tempdata,
/u01/logout/Agile, /u01/logout/Agile/in, /u01/logout/Agile/out,
/u01/winshare/APAC/AP, /u01/winshare/crm/scorecard,
/u01/winshare/APAC/WESTPAC, /u01/logout/cm,
/u01/orahome/u01db/11.2.0.4/appsutil/outbound/DOYEN_system01
Level Name  : SITE
INFO       : Error updating/creating profile option value.
.
begin
*
ERROR at line 1:
ORA-04063: rule set "APPLSYS.WF_JAVA_DEFERRED_R" has errors
ORA-06512: at "APPS.WF_EVENT", line 1194
ORA-06512: at "APPS.FND_WF_ENGINE", line 1025
ORA-06512: at "APPS.FND_PROFILE", line 1102
ORA-06512: at "APPS.FND_PROFILE", line 2353
ORA-06512: at "APPS.ADX_PRF_PKG", line 192
ORA-06512: at line 42

The above error seems to be an issue with the WF Ruleset.

Solution:
-----------

Checked the following Rule Set is valid and found to be invalid.

select object_name, object_type, status from dba_objects where object_name='WF_JAVA_DEFERRED_R';

WF_JAVA_DEFERRED_R RULE SET INVALID


This is because of the issues with the Workflow queues. So i did the clean up and enque processes as suggested in the below Note id.

After following the following noteid , It fixed the  issue:

Fixing Invalid Workflow Rule Sets such as WF_DEFERRED_R and Related Errors on Workflow Queues:ORA-24033 (Doc ID 337294.1)

Once it is done, I have checked the status of the Ruleset and it is valid.

select object_name, object_type, status from dba_objects where object_name='WF_JAVA_DEFERRED_R';

WF_JAVA_DEFERRED_R RULE SET VALID


Now , Ran the Autoconfig and it has completed Normal.

Cause: cleanup_node failed due to ORA-01427

Scenario:
------------

The concurrent requests are going to Error in R12.2.5 and cannot view the log files as well.


Error:
------

Cause: cleanup_node failed due to ORA-01427: single-row subquery returns more than one row
ORA-06512: at "APPS.FND_CP_FNDSM", line 91
ORA-06512: at line 1.

The SQL statement being executed at the time of the error was: begin fnd_cp_fndsm.mark_killed_fndsm(:nn); end;  and was executed from the file &ERRFILE.
Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /test/app/fs2/EBSapps/appl/fnd/12.0.0/bin/FNDLIBR.

Check that your system has enough resources to start a concurrent manager process. Contact your system : 13-JUN-2017 22:28:18
Starting STANDARD Concurrent Manager               : 13-JUN-2017 22:28:18

Could not initialize the Service Manager FNDSM_DOYSER_DEV. Verify that DOYSER has been registered for concurrent processing.
An error occured in client-side routine afpsmcsm for Service Manager FNDSM_DOYSER_DEV.  The routine returned code 126.

Check for preceding errors and as well as the service manager log file for further details."

ORACLE error 1427 in cleanup_node


Cause:
---------

After clone the node is not cleaned up which has the old values.

Solution:
----------

1. Shutdown the apps node.
2. login to db node and run the following.

sqlplus apps/apps

sql>exec fnd_conc_clone.setup_clean;

commit;

sql>@cmclean.sql

3. Run autoconfig in db tier.
4. Run autoconfig in the apps tier and start the services.

This should be fixed.

ORA-20100 : Temporary file creation for FND_FILE failed.

Scenario:
---------

Request completed with the following error:

ORA-20100 : Temporary file creation for FND_FILE failed.

Log file shows the following :
------------------------------------
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDOAMCOL: OAM Applications Dashboard Collection
+---------------------------------------------------------------------------+

Updated system property java.protocol.handler.pkgs to HTTPClient
Refreshing All ...
Refreshing Applications System Status ...
Refreshing Activity ...
Refreshing Configuration Changes ...
Refreshing Throughput ...
Refreshing Exceptions Summary ...
Refreshing User Alert Summary ...
Collecting metric values for each aplication tier node ...
Collecting metric values for each database instance ...
Done Refreshing All ...
Checking collected data for alerting ...
Checking long running requests for alerting ...
SQLException:
java.sql.SQLException: ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.

Action: Check that the directory is a valid directory with write permissions on the database server node and is listed under utl_file_dir para
ORA-06512: at "APPS.FND_FILE", line 319
ORA-06512: at "APPS.FND_FILE", line 364
ORA-06512: at "APPS.FND_FILE", line 421
ORA-06512: at "APPS.FND_OAM_COLLECTION", line 2786
ORA-06512: at line 1

Oracle error : An unexpected system error has been detected in Application code. Please contact System Administrator for assistance.Successfully resubmitted concurrent program FNDOAMCOL with request ID 84242340 to start at 31-MAY-2017 23:45:52 (ROUTINE=AFPSRS)

+---------------------------------------------------------------------------+
No completion options were requested.

Output file size:
----------------------------------------------------------------------------+

Reason:
---------

The APPLPTEMP location points to a directory which is not in the utl_file directory in the database. So when the application user is trying to create a temp file in the location it is not allowed.


grep -i APPLPTMP $CONTEXT_FILE
         /doyen/app/DOYENSYS/fs2/inst/apps/DOYENSYS_sara1/temp


when i check the utl_file, It shows the following :

/usr/tmp


 Solution:
=======

1. Either add the following location in utl_file dir and restart the db /doyen/app/DOYENSYS/fs2/inst/apps/DOYENSYS_sara1/temp    or
2. Change the s_applptmp value to /usr/tmp and run autoconfig and try running the report again.

ORA-20100: Temporary file creation for FND_FILE failed

Scenario:
-----------

While running a report in Payables or any of the program errored out and the log file shows the following error in R12.2.4

ORA-20100: Temporary file creation for FND_FILE failed

Error in Log file :
----------------------

Enter Password:
MSG-00101: Error occured in BATCH_APPROVAL()
MSG-00102: Error Code : -20100
MSG-00103: Error Message : ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.

Action: Check that the directory is a valid directory with write permissions on the database server node and is listed under utl_file_dir para
ORA-06512: at "APPS.FND_FILE", line 319
ORA-06512: at "APPS.FND_FILE", line 364
ORA-06512: at "APPS.FND_FILE", line 421
ORA-06512: at "APPS.AP_APPROVAL_PKG", line 10672
MSG-00000: When Others:User-Defined Exception
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-00101: Error occured in BATCH_APPROVAL()
MSG-00102: Error Code : -20100
MSG-00103: Error Message : ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.
Action: Check that the directory is a valid directory with write permissions on the database server node and is listed under utl_file_dir para
ORA-06512: at "APPS.FND_FILE", lin

Solution:
-----------

1. Check the APPLPTMP for ex. /usr/tmp/SARA
2. check whether that exsists in utl_file_directory.
Note : Better to check with gv$ view like below
select name,value FROM gv$parameter2 WHERE name='utl_file_dir' and value like '%SAR%';

If it is not same which is in APPLPTMP. then

a) Change the APPLPTMP location to any one location which is there in UTL file in env file and XML and bounce the concurrent
or
b) Add the same value which is in APPLPTMP to the UTL file location and bounce the db.

XML-20201: (Fatal Error) Expected name instead of .

Error :
-------

Output post processor failed with below error processing report output

Caused by: org.xml.sax.SAXParseException: : XML-20201: (Fatal Error) Expected name instead of  .

Concurrent Log file Error:
-------------------------------

Inserting invoice IDs into Temp Table
SQL STATEMENT :  INSERT into xxdn.xxdn_ACCOUNT_ANALYSIS_INVTEMP  SELECT pv.VENDOR_NAME supplier_name,   ai.invoice_num invoice_number,   ab.INVOICE_DATE invoice_date,   ab.invoice_amount  invoice_amount,   ab.invoice_id SOURCE_INVOICE_ID,   ab.ORG_ID,   ab.SET_OF_BOOKS_ID   FROM   hr_organization_information oi, hr_all_organization_units_tl ae, AND ae.language = USERENV('LANG')   AND NVL(ORG_ID,85 ) = 85

Inserted records into Temp Table successfully..

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 321496451 on node USWS1HMSDVCM02 at 12-SEP-2016 16:48:24.
Post-processing of request 321496451 failed at 12-SEP-2016 16:48:28 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.

OPP Log file shows the following error:
--------------------------------------------------
[9/12/16 4:48:28 PM] [UNEXPECTED] [2058679:RT321496451] java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5943)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:290)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: org.xml.sax.SAXParseException: : XML-20201: (Fatal Error) Expected name instead of  .
        at oracle.xdo.parser.v2.XMLError.flushErrorHandler(XMLError.java:441)
        at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:303)
        at oracle.xdo.parser.v2.XMLReader.scanNameChars(XMLReader.java:1061)
        at oracle.xdo.parser.v2.XMLReader.scanQName(XMLReader.java:1871)
        at oracle.xdo.parser.v2.XMLReader.getEntity(XMLReader.java:2125)
        at oracle.xdo.parser.v2.NonValidatingParser.parseContentEntityRef(NonValidatingParser.java:1654)
        at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1272)
        at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:338)
        at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)
        at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289)
        ... 17 more


Solution:
-----------

select invoice_number from xxdn_ACCOUNT_ANALYSIS_INVTEMP where invoice_number like '%&%';

The above table is taken from the output file of the concurrent request and this gives the output column in which the "&" is included in the value which is supposed to be removed.

Checking output xml file Line 17018, we notice “&”, which is causing the issue.
2016-0402 & 2016-5829

You will have to run a data fix for this particular output or check with the developers to fix this.

OPM:Can not find one alive process, Page cannot be displayed in 11i after running ADCFGCLONE

Issue :

 After running adcfgclone in apps Tier in 11i , It got completed without any error and When we tried to login the First page comes but when we try to click on homepage, it redirects to blank page which says "Page cannot be displayed" instead of login page.

In Apache Error log:
--------------------------

iAS Home/Apache/Apache/logs :

[Tue Apr  5 20:41:43 2016] [error] [client 10.1.163.122] File does not exist:
[Tue Apr  5 20:45:05 2016] [error] [client 10.1.163.122] File does not exist: /u01/app/doyen/doyencomn/html/US/ICXINDEX_doyen_usws1rdvcm04.htm
[Tue Apr  5 20:45:22 2016] [error] OPM:Can not find one alive process
[Tue Apr  5 20:45:22 2016] [error] [client 10.1.163.122] File does not exist: /servlets/weboam/oam/oamLogin/oam/oamLogin
[Tue Apr  5 20:51:13 2016] [error] OPM: EW: Fail to start process with mod=JServ and grp=DiscoGroup, it's possible that your configuration file is not correct.
[Tue Apr  5 20:51:13 2016] [error] OPM: EW: Fail to start process with mod=JServ and grp=OACoreGroup, it's possible that your configuration file is not correct.
[Tue Apr  5 20:51:13 2016] [error] OPM: EW: Fail to start process with mod=JServ and grp=OACoreGroup, it's possible that your configuration file is
[Tue Apr  5 21:12:18 2016] [notice] Oracle HTTP Server Powered by Apache/1.3.19 configured -- resuming normal operations
[Tue Apr  5 21:25:42 2016] [error] [client 10.1.163.122] File does not exist: /u01/app/doyen/doyencomn/portal/doyen_doyendb02/favicon.ico
[Tue Apr  5 21:25:45 2016] [error] [client 10.1.163.122] File does not exist: /u01/app/doyen/doyencomn/portal/doyen_doyendb02/favicon.ico
[Tue Apr  5 21:25:45 2016] [error] OPM:Can not find one alive process

In Jserv Logs:
----------------

[apdoyen@doyendb02 jvm]$ pwd
/u01/app/doyen/doyenora/iAS/Apache/Jserv/logs/jvm

vi OACoreGroup.4.stderr

Please use CMSClassUnloadingEnabled in place of CMSPermGenSweepingEnabled in the future
Could not create the Java virtual machine.

vi XmlSvcsGrp.0.stdout

/usr/bin/jdk1.6.0_30/jre/bin/java -DCLIENT_PROCESSID=8314 -verbose:gc -Xmx1600M -Xms1600M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:
+PrintClassHistogram -XX:+UseTLAB -XX:+CMSPermGenSweepingEnabled -XX:+CMSClassUnloadingEnabled -Djava.awt.headless=false -DFND_TOP=/u01/app/doyen/doyenappl/fnd/11.5.0 -OA_HTML=/u01/app/doyen/doyencomn/html/ -DOA_MEDIA=/u01/app/doyen/doyencomn/java/oracle/apps/media/ -DOASMTPServer=doyendb02.hrbl.net -DWebProxyHost=doyendb02.hrbl.net -
DWebProxyPort=80 -DWebProxyByPassDomain=hrbl.net -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.ssl=false -
DOASSLCACertFile=/u01/app/doyen/doyenora/iAS/Apache/Apache/conf/ssl.crt/ca-bundle.crt -DOXTAInPoolSize=1 -DOXTAOutThreads=1 -DOXTAOutUseProxy=false -
DOXTAOutProxyHost=doyendb02.hrbl.net -DOXTAOutProxyPort=80 -DCOMMON_TOP=/u01/app/doyen/doyencomn -DOXTALogDebugMsg=false -DEXTERNAL_URL=http://doyendb02.hrbl.net:8016 -
Djbo.323.compatible=true -DAPPLRGF=/u01/app/doyen/doyencomn/rgf/doyen_doyendb02 -DJTFDBCFILE=/u01/app/doyen/doyenappl/fnd/11.5.0/secure/doyenapps01_doyen.dbc -
Dservice.Logging.common.filename=/u01/app/doyen/doyencomn/temp/ibe.log -Dframework.Logging.system.filename=/u01/app/doyen/doyencomn/temp/fwsys.log -
DIMT_COM_PROPERTY_FILE=/u01/app/doyen/doyenappl/imt/11.5.0/admin/scripts/imtjserv.properties -Dpoolsize=100 -Dminpoolsize=10 -Dpoolincrement=10 -Dpooldelayincrement=3 -
DBNEDBCFILE=/u01/app/doyen/doyenappl/fnd/11.5.0/secure/doyenapps01_doyen.dbc -Djserv.session.getValue.instrument=false org.apache.jserv.JServ -opmpropfile
/u01/app/doyen/doyenora/iAS/Apache/Jserv/etc/xmlsvcs.properties -opmhost doyendb02.hrbl.net -opmport 8116 -opmgrp XmlSvcsGrp -opmindex 0 -opmprocid 7
-------------------------------
Error occurred during initialization of VM
Could not reserve enough space for object heap
---------------------------------------------------

Solution  :
-----------
Cause :
---------

System was unable to reserve 1600M java heap memory for the jvm …

Solution : 

Reduced the java heap memory to be used by the jvm to 512M (updated the s_jvm_options  in the CONTEXT_FILE and ran autoconfig)


Before:
-verbose:gc –Xmx1600M –Xms1600M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:
+PrintClassHistogram -XX:+UseTLAB -XX:+CMSClassUnloadingEnabled

After:

-verbose:gc -Xmx512M -Xms512M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -
XX:+PrintClassHistogram -XX:+UseTLAB -XX:+CMSClassUnloadingEnabled

After this Run Autoconfig and retest the issue.

Reference : Error 'Could not reserve enough space for object heap' During Initialization of JVM (Doc ID 1028915.1)

ORA-06508 : PL/SQL: Could not find the program unit being called in Package AHL_UMP_SR_GRP Procedure Create_SR_Unit_Effectivity

When we run Depot report in 12.1.3, we end up with the following error.

Error:

ORA-06508 : PL/SQL: Could not find the program unit being called in Package AHL_UMP_SR_GRP Procedure Create_SR_Unit_Effectivity.

Cause :

The following package AHL_UMP_SR_GRP is invalid or the dependent one is invalid.

Solution:

Check for those package and validate it and also compile the package body.

Reference :

Service Request Tab: ORA-06508 Error In Package AHL_UMP_SR_GRP When Saving New Service Requests [ID 1069550.1]

Namespace prefix 'crosstab' used but not declared

Report Completed with Warning which shows the OPP error in the log file in R12.1.1

Scenario 
========

When we tried to run an cutom report using RTF we get the following error.

OPP Error LOG
=============

Template code: XX_DOYEN_DEMO
Template app:  SQLAP
Language:      en
Territory:     US
Output type:   EXCEL
[7/4/13 2:43:34 PM] [UNEXPECTED] [2036125:RT5861522] java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at oracle.apps.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(XSLT10gR1.java:558)
        at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:228)
        at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
        at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
        at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
        at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
        at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)
        at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:285)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:173)
Caused by: oracle.xdo.parser.v2.XPathException: Namespace prefix 'crosstab' used but not declared.
        at oracle.xdo.parser.v2.XSLProcessor.reportException(XSLProcessor.java:806)
        at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:571)
        ... 16 more


Solution:
========

Pivot table is used in the RTF Template which is not supported on the latest version of BI . BI Publisher embedded with E-Business is based on 5.6.3 version has limited functionality. 

1.  Please install Patch 12395372 - Update For BI Publisher Desktop 10.1.3.2.1 (5.6.3) for the E-business Publisher Desktop Utility.Ensure no Windows applications such as Outlook are running when installing the Utility. 
2.  Select the Add-Ins tab.
3.  Select Insert - Crosstab.
4.  Create the Crosstab there using the Crosstab Wizard.
5.  After Crosstab is created, Validate Template to ensure it runs successfully.

OR

Work Around :
===========

Remove the Pivot table in the RTF Template and test by running the report

Reference :
=========

Note :1   Oracle.Xdo.Parser.V2.Xpathexception: Namespace Prefix 'Crosstab' Used But Not Declared [ID 743882.1]

Note :2   How to Create Crosstab Report In XML Publisher In E-Business Suite Publisher Desktop Utility? [ID 1313546.1]

REP-57054: In-process job terminated:Terminated with error

Scenario:

=========

Active Users concurrent request Errored out.

Log file shows the following error:

==================================

APPLLCSP Environment Variable set to :

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

American_America.UTF8

'.,'

Enter Password:

REP-3000: Internal error starting Oracle Toolkit.

REP-3000: Internal error starting Oracle Toolkit.

REP-0069: Internal error

REP-57054: In-process job terminated:Terminated with error:

REP-3000: Internal error starting Oracle Toolkit.

Following things needs to be checked :

====================================

Check $CONTEXT_FILE display variable. If this is correct we can ignore this and if there is any change then run autoconfig.

Now check the reports.sh file inside the apps $ORACLE_HOME/bin

Display variable to set DISPLAY=192.168.1.20:1.0; export DISPLAY

If still issue persists then follow the below step.

Solution:

=========

1. From Unix Run the following command:

$ /usr/lpp/X11/bin/xinit /usr/lpp/X11/bin/mwm -multiscreen -- :1 -vfb -force -x abx -x dbe -x GLX &

2. Bounce the Applications service/report server to take effect.

Note Id :

=========

After Upgrade to R 12.1.2 Running Any PDF Reports: Get: REP-3000,REP-0069 and REP-57054 [ID 1204553.1]

Extension function error: Method not found 'xdo_format_currency'

Scenario :

========

After the upgrade from 12.0.4 to 12.1.3 the custom reports are completed with warning and the request log file show there was an error in OPP and OPP log file shows the following error

OPP Log file error :

=================

Output file was found but is zero sized - Deleted

Request log file :

==============

DOYNODC module: DOYN-Print PO Stand

+---------------------------------------------------------------------------+

Current system time is 13-JUN-2013 15:39:25

+---------------------------------------------------------------------------+

| Starting concurrent program execution...

+-----------------------------

Arguments

------------

p_po_num='1239'

p_po_num_to='1239'

------------

Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

 APPLLCSP Environment Variable set to :

 Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

American_America.UTF8

'.,'

Enter Password: 

Report Builder: Release 10.1.2.3.0 - Production on Thu Jun 13 15:39:32 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

Executing request completion options...

Output file size: 

111825

+------------- 1) PUBLISH -------------+

Beginning post-processing of request 12668087 on node DEVSERVER at 13-JUN-2013 15:39:34.

Post-processing of request 12668087 failed at 13-JUN-2013 15:39:36 with the error message:

One or more post-processing actions failed. Consult the OPP service log for details.

+--------------------------------------+

+------------- 2) PRINT   -------------+

Not printing the output of this request because post-processing failed.

+--------------------------------------+

Finished executing request completion options.

+---------------------------------------------------------------------------+

Concurrent request completed

Current system time is 13-JUN-2013 15:39:36

+---------------------------------------------------------------------------+

OPP log shows the following error :

==================================

[6/13/13 3:09:21 PM] [1651373:RT12668079] Completed post-processing actions for request 12668079.

[6/13/13 3:38:53 PM] [OPPServiceThread1] Post-processing request 12668083.

[6/13/13 3:39:34 PM] [OPPServiceThread0] Post-processing request 12668087.

[6/13/13 3:39:35 PM] [1651373:RT12668087] Executing post-processing actions for request 12668087.

[6/13/13 3:39:35 PM] [1651373:RT12668087] Starting XML Publisher post-processing action.

[6/13/13 3:39:35 PM] [1651373:RT12668087] 

Template code: XXDNPODC

Template app:  XXDN

Language:      en

Territory:     00

Output type:   RTF

[6/13/13 3:39:36 PM] [1651373:RT12668087] Output file was found but is zero sized - Deleted

[6/13/13 3:39:36 PM] [UNEXPECTED] [1651373:RT12668087] java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

at java.lang.reflect.Method.invoke(Method.java:599)

at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(XSLT10gR1.java:677)

at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:425)

at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:244)

at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)

at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)

at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)

at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)

at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)

at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)

at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)

at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)

at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)

at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)

at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)

Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Method not found 'xdo_format_currency'

at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)

at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)

at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)

at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)

at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)

at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)

... 18 more

Cause :

=======

Templates were not regenerated properly.

Solution :

========

Regenerate templates and try again.

Steps to regenerate templates :

=============================

Responsibility: XML Publisher Administrator

Navigation: Request > Run

Submit Concurrent Process = XML Publisher Template Re-Generator 

Select 'ALL'

Once templates are regenerated test the report again to see if issue is resolved.

Reference :

==========

AR to GL Reconciliation Report Error: Method not found 'xdo_format_currency' [ID 787974.1]

You must allow access to at least one attribute group

Scenario:

When are working in the inventory module and when we tried to do some transactions, We faced the following issue.

Error :

You must allow access to at least one attribute group

I have checked the responsibility Inventory Vision Operations (USA) and it doesn't have any exclusions in System Administrator. 

I have also checked the seeded Inventory Responsibility and when I opened Master Items or Organization Items screen the same problem You must allow access to at least one attribute group and after clicking on OK button the Item screen opens up and only Process Manufacturing tab is active and all the other tabs are greyed out.

                        

Also we get the following error when we ignored the above and started working further.

Cause: 

The components for the Inventory Items screen are not licenced in License Manager for R12.1.1.

Solution:

Please license the Products through System Administration or System Administrator Responsibility.

System Administrator > Oracle Applications Manager > Lincese Manager

Click on the the Products under License section and license the Respective Products. For example (INV etc)

After performing the above steps the Items Screen attributes are active.

ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85

ISSUE REPORTED:XML reports  complete in warning


Error in OPP logfile :

ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ
ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85


SCENARIO :

This is a freshly cloned instance and all managers and OPP services 
were up and running.
However users were reporting of XML reports completing in error.
A check of the OPP logs revealed the following error:

[OPPServiceThread0] java.sql.SQLException: ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ
ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85
ORA-06512: at line 1
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225)at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)at oracle.apps.fnd.cp.opp.OPPAQMonitor.initAQ(OPPAQMonitor.java:558)at oracle.apps.fnd.cp.opp.OPPAQMonitor.init(OPPAQMonitor.java:534)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.initialize(OPPAQMonitor.java:89)at oracle.apps.fnd.cp.opp.OPPServiceThread.init(OPPServiceThread.java:94)at oracle.apps.fnd.cp.gs
f.BaseServiceThread.run(BaseServiceThread.java:135)


SOLUTION:

SQL> select count(*) from applsys.FND_CP_GSM_OPP_AQTBL ;

  COUNT(*)
----------
   1039973

Take a back up of the table :

SQL> create table applsys.FND_CP_GSM_OPP_AQTBL_bkp2 as select * from applsys.FND_CP_GSM_OPP_AQTBL;

Table created.

SQL> show user
USER is "APPS"
SQL> conn applsys/devapps
Connected.
SQL> show user
USER is "APPLSYS"


SQL> exec dbms_aqadm.purge_queue_table('FND_CP_GSM_OPP_AQTBL', null, null);

PL/SQL procedure successfully completed.

SQL> select count(*) from applsys.FND_CP_GSM_OPP_AQTBL ;

  COUNT(*)
----------
         0

Connect as APPS

bash-3.00$ sqlplus apps/devapps

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Sep 11 11:12:45 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>@$FND_TOP/patch/115/sql/afopp002.sql
Enter value for 1: APPLSYS
Enter value for 2: devapps
Connected.

PL/SQL procedure successfully completed.

SQL> exec fnd_cp_opp_ipc.remove_all_subscribers();

Now run cmclean and start the concurrent manager.

The custom manager restarts often by itself.

Issue :

The custom manager restarts often by itself.

Scenario:

We have a custom manager XX_Custom_Receiving_mgr which has 3 programs

1. Purchasing     -  Receiving Transaction Processor

2. Ware house   -  Pre-generate

3. Asia/Pacific Localization   -  India - Receiving  Transaction Processor

We have done some server migration and after that this manager keep on restarting.But rest of the custom managers are working fine.

Work Around :

As the above mentioned are the critical program for us, We have to go for a workaround provided there is no downtime for the same.

1. Created a new custom manager XX_Custom_Receiving_mgr1

2. Deleted the programs that are in the existing manager XX_Custom_Receiving_mgr

3. Included those programs that were deleted from the existing manager to the new manager XX_Custom_Receiving_mgr1.

4. Now the old manager XX_Custom_Receiving_mgr has no programs inside and the new manager XX_Custom_Receiving_mgr1 has the three programs included.

Again Issue:

Now the issue is that both the manager keeps restarting.

 Also the new issue is that, The old manager which has No programs in the Include , acts like a STANDARD MANAGER. The program what are all runs in Standard is running in this manager if there is any busy in Standard manager.

Fix what i did :

1. Down the concurrent manager.

2. Run the cmclean.sql script and commit.

3. start the concurrent manager.

Now after the restart still the issue occurs. The restart happens.

So, I have followed the below steps

1. Exclude the program    Purchasing     -  Receiving Transaction Processor from the new manager XX_Custom_Receiving_mgr1  and Include that to the old manager XX_Custom_Receiving_mgr which is now acting like a standard manager.

2. Now the issue seems to be fixed for the old manager XX_Custom_Receiving_mgr and it runs the only program which has attached to it. Also the restart does not happens for this.

3. Now the issue still remains for the new manager (XX_Custom_Receiving_mgr1) which has 2 Includes and 1 Exclude programs.

4. Now what i did is that, I have excluded the program in the old manager  XX_Custom_Receiving_mgr which is the program that is included in the new manager XX_Custom_Receiving_mgr1. Now the issue got fixed.

Final Solution is :

1. If a new manager is created and no program is added then it will acts like a Standard manager.

2. If you have added some program to the manager then it is not advisable to just delete the program and add that to another manager. We need to exclude it in the existing manager and Include that to the new manager.

Active Users concurrent program takes long time (never completes) after clone:

Version : 12.1.1

Scenario:
=======

Active Users concurrent program never completes after clone:

Recently we did a clone (R12). Everything worked as expected, except for Active Users Concurrent program which never completed when submitted. The status remains Running ? Normal for very long

This is how the issue was approached and resolved.:

1)We tried to run the Active User request with trace enabled,

but no trace file was generated.Hence we ran the report manually from the command prompt:

$INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/ mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132x66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace 
(should generate trace in the same location)

This command produced the following error:

$ $INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/ mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132x66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace
Environment:Environment java.lang.UnsatisfiedLinkError: Can't find library rwu  (librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/devapps/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/tech_st/10.1.2/lib32:/devapps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/apps_st/appl/cz/12.0.0/bin:/devapps/apps/tech_st/10.1.2/lib32:/devapps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/apps_st/appl/sht/12.0.0/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
Environment:getEnvironmentStrings java.lang.UnsatisfiedLinkError: Can't find library rwu  (librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/devapps/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/tech_st/10.1.2/lib32:/devapps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/apps_st/appl/cz/12.0.0/bin:/devapps/apps/tech_st/10.1.2/lib32:/devapps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/apps_st/appl/sht/12.0.0/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
REP-50125: Caught exception: java.lang.reflect.InvocationTargetException

2)Next we checked for the reports servers running by

$ rwdiag.sh -findAll

(This command also produced the following error)

Environment:Environment java.lang.UnsatisfiedLinkError: Can't find library rwu  (librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/devapps/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/devapps/apps/tech_st/10.1.2/jdk/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/tech_st/10.1.2/lib32:/devapps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/apps_st/appl/cz/12.0.0/bin:/devapps/apps/tech_st/10.1.2/lib32:/devapps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/apps_st/appl/sht/12.0.0/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
Environment:getEnvironmentStrings java.lang.UnsatisfiedLinkError: Can't find library rwu  (librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/devapps/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/devapps/apps/tech_st/10.1.2/jdk/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/tech_st/10.1.2/lib32:/devapps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/apps_st/appl/cz/12.0.0/bin:/devapps/apps/tech_st/10.1.2/lib32:/devapps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devapps/apps/apps_st/appl/sht/12.0.0/lib:/devapps/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
java.lang.reflect.InvocationTargetException
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0

This indicated that the reports executables need to be relinked as per the note Concurrent Reports UnsatisfiedLinkError [ID 849369.1]

Solution:
======

To implement the solution, we executed the following steps:

1. Relink the reports executables:

cd $ORACLE_HOME/reports/lib32
make -f ins_reports.mk install

(Error again!!!!)
============

Error while trying to relink :  Even though application tier was down we got the error:
      /devapps/apps/tech_st/10.1.2/bin/mkexp.sh /devapps/apps/tech_st/10.1.2/lib32//librwu.a  > librwuso.exp
        rm -f rwsutil.o rwspid.o ;  /bin/ar x /devapps/apps/tech_st/10.1.2/lib32//librwu.a  rwsutil.o rwspid.o ;  (LD_OPTIONS="-zmultidefs";  ld -o /devapps/apps/tech_st/10.1.2/lib32//librwu.so -bM:SRE -bnoentry -bnolibpath  -bE:librwuso.exp rwsutil.o rwspid.o  -lm -lc -lm  -ldl /devapps/apps/tech_st/10.1.2/lib32/libclntsh.a -lpthreads  -L/usr/lpp/X11/lib/R6 -L/usr/lpp/X11/lib/R6/Motif2.1 -lXm -lXt -lX11 -lm `cat /devapps/apps/tech_st/10.1.2/lib32/sysliblist` /devapps/apps/tech_st/10.1.2/lib32/libclntst10.a )
        rm -f zrhitem.o zrhcursor.o;  /bin/ar x /devapps/apps/tech_st/10.1.2/lib32//librw.a zrhitem.o zrhcursor.o
        /devapps/apps/tech_st/10.1.2/bin/mkexp.sh /devapps/apps/tech_st/10.1.2/lib32/libmmcm.a > temp1.exp
        /devapps/apps/tech_st/10.1.2/bin/mkexp.sh /devapps/apps/tech_st/10.1.2/lib32/librw.a > temp2.exp
        cat temp1.exp temp2.exp > temp.exp
        sort -u temp.exp > librw.exp
        rm temp1.exp temp2.exp temp.exp
ld: 0711-851 SEVERE ERROR: Output file: /devapps/apps/tech_st/10.1.2/lib32//librw.so
        The file is in use and cannot be overwritten.
make: 1254-004 The error code from the last command is 12.

This meant that the file was in use :

We referred to the following Metalink note ID

What are the steps needed to Clean up the Libraries during Relinking of Reports on AIX? [ID 834577.1]

In order to overcome this issue:

su - root

Issued the following command:

/usr/sbin/slibclean

Then login as a normal user and now relink the Reports Services.

$ORACLE_HOME/reports/lib32> make -f ins_reports.mk install

2. Retest for the issue
Success!!!
Active user completed Normal