Home » Applications » Oracle Fusion Apps & E-Business Suite » Auto Invoice error
Auto Invoice error [message #381019] Wed, 14 January 2009 19:35 Go to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
Hi,
while running autoinvoice im getting error.

"Single Subquery returns more than one row"

please solve the issue.
  • Attachment: logfile.pdf
    (Size: 32.33KB, Downloaded 1016 times)

[Updated on: Wed, 14 January 2009 19:43]

Report message to a moderator

Re: Auto Invoice error [message #381969 is a reply to message #381019] Tue, 20 January 2009 08:26 Go to previous messageGo to next message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Hi,

This is because RA_INTERFACE_LINES_ALL table has duplicate records.

please find sample query to identify the duplicate data

1) Check rows and correct data.

Need to identify the rows in the interface table that have identical
interface_line_attributes 1-15 (depending on how many atributes you are using).

A)
SQL> SELECT DISTINCT interface_line_context
FROM ra_interface_lines_all;

This will return the context name which should be entered in next script.

B)
SQL> SELECT interface_line_attribute1, interface_line_attribute2,
interface_line_attribute3, interface_line_attribute4,
interface_line_attribute5, interface_line_attribute6,
interface_line_attribute7, interface_line_attribute8,
COUNT (*)
FROM ra_interface_lines_all
WHERE interface_line_context='&context'
GROUP BY interface_line_attribute1,interface_line_attribute2,
interface_line_attribute3, interface_line_attribute4,
interface_line_attribute5, interface_line_attribute6,
interface_line_attribute7, interface_line_atribute8
HAVING COUNT (*) > 1;

If this script returns more than one row, delete the duplicate row(s) from the
RA_INTERFACE_LINES_ALL table and leave one distinct record for transaction
flexfield.

2) To check if there is a unique index and whether the status is valid:

SQL> SELECT owner, index_name, index_type, status
FROM all_indexes;

If the unique index is not defined or is not valid see the Oracle Applications
Open Interfaces Manual to create the unique concatenated index for the
transaction flexfield in the RA_INTERFACE_LINES_ALL table.


Re: Auto Invoice error [message #382539 is a reply to message #381969] Thu, 22 January 2009 19:42 Go to previous message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
Hi,
Thank u .
i issue was solved.
there are duplicates in my interface tables.
Previous Topic: condition using not null in interfaces
Next Topic: customer account number was changed
Goto Forum:
  


Current Time: Wed Dec 07 22:20:20 CST 2016

Total time taken to generate the page: 0.10766 seconds