while running a interface if we get 100 records as erors.
how to debug it.

Answers were Sorted based on User's Feedback



while running a interface if we get 100 records as erors. how to debug it...

Answer / srinivas.r

We are having to two types the error records.....
1)Rejected by the SQL Loader.
These are stored in the '.BAD' file......
2)Rejected by the condition which have been mention in the
control file.
These are stored in the '.dis' file......

atfer getting the error records in the specified file then
we will correct the errors and proceed them once again...

Is This Answer Correct ?    1 Yes 0 No

while running a interface if we get 100 records as erors. how to debug it...

Answer / roshan

if where clause doesn't satified the condition and flatfile
error, so we can refer discardfile.... and debug the errors

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Apps Technical Interview Questions

What are do's and dont's of Interface?

0 Answers  


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

0 Answers  


Stored procedure?

4 Answers  


in reports token is casesensitive or not?

2 Answers  


diff between key and descriptive flexfield.

4 Answers   Convergys,


Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

0 Answers  


What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,


In a Standard form a DFF is disable?How we can Enable it?

5 Answers   Caritor, TCS,


What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,


What is the autonomous transaction?give me example?

2 Answers   Cap Gemini,


Exception Handilings?

1 Answers  


In what situation u create the BPA.

2 Answers   Accenture,


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)