+---------------------------------------------------------------------------+
Subledger Accounting: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
XLAACCPB module: Create Accounting
+---------------------------------------------------------------------------+
Current system time is 29-MAY-2009 01:05:49
+---------------------------------------------------------------------------+
XDO Data Engine Version No: 5.6.3
Resp: 50559
Org ID : 204
Request ID: 9879427
All Parameters: P_SOURCE_APPLICATION_ID=:P_APPLICATION_ID=222:P_DUMMY=:P_LEDGER_ID=1:P_PROCESS_CATEGORY_CODE=:P_END_DATE=:P_CREATE_ACCOUNTING_FLAG=Y:P_DUMMY_PARAM_1=:P_ACCOUNTING_MODE=F:P_DUMMY_PARAM_2=:P_ERRORS_ONLY_FLAG=N:P_REPORT_STYLE=D:P_TRANSFER_TO_GL_FLAG=:P_DUMMY_PARAM_3=:P_POST_IN_GL_FLAG=N:P_GL_BATCH_NAME=:P_MIN_PRECISION=2:P_INCLUDE_ZERO_AMOUNT_LINES=:P_REQUEST_ID=:P_ENTITY_ID=2312417:P_SOURCE_APPLICATION_NAME=:P_APPLICATION_NAME=:P_LEDGER_NAME=:P_PROCESS_CATEGORY_NAME=:P_CREATE_ACCOUNTING=:P_ACCOUNTING_MODE_NAME=:P_ERRORS_ONLY=:P_ACCOUNTING_REPORT_LEVEL=:P_TRANSFER_TO_GL=:P_POST_IN_GL=:P_INCLUDE_ZERO_AMT_LINES=:P_VALUATION_METHOD_CODE=:P_SECURITY_INT_1=:P_SECURITY_INT_2=:P_SECURITY_INT_3=:P_SECURITY_CHAR_1=:P_SECURITY_CHAR_2=:P_SECURITY_CHAR_3=:P_CONC_REQUEST_ID=:P_INCLUDE_USER_TRX_ID_FLAG=:P_INCLUDE_USER_TRX_IDENTIFIERS=:P_USER_ID=:DebugFlag=
Data Template Code: XLAACCPB
Data Template Application Short Name: XLA
Debug Flag:
{P_ACCOUNTING_REPORT_LEVEL=, P_DUMMY=, P_ACCOUNTING_MODE_NAME=, P_ERRORS_ONLY_FLAG=N, P_REPORT_STYLE=D, P_GL_BATCH_NAME=, P_END_DATE=, P_SECURITY_INT_3=, P_SECURITY_INT_2=, P_SECURITY_INT_1=, P_VALUATION_METHOD_CODE=, P_POST_IN_GL=, P_TRANSFER_TO_GL=, P_TRANSFER_TO_GL_FLAG=, P_INCLUDE_USER_TRX_IDENTIFIERS=, P_USER_ID=, P_PROCESS_CATEGORY_NAME=, P_ERRORS_ONLY=, P_DUMMY_PARAM_3=, P_SECURITY_CHAR_3=, P_DUMMY_PARAM_2=, P_SECURITY_CHAR_2=, P_DUMMY_PARAM_1=, P_SECURITY_CHAR_1=, P_ENTITY_ID=2312417, P_PROCESS_CATEGORY_CODE=, P_INCLUDE_ZERO_AMT_LINES=, P_LEDGER_ID=1, P_POST_IN_GL_FLAG=N, P_APPLICATION_ID=222, P_INCLUDE_USER_TRX_ID_FLAG=, P_APPLICATION_NAME=, P_REQUEST_ID=, P_CONC_REQUEST_ID=, P_LEDGER_NAME=, P_SOURCE_APPLICATION_ID=, P_CREATE_ACCOUNTING=, P_CREATE_ACCOUNTING_FLAG=Y, P_MIN_PRECISION=2, P_SOURCE_APPLICATION_NAME=, P_INCLUDE_ZERO_AMOUNT_LINES=, P_ACCOUNTING_MODE=F}
Calling XDO Data Engine...
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
29-MAY-2009 01:05:55 - Beginning of the Report
29-MAY-2009 01:05:56 - request for balance calulation submitted
29-MAY-2009 01:05:57 - executing extract hook
ARP_XLA_EXTRACT_MAIN_PKG.extract()+
p_application_id :222
p_accounting_mode :F
Calling upgrade_11i_r12_post +
Get 11i application to upgrade
End upgrade_11i_r12_post -
arp_xla_extract_main_pkg.load_header_data_ctlgd ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-
arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+
arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-
arp_xla_extract_main_pkg.load_line_data_app_from_cr()+
arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-
arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+
arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-
arp_xla_extract_main_pkg.load_line_data_mcd()+
arp_xla_extract_main_pkg.load_line_data_mcd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-
ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()+
ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()-
JL Callout JL_BR_AR_BANK_ACCT_PKG.load_occurrences_header_data
+--------BEGIN READING XLA_EVENTS_GT--------------+
|------------------EVENT#1----------------|
2312417
222
1
204
RECEIPTS
RN-301
85842
2402949
RECEIPT
RECP_CREATE
1
27-MAY-09
U
U
27-MAY-09
N
+--------END READING XLA_EVENTS_GT----------------+
+--------BEGIN READING AR_XLA_LINES_EXTRACT-------+
|---------LINE#1--------------------------|
Y
H
RECP_CREATE
RECEIPT
RECEIPTS
N
2402949
USD
204
85842
CR
85842
11640
40764
1
|---------LINE#2--------------------------|
N
L
REMITTED
-125000
RECP_CREATE
RECEIPT
RECEIPTS
2402949
385004
1
115605
CRH
385004
USD
-125000
0
204
115605
CRH
85842
1
|---------LINE#3--------------------------|
284650
N
L
UNID
125000
RECP_CREATE
RECEIPT
RECEIPTS
2402949
385003
1
284650
RA
385003
USD
125000
0
204
284650
CRH
85842
1
+--------END READING AR_XLA_LINES_EXTRACT---------+
ARP_XLA_EXTRACT_MAIN_PKG.extract()-
event key = 15291
29-MAY-2009 01:05:59 - extract hook executed successfully
***************************************************************************************************
The following REVERSAL events could not be processed. The event/process status is U/U:
Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
-------NO SUCH EVENTS-----------
***************************************************************************************************
29-MAY-2009 01:06:14 - executing postprocessing hook
ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+
ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-
event key = 15291
29-MAY-2009 01:06:14 - postprocessing hook executed successfully
29-MAY-2009 01:06:14 - Calling sequencing get_sequence_number
Technical problem : Problem encountered in sequencing GET_SEQUENCE_NUMBER.
29-MAY-2009 01:06:16 - End of the Report
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 29-MAY-2009 01:06:16
+---------------------------------------------------------------------------+