What are the validations you don in .CTL file in inbound
interface process?
Answer / emmanuel - tcs
1) we can eliminate the records by using the WEHN condition
in CTL File
2) we can use the SQL Built-in Functions in CTL File.
3) we can skip the particular column -- Filler
4) we can Skip the top number of records -- Skip
Thanks,
Emmanuel - TCS
Is This Answer Correct ? | 8 Yes | 1 No |
we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?
can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)
IN WHICH MODULE THE LEGAL ENTITY COMES?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
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?
How do u customize the Reports?
How we print the multi language in report?can any one give me step bye step explanation.
2 Answers HCL, IBM, Tech Mahindra,
q)what are the validations in sql*loader
Tell me some thing about SQL-LOADER.
in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?