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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know where we can check the status of po?

946


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

2127


In oracle application how do you debug or trace errors?

867


What is the concept of soa governance?

1009


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2771


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?

873


What are the different components you should consider while defining a responsibility in oracle apps?

859


List the various types of value set.

826


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2361


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2389


how can i print random rows in plsql table

2153


Plz anybody send me Technical specification for AP Interface

2306


How many schemas we have? how many you have used?

1819


what are the different transaction clauses in AR?

1846


tell me the scenarios of the independent in reports

2397