How will you get the concurrent program output as email?
Answers were Sorted based on User's Feedback
Answer / chenna
by using xml bursting we can send concurrent program output as email.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / nusrath
Using Shell script we can attach the output of a concurrent
program.
mutt -s <subject> -a <attachment> <mail_id> < <mail body>
Eg:mutt -s "Output-conc prgm" -a XXCUST_TOP/bin/xx_pr.txt
abcd@gmail.com < "Hello, PFA output of conc.program."
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / tj
Incase of only concurrent program, we can set delivery options.
Incase of PL/SQL stored procedure execution method concurrent program, we can define one Host concurrent program which contains mailx command in .prog file. Place the file in respective TOP . Now call the concurrent program from PL/SQL package or procedure of previous concurrent program or we can create a request set(manual run) with two cp's. We can set delivery options for the second cp in request set. Request set mail parameters will not changes once scheduled(automatic run).
Incase of XML Publisher report creation, we can use bursting control file.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the package?
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?
what is inbound and outbound interface?
what is the need of registering table in apps?
how many layout sections are tehre in layout editor?
can we pass bind variablein lexical parameter?
What is ment by Global Templates in Oracle.
What are the different components of soa suite?
how can we return morethan one parameters in procedure?
HOW CAN U KNOW TABLE IS REGISTERD IN APPS?
what is the invoice matching
Can we create tables in apps schema?