7.9 Overview of SOA Integration

With 12c Release (, Oracle Reports is integrated with the Oracle Service-Oriented Architecture (SOA) suite, which includes Oracle BPEL Process Manager to automate and monitor reporting requirements.

7.9.1 About BPEL

Business Process Execution Language (BPEL) is the emerging standard for assembling a set of discrete services into an end-to-end process flow, radically reducing the cost and complexity of process integration initiatives. Oracle BPEL Process Manager, a key component of Oracle Fusion Middleware, enables enterprises to orchestrate disparate applications and web services into business processes. The ability to quickly build and deploy these processes in a standards-based manner delivers critical functionality for developing a Service-Oriented Architecture (SOA).

For more information about Oracle BPEL Process Manager, see Developing SOA Applications with Oracle SOA Suite.

Users can submit Oracle Reports jobs from the Oracle BPEL Process Manager business process, get the status of report execution, and also invoke an Oracle BPEL Process Manager business process from reports. For example, submit a report request when an order gets approved.

Using Oracle Reports with Oracle BPEL Process Manager involves the following steps:

  • Define a business process by using Oracle JDeveloper.

  • Call the Oracle Reports web service to start executing the report at an appropriate stage in your business process.

  • Submit the reports job synchronously or asynchronously.

  • Obtain the status of the report job at any time.