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 stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
when will formula,place holder and summary columns fire in reports?
After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?
how to change the logo in template dynamically?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
What is SET-OF-BOOKS?
what is the defference between credit memo and debit memo
What are basic steps for AIM?
what is the use of placeholer column?
How to move the one file from one instance to another instance? And your scripts also?
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
what is pick selection list generation report.