Home » Applications » Oracle Fusion Apps & E-Business Suite » oracle apps Auto invoice in R12 failing with ORA-01427: single-row subquery returns more than one ro (oracle apps R12 instance)
oracle apps Auto invoice in R12 failing with ORA-01427: single-row subquery returns more than one ro [message #570824] Fri, 16 November 2012 02:58 Go to next message
harish237
Messages: 2
Registered: November 2012
Location: Bangalore
Junior Member
Hi,

i populated all the datas to RA_INTERFACE_LINES_ALL table and RA_INTERFACE_DISTRIBUTIONS_ALL table , when i run auto invoice master program, the program got completed normal but Autoinvoice Import Program completed error
when i check log file i found this error ORA-01427: single-row subquery returns more than one row
pls help in this,

i have attach the log file with this


+---------------------------------------------------------------------------+
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

+---------------------------------------------------------------------------+

Pls help me out from this . its urgent
Re: oracle apps Auto invoice in R12 failing with ORA-01427: single-row subquery returns more than one ro [message #571188 is a reply to message #570824] Thu, 22 November 2012 01:45 Go to previous message
ata_rehman70
Messages: 1
Registered: November 2012
Location: Pakistan
Junior Member
Dear
AutoInvoice Error: ORA-01427 Single-Row Subquery Returns More Than One Row ID_1209258.1[/b]b]ID 1209258.1[/b

Solution
<My Oracle Support contents removed by LF>

Ata


[EDITED by LF: Ata, you are not allowed to distribute materials protected by copyright. I left the document ID so anyone - who has access to MOS - can review it]

[Updated on: Thu, 22 November 2012 02:34] by Moderator

Report message to a moderator

Previous Topic: Upload files
Next Topic: GOP to consider Fixed production days
Goto Forum:
  


Current Time: Mon Jul 28 01:48:10 CDT 2014

Total time taken to generate the page: 0.20634 seconds