Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export to Excel in BPM 12c

user12859640Apr 17 2017 — edited Apr 17 2017

Hi,

I need to export the results of a query and other data as excel (available to be downloaded by users).

In BPM 10g, we had the liberty to use jsp for download/exporting to excel.

How to incorporate similar behavior in 12c?

We are using ADF forms to get user input details, however, we are not able to access in built BPMN functions (available in the XPATH expresssion builder) in ADF

how to integrate both and provide download to the user as he submits the form.

is it a limitation with BPM 12c?

Thanks in advance!

Comments

Tubby 
Johnny B wrote:
Hi all,
Have a materialized view defined as refresh fast on commit:
CREATE MATERIALIZED VIEW mat_vw_name REFRESH FAST ON COMMIT WITH ROWID AS 
Importing data to the table that is part of the mat view using SQL Loader. The query is taking a long time to process.
Do I need to perform anything after the bulk import is done? Is the mat view running after the bulk import?
Is there a way to see if any process is running in the background?
Thanks in advance.
Johnny
using: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit

The materialized view based on the table you are loading will be updated as part of the transaction that is loading the base table. If you wanted to see what was going on you could query for the session doing the data load and watch what is being executed (v$ views, OEM, TOAD, etc will all allow you to view what the session is doing).

Cheers,

Johnny B
Answer

Very weird, it was not showing locked items. Now it is working fine as it was before I incorporate the loader.

Thanks for your help.

Marked as Answer by Johnny B · Sep 27 2020
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 15 2017
Added on Apr 17 2017
#business-process-management-suite, #soa-process-management
2 comments
232 views