In interface how u find errors and how to solve. How to fix
it?
Answers were Sorted based on User's Feedback
Answer / uday
RA_INTERFACE_ERRORS_ALL is used to find the errors in
Interface
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / indu
MTL_INTERFACE_ERRORS used to find INV Interface errors
RA_INTERFACE_ERRORS used to find AR Interface errors.. etc
will have for every interface
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rupesh babu k
while moving data from legacy to staging table(temp table
created based on the structure of interface table)if errors
occurs that data(custom data errors)we can collect in a
table(custom error table).
while moving data from staging table to interface table
if error occurs that data(standard error data)we can
collect into standard error table(each module having one or
more interface error tables). Both custom eror data and
standard data can be send to client or we can fix the
errors using utl_file package(outbound interface).
The errors may occur due to different reasons.
ex:invalid data,invalid datatype,undefined columns
(accounting_date,sob,currency,coa),uninitialized columns
| Is This Answer Correct ? | 2 Yes | 0 No |
Where we can write a PL/SQL code in report triggers?
In hierarchical structure of a database? we have write query from where we should start?
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?
What is sca and how is it useful?
can we get profile values in report without using user exists is it possible how?
what is meant by Drill Down in Discoverer report? why it will be use?
can we execute one concurrent program through another concurrent program?
how can u find the status in po?
sourcing in GL
what type of testing u r doing?
How to register a form and stored procedure in oracle apps