Hi there,
I submitted the concurrent program with xml output generated by the Oracle report to print BIP report, and this concurrent program keeps long running and has the errors. We have just upgraded from the database from 11g to 12c, before upgrading it has no issue. Below is the error log. I have no what is the problem, appreciate someone can advise me. Thanks in advance.
+---------------------------------------------------------------------------+
Seagate Oracle Order Entry: Version : 12.1
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
SO0ACKBM_BIP: Bitmap Sales Order Acknowledgment - Batch Report - BIP
+---------------------------------------------------------------------------+
Current system time is 15-JAN-2018 09:27:45
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_ORG_ID='87'
P_SOB_ID='2066'
P_ORGANIZATION_ID='82'
P_ORDER_NUMBER='404414736'
P_REPRINT='Y'
DebugFlag='Y'
P_Customer_Type_Code='BR-ENDU'
P_Footer_language='en'
------------
Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing
APPLLCSP Environment Variable set to :
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.AL32UTF8
'.,'
stat_low = 86
stat_high = 0
emsg:was terminated by signal 6
Enter Password:
SELECT * from OE_TAX_LINES_SUMMARY_V¿¿d¿
WHERE trx_header_id = :b1
ORDER BY trx_header_id, trx_line_id, location_qualifier
SQL STATEMENT LENGTH = 151
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0x306bc7dc, pid=59316, tid=3431549760
#
# Java VM: Java HotSpot(TM) Server VM (1.4.2_14-b05 mixed mode)
# Problematic frame:
# C 0x306bc7dc
#
# An error report file with more information is saved as hs_err_pid59316.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
#
Report Builder: Release 10.1.2.3.0 - Production on Mon Jan 15 09:27:47 2018
Copyright (c) 1982, 2005, Oracle. All rights reserved.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program was terminated by signal 6
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 156604672.
Review your concurrent request log and/or report output file for more detailed information.
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
0
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 15-JAN-2018 09:27:58
+---------------------------------------------------------------------------+
Regards,
BE