Answer Posted / ratnakar

if u know updated date then following query will work

select * from emp where effecive_start_date = (select
sysdate from dual);


or

select * from emp where effective_start_date = (select
to_date(dateof update,'dd-mon-yy') from dual);

How can you achieve loose coupling in soa framework?

964

---

what are the prerequisites for costing transactions?

2849

---

List the types of flexfield?

781

---

Tell me how to debug the report?

836

---

Can you explain the difference between architecture followed in 10g & 11g?

846

---

---

What are the different components you should consider while defining a responsibility in oracle apps?

825

---

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

1830

---

q)what are the validations in sql*loader

1979

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2006

---

What do you understand by soa and what are the benefits of using this architecture?

796

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2795

---

is it possible to run the interface without using oracle apps?

1690

---

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

14293

---

Can we create tables in apps schema?

836

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2332

---