Answer Posted / mkjmkumar

TRUNCATE

1. It is DDL.
2. Speed is faster
3. Do not Check Constraints.
4. Roll Back is not possible.
5. Can not use where clause

DELETE

1. It is not a DDL
2. Speed is slow
3. Check constraints, If Exists then shoe error.
4. We can rollback .
5. User Where Clause

Could you please let me know the interfaces in OM / FA??

1730

---

What is the difference between recovery and restoring of the oracle database?

650

---

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

716

---

as a technical developer in oracle applications which type errors feced in your experience sofar

1760

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

607

---

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

637

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1696

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

743

---

What is auto invoicing? : oracle accounts receivable

647

---

What is auto invoicing? Explain : oracle accounts receivable

602

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1627

---

what are the API of GL,PO,AP

1764

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

727

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

16335

---

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

658

---