can i write commit in Before report trigger
Answers were Sorted based on User's Feedback
Answer / shailesh
Yes u can write directly write a coomit; in any of the
report trigger.
e.g I have created a report and written in before report
trigger
update scott.emp set ename='SMITH_1' where ename
like 'SMITH';
commit;
It worked
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pushpendra saini
yes u can do commit in Before report trigger
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / lreddy
NO, IN Before Report Trigger we can use SRW.DO_SQL to
perform any DDL Operations.
For DDL Operations are internal commit.
so no need to use Commit statement in Before Reprot Trigger.
| Is This Answer Correct ? | 0 Yes | 1 No |
How you define procure to pay?
What is the purpose of the product order option in the column property sheet?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
What are User Exits and what are different types of User Exits in Oracle Apps ?
Why oracle forms required?
how do u place it in required folder
What is lexical parameter ?
What is forms_DDL?
I developed on form as per my requirement,and register that one in apps custom_top.But the problem is ,if you open the form but not closed,I founded why this is error is comming ,the custom_top is not supported my form . I need any one your help in advicing me...what I do the custom_top supported the forms.
While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?
What is coordination Event?
Where is the external query executed at the client or the server?