In interface how u find errors and how to solve. How to fix
it?
Answers were Sorted based on User's Feedback
Answer / uday
RA_INTERFACE_ERRORS_ALL is used to find the errors in
Interface
| Is This Answer Correct ? | 6 Yes | 2 No |
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 |
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 |
what are the receipt types in Po?
where to define interorganization transaction charges and what are the different options?
sourcing in GL
which API to return the parameters & valuesets etc
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
What is count(*) from po_vendors(any table)?
what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .
maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?
What is set function in sql .E.g.What is difference between union and union all
what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions
wht is format triger?
What is an Index , Types od index why we are use index.