Feed aggregator

Oracle SOA/BPM: Payload Validation per Composite

Jan Kettenis - Fri, 2015-10-23 13:14
In this article I will explain how you can enable payload validation in the Oracle SOA/BPM Suite per composite, both design and deployment time. This works for 11g as well as 12c

When developing BPM processes or SOA services it is advisable enable payload validation on the development server. The reason being that this will force you to work with more representable test data, and in some occasions help you preventing coding errors (like assignment of a string to an integer, or forgetting to map mandatory data in a call). Specifically there where you have to communicate with external systems, this might become very important, not speak of the situation where payload validation is enforced for example by a server bus.

Preferable you have payload validation switched on from the beginning, starting with the development server, but better also for the test server(s). Normally you would leave it off (the default) for production and load and stress test environments (for performance reasons).

However, sometimes you find yourself in a situation where existing composites already violate one or more XML rules. This can make it practically impossible to switch payload validation on for the whole server. You then will have to do it on a composite by composite basis. Fortunately this is supported out-of-the-box by the validateSchema property you can set on a composite, as shown below:

Assuming that you use configuration plans per environment you deploy to, you can switch it on for any environment you want to enable it for, using the following entry in the configuration plan:
When deployed, payload validation will automatically have been enabled for the composite, preventing that you have to do so manually every time you deploy:

No excuses for those lazy developers hiding behind someone else's bad written code!

Universal Theme Face Lift

Scott Spendolini - Fri, 2015-10-23 09:42
I'm a huge fan of APEX's new Universal Theme, and have been working quite a bit with it.  One of the coolest features is how easy it is to change the colors.  You don't even need to be good at design - just click Theme Roller, and spin all the things!

However, as much as you change the colors, the look and feel still largely looks the same, since the base font is unchanged.

So let's change it up! More importantly, let's change it up without making any changes to the Universal Theme itself, so that when we upgrade to APEX 5.1, our changes will be preserved.

