Unapplied Receipts Journal report is erroring out

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

-- Problem Statement:
Unapplied Receipts Journal report is erroring out

Post-processing of request 5480230 failed at 09-APR-2009 08:44:50 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details

-- Steps To Reproduce:
1. Run Unapplied Receipts Journal program and it completes with warning.

-- Business Impact:
Users are not able to find unapplied receipts for a period and because of it they are facing lot of difficulty in their day to day activities.

Log File
-----------

Filename = <a href="http://sew.oraclecorp.com/SEW/fileDownload?forceDownload=0&fileURL=https%3A%2F%2Fgtcr.oracle.com%2Fgtcr-dir%2Fgtcr_322189299%2F7523545.992%2FWO-12562.log"target="_blank">https://gtcr.oracle.com/gtcr-dir/gtcr_322189299/7523545.992/WO-12562.log</a>

FND CONC-CP EXCEPTION N EXCEPTION 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:324)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:473)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:188)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:160)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1015)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:968)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:209)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1561)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:951)
at oracle.apps.xdo.oa.schema.serv

at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper
...
Caused by: oracle.xdo.parser.v2.XMLParseException: Start of root element

Note.471209.1 Ext/Pub Unapplied Receipt Register Report Failing With One Or More Post-Processing Actions Failed.:
Note.788084.1 Int/Pub Unapplied Receipts Journal And Applied Receipts Journal Ending In Warning One or more post-processing actions failed:
Note.740529.1 Ext/Pub Output Post Processor Fails Due To java.sql.SQLException Exhausted Resultset:
Note.456742.1 Lim/Pub ARXUNAJR Unapplied Receipts Journal errored out ORA-31011 XML parsing failed:

Solution:

1) Please download and review the readme for Patch.Standalone Patch 6394101 XML PUBLISHER POST-PROCESSING FAILING FOR CUMULATIVE ACTIVITY REPORT

Applicable Family Pack/Release
11i.AR.O

Branched versions of files included in this patch
ar patch/115/sql ARXCUABB.pls 115.4.15104.5

ge fr� 7 l e � � =1 wait_time=53405
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=302
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=626
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=10639
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=28444553, #bytes=1, =0
temporary object counter: 0
----------------------------------------
******************** Session Cursor Dump **********************
Current cursor: 19, pgadep: 0
Open cursors(pls, sys, hwm, max): 19(13, 2, 64, 2500)
NULL 3 SYNTAX 0 PARSE 0 BOUND 16 FETCH 0 ROW 0
----------------------------------------
Cursor#19(800003ffbfdc1f78) state=NULL curiob=800003ffbfc2da80
curflg=44 fl2=0 par=0000000000000000 ses=c0000001fedbeee8
sqltxt(c0000001e752ad38)=SELECT SERVER_ID,TYPE_ID,MEMBER_SVR_GROUP_ID, DNS_NAME,IP_ADDRESS,LOCATION FROM IEO_SVR_SERVERS WHERE SERVER_NAME = :1
hash=befdfc91dcf1de63a98a59741d85d682
parent=c0000001e951d278 maxchild=02 plk=c0000001d8af18e0 ppn=n
cursor instantiation=800003ffbfc2da80 used=1238445218
child#0(c0000001e74fd758) pcs=c0000001e74fda88
clk=c0000001bfed4500 ci=c0000001b859aa38 pn=c0000001c96dc160 ctx=c0000001e949fd38
kgsccflg=0 llk[800003ffbfc2da88,800003ffbfc2da88] idx=0
xscflg=20028 fl2=0 fl3=2022000 fl4=0
Bind bytecodes
Frames pfr 0000000000000000 siz=0 efr 0000000000000000 siz=0
Cursor frame dump
enxt: 1.0x00000000
pnxt: 1.0x00000000
Session cached cursors
-----------------------------------------------------------

Solution:

If you see the call stack information in the trace file : -

Error from U_get_previous_frame_x is 1
Stack is not Windable
Stack has no Unwind_descriptor

Please refer the Note below : -

Article-ID: Note 73835.1
Circulation: PUBLISHED (EXTERNAL)
Folder: ST.Server.DBA.Admin
Topic: Archives
Title: ALERT:HP-UX: ORA-7445 and Core Dump Generating Oracle Stack Trace .

This patch is very, very old. Release date was: 1998/11/30
This patch is not appropriate for 11.23. 11.23 was released September 2003!

Please go back to Oracle and ask for more details and a fix for 11.23.

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

This patch as per HP is for 11.00 Platform and we are having 11.23 release

Article-ID: Note 43507.1
Circulation: PUBLISHED (EXTERNAL)
Folder: ST.Platform.Unix.HPUX
Topic: Configuration
Title: HP-UX: Patch Levels Advised

Check with HP for details and do the needful.

Oracle must be relinked after applying this patch, as follows:
%cd $ORACLE_HOME/rdbms/lib
%make -f ins_rdbms.mk ioracle
The instance needs to be shutdown when relinking.

Get Oracle Certifications for all Exams
Free Online Exams.com