Oracle World: Jun 28, 2011

Tuesday, June 28, 2011

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

ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded]

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

### Detailed Problem Statement ###
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded],

PMON: terminating instance due to error 474
Tue Mar 31 00:33:51 2009
Errors in file sid_lms0_21814.trc:
ORA-00474: SMON process terminated with error
Tue Mar 31 00:33:51 2009
Errors in file sid_lmon_21782.trc:
ORA-00474: SMON process terminated with error
Tue Mar 31 00:33:51 2009
Errors in file sid_dbw0_21820.trc:
ORA-00474: SMON process terminated with error

ALERT LOG
-------------------

Tue Mar 31 00:33:41 2009
Errors in file /u01/ptyp/ptypdb/10.2.0/admin/PTYP2_pebpdb02/udump/ptyp2_ora_21976.trc:
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded], [], [], [], [], [], [], []

TRACE FILE
------------
sid_ora_21976.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME =

System name: HP-UX
Node name:
Release: B.11.23
Version: U
Machine: 9000/800
Instance name:
Redo thread mounted by this instance: 2
Oracle process number: 0
Unix process pid: 21976, image: oracle@
*** SERVICE NAME:(PTYP) 2009-03-31 00:33:41.008
*** SESSION ID:(1423.10903) 2009-03-31 00:33:41.008
*** 2009-03-31 00:33:41.008
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded], [], [], [], [], [], [], []

STACK TRACE
------------
kglobf0 <- kglhpd_internal

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Error from U_get_previous_frame_x is 1
Stack is not Windable
Stack has no Unwind_descriptor
sdsnm: dlmodinfo failed for address : 0x40000000
ksedst()+40 ? ksedst1() 090072FFF ?
80000001000164D8 ?
80000001000164D8 ?
800000010012D388 ?
ksedmp()+168 ? ksedst() 80000001000164D8 ?
800000010012D388 ?
C0000001F0B55478 ?
4000000001B5446F ?
ksfdmp()+32 ? ksedmp() 80000001000164D8 ?
800000010013F6D8 ?
80000001000164D8 ?
00000000C ?
kgerinv()+152 ? ksfdmp() 80000001000164D8 ?
00000000C ?
4000000004E70BE7 ?
1700016098 ?
kgeasnmierr()+88 ? kgerinv() C0000001B8503080 ?
000000000 ?
C0000001FF92E798 ?
800000010012D388 ?
kglobf0()+992 ? kgeasnmierr() A9A00000000 ?
80000001000165B0 ?
4000000001AB89EB ?
000000000 ?
kglhpd_internal()+2 ? kglobf0() C000000100E0BB60 ?
92 4000000004E7368B ?
000000000 ?
800000010012D388 ?
0x0000000040000000 ? kglhpd_internal() 80000001000165B0 ?
C0000001B1D5DC98 ?
000000000 ?
4000000001B374F3 ?

--------------------- Binary Stack Dump ---------------------

SQL
-----
No current SQL statement being executed.

PROCESS STATE
---------------
user: 44/APPS
O/S info: user: applptyp, term: unknown, ospid: , machine: pebpap05.dubaiworld.ae
program: JDBC Thin Client
client info: 104 0
application name: JDBC Thin Client, hash value=0
last wait for 'SQL*Net message from client' blocking sess=0x0000000000000000 seq=46 wait_time=326 seconds since wait started=3
driver id=28444553, #bytes=1, =0
Dumping Session Wait History
for 'SQL*Net message from client' count=1 wait_time=326
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=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:

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

Get Oracle Certifications for all Exams
Free Online Exams.com

Applying arabic syncronization patch [8466814] for EBS using adpatch fails

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

### Detailed Problem Statement ###
Applying arabic syncronization patch [8466814] for EBS using adpatch fails ( @ the end after workers have finished thier jobs) with :

The following Oracle Forms objects did not generate successfully:

on forms/AR PNXVAREN.fmx

Trouble shooing

LOG FILE
-----------------------
Filename =adadmin.log
See the following error:

The following Oracle Forms objects did not generate successfully:
pn forms/AR PNXVAREN.fmx

The US version of the form has been regenerated successfully.

Solution:

This is explained in the following bug:
Bug.6436010 - FORM PNXVAREN FAILED TO REGENERATE DURING NLS TRANSLATION

After applied the patch run adadmin generate the forms and update the status

Get Oracle Certifications for all Exams
Free Online Exams.com

Use DBMS_RANDOM to generate text number date and time stamp values

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

SELECT DBMS_RANDOM.VALUE FROM DUAL;

For integers in a given range, add the arguments low_value and high_value, andtruncate the decimals from the result (the high value is not included as a possible value). So, for integers from 0 to 99,you would use this code:

SELECT TRUNC(DBMS_RANDOM.VALUE(0, 100)) FROM DUAL;

To generate random text strings, use the STRING function andsupply a code indicating the type of string and the desired length:

SELECT DBMS_RANDOM.STRING('A', 20) FROM DUAL;

The type codes are documented in the Oracle Database 10g PL/SQL Packages and Types Reference. Here are a few type codes: 'U' generates uppercase, 'L' generateslowercase, and 'A' generates mixed case.
Oracle stores dates as integer offsets from a key date inthe past (January 1, 4712 B.C., in case you were curious). This means that youcan generate random dates in a given range by finding the integer thatcorresponds to your desired start date, and then adding a random integer to it.

You can generate the internal date number for today's dateby using the TO_CHAR function with the 'J' format code:

SELECT TO_CHAR(SYSDATE, 'J') FROM DUAL;

For example, to generate random dates during the year 2003,you would first determine the date integer for January 1, 2003:

SELECT TO_CHAR(TO_DATE('01/01/03','mm/dd/yy'),'J')

FROM DUAL;

The system responds with 2452641. So, to generate a randomdate within the year, we use DBMS_RANDOM.VALUE with a low_valueof 2452641 and a high_value of 2452641+364, andconvert it to a date:

SELECT TO_DATE(TRUNC(DBMS_RANDOM.VALUE(2452641,2452641+364)),'J')
FROM DUAL;

This is how to generate Random Time Stamp between two dates:

alter session set NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS';

SELECT TO_DATE ('01/07/2011', 'DD/MM/YYYY HH24:MI:SS')
+ DBMS_RANDOM.VALUE (0,
86400
* ( TO_DATE ('30-07-2011', 'DD/MM/YYYY HH24:MI:SS')
- TO_DATE ('02-07-2011', 'DD/MM/YYYY HH24:MI:SS')
)
+ 1
)
/ 86400
FROM DUAL;

Get Oracle Certifications for all Exams
Free Online Exams.com