Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

SOA
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive
 

Oracle BPEL Tables in the perspective of Oracle Workflow Tables.

In this article you will learn about the main tables used by the BPEL Server/Engine. For these tables, you will also see the corresponding tables in good old Oracle Workflow.

The reason I write this article is because I believe in next 5 Years time , many of the current Oracle Workflow Consultants will be working on Oracle BPEL Instead.

PROCESS_LOG [ Similar to wf_item_types in Oracle Workflows ]

This is the table in BPEL where the any activity related to changes to the process are stored.

For example, if you wish to know how many time the BPEL process was deployed onto server or revised, then this is the table to look into.

 

A higher level that this table are tables PROCESS and PROCESS_DEFAULT.

These table contain the BPEL Process name and their revision information.

CUBE_INSTANCE [ Similar to wf_items in Oracle Workflows ]

For each BPEL process instance an entry gets created in this table.

This will tell you the data on which this instance started, and the last updated date of the instance.

To purge records from this table, you can use collaxa.delete_ci, using primary key value from cikey.

State 5 or more means that the process instance is complete.

If state is less than 5, then it means that process instance is ongoing.

 

INVOKE_MESSAGE

Stores the information regarding the message that invoke a BPEL Process.

For example a Business Event can invoke a BPEL Process via WebService, as shown in image below.

Of course this table will also tell you the timestamp at which the BPEL process was invoked.

WORK_ITEM [ Similar to WF_ACTIVITIES in Oracle Workflow ]

This table contains the activities against the BPEL Process Instance.

 

DOCUMENT

If a variable with XML document has size bigger than 5MB[configurable], then variables XML data gets stored into this table.

 

AUDIT_TRAIL

This is the table that gets used to display the audit flow from BPEL Console.

This has a column named LOG which is a Large Object RAW Column, each step in BPEL process gets logged into LOG Column in XML zipped form.

 


Anil Passi

Comments   

0 #1 Ajay Kunde 2008-06-02 01:21
Hi Anil,
Thank you for sharing the tables in BPEL. This is very useful to every one. I am new to BPEL, please let me know what are the prerequisite for learning BPEL. I am good knowledge in workflows.
Rega rds,
Ajay Kunde
Quote
0 #3 cheap ugg 2009-12-26 01:45
Perhaps the fastest-growing way to act on these altruistic instincts is participating in microfinancing. You take a relatively small amount of money and, through an online marketplace of sorts, give or lend it ugg outlet to a specific person or project whose story moves you. (Not all microfinancing organizations are nonprofits, however, so be aware of the differences.)Th is fall, Kiva, one of the leading organizations in a niche that includes others like DonorsChoose and the eBay-owned MicroPlace, came under fire cheap ugg in a blog post by a microfinance researcher named David Roodman. He took Kiva to task for inaccurate information on its Web site about how the loans, made to entrepreneurs in the developing world by its users, actually worked.
Quote
0 #4 Naveed 2010-03-24 14:34
In our production env, the AUDIT Trail Table has grown to 15 Million Rows and causing performance issues. Is it possible to purge or truncate this table periodically?

Thanks
-Naveed-
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner