Post date: Nov 12, 2013 8:3:56 AM
Error Log:
+---------------------------------------------------------------------------+ Receivables: Version : 11.5.0 - Development Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. RAXTRX module: Autoinvoice Import Program +---------------------------------------------------------------------------+ Current system time is 11-NOV-2013 23:28:31 +---------------------------------------------------------------------------+ raagsp()+ Current system time is 11-NOV-2013 23:28:31 Error calling afpoget() - AR_ALLOW_TRX_LINE_EXEMPTIONS raagsp()- Current system time is 11-NOV-2013 23:28:31 Dumping data fetched from RA_BATCH_SOURCES batch_source_name = Order Entry auto_trx_numbering_flag = Y copy_doc_number_flag = Y cust_trx_type_rule = I sold_customer_rule = I bill_customer_rule = I bill_address_rule = I bill_contact_rule = I ship_customer_rule = I ship_address_rule = I ship_contact_rule = I memo_reason_rule = I term_rule = I invoicing_rule_rule = I accounting_rule_rule = I unit_of_measure_rule = I agreement_rule = I inventory_item_rule = I fob_point_rule = S ship_via_rule = S invalid_lines_rule = R salesperson_rule = I sales_credit_type_rule = I accounting_flexfield_rule = I invalid_tax_rate_rule = C rev_acc_allocation_rule = P gl_date_period_rule = R create_clearing_flag = N derive_date_flag = Y sales_credit_rule = P sales_territory_rule = I receipt_method_rule = I customer_bank_account_rule = I related_document_rule = I memo_line_rule = I allow_sales_credit_flag = Y receipt_handling_option = N raagixpfx = 0 raagixtpf = 0 raagixddf = 1 raagixacf = 0 raagixrit = 0 raagixagd = 0 raagixatn = 1 raagixcte = 0 raagixdfd = raagixctc = 0 raagixrmx = T raagixfdx = 11-NOV-13 raagixbix = raagixbsi = 1032 raagixbnx = Order Entry raagixoix = 104 raagixrix = 18467860 raagixpix = 20428 raagixpai = 222 raagixuix = 1090 raagixunx = MII raagixanx = AR raagixlul = 19313045 raagixasc = 1 raagixrho = N raagixrsf = 0 raagixcbf = 0 raagixuax = 1 Argtcm = 1 Argtvd = 0 raagixsnf = 1 raagixtao = 0 raagixptf = 0 raagixstf = 0 raagixrfi = 0 raagixtac = 0 raagixcai = 50268 raagixsbi = 1001 raagixcpr = 2 raagixmau = raagixmlx = 0 raagixmbx = 300000 raagixafp = Account raagixifp = Item raagixtfp = Argbdf = 1 Argddo = -9999 crb->raaucrpn = RAXTRX crb->raaucrcr = 18467860 crb->raaucrnt = 0 crb->raaucrml = 0 Validating : Current system time is 11-NOV-2013 23:33:10 raavgi()+ Current system time is 11-NOV-2013 23:33:11 raavgi()- Current system time is 11-NOV-2013 23:33:11 Current system time is 12-NOV-2013 01:43:04 APP-AR-11526: ORA-01555: snapshot too old: rollback segment number 42 with name "_SY INSERT INTO RA_INTERFACE_ERRORS (INTERFACE_LINE_ID, MESSAGE_TEXT, APP-AR-11526: 3705280/ar/src/autoinv/raavdf.lpc 816 INSERT INTO RA_INTERFACE_ERRORS (INTERFACE_LINE_ID, MESSAGE_TEXT, INVALID_VALUE) SELECT INTERFACE_LINE_ID, :b_err_msg6, 'trx_number='||T.TRX_NUMBER||','||'customer_trx_id='||TL.CUSTOMER_TRX_ID FROM RA_INTERFACE_LINES_GT IL, RA_CUSTOMER_TRX_LINES TL, RA_CUSTOMER_TRX T WHERE IL.REQUEST_ID = :b1 AND IL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY' AND T.CUSTOMER_TRX_ID =TL.CUSTOMER_TRX_ID AND IL.INTERFACE_LINE_CONTEXT = TL.INTERFACE_LINE_CONTEXT AND IL.INTERFACE_LINE_ATTRIBUTE1 = TL.INTERFACE_LINE_ATTRIBUTE1 AND IL.INTERFACE_LINE_ATTRIBUTE2 = TL.INTERFACE_LINE_ATTRIBUTE2 AND IL.INTERFACE_LINE_ATTRIBUTE3 = TL.INTERFACE_LINE_ATTRIBUTE3 AND IL.INTERFACE_LINE_ATTRIBUTE4 = TL.INTERFACE_LINE_ATTRIBUTE4 AND IL.INTERFACE_LINE_ATTRIBUTE5 = TL.INTERFACE_LINE_ATTRIBUTE5 AND IL.INTERFACE_LINE_ATTRIBUTE6 = TL.INTERFACE_LINE_ATTRIBUTE6 AND IL.INTERFACE_LINE_ATTRIBUTE7 = TL.INTERFACE_LINE_ATTRIBUTE7 AND IL.INTERFACE_LINE_ATTRIBUTE8 = TL.INTERFACE_LINE_ATTRIBUTE8 AND IL.INTERFACE_LINE_ATTRIBUTE9 = TL.INTERFACE_LINE_ATTRIBUTE9 AND IL.INTERFACE_LINE_ATTRIBUTE11 = TL.INTERFACE_LINE_ATTRIBUTE11 AND IL.INTERFACE_LINE_ATTRIBUTE12 = TL.INTERFACE_LINE_ATTRIBUTE12 AND IL.INTERFACE_LINE_ATTRIBUTE13 = TL.INTERFACE_LINE_ATTRIBUTE13 AND IL.INTERFACE_LINE_ATTRIBUTE14 = TL.INTERFACE_LINE_ATTRIBUTE14 Error calling raavdf() Error calling raapu0() Commit after cleanup - Current system time is 12-NOV-2013 01:43:16 +---------------------------------------------------------------------------+ Start of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ End of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ No completion options were requested. Error calling raapu0() +---------------------------------------------------------------------------+ Concurrent request completed Current system time is 12-NOV-2013 01:43:43 +---------------------------------------------------------------------------+
Solution:
To implement the solution, please reorganize interface tables RA_INTERFACE_ERRORS_ALL, and RA_INTERFACE_LINES_ALL:
1. Copy any rows on the interface tables to a backup table. For example:
create table ra_i_err as select * from ra_interface_errors_all; create table ra_i_lin_all as select * from ra_interface_lines_all;
2. Truncate the interface tables:
truncate table ra_interface_errors_all; truncate table ra_interface_lines_all;
3. Reinsert the rows into the interface table from backup table:
insert into ra_interface_errors_all select * from ra_i_err; insert into ra_interface_lines_all select * from ra_i_lin_all;
4. Gather statistics for these tables and their indexes. REFERENCES