Answer Posted / prasad reddy

BEGIN
IF l_return_status = 'Y'
THEN
UPDATE xxdc_inv_mtl_item_stg_t
SET process_status = 2
WHERE ROWID = cur_rec.ROWID;

l_txn_validated := l_txn_validated + 1;
ELSIF l_return_status = 'E'
THEN
UPDATE xxdc_inv_mtl_item_stg_t
SET process_status = 3,
error_message = error_message ||
l_error_msg
WHERE ROWID = cur_rec.ROWID;

l_txn_failed := l_txn_failed + 1;
END IF;

IF MOD (l_txn_inserted, p_commit_point) = 0
THEN
COMMIT;
END IF;


Pls look at the above code it may help you out.

Any how here i am giving explanation

take the count of inserted rows and mod by 100 or 1000 or
2000 wat ever you want and do commit;

simple

code

IF MOD (l_txn_inserted, p_commit_point) = 0
THEN
COMMIT;
END IF;

Regards,
-Prasad.

testing tools?

2260

---

What are file in oracle.

2240

---

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

1072

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3665

---

Can u give the Documentation of Custom.pll in oracle apps

3483

---

What are do's and dont's of Interface?

2432

---

In support project one ticket alloted which steps follows manualy tell me ?

2666

---

How can we import the data into a database using sql * loader?

1196

---

What does appl_top directory contain?

1129

---

what are the different transaction clauses in AR?

2121

---

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

2266

---

Tell me where we find the status of order information?

1140

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3035

---

Tell me how to debug the report?

1125

---

Which oracle apps version you are very confident in?

1215

---