|
|
| Re: Auto Invoice error [message #381969 is a reply to message #381019] |
Tue, 20 January 2009 08:26   |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
