XML Report Error ( java.lang.reflect.InvocationTargetException ) or ( oracle.xdo.parser.v2.XMLParseException: Expected name instead of . )

XML Report Log Error Message

Template code: TEMPLATE_NAME
Template app:  GMI
Language:      en
Territory:     00
Output type:   PDF
[5/8/12 1:56:05 PM] [UNEXPECTED] [347969:RT17367773] java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
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:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: oracle.xdo.parser.v2.XMLParseException: Expected name instead of  .
at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:337)
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)
... 16 more
Reason -
Some Column having the special chr contents

Solution-
Remove the special chr from the report columns or use replace function for removing the special chr at report level.

ORA-01031 insufficient privileges sysdba login

Error
$ sqlplus /nolog
SQL>conn sys/xxx as sysdba;
error: "ORA-01031: insufficient privileges" 

Solution

$ORACLE_SID=oracle
$export ORACLE_SID
$ORACLE_HOME=/db/oracle/9.2.0
$export ORACLE_HOME
$cd /db/oracle/9.2.0/dbs
$mv orapworacle9i orapworacle9i_bk
$cd /db/oracle/9.2.0/bin
$orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=xxx entries=40
$ sqlplus /nolog
SQL>conn sys/xxx as sysdba;
Connected to an idle instance.
Check the metalink Document

SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1]
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=50507.1

EM install failed AIX 6.1 Database 11gR1

bash-3.00$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Apr 10, 2012 12:34:14 AM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: STAR
Unhandled exception
Type=Segmentation error vmState=0x00000000
J9Generic_Signal_Number=00000004 Signal_Number=0000000b Error_Value=00000000 Signal_Code=00000033
Handler1=09001000A03E0C78 Handler2=09001000A03D8538
R0=0000000000000000 R1=0FFFFFFFFFFFDF70 R2=0000000000000001 R3=0000000000000017
R4=0700000000353830 R5=00000000000000B8 R6=0000000000000000 R7=0000000000000018
R8=0000000000000000 R9=0000000000000001 R10=00000001101EC908 R11=09000000009B2C38
R12=00000001101CF0E4 R13=0000000110015FA0 R14=0000000111562800 R15=000000011016BF00
R16=0000000110A02270 R17=00000001122F39E8 R18=09001000A03E43B0 R19=0700000000000FA0
R20=000000011148FD08 R21=0000000111562968 R22=0000000000000032 R23=000000000000002A
R24=00000000995188BE R25=07000000003533C8 R26=FFFFFFFFFFFFFFFF R27=0000000000000017
R28=070000000035FF48 R29=0000000000000001 R30=0000000000000016 R31=0000000000000000
IAR=09000000009B2C38 LR=00000001101ECABC MSR=A00000000000D032 CTR=09000000009B2C38
CR=8458508420000003 FPSCR=8202000000000000 XER=2000000382020000
FPR0 0000000800000008 (f: 8.000000, d: 1.697597e-313)
FPR1 41e0000000000000 (f: 0.000000, d: 2.147484e+09)
FPR2 3fe8000000000000 (f: 0.000000, d: 7.500000e-01)
FPR3 3fee666660000000 (f: 1610612736.000000, d: 9.500000e-01)
FPR4 4530000000000000 (f: 0.000000, d: 1.934281e+25)
FPR5 4530000000000000 (f: 0.000000, d: 1.934281e+25)
FPR6 3ff0000000000000 (f: 0.000000, d: 1.000000e+00)
FPR7 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR8 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR9 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR10 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR11 4026000000000000 (f: 0.000000, d: 1.100000e+01)
FPR12 3fe8000000000000 (f: 0.000000, d: 7.500000e-01)
FPR13 4020800000000000 (f: 0.000000, d: 8.250000e+00)
FPR14 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR15 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR16 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR17 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR18 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR19 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR20 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR21 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR22 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR23 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR24 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR25 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR26 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR27 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR28 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR29 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR30 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR31 0000000000000000 (f: 0.000000, d: 0.000000e+00)
Module=/pd/Star/db/tech_st/11.1.0/jdk/jre/bin/libj9jit23.so
Module_base_address=0900000000988000
Target=2_30_20070131_11312_BHdSMr (AIX 6.1)
CPU=ppc64 (32 logical CPUs) (0x7b8000000 RAM)
JVMDUMP006I Processing Dump Event "gpf", detail "" - Please Wait.
JVMDUMP007I JVM Requesting System Dump using '/pd/Star/db/tech_st/11.1.0/bin/core.20120410.003419.9437226.dmp'
JVMDUMP010I System Dump written to /pd/Star/db/tech_st/11.1.0/bin/core.20120410.003419.9437226.dmp
JVMDUMP007I JVM Requesting Snap Dump using '/pd/Star/db/tech_st/11.1.0/bin/Snap0001.20120410.003419.9437226.trc'
JVMDUMP010I Snap Dump written to /pd/Star/db/tech_st/11.1.0/bin/Snap0001.20120410.003419.9437226.trc
JVMDUMP007I JVM Requesting Java Dump using '/pd/Star/db/tech_st/11.1.0/bin/javacore.20120410.003419.9437226.txt'
JVMDUMP010I Java Dump written to /pd/Star/db/tech_st/11.1.0/bin/javacore.20120410.003419.9437226.txt
JVMDUMP013I Processed Dump Event "gpf", detail "".

