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 could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .
What is count(*) from po_vendors(any table)?
Attribute data types?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
HOW CAN U KNOW THE STAUS OF PO?
what are the error tables in AP?
How many parameters we can pass through pl/sql program in Oracle apps
where do u specify in org_id?
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
in ap_terms table what data will be stored
how can i print random rows in plsql table
what are the different calculation columns available in reports?