BPM – Disable DBMS job to refresh B2B Materialized View

If you are running BPM and you are not using B2B, you might want to disable the DBMS job that refreshes the B2B materialized view.  This job runs every minute by default.

To find the job, use a query like the one below.  Update the schema user to match the environment:

, schema_user
, broken
, what
, interval
  schema_user = “DEV_SOAINFRA”

Look for the job which contains something like the following in the WHAT column.  Note that it may be different if a different schema prefix was used in the environment.


To remove the job, take note of the job number from the JOB column and then use a command like the following, substituting in the correct job number in place of 24:


Alternatively, alter the materialized view to be refreshed on demand, using a command similar to this:

alter materialized view dev_soainfra.b2b_system_mv refresh on demand;

About Mark Nelson

Mark Nelson is an Architect (an "IC6") in the Fusion Middleware Central Development Team at Oracle. Mark's job is to make Fusion Middleware easy to use in the cloud and at home, for developers and operations folks, with special focus on continuous delivery, configuration management and provisioning - making it simple to manage the configuration of complex environments and applications built with Oracle Database, Fusion Middleware and Fusion Applications, on-premise and in the cloud. Before joining this team, Mark was a senior member of the A-Team since 2010, and worked in Sales Consulting at Oracle since 2006 and various roles at IBM since 1994.
This entry was posted in Uncategorized and tagged , . Bookmark the permalink.

One Response to BPM – Disable DBMS job to refresh B2B Materialized View

  1. Pingback: Process Accelerator Kit « SOA Community Blog

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s