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

how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,


Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .

1 Answers   TCS,


What is the Lookup's and what is the use of lookup's?

3 Answers   TCS,


In custom.pll what are the events we can Not write.

1 Answers  


Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  






what is the defference between credit memo and debit memo

2 Answers  


what is item status? name the related table.

1 Answers   Scan Steel,


After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,


is it possible to run the interface without using oracle apps?

2 Answers   Accenture,


How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,


Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.

3 Answers  


In oracle application how do you debug or trace errors?

0 Answers  


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)