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

What do you understand by concurrent programs?

838


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1883


How to create a purchase order without a requisition?

886


What are file in oracle.

2046


what is pay run id ?

1949


Which oracle apps version you are very confident in?

975


tell my any difficult situtation you solved in your experience in your company?

2119


Can you differentiate between mediator and osb?

902


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

969


what is the differences between internal requisition and internal sales order?

2426


How can you achieve loose coupling in soa framework?

1023


What is a value set? List its various types.

885


what is global tempory table?

6817


tell me the scenarios of the independent in reports

2285


Plz anybody send me Technical specification for AP Interface

2326