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?
KPMG,
1 7791in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
1 8792what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
IBM,
1 5142A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
1 6815There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.
3 9474Post New Oracle Apps Technical Questions
Can you define an erp system?
tell me the scenarios of the independent in reports
Tell me how to debug the report?
tell my any difficult situtation you solved in your experience in your company?
q)what are the validations in sql*loader
what is pay run id ?
What are the benefits of using soa architecture?
Are you familiar with internet architecture of oracle apps 11i?
please send me forms, xml pulisher questions,answers
What is a value set? List its various types.
Do you know what is applysys in oracle application database schema, what is apps?
List the various types of value set.
where to define interorganization transaction charges and what are the different options?
Can you explain the difference between architecture followed in 10g & 11g?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?