AR interface single-row subquery returns more than one row [message #376842] |
Thu, 18 December 2008 19:48 |
radhavijaym
Messages: 65 Registered: December 2008 Location: singapore
|
Member |
|
|
Hi,
my user uploaded invoice,debit memos and credit memos transactions.
after uploading she had done auto invoice.
invoice and debimemos auto invoice was completed successfully but credit memos she got an error.
again she did auto invoice for credit memos,then it was completed but with zero records.
actually there are two records for credit memos.
please help me.
this is an urgent issue.
i got the error due to this
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: 3966142/ar/src/autoinv/raamil.lpc 1333
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 = 'TTAS'
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
AND L1.LINK_TO_LINE_ATTRIBUTE3 = L2.INTERFACE_LINE_ATTRIBUTE3
AND L1.LINK_TO_LINE_ATTRIBUTE5 = L2.INTERFACE_LINE_ATTRIBUTE5
)
WHERE NVL(INTERFACE_STATUS, '~') != 'P'
AND (REQUEST_ID IS NULL OR REQUEST_ID IN (:b6)
)
AND EXISTS
(
SELECT 'x'
FROM RA_INTERFACE_LINES L2
WHERE L2.REQUEST_ID = :b7
AND L2.INTERFACE_LINE_CONTEXT = 'TTAS'
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
AND L1.LINK_TO_LINE_ATTRIBUTE3 = L2.INTERFACE_LINE_ATTRIBUTE3
AND L1.LINK_TO_LINE_ATTRIBUTE5 = L2.INTERFACE_LINE_ATTRIBUTE5
)
Error calling raamil()
Error calling raapft()
raafds()+ Current system time is 17-DEC-2008 15:42:22
raafeb()+ Current system time is 17-DEC-2008 15:42:22
raafeb()- Current system time is 17-DEC-2008 15:42:22
raafds()- Current system time is 17-DEC-2008 15:42:22
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Concurrent program returned no reason for failure.
so please help me how to solve this.
19-DEC-08 03:18:02 GMT
New info : yandrapu.radha@niit-tech.com.sg
hello please solve my issue.
i got this due to single sub query returns more than one row so please respond to my
resquest ASAP.
18-DEC-08 19:52:35 : CHANGES MADE VIA MetaLink
NOT YET FORWARDED TO OUR INTERNAL SYSTEMS :
New info : yandrapu.radha@niit-tech.com.sg
hello please solve my issue.
im getting error due to auto invoice
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: 3966142/ar/src/autoinv/raamil.lpc 1333
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 = 'TTAS'
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
AND L1.LINK_TO_LINE_ATTRIBUTE3 = L2.INTERFACE_LINE_ATTRIBUTE3
AND L1.LINK_TO_LINE_ATTRIBUTE5 = L2.INTERFACE_LINE_ATTRIBUTE5
)
WHERE NVL(INTERFACE_STATUS, '~') != 'P'
AND (REQUEST_ID IS NULL OR REQUEST_ID IN (:b6)
)
AND EXISTS
(
SELECT 'x'
FROM RA_INTERFACE_LINES L2
WHERE L2.REQUEST_ID = :b7
AND L2.INTERFACE_LINE_CONTEXT = 'TTAS'
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
AND L1.LINK_TO_LINE_ATTRIBUTE3 = L2.INTERFACE_LINE_ATTRIBUTE3
AND L1.LINK_TO_LINE_ATTRIBUTE5 = L2.INTERFACE_LINE_ATTRIBUTE5
)
Error calling raamil()
Error calling raapft()
raafds()+ Current system time is 17-DEC-2008 15:42:22
raafeb()+ Current system time is 17-DEC-2008 15:42:22
raafeb()- Current system time is 17-DEC-2008 15:42:22
raafds()- Current system time is 17-DEC-2008 15:42:22
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Concurrent program returned no reason for failure.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 17-DEC-2008 15:42:22
+---------------------------------------------------------------------------+
this im getting because in the query im must add one line l2.mtl_system_items_seg1=l1.mtl_system_items_seg1
but this is autoinvoice program and the executable method for this program is SPAWNED and in d:\oracle\prodappl\ar\11.5.0\bin\raxtrx.exe or raxtrx.map
but nopw how can i modify the query please help me.
please its an urgent issue.
[Updated on: Fri, 26 December 2008 06:20] by Moderator Report message to a moderator
|
|
|
Re: please help this is an urgent issue [message #377029 is a reply to message #376842] |
Fri, 19 December 2008 09:04 |
Steve Corey
Messages: 336 Registered: February 2005 Location: RI
|
Senior Member |
|
|
Hello,
You have taken the appropriate path by contacting a Metalink support analyst. The error belongs to seeded Oracle code and should not be altered manually. More than likely, a patch exists or will be created for your issue. The only other alternative is to create a customized process that mimicks the seeded process with the corrections made to the code. This is however, a very time consuming process so I would advise looking for a patch for this particular issue.
HTH,
Steve
|
|
|
|
|