In interface how u find errors and how to solve. How to fix
it?

Answers were Sorted based on User's Feedback



In interface how u find errors and how to solve. How to fix it?..

Answer / uday

RA_INTERFACE_ERRORS_ALL is used to find the errors in
Interface

Is This Answer Correct ?    6 Yes 2 No

In interface how u find errors and how to solve. How to fix it?..

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

In interface how u find errors and how to solve. How to fix it?..

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

Post New Answer

More Oracle Apps Technical Interview Questions

What are documents and test cases u followed.

2 Answers   Accenture,


what is MRC? Why it is needed?

4 Answers   Convergys,


what is the need of registering table in apps?

5 Answers   TCS,


difference between 2 way and 4 way matching

3 Answers   Convergys, TCS,


maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,






Give a overview on Aol

2 Answers   Zensar,


What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,


what is back order in OM

4 Answers   IBM, Oracle,


what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  


difference b/w procedures&functions

2 Answers   Oracle, TCS,


How You Will display the key flexifields in your report

3 Answers   TCS,


Is it possible calling from one report to another? if possible means tell me ?

3 Answers   Intelligroup, Satyam,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)