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.

Explain what are the tables of auto invoice?

648

---

How is choreography different from orchestration?

652

---

What do you understand by concurrent programs?

619

---

what are the balancing segments in AR?

1653

---

what is pay run id ?

1711

---

---

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?

637

---

what is the differences between internal requisition and internal sales order?

2158

---

Is soa a part of oracle fusion middleware?

607

---

What is a value set? List its various types.

650

---

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

3079

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1688

---

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

2996

---

Can we create tables in apps schema?

622

---

Tell me how to debug the report?

640

---

What do you understand by a set of books?

649

---