First, head on over to Google Fonts (https://www.google.com/fonts) and pick a font to use as your new base font.  It doesn't really matter which one you use.  For this example, I’m going to use Montserrat.  Once you've chosen which font to use, click on the Quick Use icon.  This will render a page with a number of different options as to how to include the font in your application.

Select which styles of the font that you want to include.  Some fonts will have bold and italic; others will not, so make sure the font you select also have the styles that you want, too.

2015 10 23 10 20 56

Next, pick the character set(s) that you want to include.  My choice was pretty simple.

2015 10 23 10 21 09

Since there’s no “APEX” tab, we’re going to have to make do with the @import tab.  You’ll want to copy just the URL portion of the snippet.  So in this example, it would be: https://fonts.googleapis.com/css?family=Montserrat

2015 10 23 10 21 25

Lastly, we’ll also need to copy the font-family name, as we’ll use that in Theme Roller.  For this example, we would only need Montserrat

2015 10 23 10 21 35

Now that we have all of the details from Google Fonts, head on over to APEX.  First, edit your application’s Shared Components and navigate to User Interface Attributes and edit the DESKTOP UI.  In the Cascading Style Sheets section, paste the URL that you copied from Step 3 of the Google Fonts page into the File URLs region.

2015 10 23 10 33 42

Scroll to the top and click Apply Changes.

Next, run your application and open up Theme Roller by clicking on the link in the developer toolbar.  Once Theme Roller opens up, expand the Custom CSS region and paste the following code there, replacing Montserrat with your font-family name defined in Step 4 of the Google Fonts page:
body {
font-family: 'Montserrat', sans-serif;
font-weight: 300;
line-height: 25px;
font-size: 14px;
Save your changes, and notice that the entire application should be using your new font!  Don’t like how it looks?  Go pick a different font and see if that helps; or simply remove the Custom CSS and File URL to revert to the default one.

Oracle Priority Support Infogram for 22-OCT-02015

Oracle Infogram - Thu, 2015-10-22 17:15

Oracle OpenWorld

Oracle Data Visualization: Visit Us at OpenWorld 2015!

And for when you’re a little ‘Oracled out’: Free San Francisco Architecture walking Tour

The latest roadmap includes extended support on 11.2.
  • Extended Support for Database release 11.2 will be available through December 2020.
  • The Extended Support fees are waived from February 1, 2015 through May 31, 2017.

The Technical Support Policy and Lifetime Support Policy documents have been updated accordingly.   
 Please note that you must be on, the terminal release, to qualify for the extension:



Apex 5.0.2 was released, from Proactive Support - Oracle Development Tools.

From the same source: Oct 2015 Critical Patch Update.


Additional new content SOA & BPM Partner Community, from SOA & BPM Partner Community Blog.



Demantra is available!, from the Oracle Demantra blog.


From the Oracle E-Business Suite Support blog:

From the Oracle E-Business Suite Technology blog:

OOW and JavaOne 2015 - Where I'll Be

Shay Shmeltzer - Thu, 2015-10-22 10:41

It's that time of the year again, and next week is going to be crazy busy for us at Oracle OpenWorld and at JavaOne.

In case you want to catch me, here is a list of the locations where I'll be:

Building iOS Apps with Java 8 [CON1588]

Monday, Oct 26, 12:30 p.m. | Hilton—Continental Ballroom 4

Build Responsive Web Applications with Oracle ADF [HOL10380]

Monday, Oct 26, 5:00 p.m. | Hotel Nikko—Nikko Ballroom III (3rd Floor)

General Session: Revolutionizing Application Development with Oracle Cloud [GEN9500]

 Tuesday, Oct 27, 11:00 a.m. | Moscone South—103 

Meet the Experts: Oracle’s Development Tools and Frameworks [MTE10022]

Tuesday, Oct 27, 6:15 p.m. | Moscone South—300

Oracle Application Development Framework and Oracle JDeveloper—What’s New and How to Use It [CON8333]

Wednesday, Oct 28, 1:45 p.m. | Moscone South—304

Building iOS Apps with Java 8 [CON1588]

Thursday, Oct 29, 9:00 a.m. | Hilton—Continental Ballroom 1/2/3

Moving Oracle ADF to the Cloud—Development and Deployment in the New Age [CON8332]

Thursday, Oct 29, 1:15 p.m. | Moscone South—270

In between you could also catch me at the Oracle demo ground in Moscone south (mostly in the Oracle Application Builder Cloud Service), and at the JavaOne GeekBar on Monday.

At the rest of the time, I'll try and catch some of the sessions on this list.

See you there...

Categories: Development

OpenWorld Session Teaser

Duncan Davies - Thu, 2015-10-22 10:22

As a teaser to the session that Mark Thomas and myself are presenting on Selective Adoption at OpenWorld next week, here’s a slide showing why Selective Adoption is important for so many clients:

teaser slide

By virtue of such a high proportion of clients upgrading to 9.2 already, Selective Adoption is impacting a huge number of customers.

Come to Mark’s and my session at 9:30am on Thursday to find out the adjustments that you need to make to ensure that you get the biggest benefits from the Selective Adoption functionality.

Come to our session, PeopleSoft Selective Adoption Experiences from the Front Line [CON7071], and find out what you can do.


Select all Checkboxes in IR - APEX 5

Denes Kubicek - Thu, 2015-10-22 06:54
If <input type="checkbox" onclick="$f_CheckFirstColumn(this)"> doesn't work for you in APEX 5 Interactive Reports then you will need to disable Fixed Headings (standard). Fixed headings splits the report into two tables and the function won't work.

Categories: Development

Oracle Live SQL

Denes Kubicek - Thu, 2015-10-22 06:45
Oracle Live SQL is a great source for learning SQL and PL/SQL. It has a lot of good examples and interactive educational tutorials. The best thing is, it runs on APEX ;) Add this site to your bookmarks.

Categories: Development

Oracle OpenWorld 2015. Additional Attractions to Consider: OakTable World and EMC Rocks Oracle OpenWorld.

Kevin Closson - Thu, 2015-10-22 02:17

This is a quick blog entry to to share some information with readers who are attending Oracle OpenWorld 2015.

EMC Rocks Oracle OpenWorld

EMC has a concurrent event at the Elan Event Center (directly across the street from Moscone West) during OpenWorld. This event is a great opportunity to come see the most unique and powerful solutions and products EMC has to offer to folks using Oracle Database. You can register for the event at the following link or just show up with your OpenWorld badge. Link to register for EMC Rocks Oracle OpenWorld. Please visit the link to get more information about the event. I hope to see you there.


Oaktable World 2015

Folks who are aware of the Oaktable Network organization will be pleased to hear that Oaktable World is once again being held concurrently with Oracle OpenWorld. Please visit the following link to get more information about Oaktable Word. You’ll find that no registration is necessary and the speaker list is quite attractive. Link to information about Oaktable World 2015

Shameless Plug

Well, it is my blog after all!  I’ll be delivering another installment of my Modern Platform Topics for Modern DBAs track. This session will show how to use SLOB to study how CPU-intensive your Oracle OLTP-related *waits* are. I’ll also be showing CPU costs associated with key DW/BI/Analytics processing “underpinnings” like scan, filtration and projection on modern 2-socket servers running Linux and Oracle Database 12c. Please join us on Monday October 26 at 3PM as per the Oaktable World schedule (see below or follow the links).


Here is a screenshot of the EMC Rocks Oracle OpenWorld:

Screen Shot 2015-10-21 at 5.02.28 PM

The following is the schedule for technical sessions at EMC Rocks Oracle OpenWorld. I’ve highlighted the XtremIO related sessions since that is the business unit of EMC I work in.

Screen Shot 2015-10-21 at 5.24.24 PM


The following is the Oaktable World schedule:

Screen Shot 2015-10-21 at 4.59.00 PM

Screen Shot 2015-10-21 at 5.28.02 PM


Filed under: oracle

Application Development with Node.js, Python, PHP, R, C, and C++ at OOW

Christopher Jones - Thu, 2015-10-22 01:18
The huge Oracle OpenWorld conference in San Francisco starts in a few days. We've put together some lists of sessions that we think app developers will be interested in.

These lists should help you work out a great schedule!

Look out for the talks Enterprise App Development with Node.js, Python, and PHP for Oracle Database 12c (Monday), Oracle Net Services 12c: Best Practices for Database Performance and Scalability (Tuesday), Meet the Oracle Programming and Scripting Experts (Tuesday), Best Practices for Application Performance and Scalability (Wednesday), and Best Practices for Application High Availability on Thursday.

If you want to explore what else is happening, look at the OOW Content Catalog

Article on installing node-oracledb on Windows

Christopher Jones - Thu, 2015-10-22 00:14
OTN has posted a detailed article on Installing node-oracledb on Microsoft Windows by Bill Christo (@bchr02). Check it out!

You may also be interested in the research Bill is doing into pre-creating binaries so you don't need to compile yourself: github.com/oracle/node-oracledb/issues/18.

How To Install Latest Verisign G5 Root Certificates

Vikram Das - Wed, 2015-10-21 16:48
Dhananjay pinged me today and told me that for their Paypal integration, they had to upgrade to Verisign G5 root certificate.  This was the message from Paypal:

Global security threats are constantly changing, and the security of our merchants continues to be our highest priority. To guard against current and future threats, we are encouraging our merchants to make the following upgrades to their integrations:
  1. Update your integration to support certificates using the SHA-256 algorithm. PayPal is upgrading SSL certificates on all Live and Sandbox endpoints from SHA-1 to the stronger and more robust SHA-256 algorithm.
  2. Discontinue use of the VeriSign G2 Root Certificate. In accordance with industry standards, PayPal will no longer honor secure connections that require the VeriSign G2 Root Certificate for trust validation. Only secure connection requests that are expecting our certificate/trust chain to be signed by the G5 Root Certificate will result in successful secure connections.
For detailed information on these changes, please reference the Merchant Security System Upgrade Guide. For a basic introduction to internet security, we also recommend these short videos on SSL Certificates and Public Key Cryptography.

There is a support.oracle.com article published on October 16, 2015 which has detailed steps for 11i and R12.1:

How To Install Latest Verisign Root Certificates For Use With Paypal SDK 4.3.X (Doc ID 874433.1)

The Verisign G5 root certificate can be downloaded from:

Paypal Microsite about this change: https://www.paypal-knowledge.com/infocenter/index?page=content&id=FAQ1766&expand=true&locale=en_US

Useful Links
Categories: APPS Blogs

Apex 5.0.2 released

Flavio Casetta - Wed, 2015-10-21 15:37
Categories: DBA Blogs

My OOW Session: IT Analytics for DBAs and Middleware Administrators

Debu Panda - Wed, 2015-10-21 08:00
I have been presenting at Oracle Open World for past 15 years. I will be speaking at Oracle Open World 2015 again. My session is on a completely different topic and I will be showcasing an exciting new Cloud Service.  If you are a DBA or WebLogic Administrator and you are attending Oracle Open World 2015, you probably do not want to miss this exciting session!

You can use this following link to register to my session.

Tuesday, Oct 27, 5:15 p.m. | Moscone South—300

DBAs and middleware administrators need tools that go beyond monitoring to analyze their application infrastructure and get insight on resource capacity and performance bottlenecks to improve application performance and availability. Come to this session to learn about Oracle IT Analytics Cloud Service, the next-generation management cloud service built on a unified data platform and designed to help DBAs and middleware administrators plan for capacity based on real workloads and identify and remediate common problems across their database and application servers.

powershell odbc sybase

Laurent Schneider - Wed, 2015-10-21 07:41

Oracle goes there ==> …/oracle-odbc-hello-world-with-powershell.html

To test Sybase ODBC driver with Powershell, it’s not much different

  1. configure the DsN with odbcconf or %SYSTEMROOT%\SysWOW64\odbcconf for the 32bits drivers under Windows 64.
    cmd /c "%SYSTEMROOT%\SysWOW64\odbcconf.exe /a {configdsn ""Adaptive Server Enterprise"" ""DSN=helloworld|database=mydb|port=25000|server=srv01""}"

    The name of the driver is important. It is probably also called “Adaptive Server Enterprise” on your machine.

  3. test it, same as in Oracle. If you need to test the 32bits drivers under 64bits windows, use the 32bits powershell %SystemRoot%\syswow64\WindowsPowerShell\v1.0\powershell.exe
    $conn = New-Object data.odbc.odbcconnection
    $conn.ConnectionString = "dsn=helloworld;uid=scott;pwd=tiger"
    (new-Object Data.Odbc.OdbcCommand("select 'Hello World'",$conn)).ExecuteScalar()

Oracle APEX 5.0.2 now available

Patrick Wolf - Wed, 2015-10-21 02:51
Oracle Application Express 5.0.2 is now released and available for download. If you wish to download the full release of Oracle Application Express 5.0.2, you can get it from the Downloads page on OTN. If you have Oracle APEX 5.0.0 … Continue reading
Categories: Development

EBS 12.2.7 AD & TXK Delta 7 Features Review

Senthil Rajendran - Tue, 2015-10-20 22:25
With 12.2.7 AD & TXK Delta 7 - EBS Customers on 12.2 should be seeing improvements and stability. It is time now to review them. Watch this blog for the detailed review.

Some of the key features of Delta 7 are
  • Enhanced adop Console Messages
  • New adop Monitoring Tool
  • New adop 'validate' Option
  • Support for Middle Tier EBS Technology Checker
  • Support for EBS Installation Central Inventory
  • Script to Automate Changing Oracle WebLogic Server Administration User Password
  • Simplified Procedure for Changing WLS Data Source
  • New 'dualfs' Option in Standard Cloning
  • Improved Delete Node and Delete Managed Server APIs
  • Mandatory Definitions of Context Variables
  • Automatic Execution of ETCC on Database Tier After Cloning
  • Various adop Enhancements and Fixes

I’m Wade ‘Smart Panda’ Coombs and this is how I work

Duncan Davies - Tue, 2015-10-20 15:23

Next up in our ‘How I Work‘ series is Wade ‘Smart Panda’ Coombs. Wade is one of the most prolific bloggers currently sharing their PeopleSoft knowledge. He writes at his thesmartpanda.com website and has a lot of great content – particularly focusing on SSL certs, Change Assistant, server admin, SES and Weblogic. Wade also has a ‘Smart Thinking’ newsletter (this is the current issue, including a sign-up link).


Name: Wade Coombs (a.k.a The Smart Panda)

Occupation: Owner at The Smart Panda
Location: St Thomas, Ontario, Canada.
Current computer: HP Envy & Eurocom X3
Current mobile devices: iPhone 5 & iPad Air 2
I work: To help clients make their systems work for them, there should be no pain when operating an Enterprise system. Seriously it shouldn’t be painful – no really!

What apps/software/tools can’t you live without?

  • Software: UltraEdit, Beyond Compare, Bitvise SSH Client, Notepad (I know)
  • SQL, VPN & Mobile Hotspots
  • My Private Cloud Servers

Besides your phone and computer, what gadget can’t you live without?
I do love my iPhone’s GPS system, but one of my favourite tools I have is my WebEx account.

What’s your workspace like?
I tend to get stuck on my computer for long periods of time so I typically change every day where I am working from, some days I don’t even get out of bed and some days I don’t get to bed, but any place that can hold my coffee and computer – I am good to go.


What do you listen to while you work?
I have a huge musical collection that covers 60’s country to Opera to the soundtracks of Disney (yes I have a daughter) to all the latest music trends. However most days all I hear are my daughter singing and/or my son playing Minecraft.

What PeopleSoft-related productivity apps do you use?

  • PeopleTools: Change Assistant, App Designer, Data Mover
  • SQL Tools: SQL Developer & SSMS (SQL Server Management Studio)
  • Browsers: Firefox & Chrome
  • Microsoft Office: Excel, Word & Visio
  • SSL tools: Portecle, openSSL, keytool

Do you have a 2-line tip that some others might not know?
When it comes to PeopleSoft – experience is worth its weight in gold. There is a lot of assumed knowledge and unless you have worked with it, you will go down some dark roads.

What SQL/Code do you find yourself writing most often?
I have an entire script for refreshing a database, but I often find myself doing updates to PSOPRDEFN & PSACCESSPRFL and:

  • grant select on PSOPRDEFN to people;
  • grant select on PSACCESSPRFL to people;
  • grant select on PSTATUS to people;

What would be the one item you’d add to PeopleSoft if you could?
If anything, I would remove some of the crazy unnecessary stuff like: COBOL, nVision, Crystal (actually finally going away). The PeopleTools are extremely well written and work very well, so having all these crazy 3rd party programs makes it hard to be knowledgeable in all the areas. I believe in the KISS methodology.

What everyday thing are you better at than anyone else?
In 20 years of PeopleSoft and 30 years of database work, I have seen just about everything. I have a unique ability in taking that knowledge and applying it to the next latest and greatest thing and achieving amazing results for my clients.  Today, we focus on hosting environments for clients with SmartHosting or with client hardware either way we have found the complexity of PeopleSoft has increased to such a level that it is more cost and time effective to outsource to experts that can deliver the results clients demand.

What’s the best advice you’ve ever received?
Be Authentic. People have an amazing ability to smell bulls*$t, so do what you say you are going to do and do it to the best of your ability.

October 2015 Critical Patch Update Released

Oracle Security Team - Tue, 2015-10-20 14:56

Hi, this is Eric Maurice. Oracle released the October 2015 Critical Patch Update today.  As a reminder, the Critical Patch Update is Oracle’s primary program for the release of security fixes across Oracle product lines. 

Critical Patch Updates are released 4 times a year, in a schedule that is announced a year in advance.  This predictability is intended to provide Oracle customers the ability to plan for the timely application of these security fixes, so that they can maintain their security posture.  In other words, the predictability of the Critical Patch Update schedule is intended to provide Oracle customers with the ability to include security patching in their regular maintenance activities. 

Periodically, Oracle continues to receive reports of malicious exploitation of vulnerabilities for which Oracle has already released fixes.  In some instances, it was reported that malicious attackers were successful because targeted Oracle customers had not applied available security patches.  The problem of the non-application of security fixes is all too common in the industry, particularly around complex enterprise applications, due to their complexity, need for near-complete availability, and need for patch testing and validation prior to deployment in production. Oracle recommends that Critical Patch Updates be applied as soon as possible.  This recommendation is particularly important today because the October 2015 Critical Patch Update include a number of fixes for very severe vulnerabilities. 

The October 2015 Critical Patch Update provides fixes for 154 new security vulnerabilities across a wide range of product families, including: Oracle database, Oracle Fusion Middleware, Oracle Hyperion, Oracle Enterprise Manager, Oracle E-Business Suite, Oracle Supply Chain Products Suite, Oracle PeopleSoft Enterprise, Oracle Siebel CRM, Oracle Industry Applications, including Oracle Communications Applications and Oracle Retail Applications, Oracle Java SE, Oracle Sun Systems Products Suite, Oracle Pillar Axiom, Oracle Linux & Virtualization, and Oracle MySQL.

Out of these 154 new security fixes, 8 are for the Oracle Database.  The most severe of these database vulnerabilities (CVE-2015-4863) has received a CVSS Base Score of 10.0.  This CVSS Base Score of 10.0 denotes a vulnerability that is remotely exploitable without authentication, which, if successfully exploited, can result in a full compromise of the targeted system.  In addition, 3 database vulnerabilities received a CVSS Base Score of 9.0. 

The October 2015 Critical Patch Update provides 15 new security fixes for Oracle Sun Systems Products Suite.  One of the vulnerabilities fixed with this Critical Patch Update (CVE-2015-4915), has received a CVSS Base Score of 10.0.  This vulnerability affects the Integrated Lights Out Manager (a.k.a. ILOM), which is used across a number of products.  In addition to applying the necessary patches as soon as possible, Oracle recommends that customers ensure the ILOM interface be not publicly accessible over the Internet.

This Critical Patch Update also provides 23 security fixes for Oracle Fusion Middleware, 16 of which are remotely exploitable without authentication.  The most severe CVSS Base Score reported for these vulnerabilities is 7.5. 

Oracle Hyperion receives one new security fix with a CVSS Base Score of 1.2.

Oracle Enterprise Manager Grid Control receives 5 new security fixes, 3 of which are remotely exploitable without authentication.  The highest reported CVSS Base Score for the vulnerabilities is 6.8.

This Critical Patch Update also includes a number of fixes for Oracle Applications, including 12 new security fixes for Oracle E-Business Suite (maximum reported CVSS Base Score for E-Business Suite is 6.8), 8 new fixes for Oracle Supply Chain Products Suite (maximum CVSS Base Score of 6.8), 8 new security fixes for Oracle PeopleSoft Enterprise products (maximum CVSS Base Score of 6.8), 1 new security fix for Oracle Siebel CRM (CVSS Base Score of 4.3). 

Oracle Industry Applications receive 14 new security fixes.  9 of these fixes are for Oracle Communications Applications, including 5 new fixes for a vulnerability rated with a CVSS Base Score of 10.0 (CVE-2015-2608 affects a component used on 5 of these products).  Oracle Retail Applications get 4 new fixes and the highest reported CVSS Base Score for these vulnerabilities is 7.5.

Oracle Java SE receives 25 new security fixes, 24 of which are remotely exploitable without authentication.  The highest reported CVSS Base Score for these Java SE vulnerabilities is 10.0.  20 of the Java SE vulnerabilities only affect client deployment of Java SE (e.g., Java in the browser).  The remaining 5 vulnerabilities affect client and server deployments of Java SE.  Java home users should visit the java.com web site, to ensure that they are using the most recent version of Java and remove obsolete JAVA SE versions from their desktop if they are not needed.

Due to the severity of a number of vulnerabilities fixed in this Critical Patch Update, Oracle recommends that the necessary patches be applied as soon as possible.  As of October 19th, the company’s security team didn’t have any indication that any of the most severe vulnerabilities fixed in this Critical Patch Update had been successfully exploited “in the wild” (some of these bugs were discovered internally as part of our ongoing assurance effort).  However, it is our experience that malicious actors will often attempt to reverse-engineer fixes to develop exploit code in an attempt to attack organizations lagging behind in their patching effort.  Keeping up with security releases is important to help preserve a security-in-depth posture.  Fortunately, Critical Patch Update fixes for most Oracle products are cumulative, and this means that the application of the October 2015 Critical Patch Update will resolve not only the new vulnerabilities reported in today’s advisory, but also all the previously-reported security issues affecting the affected Oracle product versions.

For More Information:

The October 2015 Critical Patch Update advisory is located at http://www.oracle.com/technetwork/topics/security/cpuoct2015-2367953.html

The Oracle Software Security Assurance web site is located at http://www.oracle.com/us/support/assurance/overview/index.html 

Richard Foote: Upcoming Presentation Events (David Live)

Richard Foote - Mon, 2015-10-19 19:28
I’ll be doing the rounds in Australia/NZ in the coming weeks so plenty of opportunity to catch-up and see me in action I’ll be doing a “National Tour” of my Let’s Talk Oracle Database sessions that I’ve been running locally in Canberra for a number of years. All events have limited places available so please […]
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator