Thursday, June 22, 2017

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.




Wednesday, June 14, 2017

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.

Wednesday, May 31, 2017

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.


Friday, May 26, 2017

Configure Patch fs in R12.2

Scenario:

Assuming the Run and Patch fs are going to be in single node and the Run fs is already configured and the instance is up and running.

Steps to configure the patch File system in R12.2

Now to configure the patch fs.  Do the following

1.   Run the preclone in the Run fs.
[appdoyen@doyserv1 scripts]$ pwd
/test/app/TEST/fs2/inst/apps/TEST_doyserv1/admin/scripts

[appdoyen@doyserv1 scripts]$ adpreclone.pl appsTier
Copyright (c) 2011, 2014 Oracle Corporation
                        Redwood Shores, California, USA
                        Oracle E-Business Suite Rapid Clone
                                 Version 12.2
                      adpreclone Version 120.31.12020000.20
Enter the APPS User Password:
Enter the Weblogic AdminServer password :
 Checking the status of the Oracle WebLogic Administration Server....
 Running perl /test/app/TEST/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/test/app/TEST/fs2/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
Running:
perl /test/app/TEST/fs2/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/test/app/TEST/fs2/EBSapps/comn/util/jdk64 mode=stage stage=/test/app/TEST/fs2/EBSapps/comn/clone component=appsTier method= appctx=/test/app/TEST/fs2/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml showProgress
 Setting the wls environment
Beginning application tier Stage - Mon May 22 18:39:00 2017
/test/app/TEST/fs2/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /test/app/TEST/fs2/FMW_Home/webtier/lib/xmlparserv2.jar:/test/app/TEST/fs2/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/test/app/TEST/fs2/EBSapps/comn/java/classes:/test/app/TEST/fs2/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/test/app/TEST/fs2/FMW_Home/webtier/oui/jlib/ewt3.jar:/test/app/TEST/fs2/FMW_Home/webtier/oui/jlib/share.jar:/test/app/TEST/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/test/app/TEST/fs2/FMW_Home/webtier/jlib/ojmisc.jar:/test/app/TEST/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/test/app/TEST/fs2/FMW_Home/oracle_common/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.StageAppsTier -e /test/app/TEST/fs2/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml -stage /test/app/TEST/fs2/EBSapps/comn/clone -tmp /tmp -method CUSTOM   -showProgress -nopromptmsg
Log file located at /test/app/TEST/fs2/inst/apps/TEST_doyserv1/admin/log/clone/StageAppsTier_05221839.log

  /     20% completed

Completed Stage...

2.     Now create a empty patch fs directory in our case  (fs1).
/test/app/TEST/fs1

3.    Now shut down the runfs (fs2) and copy the EBS directory from run to patch fs

Note:  Now you can startall services in the run fs.

[appdoyen@doyserv1 scripts]$ cd $RUN_BASE
[appdoyen@doyserv1 fs2]$ pwd
/test/app/TEST/fs2

[appdoyen@doyserv1 fs2]$ cp -rp EBSapps /test/app/TEST/fs1/

4.     Unset the env if anything is set already.
5.      Go inside /test/app/TEST/fs1/EBSapps/comn/clone/bin of Patch fs ie) fs1 here , and run adcfgclone.pl
6.      Run perl adcfgclone.pl appsTier
7.      Give the port pool incremented by one on the run fs. for ex. If run fs is running in port pool 36 you can give as 37. Also check if it is already allcated by using 

netstat -an|grep -i 8037
    
[appdoyen@doyserv1 bin]$ perl adcfgclone.pl appsTier

                     Copyright (c) 2002, 2015 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.56

              ***********************************************************
                            In AD-TXK Delta 7, we recommend you clone the run and patch
                            file systems in a single operation using the 'dualfs' option.
                            Separate cloning of the run and patch file systems will be deprecated
              ************************************************************

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :
 Running: Context clone...
 Log file located at /test/app/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_0522221213.log

Target System File Edition type [run] : patch

Enter the full path of Run File System Context file : /test/app/TEST/fs2/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml

Provide the values required for creation of the new APPL_TOP Context file.

Target System Fusion Middleware Home set to /test/app/TEST/fs1/FMW_Home

Target System Web Oracle Home set to /test/app/TEST/fs1/FMW_Home/webtier

Target System Appl TOP set to /test/app/TEST/fs1/EBSapps/appl

Target System COMMON TOP set to /test/app/TEST/fs1/EBSapps/comn

Target System Instance Top set to /test/app/TEST/fs1/inst/apps/TEST_doyserv1

Target System Port Pool [0-99] : 37

Checking the port pool 37
done: Port Pool 37 is free
Report file located at /test/app/TEST/fs1/inst/apps/TEST_doyserv1/admin/out/portpool.lst
The new APPL_TOP context file has been created :
  /test/app/TEST/fs1/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml
Check Clone Context logfile /test/app/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_05348.log for details.

Running Rapid Clone with command:

Running:
perl /test/app/TEST/fs1/EBSapps/comn/clone/bin/adclone.pl java=/test/app/TEST/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/test/app/TEST/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/test/app/TEST/fs1/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml showProgress contextValidated=true
  
FMW Pre-requisite check log file location : /test/app/TEST/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /test/app/TEST/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /test/app/TEST/fs1/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml -stage /test/app/TEST/fs1/EBSapps/comn/clone -log /test/app/TEST/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply - Mon Feb 22 22:20:59 2016

/test/app/TEST/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /test/app/TEST/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/java:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/test/app/TEST/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/test/app/TEST/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e /test/app/TEST/fs1/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml -stage /test/app/TEST/fs1/EBSapps/comn/clone    -showProgress -nopromptmsg
Log file located at /test/app/TEST/fs1/inst/apps/TEST_doyserv1/admin/log/clone/ApplyAppsTier_05222221.log
  \    100% completed

Completed Apply...
Mon Feb 22 23:10:14 2016

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is COMPLETED

8.      Now source the env and startall .



Thursday, October 20, 2016

AWR Snapshots are not generated Automatically

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

Oracle Database 11.2.0.4. My AWR Snapshots were not being generated even though it was full enabled.

Basic Checks done:
------------------------

1. Checked that I had enough free space on SYSAUX tablespace. I was using only 5GB of the total 20GB.
2. System Parameter statistics_level was TYPICAL.
3. DBMS_STATS.GET_STATS_HISTORY_RETENTION was to 30 days.
4. The snapshot Interval was 60 minutes and Retention was 8 days.

Query Check the AWR intervals:
=========================
select
extract( day from snap_interval) *24*60+
extract( hour from snap_interval) *60+
extract( minute from snap_interval ) "Snapshot Interval",
extract( day from retention) *24*60+
extract( hour from retention) *60+
extract( minute from retention ) "Retention Interval"
from
dba_hist_wr_control;

5. Everything was OK,So finally checked the process responsible for AWR collection ie) MMON

Now MMON was not running.

Now it is a critical system and CRP testing is going, So i cannot bring down the system but i need to spawn the MMON process.

Here is the workaround :
-------------------------------

Just enable and disable the restricted sessions.

SQL> alter system enable restricted session;

System altered.

SQL> alter system disable restricted session;

System altered.

Now check the MMON.

[oradoyen@saravanadb trace]$ ps -ef|grep mmon
oradoy  9732     1  3 18:46 ?        00:00:00 ora_mmon_ORADOY
oradoy  9977 50953  0 18:47 pts/8    00:00:00 grep mmon
oradoy 28182     1  0 Oct10 ?        00:11:40 ora_mmon_DEV

Now AWR snapshots started generating.

Note :
Actually this is a bug in 11.2.0.4 and it is fixed by a patch 19565533.

Note id : 2023652.1 AWR Snapshots Are Not Being Created Because MMON Is Not Being Respawned


Thursday, October 6, 2016

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.






Tuesday, September 13, 2016

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.