This discussion is archived
0 Replies Latest reply: Oct 3, 2012 7:15 AM by user441402 RSS

"java.lang.NumberFormatException" error while running custom BIP report

user441402 Newbie
Currently Being Moderated
Hi,

When we are running a custom BIP report, it is completing in ERROR at times and running Succesfully at times for the same set of parameters.
Please let us know the solution if any one faced similar kind of an issue.

Below is the log file when the program errors out:

Calling XDO Data Engine...
java.lang.NumberFormatException: For input string: "000</UIN><ACC>726030</ACC><ACC_N>Express Services - Mail and Courier</ACC_N><S_ACC_N>00000</S_ACC_N><S_ACC_NA>Default - Sub Account</S_ACC_NA><I_CO>000</I_CO><PROD>Term Life - GBL - Allocation Ind NQ NP BCLIC Direct</PROD><BAL>1126.47</BAL><A_L>9</A_L><P_ACC>GEN_EXP_POSTAGE_S</P_ACC><S_F>N</S_F><R_ID>3123</R_ID>ACC_N><S_ACC_NA>Default - Sub Account</S_ACC_NA><I_CO>000</I_CO><PROD>Annuities Dep Type - Allocation Ind NQ NP OCB</PROD><BAL>13.5</BAL><A_L>9</A_L><P_ACC>GEN_EXP_POSTAGE_S</P_ACC><S_F>N</S_F><R_ID>3124</R_ID>N><ACC>MGMT_ACCT_HIERARCHY</ACC><ACC_N/><S_ACC_N/><S_ACC_NA/><I_CO/><PROD>FPDA - Other Ind Q NP BCLIC Ind Agt</PROD><BAL>176028.27</BAL><A_L>0</A_L><P_ACC/><S_F>Y</S_F><R_ID>36</R_ID>_T>>726030</ACC><ACC_N>Express Services - Mail and Courier</ACC_N><S_ACC_N>00000</S_ACC_N><S_ACC_NA>Default - Sub Account</S_ACC_NA><I_CO>000</I_CO><PROD>Annuities Other - Allocation Ind NQ NP NON OCB</PROD><BAL>2.58</BAL><A_L>9</A_L><P_ACC>GEN_EXP_POSTAGE_S</P_ACC><S_F>N</S_F><R_ID>3127</R_ID>R_ID>3128</R_ID>S_F><R_ID>41</R_ID>ther - Allocation Ind NQ NP BCLIC Career</PROD><BAL>267.97</BAL><A_L>9</A_L><P_ACC>GEN_EXP_POSTAGE_S</P_ACC><S_F>N</S_F><R_ID>3131</R_ID>areer</PROD><BAL>53.31</BAL><A_L>9</A_L><P_ACC>GEN_EXP_POSTAGE_S</P_ACC><S_F>N</S_F><R_ID>3132</R_ID>o CV Ind NQ NP BCLIC Direct</PROD><BAL>-29963</BAL><A_L>0</A_L><P_ACC/><S_F>Y</S_F><R_ID>46</R_ID>N>Telecommunication/Online Services</ACC_N><S_ACC_N>00000</S_ACC_N><S_ACC_NA>Default - Sub Account</S_ACC_NA><I_CO>000</I_CO><PROD>Term Life - Other - Allocation Grp NQ NP BCLIC Career</PROD><BAL>.06</BAL><A_L>9</A_L><P_ACC>GEN_EXP_POSTAGE_S</P_ACC><S_F>N</S_F><R_ID>3135</R_ID>_ACC_NA><I_CO>000</I_CO><PROD>LTC - Allocation Ind Guar Ren NON OCB</PROD><BAL>22.05</BAL><A_L>9</A_L><P_ACC>GEN_EXP_POSTAGE_S</P_ACC><S_F>N</S_F><R_ID>3136</R_ID>ROD>Term Life - Other - Allocation Grp NQ NP BCLIC Career</PROD><BAL>1118.96</BAL><A_L>0</A_L><P_ACC/><S_F>Y</S_F><R_ID>51</R_ID>S_ACC_N>00000</S_ACC_N><S_ACC_NA>Default - Sub Account</S_ACC_NA><I_CO>000</I_CO><PROD>Annuities Other - Allocat"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:59)
at java.lang.Integer.parseInt(Integer.java:467)
at java.lang.Integer.parseInt(Integer.java:508)
at oracle.apps.xdo.dataengine.ScalableStringList.get(ScalableStringList.java:162)
at oracle.apps.xdo.dataengine.XMLPGEN.writeRowSetListToStream(XMLPGEN.java:1277)
at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:559)
at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445)
at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

Oracle error 6502: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_CONCURRENT", line 1331
ORA-06512: at line 1
has been detected in FND_CONCURRENT.SET_INTERIM_STATUS.---------------------------------------------------------------------------
Start of log messages from FND_FILE
---------------------------------------------------------------------------
---------------------------------------------------------------------------
End of log messages from FND_FILE
---------------------------------------------------------------------------

---------------------------------------------------------------------------
Executing request completion options...

Output file size:
9662

------------- 1) PUBLISH -------------
Beginning post-processing of request 970405 on node UXEBSCMP01 at 29-SEP-2012 21:02:30.
Post-processing of request 970405 failed at 29-SEP-2012 21:02:30 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
--------------------------------------


Finished executing request completion options.

---------------------------------------------------------------------------
Concurrent request completed
Current system time is 29-SEP-2012 21:02:30

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


Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points