| Customized report error out after upgraded [message #651368] |
Mon, 16 May 2016 12:31  |
 |
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  |
|
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 #651388 is a reply to message #651373] |
Tue, 17 May 2016 02:46 |
cookiemonster
Messages: 13960
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
