Home » Developer & Programmer » Reports & Discoverer » Customized report error out after upgraded
Customized report error out after upgraded [message #651368] Mon, 16 May 2016 12:31 Go to next message
pthrinadh3@gmail.com
Messages: 14
Registered: March 2016
Location: VIZAG
Junior Member
Hello Every one,
We are currently working an R12 upgrade project from 11.5.10 to 12.2.4. I am currently converting a report from 11i to R12 but it is error out when I run it in R12.
the error is ("MSG-00100: DEBUG: AfterParam_Procs.Populate_Tax_Printing_Option - Failed.")
Below is the log. Any help would be greatly appreciated.
Re: Customized report error out after upgraded [message #651369 is a reply to message #651368] Mon, 16 May 2016 12:33 Go to previous messageGo to next message
pthrinadh3@gmail.com
Messages: 14
Registered: March 2016
Location: VIZAG
Junior Member
Please see the below log file messges

Receivables: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

BMXRAXINV: BMX Invoice Print Selected Invoices
+---------------------------------------------------------------------------+

Current system time is 12-MAY-2016 15:00:16

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
P_SHOW_SERIAL='Y'
p_order_by='TRX_NUMBER'
p_cust_trx_source_id='1146'
p_trx_number_low='10433'
p_trx_number_high='10433'
p_open_invoice='N'
p_check_for_taxyn='N'
p_choice='SEL'
p_header_pages='1'
p_debug_flag='N'
p_message_level='10'
P_CHECK='NO'
------------


-- Start of Reports Command --
/oracle_homes/archr12/fs1/inst/apps/ARCH_archapp1/ora/10.1.2/bin/appsrwrun.sh
P_CONC_REQUEST_ID=43819704
P_SHOW_SERIAL='Y'
p_order_by='TRX_NUMBER'
p_cust_trx_source_id='1146'
p_trx_number_low='10433'
p_trx_number_high='10433'
p_open_invoice='N'
p_check_for_taxyn='N'
p_choice='SEL'
p_header_pages='1'
p_debug_flag='N'
p_message_level='10'
P_CHECK='NO'
report=/oracle_homes/archr12/fs1/EBSapps/appl/ar/12.0.0/reports/US/BS_RAXINV.rdf
batch=yes
destype=file
desname=/oracle_homes/archr12/fs_ne/inst/ARCH_archapp1/logs/appl/conc/out/o43819704.out
desformat=XML
-- End of Reports Command --



Request language is :AMERICAN
Request territory is :AMERICA
Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing
APPLLCSP Environment Variable set to :
Previous NLS_LANG Environment Variable was :AMERICAN_AMERICA.UTF8
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :AMERICAN_AMERICA.UTF8

'.,'

Enter Password:
MSG-00100: DEBUG: AfterPForm_Trigger +
MSG-00100: DEBUG: Multi Org established.
MSG-00100: DEBUG: AfterParam_Procs.Get_Country_Details
MSG-00100: DEBUG: AfterParam_Procs.Get_Country_Details
MSG-00100: DEBUG: BeforeReport_Trigger +
MSG-00100: DEBUG: BeforeReport_Procs.Populate_Printing_Option
MSG-00100: DEBUG: BeforeReport_Procs.Populate_Tax_Printing_Option
MSG-00100: DEBUG: AfterParam_Procs.Populate_Tax_Printing_Option - Failed.

Report Builder: Release 10.1.2.3.0 - Production on Thu May 12 15:00:17 2016

Copyright (c) 1982, 2005, Oracle. All rights reserved.



Reset original NLS_LANG in environment as :AMERICAN_AMERICA.UTF8

====================================================================
THIS IS THE TAX PRINTING OPETION CODE
===================================================================

PROCEDURE Get_Tax_Option IS
tax_option varchar2(30);
BEGIN

srw.message (100, 'DEBUG: AfterParam_Procs.Get_Tax_Option');

if (:p_tax_printing_option is null) then
select tax_invoice_print
into tax_option
from ar_system_parameters;

:p_tax_printing_option := tax_option;
end if;

EXCEPTION
WHEN OTHERS THEN
srw.message (100, 'DEBUG: AfterParam_Procs.Get_Tax_Option - Failed.');
RAISE;

END Get_Tax_Option;


[Updated on: Mon, 16 May 2016 12:34]

Report message to a moderator

Re: Customized report error out after upgraded [message #651372 is a reply to message #651369] Mon, 16 May 2016 12:45 Go to previous messageGo to next message
Michel Cadot
Messages: 67439
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Re: Customized report error out after upgraded [message #651373 is a reply to message #651372] Mon, 16 May 2016 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 67439
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In addition, if you want someone help you, you should envisage to answer the questions that have been asked to you and to feedback in your previous topics.
Just ignoring those who spend time to try to help you is not a good way to have further help or to be appreciated in your professional life.

Re: Customized report error out after upgraded [message #651388 is a reply to message #651373] Tue, 17 May 2016 02:46 Go to previous messageGo to next message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
This:
EXCEPTION
WHEN OTHERS THEN
srw.message (100, 'DEBUG: AfterParam_Procs.Get_Tax_Option - Failed.');
RAISE;

Is deeply silly. You've got an error. The above code catches the error and then returns a message that gives you zero clues as to what the error is and prevents the actual error from being logged anywhere.
Delete it and you'll get the actual error message in the log file.

[Updated on: Tue, 17 May 2016 02:47]

Report message to a moderator

Re: Customized report error out after upgraded [message #651431 is a reply to message #651388] Tue, 17 May 2016 14:21 Go to previous messageGo to next message
Littlefoot
Messages: 21608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Log says "AfterParam_Procs.Populate_Tax_Printing_Option - Failed". Why did you post "Get_Tax_Option" procedure code, then?
Re: Customized report error out after upgraded [message #651446 is a reply to message #651431] Wed, 18 May 2016 02:46 Go to previous message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
Good spot. My recommendation above should be applied to all procedures that have those exception handlers.
Previous Topic: How to remove junk characters in seeded oracle report?
Next Topic: use one group column in another group in report
Goto Forum:
  


Current Time: Mon Oct 19 18:25:51 CDT 2020