----

bash-3.00$ java -version
java version "1.6.0"
Java(TM) SE Runtime Environment (build pap3260-20071123_01)
IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 AIX ppc-32 jvmap3260-20071121_15015 (JIT enabled)
J9VM - 20071121_015015_bHdSMR
JIT  - r9_20071121_1330
GC   - 20071031_AA)
JCL  - 20071118_01

---

The solution for this error is run below command before starting the task
export JAVA_COMPILER=NONE

SQL Developer is not showing view outputs

SQL Developer is not showing org_organization_definitions view output

Cause: SQL developer default NLS setting taken from client Language settings. If client language setting is not matched with database language setting, language specified view will not show any outputs in SQL Developer

Solution: Skip NLS setting in SQL Developer
 Tools à Preferences à Database à NLS

R12 Cloning issues

AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management

------Appstier cloning------
Beginning application tier Apply - Tue Dec 21 20:20:14 2010

/12i/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /12i/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/12i/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/12i/apps/apps_st/comn/clone/jlib/java:/12i/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/12i/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/12i/apps/apps_st/comn/clone/jlib/oui/share.jar:/12i/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/12i//apps/apps_st/comn/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e /12i/inst/apps/inst_machine//appl/admin/inst_machine.xml -stage /12i/apps/apps_st/comn/clone -showProgress
APPS Password : Log file located at /12i/inst/apps/inst_machine/admin/log/ApplyAppsTier_12212020.log

3% completed

AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management
Deactivating Context Value Management System.

Restored the Context file in :
/12i/inst/apps/inst_machine/appl/admin/inst_machine.xml
Aborting the running of Context Value Management
Error occured before Context Value Management could be completed

- 78% completed

Completed Apply...
Tue Dec 21 20:30:42 2010

If you ignore this error, cloning will be completed sucessfully

How to find the financial year starting date based on tansaction date

Example : Financial period April to March


select '01-APR-'|| decode (to_char (to_date (:transaction_date), 'MM'), '01', to_char (to_number (to_char (to_date (:transaction_date), 'YYYY')) - 1), '02', to_char (to_number (to_char (to_date (:transaction_date), 'YYYY')) - 1), '03', to_char (to_number (to_char (to_date (:transaction_date), 'YYYY')) - 1), to_char (to_number (to_char (to_date (:transaction_date), 'YYYY'))))yearfrom dual

Transaction date : 31-DEC-2009
Result : 01-APR-2009


Transaction date : 01-MAR-2010
Result : 01-APR-2009