Home » Applications » Oracle Fusion Apps & E-Business Suite » AR interface single-row subquery returns more than one row (please help this is an urgent issue)
AR interface single-row subquery returns more than one row [message #376842] Thu, 18 December 2008 19:48 Go to next message
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 Go to previous messageGo to next message
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
Re: please help this is an urgent issue [message #377876 is a reply to message #376842] Fri, 26 December 2008 00:26 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
ya i got the solution
fault itself in data file
Re: please help this is an urgent issue [message #570808 is a reply to message #377876] Fri, 16 November 2012 01:24 Go to previous message
harish237
Messages: 2
Registered: November 2012
Location: Bangalore
Junior Member
Hi,

May i know what mistake is in datas, bcos i also got same error . can u pls help me out
Previous Topic: package
Next Topic: PRE-FORM trigger raised unhandled exception ORA-06510
Goto Forum:
  


Current Time: Thu Mar 28 06:18:59 CDT 2024