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

in reports token is casesensitive or not?

2 Answers  


how can u link a org-id with a responsibility in reports?

2 Answers   TCS,


What is request group

4 Answers   Accenture,


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

0 Answers  


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

1 Answers  






Form development process?

1 Answers  


Is that Possible To create package Overloading , If Yes Give any Examples

1 Answers   PWC,


What is Place holder Columns?

3 Answers  


Exception Handilings?

1 Answers  


What r the validation types?

3 Answers  


Are you familiar with internet architecture of oracle apps 11i?

0 Answers  


what is the difference between %_all and %_f tables

1 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)