+---------------------------------------------------------------------------+ Receivables: Version : 12.0.0 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. RAXTRX module: Autoinvoice Import Program +---------------------------------------------------------------------------+ Current system time is 15-NOV-2012 13:16:02 +---------------------------------------------------------------------------+ org parameter (raamai) = ~82~ raassc()+ Current system time is 15-NOV-2012 13:16:02 org parameter (raassc) character = ~82~ org parameter (raassc) numeric = ~82~ raassc()- Current system time is 15-NOV-2012 13:16:02 raagsp()+ Current system time is 15-NOV-2012 13:16:02 raagsp()- Current system time is 15-NOV-2012 13:16:02 raaini()+ Current system time is 15-NOV-2012 13:16:02 raaapx()+ Current system time is 15-NOV-2012 13:16:02 raaapx()- Current system time is 15-NOV-2012 13:16:02 raagbo()+ Current system time is 15-NOV-2012 13:16:02 Dumping data fetched from RA_BATCH_SOURCES batch_source_id = 1011 batch_source_name = KOF1 auto_trx_numbering_flag = N copy_doc_number_flag = N cust_trx_type_rule = R sold_customer_rule = R bill_customer_rule = R bill_address_rule = R bill_contact_rule = I ship_customer_rule = R ship_address_rule = I ship_contact_rule = I memo_reason_rule = R term_rule = R invoicing_rule_rule = N accounting_rule_rule = N unit_of_measure_rule = I agreement_rule = N inventory_item_rule = R fob_point_rule = N ship_via_rule = N invalid_lines_rule = R salesperson_rule = R sales_credit_type_rule = I accounting_flexfield_rule = I invalid_tax_rate_rule = R rev_acc_allocation_rule = A gl_date_period_rule = A create_clearing_flag = N derive_date_flag = Y sales_credit_rule = P sales_territory_rule = N receipt_method_rule = I customer_bank_account_rule = I related_document_rule = N memo_line_rule = R allow_sales_credit_flag = Y receipt_handling_option = N allow_duplicate_trx_num_flag = N raagbo()- Current system time is 15-NOV-2012 13:16:02 raaggi()+ Current system time is 15-NOV-2012 13:16:02 raagixpfx = 0 raagixtpf = 0 raagixddf = 1 raagixacf = 0 raagixagd = 1 raagixatn = 0 raagixadn = 0 raagixcte = 0 raagixdfd = raagixctc = 0 raagixrmx = T raagixfdx = 15-NOV-12 raagixbix = raagixbsi = 1011 raagixbnx = KOF1 raagixoix = 82 raagixrix = 454873 raagixpix = 20428 raagixpai = 222 raagixuix = 1271 raagixunx = SHITIJ raagixanx = AR raagixlul = 117224 raagixasc = 1 raagixrho = N raagixrsf = 0 raagixcbf = 0 raagixuax = 0 raagixsnf = 1 raagixtao = 1 raagixptf = 0 raagixstf = 0 raagixrfi = 0 raagixtac = 0 raagixcai = 50368 raagixsbi = 2021 raagixcpr = 2 raagixmau = raagixmlx = 9 raagixmbx = 2048000 raagixafp = KONTO raagixifp = Item raagixtfp = Salesdistrict Argbdf = 1 Argddo = -9999 raaggi()- Current system time is 15-NOV-2012 13:16:02 raaseb()+ Current system time is 15-NOV-2012 13:16:02 raaseb()- Current system time is 15-NOV-2012 13:16:02 arcdsu()+ Current system time is 15-NOV-2012 13:16:02 arcdsu() error level: 9 array size: 2048000 insert array size: 2048000 arcdsu() Use Invoice Accounting For Credit Memo: N arcdsu()- Current system time is 15-NOV-2012 13:16:02 raaini()- Current system time is 15-NOV-2012 13:16:02 raapft()+ Current system time is 15-NOV-2012 13:16:02 raagtr()+ Current system time is 15-NOV-2012 13:16:02 crb->raaucrpn = RAXTRX crb->raaucrcr = 454873 crb->raaucrnt = 0 crb->raaucrml = 9 raagtr()- Current system time is 15-NOV-2012 13:16:02 raamil()+ Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 raaasf()+ Current system time is 15-NOV-2012 13:16:02 raaasf()- Current system time is 15-NOV-2012 13:16:02 UPDATE RA_INTERFACE_LINES SET LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = :b1, LAST_UPDATE_LOGIN = :b2, SET_OF_BOOKS_ID = NVL(SET_OF_BOOKS_ID, :b3), ORG_ID = NVL(ORG_ID, :b4), TRX_DATE = TRUNC(TRX_DATE), GL_DATE = TRUNC(GL_DATE), ORIGINAL_GL_DATE = TRUNC(GL_DATE), CONVERSION_DATE = TRUNC(CONVERSION_DATE), PURCHASE_ORDER_DATE = TRUNC(PURCHASE_ORDER_DATE), RULE_START_DATE = TRUNC(RULE_START_DATE), RULE_END_DATE = TRUNC(RULE_END_DATE), SALES_ORDER_DATE = TRUNC(SALES_ORDER_DATE), SHIP_DATE_ACTUAL = TRUNC(SHIP_DATE_ACTUAL), CUSTOMER_TRX_ID = NULL, INTERFACE_LINE_ID = NVL(INTERFACE_LINE_ID, RA_CUSTOMER_TRX_LINES_S.NEXTVAL) WHERE NVL(INTERFACE_STATUS, '~') != 'P' AND REQUEST_ID = :b5 AND LINK_TO_LINE_ATTRIBUTE1 IS NULL AND LINK_TO_LINE_ATTRIBUTE2 IS NULL AND LINK_TO_LINE_ATTRIBUTE3 IS NULL AND LINK_TO_LINE_ATTRIBUTE4 IS NULL AND LINK_TO_LINE_ATTRIBUTE5 IS NULL AND LINK_TO_LINE_ATTRIBUTE6 IS NULL AND LINK_TO_LINE_ATTRIBUTE7 IS NULL AND LINK_TO_LINE_ATTRIBUTE8 IS NULL AND LINK_TO_LINE_ATTRIBUTE9 IS NULL AND LINK_TO_LINE_ATTRIBUTE10 IS NULL AND LINK_TO_LINE_ATTRIBUTE11 IS NULL AND LINK_TO_LINE_ATTRIBUTE12 IS NULL AND LINK_TO_LINE_ATTRIBUTE13 IS NULL AND LINK_TO_LINE_ATTRIBUTE14 IS NULL AND LINK_TO_LINE_ATTRIBUTE15 IS NULL len = 1246 10000 rows updated Current system time is 15-NOV-2012 13:16:13 raagtf()+ Current system time is 15-NOV-2012 13:16:13 raagtf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 raaasf()+ Current system time is 15-NOV-2012 13:16:19 raaasf()- Current system time is 15-NOV-2012 13:16:19 UPDATE RA_INTERFACE_LINES L1 SET REQUEST_ID = :b1, LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = :b2, LAST_UPDATE_LOGIN = :b3, CUSTOMER_TRX_ID = NULL, INTERFACE_LINE_ID = NVL(INTERFACE_LINE_ID, RA_CUSTOMER_TRX_LINES_S.NEXTVAL), SET_OF_BOOKS_ID = NVL(SET_OF_BOOKS_ID, :b4), LINK_TO_LINE_ID = ( SELECT INTERFACE_LINE_ID FROM RA_INTERFACE_LINES L2 WHERE L2.REQUEST_ID = :b5 AND L2.INTERFACE_LINE_CONTEXT = 'KOF1' AND L1.LINK_TO_LINE_CONTEXT = L2.INTERFACE_LINE_CONTEXT AND L1.LINK_TO_LINE_ATTRIBUTE1 = L2.INTERFACE_LINE_ATTRIBUTE1 AND L1.LINK_TO_LINE_ATTRIBUTE2 = L2.INTERFACE_LINE_ATTRIBUTE2 ) WHERE NVL(INTERFACE_STATUS, '~') != 'P' AND (REQUEST_ID IS NULL) AND (( LINK_TO_LINE_CONTEXT ,LINK_TO_LINE_ATTRIBUTE1 ,LINK_TO_LINE_ATTRIBUTE2 ) IN ( SELECT /*+ cardinality(L2 10) */ L2.INTERFACE_LINE_CONTEXT ,L2.INTERFACE_LINE_ATTRIBUTE1 ,L2.INTERFACE_LINE_ATTRIBUTE2 FROM RA_INTERFACE_LINES L2 WHERE L2.REQUEST_ID = :b6 AND L2.INTERFACE_LINE_CONTEXT = 'KOF1' )) len = 1028 Current system time is 15-NOV-2012 13:16:19 APP-AR-11526: ORA-01427: single-row subquery returns more than one row UPDATE RA_INTERFACE_LINES L1 SET REQUEST_ID = :b1, LAST_UPDATE_DATE =  APP-AR-11526: 8361933/ar/lib/raamil.lpc 1355 UPDATE RA_INTERFACE_LINES L1 SET REQUEST_ID = :b1, LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = :b2, LAST_UPDATE_LOGIN = :b3, CUSTOMER_TRX_ID = NULL, INTERFACE_LINE_ID = NVL(INTERFACE_LINE_ID, RA_CUSTOMER_TRX_LINES_S.NEXTVAL), SET_OF_BOOKS_ID = NVL(SET_OF_BOOKS_ID, :b4), LINK_TO_LINE_ID = ( SELECT INTERFACE_LINE_ID FROM RA_INTERFACE_LINES L2 WHERE L2.REQUEST_ID = :b5 AND L2.INTERFACE_LINE_CONTEXT = 'KOF1' AND L1.LINK_TO_LINE_CONTEXT = L2.INTERFACE_LINE_CONTEXT AND L1.LINK_TO_LINE_ATTRIBUTE1 = L2.INTERFACE_LINE_ATTRIBUTE1 AND L1.LINK_TO_LINE_ATTRIBUTE2 = L2.INTERFACE_LINE_ATTRIBUTE2 ) WHERE NVL(INTERFACE_STATUS, '~') != 'P' AND (REQUEST_ID IS NULL) AND (( LINK_TO_LINE_CONTEXT ,LINK_TO_LINE_ATTRIBUTE1 ,LINK_TO_LINE_ATTRIBUTE2 ) IN ( SELECT /*+ cardinality(L2 10) */ L2.INTERFACE_LINE_CONTEXT ,L2.INTERFACE_LINE_ATTRIBUTE1 ,L2.INTERFACE_LINE_ATTRIBUTE2 FROM RA_INTERFACE_LINES L2 WHERE L2.REQUEST_ID = :b6 AND L2.INTERFACE_LINE_CONTEXT = 'KOF1' )) Error calling raamil() Error calling raapft() raafds()+ Current system time is 15-NOV-2012 13:16:22 raafeb()+ Current system time is 15-NOV-2012 13:16:22 raafeb()- Current system time is 15-NOV-2012 13:16:22 arcdcu()+ Current system time is 15-NOV-2012 13:16:22 arcdcu()- Current system time is 15-NOV-2012 13:16:22 raafds()- Current system time is 15-NOV-2012 13:16:22 +---------------------------------------------------------------------------+ Start of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ End of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ No completion options were requested. Output file size: 0 Concurrent program returned no reason for failure. +---------------------------------------------------------------------------+ Exceptions posted by this request: Concurrent Request for "Autoinvoice Import Program" has completed with error. +---------------------------------------------------------------------------+ Concurrent request completed Current system time is 15-NOV-2012 13:16:22 +---------------------------------------------------------------------------+