Feed aggregator

Oracle Recognized as a Leader in Gartner Magic Quadrant for Cloud HCM Suites for Midmarket and Large Enterprises

Oracle Press Releases - Thu, 2018-09-20 07:00
Press Release
Oracle Recognized as a Leader in Gartner Magic Quadrant for Cloud HCM Suites for Midmarket and Large Enterprises Oracle Placed Furthest for Completeness of Vision within the entire Gartner Magic Quadrant

REDWOOD SHORES, Calif. —Sep 20, 2018

Oracle today announced that it has been recognized, for the third consecutive year, as a Leader in Cloud HCM Suites for Midmarket and Large Enterprises by Gartner. The 2018 Gartner Magic Quadrant for Cloud HCM Suites for Midmarket and Large Enterprises evaluates vendors based on completeness of vision and ability to execute. It positioned Oracle furthest for completeness of vision for Cloud HCM Suites. A complimentary copy of the report is available here.

“Our strong investment in a simple, powerful HCM system, and innovation in artificial intelligence and digital assistants, will forever change the experience of working with HCM systems,” said Chris Leone, senior vice president of development, Oracle HCM Cloud. “We are very pleased to be recognized by Gartner and believe our position as a Leader in this year’s report further validates our relentless commitment to helping customers gain a competitive advantage while adapting to the ever-accelerating pace of technological change.”

According to Gartner, “Leaders demonstrate a market-defining vision of how HCM technology can help HR leaders achieve business objectives. Leaders have the ability to execute against that vision through products and services, and have demonstrated solid business results in the form of revenue and earnings. In the cloud HCM suite market, Leaders show a consistent ability to win deals, including the foundational elements of admin HR (with a large number of country-specific HR localizations) and high attach rates of Talent Management, Workforce Management and HRSD capabilities. They have multiple proof points of successful implementations. Further, these customers have workforces deployed in more than one of the main geographic regions (North America, Europe, MENA, Latin America and Asia/Pacific), in a wide variety of vertical industries and sizes of organization (by number of employees). Leaders are often what other providers in the market measure themselves against.”

Part of Oracle Cloud Applications, Oracle HCM Cloud enables HR professionals to simplify the complex in order to meet the increasing expectations of an ever-changing workforce and business environment. By providing a complete and powerful platform that spans the entire employee life cycle, Oracle HCM Cloud helps HR professionals deliver superior employee experience, align people strategy to evolving business priorities, and cultivate a culture of continuous innovation.

For additional information on Oracle HCM Cloud visit: https://cloud.oracle.com/en_US/hcm-cloud.

Gartner, Magic Quadrant for Cloud HCM Suites for Midmarket and Large Enterprises, Melanie Lougee, Ranadip Chandra, et al., 15 August 2018.

Contact Info
Simon Jones
Oracle PR
Gartner Disclaimer

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Simon Jones

  • 415-202-4574

Object Erasure capability introduced in

Anthony Shorten - Wed, 2018-09-19 17:45

With data privacy regulations around the world being strengthened data management principles need to be extended to most objects in the product. In the past, Information Lifecycle Management (ILM) was introduced for transaction object management and is continued to be used today in implementations for effective data management. When designing the ILM capability, it did not make sense to extend it to be used for Master data such as Account, Persons, Premises, Meters, Assets, Crews etc as data management and privacy rules tend to be different for these types of objects.

In Oracle Utilities Application Framework V4., we have introduced Object Erasure to support Master Data and take into account purging as well as obfuscation of data. This new capability is complementary to Information Lifecycle Management to offer full data management capability. This new capability does not replace Information Lifecycle Management or depends on Information Lifecycle Management being licensed. Customers using Information Lifecycle Management in conjunction with Object Erasure can implement full end to end data management capabilities.

The idea behind Object Erasure is as follows:

  • Any algorithm can call the Manage Erasure algorithm on the associated Maintenance Object to check for the conditions to ascertain that the object is eligible for object erasure. This is flexible to allow implementations to have the flexibility to initiate the process from a wide range of possibilities. This can be as simple as checking some key fields or some key data on an object (you decide the criteria). The Manage Erasure algorithm is used to detect the conditions, collate relevant information and call the F1-ManageErasureSchedule Business Service to create an Erasure Schedule Business Object in a Pending state to initiate the process. A set of generic Erasure Schedule Business Objects is provided (for example, a generic Purge Object for use in Purging data) and you can create your own to record additional information.
  • The Erasure Schedule BO has three states which can be configured with algorithms (usually Enter Algorithms, a set are provided for reuse with the product).
    • Pending - This is the initial state of the erasure
    • Erased - This is the most common final state indicating the object has been erased or been obfuscated.
    • Discarded - This is an alternative final state where the record can be parked (for example, if the object becomes eligible, an error has occurred in the erasure or reversal of obfuscation is required).
  • A new Erasure Monitor (F1-OESMN) Batch Control can be used to transition the Erasure Schedule through its states and perform the erasure or obfuscation activity.

Here is a summary of this processing:

Erasure Flow

Note: The base supplied Purge Enter algorithm (F1-OBJERSPRG) can be used for most requirements. It should be noted that it does not remove the object from the _K Key tables to avoid conflicts when reallocating identifiers.

The solution has been designed with a portal to link all the element together easily and the product comes with a set of pre-defined objects ready to use. The portal also allows an implementer to configure Erasure Days which is effectively the number of days the record remains in the Erasure Schedule before being considered by the Erasure Monitor (a waiting period basically).

Erasure Configuration

As an implementer you can just build the Manage Erasure algorithm to detect the business event or you can also write the algorithms to perform all of the processing (and every variation in between). The Erasure will respect any business rules configured for the Maintenance Object so the erasure or obfuscation will only occur if the business rules permit it.

Customers using Information Lifecycle Management can manage the storage of Erasure Schedule objects using Information Lifecycle Management.

Objects Provided

The Object Erasure capability supplies a number of objects you can use for your implementation:

  • Set of Business Objects. A number of Erasure Schedule Business Objects such as F1-ErasureScheduleRoot (Base Object), F1-ErasureScheduleCommon (Generic Object for Purges) and F1-ErasureScheduleUser (for user record obfuscation). Each product may ship additional Business Objects.
  • Common Business Services. A number of Business Services including F1-ManageErasureSchedule to use within your Manage Erasure algorithm to create the necessary Erasure Schedule Object.
  • Set of Manage Erasure Algorithms. For each predefined Object Erasure object provided with the product, a set of Manage Erasure algorithms are supplied to be connected to the relevant Maintenance Object.
  • Erasure Monitor Batch Control. The F1-OESMN Batch Control provided to manage the Erasure Schedule Object state transition.
  • Enter Algorithms. A set of predefined Enter algorithms to use with the Erasure Schedule Object to perform common outcomes including Purge processing.
  • Erasure Portal. A portal to display and maintain the Object Erasure configuration.
Refer to the online documentation for further advice on Object Erasure.

In-Database Archiving

Tom Kyte - Wed, 2018-09-19 15:46
Hi, Currently i am using list partitioning based on a status column to classify the data as ACTIVE and EXPIRED. And then the corresponding partitions are exported and then dropped from Prod. The problem with this approach is the internal data m...
Categories: DBA Blogs

TDE Column vs TDE tablespace when to use

Tom Kyte - Wed, 2018-09-19 15:46
Hi, I have gone through the TDE column and TDE tablespace encryption. Most cases TDE tablespace option is found to be better compared to TDE column option. Wanted to know what advantage TDE column encryption gives or rather the use cases for TD...
Categories: DBA Blogs

In explain plan one of the tables in the query is not even scanned for joining , Do you know why ?

Tom Kyte - Wed, 2018-09-19 15:46
I am running a query like below explain plan for select count(1) from A , B where A.column1=1 and A.column2=3 and A.column3=b.column3(+) When I check the explain plan I can see the sort aggregate and other things ,However I do not see...
Categories: DBA Blogs

Missing directory in /var/run or /run - tmpfiles.d

Dietrich Schroff - Wed, 2018-09-19 14:40
Sometimes is happens, that an application/demon refuses to start because of missing files/directories in /var/run.
The first solution is:
  • Create the directory in /var/run
  • Change the permissions
and everything is fine.

Not really.

After the next reboot, the directory is missing again and you have to go for the "first" solution again.

The right solution works like this:
Inside /usr/lib/tmpfiles.d create a myexample.conf file with this content:
        d /var/run/myexample 0755 schroff schroff -
To check if everything is ok run the following command:
        systemd-tmpfiles --create myexample.conf
and you will see:
# ls -l /var/run/ |grep mxexample
drwxr-xr-x  2 schroff schroff   40 19. Sep 22:45 myexample
And this directory will be created with each reboot...

Query Logic Implementation in VBCS for ADF BC REST

Andrejus Baranovski - Wed, 2018-09-19 14:19
Oracle Visual Builder Cloud Service allows to define external REST service connections. In this post I will explain how to implement query logic against such service. Connection is defined for ADF BC REST service.

Wizard provides option to add query parameters, both static and dynamic. I have set one static parameter onlyData=true, to return data only from the service. Also I have created multiple dynamic parameters, the one used in this use case - q parameter. This parameter accepts query expression to filter data. Later in VBCS action chain, I will assign value to this parameter and service will be re-executed to bring filtered data:

Search form elements will be assigned with page scope variables, to hold user query input. On search button click, VBCS action chain will be invoked to read these values and update query parameter. Page scope variables:

Variables firstNameQueryVar and lastNameQueryVar are assigned to search form fields, here is example:

Search button invokes action chain:

Action chain does two things - calls JS function to construct query parameter and then assigns returned value to rest service query parameter to execute search:

JS function is mapped to accept input parameters from search form input fields:

JS function code - parameters are joined into ADF BC REST query string:

JS function result is mapped with page scope variable - result is assigned to this variable:

REST service query parameter q variable is assigned with this value. Once value changes, query is automatically re-executed:

In my next post I will explain how to implement filtering and pagination with transformation function, on top of service connection:

VBCS sample application code is available on GitHub (if you download ZIP from GitHub, make sure to extract it and create new archive including extracted content directly, without top folder).

MongoDB OPS Manager

Yann Neuhaus - Wed, 2018-09-19 08:03

MongoDB OPS Manager (MMS) is a tool for administering and managing MongoDB deployments, particularly large clusters. MongoDB Inc. qualified it as “the best way to manage your MongoDB data center“. OPS Manager also allows you to deploy a complete MongoDB cluster in multiple nodes and several topologies.  As you know, at dbi services, the MongoDB installation is based on our best practices, especially the MFA (MongoDB Flexible Architecture), more information here.

Is OPS Manager compatible with our installation best practices and our MongoDB DMK? For this reasons, I would like to post a guide for the installation and the configuration of the OPS Manager (MMS) based on the dbi services best practices.

In this installation guide, we’ll use the latest version of OPS Manager, release 4.0.2. We’ll install OPS Manager in a single instance, recommended for test and proof of concept.

Testing Environment

We’ll use a Docker container provisioned in the Swiss public cloud Hidora.  Below the information of the container:

  • CentOS 7
  • Add a Public IP
  • Endpoints configuration for: MongoDB DB port 2017, FTP port 21, SSH port 22, OPS Manager interface port 8080


MongoDB Installation

Once your container has been provisioned, you can start the installation of MongoDB. It’s important to know, that OPS Manager needs a MongoDB database in order to stores the application information.  That’s why we need to install and start a mongo database at first.

For more details about the MongoDB Installation, you can refer to a previous blog.

[root@node32605-env-4486959]# mkdir -p /u00/app/mongodb/{local,admin,product}

[root@node32605-env-4486959]# mkdir -p /u01/mongodbdata/
[root@node32605-env-4486959]# mkdir -p /u01/mongodbdata/{appdb,bckpdb}
[root@node32605-env-4486959]# mkdir -p /u02/mongodblog/
[root@node32605-env-4486959]# mkdir -p /u02/mongodblog/{applog,bckplog}
[root@node32605-env-4486959]# mkdir -p /u99/mongodbbackup/ 

[root@node32605-env-4486959]# chown -R mongodb:mongodb /u00/app/mongodb/ /u01/mongodbdata/ /u99/mongodbbackup/

Let’s now download the latest MongoDB and OPS Manager releases from the MongoDB Download Center.

[root@node32605-env-4486959 opt]# wget https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-rhel70-4.0.2.tgz
[root@node32605-env-4486959 opt]# wget https://downloads.mongodb.com/on-prem-mms/tar/mongodb-mms-

Based on the MFA, move the software inside the /product folder.

[root@node32605-env-4486959 opt] mv mongodb-linux-x86_64-rhel70-4.0.1.tgz mongodb-mms- /u00/app/mongodb/product/

Permissions and Extraction:

[root@node32605-env-4486959 product]# chown -R mongodb:mongodb /u00/app/mongodb/product/* [root@node32605-env-4486959 product]# su - mongodb [mongodb@node32605-env-4486959 product]$ tar -xzf mongodb-linux-x86_64-rhel70-4.0.1.tgz [mongodb@node32605-env-4486959 product]$ tar -xzf mongodb-mms-

Run mongo databases for OPS Manager and Backup:

[mongodb@node32605-env-4486959 bin]$ ./mongod --port 27017 --dbpath /u01/mongodbdata/appdb/ --logpath /u02/mongodblog/applog/mongodb.log --wiredTigerCacheSizeGB 1 --fork
[mongodb@node32605-env-4486959 bin]$ ./mongod --port 27018 --dbpath /u01/mongodbdata/bckpdb/ --logpath /u02/mongodblog/bckplog/mongodb.log --wiredTigerCacheSizeGB 1 --fork

Once the 2 databases have been successfully started, we can confirgure and start the OPS Manager application.

First, we need to configure the URL to access to OPS Manager.

[mongodb@node32605-env-4486959 ~]$ cd /u00/app/mongodb/product/mongodb-mms-

Edit the conf-mms.properties file and add the following lines:


Replace the xxx.xxx.xx.xx by your public IP or DNS name.

[mongodb@node32605-env-4486959 ~]$ cd /u00/app/mongodb/product/mongodb-mms-
[mongodb@node32605-env-4486959 bin]$ ./mongodb-mms start
 OPS Manager configuration

Access to the OPS Manager application through the following URL:




You need to register for the first time.



Once your account have been created, configure the OPS Manager access URL.


Then configure your email settings.


Click on Continue and configure the User Authentication, Backup Snapshots, Proxy.

Finish by the OPS Manager versions configuration.



Congratulation, you finish your installation. You can start using OPS Manager now and deploy a MongoDB cluster.





Cet article MongoDB OPS Manager est apparu en premier sur Blog dbi services.

Oracle Retail Enables Retailers to Deliver Compelling Assortments at the Pace of Fast Fashion with New Assortment and Item Planning Cloud Service

Oracle Press Releases - Wed, 2018-09-19 07:00
Press Release
Oracle Retail Enables Retailers to Deliver Compelling Assortments at the Pace of Fast Fashion with New Assortment and Item Planning Cloud Service Oracle Retail named as a Leader in Gartner’s Magic Quadrant Analysis of Retail Assortment Management Applications

Redwood Shores, Calif.—Sep 19, 2018

Oracle Retail has introduced a new Oracle Retail Assortment and Item Planning Cloud Service for fashion and soft line retailers. Delivering an effective assortment and item strategy that engages the customer in an omnichannel environment requires a single view of customer, inventory, order, demand, pricing and promotions that is easily accessed in a cloud environment. Oracle Retail Assortment and Item Planning cloud service provides a framework of best practices for retailers while arming business analysts with advanced analytics and data science that improve the accuracy of assortment and item planning.

Oracle has been named a leader in Gartner’s Magic Quadrant analysis of Retail Assortment Management Applications (RAMA), for the fourth consecutive year.

“Oracle continues its relative placement in the Leaders quadrant,” said Robert Hetu, Research Vice President, Gartner. “Oracle has been the leader in providing all RAMA capabilities for several years. Its leadership in the Magic Quadrant also includes the use of all 13 advanced analytics types within its RAMA application.”

“Oracle’s ongoing leadership in merchandising assortment solutions can be attributed to our extensive suite of modern technology, our focus on delivering innovation in the cloud and our growing community of retailers,” said Jeff Warren, Vice President, Oracle Retail. “The launch of Oracle Retail Assortment and Item Planning speaks to our continued commitment to innovation and leadership in retail, as demonstrated with our release of visual planning, and we appreciate that Gartner recognizes our leadership in their Retail Assortment Magic Quadrant.”

The new Oracle Retail Assortment and Item Planning Cloud Service provides retailers with a rich visual, end-to-end workflow to define and execute local market assortments. Retailers gain item level visibility across their brick and mortar footprint to improve traffic conversion in individual stores, while increasing gross margin and return on investment 

Benefits of Oracle Retail Assortment and Item Planning Cloud Service include:

  • Optimize Targeted Assortments:  Retailers can leverage embedded science and automation to drive an effective assortment strategy that considers historical data of assortment trends, attribute mix, style-color performance by location and special buys. 

  • Create One Complete Version of the Truth: Through a common business process, calculations and smart starting points in a cloud native platform planners can easily review and update sales, promotions, and markdown plans.

  • React to In-season Trends and Opportunities:  Retailers gain the agility to quickly and effectively react to season-to-date actuals and trends with exception management.  This drives an increase in profits while enabling a proactive in-season item management and exception-driven process.

  • Increase Plan Accuracy While Reducing Markdowns: The reconciliation of bottom-up and top-down item plans includes an integrated financial plan reconciliation to prevent overstocks and enable an increased return on investment.  By leveraging natural scenario planning and what-if capabilities, planners are able to easily create and toggle between multiple scenarios; maximizing overall profitability.

Recent Planning and Optimization Success Stories:
Contact Info
Matt Torres
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Matt Torres

  • 415.595.1584

Healthcare Organizations Select Oracle Cloud Applications to Increase Agility and Improve Decision Making

Oracle Press Releases - Wed, 2018-09-19 07:00
Press Release
Healthcare Organizations Select Oracle Cloud Applications to Increase Agility and Improve Decision Making Delta Dental of California, Mount Sinai Health System, and University of Wisconsin Health migrate critical business operations to Oracle Cloud Applications

Redwood City, Calif—Sep 19, 2018

To adapt to rapidly changing industry demands while providing the best possible access to patient care, healthcare organizations are selecting Oracle Cloud Applications. Delta Dental of California and its enterprise affiliates, Mount Sinai Health System, and University of Wisconsin Health (UW Health) have selected Oracle Cloud Applications to enhance business visibility, increase agility, reduce costs, and future proof their organizations on Oracle’s dynamic business innovation platform.

It is more difficult than ever for healthcare organizations to deliver optimum patient care due to increasing competition, costs, and regulatory complexity. To address these challenges, healthcare companies are turning to the cloud to increase agility, reduce costs, and improve overall business efficiency. In fact, IDC research forecasts that healthcare providers will account for 48 percent of total spending on industry cloud in 2018—more than double the investment of any other sector.1

“At Delta Dental, we’re building a culture where employees feel inspired to do—and to be—their absolute best,” said Sarah Chavarria, chief human resources officer for Delta Dental of California and its enterprise affiliates. “As we create an employee experience that empowers our people to take action when and where they need, Oracle’s HCM cloud platform provides our human resources team with the necessary benefits, compensation and talent management data to be more responsive to our employees’ needs.”

“To continue improving our research, patient care and education offering, we needed to expand our business visibility and generate better insights from our technology,” said Donald Scanlon, executive vice president and chief financial officer, Mount Sinai Health System. “Working with the team at Oracle, we will be able to manage human resource, finance and supply chain data and processes on a single, integrated platform. This will significantly improve productivity, enable smarter decision-making and help us create better healthcare outcomes for the communities we serve.”

“Technology and regulations have accelerated the rate of change in the healthcare industry and our legacy business systems were struggling to keep up,” said Elizabeth Bolt, senior vice president and chief operating officer, UW Health. “To ensure we could continue to deliver the best quality services as we grow, we needed agile systems that can quickly turn data into insight. Going forward, we will manage all of our HR, supply chain, and financial data on a single integrated platform.”

Moving to Oracle Cloud Applications enables healthcare organizations to rapidly leverage new artificial intelligence, blockchain, and Internet of Things capabilities as they are added, and benefit from Oracle’s continuous innovation in enterprise applications.

“Healthcare organizations operate in a dynamic, highly-competitive environment with constantly changing regulations, best practices, and technologies,” said Steve Miranda, executive vice president, applications product development, Oracle. “We’re helping healthcare organizations thrive amidst increasing complexity by leveraging emerging technologies, which are part of the fabric of our applications. Oracle Cloud Applications allow our customers to quickly respond to changing market conditions and patient needs to deliver the highest quality care.”

A growing number of healthcare organizations are selecting Oracle Cloud Applications for Enterprise Resource Planning (ERP), Enterprise Performance Management (EPM), Supply Chain Management (SCM) and Human Capital Management (HCM).

  • Delta Dental of California: As the largest U.S. dental carrier, Delta Dental of California and its affiliates provide coverage and access to care to 36.8 million people in the United States, Puerto Rico and Mexico. Delta Dental selected Oracle HCM Cloud to help maximize employee engagement and improve workforce and business agility.

  • Mount Sinai Health System: The Mount Sinai Health System is an integrated health care system, which includes more than 7,000 primary and specialty care physicians and 12 minority-owned free-standing ambulatory surgery centers. Mount Sinai Health System selected Oracle ERP Cloud, Oracle SCM Cloud, and Oracle HCM Cloud to improve business visibility and reduce costs.

  • University of Wisconsin Health (UW Health): UW Health serves more than 600,000 patients annually, with 1,500 physicians and 17,000 staff at seven hospitals and 87 outpatient clinics. UW Health selected Oracle ERP Cloud, Oracle EPM Cloud, Oracle SCM Cloud, and Oracle HCM Cloud to optimize the delivery of healthcare services and improve patient outcomes.

For more information on how the capabilities in Oracle Cloud can benefit healthcare organizations, visit https://www.oracle.com/industries/healthcare/index.html or read this blog.

[1] IDC Research, “Worldwide Semiannual Industry Cloud Tracker,” June 2018, https://bit.ly/2LneOJJ

Contact Info
Bill Rundle
Oracle PR
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE: ORCL), please visit us at oracle.com.


Oracle and Java are registered trademarks of Oracle and/or its affiliates.

Talk to a Press Contact

Bill Rundle

  • 650.506.1891

Central State University Enrolls Oracle Cloud to Help More Students Get Degrees

Oracle Press Releases - Wed, 2018-09-19 07:00
Press Release
Central State University Enrolls Oracle Cloud to Help More Students Get Degrees Leading Ohio University first to deploy Oracle Student Management to reach, retain and foster the success of non-traditional learners

Redwood City, Calif—Sep 19, 2018

Central State University has selected Oracle Student Management to help increase degree attainment and open educational opportunity to all students. Part of the Oracle Student Cloud suite, the technology will empower Central State to better reach, enroll, and ensure the success of students in its upcoming Distance Learning Program. In addition, select Oracle University classes will be added to the program in Fall 2019 broadening the university’s curriculum with new 21st-century technology skills that will further prepare students for the modern workforce.

Central State has an esteemed history of extending learning opportunities to diverse communities. Founded in 1887, Central State is one of 19 1890 Land-Grant institutions in the United States. Today, as an internationally growing university, it aims to be a premier institution with excellence in teaching and learning that embraces diversity and produces graduates with the knowledge, skills, and dispositions to make valuable contributions in a global society.

Central State realized that a modern technology approach was needed to reach more students and provide them the opportunity to learn on the time, schedule, and pace that best meets their unique needs and lifestyle. Oracle Student Management will play a critical role in helping the University not only attract new students to its Distance Learning program, but also provide the proactive intelligence needed to improve retention and success rates across the entire University. Central State also plans to add additional Oracle Cloud technologies over time to further improve operational efficiency and deliver an engaging, personalized student experience.

“Increasing student enrollment, improving retention, and speeding time to a degree are core priorities for Central State,” said Dr. Cynthia Jackson- Hammond, President and Chief Executive Officer, Central State University. “We understand that every student is different and has pressures of work and life that often derail their path. With Oracle Student Management, we will be able to further reach and support those students through our upcoming Distance Learning Program, ensuring they achieve the degree they need to better their employment opportunities.”

Enhancing the traditional capabilities of student information systems (SIS), Oracle Student Management helps transform the student experience with capabilities for recruiting, engagement, support, and management. Leveraging emerging technologies and built in automation, the offering delivers the insights universities need to anticipate student needs and monitor progress more proactively, illuminate the right path to better academic outcomes, and empower student success. The Oracle Student Cloud suite is designed to support a variety of business models, from a straightforward “pay to enroll” to managing complex academic requirements, providing the right footprint for each university’s unique needs.

“Delivering both traditional and non-traditional academic programs effectively requires institutions to be more visionary and have the right solutions to execute that vision,” said Vivian Wong, Oracle’s group vice president of Higher Education Development. “Oracle is partnering with Central State on their Student Cloud journey, to ensure both the University and the students themselves have the advanced tools, touchpoints, and knowledge they need to advance degree achievement.”

To further enhance Central State’s Distance Learning Program, new Oracle University classes will be added to the online course curriculum. As part of the Oracle Workforce Development Program (WDP), initial courses will center around advancing skills in Oracle Database, SQL and Java and will be available for workforce, government, military, corporate, and other non-traditional students.

Contact Info
Katie Barron
Kristin Reeves
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.


Oracle and Java are registered trademarks of Oracle and/or its affiliates.

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Kristin Reeves

  • +1.925.787.6744

[BLOG] Oracle EBS (R12) Financial: Production Based Depreciation in Fixed Assets

Online Apps DBA - Wed, 2018-09-19 05:51

✔What is Depreciation ✔What are the fixed assets ✔Production Based Depreciation in Fixed Assets & much more… Check at https://k21academy.com/financial13 ✔What is Depreciation ✔What are the fixed assets ✔Production Based Depreciation in Fixed Assets & much more… Check at https://k21academy.com/financial13

The post [BLOG] Oracle EBS (R12) Financial: Production Based Depreciation in Fixed Assets appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

How to allow private connectivity across organizations(GCP)?

Surachart Opun - Wed, 2018-09-19 02:41
It's interesting, when you would like to allow private connectivity across two VPC networks that they belong to the different project/organization on Google Cloud Platform (GCP).

As google document that we can use VPC Network Peering? VPC Network Peering is a decentralized or distributed approach to multi-project networking. Additional, it works with Compute Engine, Kubernetes Engine,and App Engine flexible environments.

I did a lab about Virtual Private Cloud (VPC) Network Peering. There shows to do VPC Network Peering between VPC networks in the same project. So, I would like to see how it works on across organizations.

Example: On My Organization (my project), I would like to connect server (Private IP Address) on another Organization (another project).

As a subnet CIDR prefix in one peered VPC network cannot overlap with a subnet CIDR prefix in another peered network. So, both VPC networks must have the different CIDR prefix.

My Organization [myproject] {ubuntu-test, default/} <======> No organization [qwiklabs-gcp***]{privatenet-us-vm/}

On No organization [qwiklabs-gcp***]: VPC network name is "privatenet".


My Organization [myproject]: I used "default" VPC and default firewall.

Then, starting to create "VPC Network Peering".

- To create "VPC Network Peering" on myproject:
Networking => "VPC network" => "VPC network peering".
Click "Create Peering Connection".  name = "peering-to-lab".
Note: you must know Project ID and VPC network name for network destination.

It should show "Waiting for peer network to connect".

-  To create "VPC Network Peering" on another Project: On No organization [qwiklabs-gcp***], "Create Peering Connection".  name = "peering-to-mygcp".

After clicking "Create". It should show "Connected" on both projects (if configuration corrects) like.

On myproject:

- Finally, test connection: ssh to my vm and test (ssh) connection to {privatenet-us-vm/}.
Note: (as firewall allow icmp/ssh). No need to do on firewall.

opun@ubuntu-test:~$ ssh
opun@'s password:
Linux privatenet-us-vm 4.9.0-8-amd64 #1 SMP Debian 4.9.110-3+deb9u4 (2018-08-21) x86_64
The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.
Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Wed Sep 19 06:22:05 2018 from
Could not chdir to home directory /home/opun: No such file or directory
$ w
 06:22:55 up 43 min,  2 users,  load average: 0.00, 0.00, 0.00
USER     TTY      FROM             LOGIN@   IDLE   JCPU   PCPU WHAT
opun     pts/1       06:22    1.00s  0.00s  0.00s w ************Reference: https://cloud.google.com/vpc/docs/vpc-peering
Categories: DBA Blogs

#Exasol Database whoami

The Oracle Instructor - Wed, 2018-09-19 02:03

This little script displays some useful meta-information:

SQL_EXA> create schema myschema;
EXA: create schema myschema;

Rows affected: 0

SQL_EXA> create or replace script whoami as
 output('Current User: '.. tostring(exa.meta.current_user))
 output('Current Schema: '.. tostring(exa.meta.current_schema))
 output('Session ID: '.. tostring(exa.meta.session_id))
 output('Database Version: '.. tostring(exa.meta.database_version))
 output('Number of Nodes: '.. tostring(exa.meta.node_count))
EXA:create or replace script whoami as...

Rows affected: 0
SQL_EXA> col output for a40;
COLUMN   output ON
FORMAT   a40
SQL_EXA> execute script whoami with output;
EXA: execute script whoami with output;

Current User: SYS
Current Schema: MYSCHEMA
Session ID: 1612024483893367379
Database Version: 6.1.0-alpha1
Number of Nodes: 1

5 rows in resultset.

All available metadata is documented here (Chapter 3. Concepts -> 3.6 UDF scripts).

Categories: DBA Blogs


Tom Kyte - Tue, 2018-09-18 21:26
Hi Tom, I installed Oracle Database 11G in the folder (E:\DB11)and successfully imported a user to it. But when you install the developer 10G IN FOLDER(E:\DEV10). and TRY TO DO a user import into the database ORACLE 11G, i am receiving the follo...
Categories: DBA Blogs

Collection to retrieve data as pipelined taking more time even the query taking lesser time

Tom Kyte - Tue, 2018-09-18 21:26
Hi sir, Have facing issue with the time. The query which is used in dynamic cursor type like 'open for select" taking 550 ms but the output we used as collection passing as pipelined value. At that time it's taking more time like 50 s. Please give...
Categories: DBA Blogs

Need script to compare table data of same table in different oracld databases

Tom Kyte - Tue, 2018-09-18 21:26
Hi, I have a requirement where table1 exists in 2 diiferent oracle dbs . I need to write a shell script or pl sql block which would compare every column of the table in db 1 and db2 and give following output from unix. It should be able to take any ...
Categories: DBA Blogs

Selection from union view by table identifier

Tom Kyte - Tue, 2018-09-18 21:26
Hi, I have a view like <code>create view V_TAB as (select 1 as id, value from TAB1 union all select 2 as id, value from TAB2 ); </code> I would expect Oracle be able to optimize the following query and execute a selection only on one tabl...
Categories: DBA Blogs

Oracle Utilities Customer To Meter/Customer Care And Billing is available

Anthony Shorten - Tue, 2018-09-18 19:03

Oracle Utilities Customer To Meter and Oracle Utilities Customer Care And Billing are now available for download from Oracle eDelivery Cloud. These new releases are based upon Oracle Utilities Application Framework with new and updated functionality.

For details of the release, refer to the release notes and documentation available from Oracle eDelivery Cloud and Oracle Utilities Help Center.

Inbound Web Services - REST Services

Anthony Shorten - Tue, 2018-09-18 14:43

In Oracle Utilities Application Framework V4., the Inbound Web Services object has been extended to support both SOAP and REST based services. This has a lot of advantages:

  • Centralized web services registration. The interface Application Programming Interface (API) are now centralized in the Inbound Web Services object. This means you can manage all your programmatic interfaces from a single object. This helps when using the Web Service Catalog used for Oracle Integration Cloud Service as well as any API management capabilities.
  • Isolation from change. One of the major features of the REST capability within Inbound Web Services is the the URI is no longer fixed but can be different from the underlying service. This means you can isolate your interface clients from changes.
  • Standardization. The Inbound Web Services object has inherent standards that can be reused across both SOAP and REST based services. For example, the ConfigTools object model can be directly wired into the service reducing time.
  • Reduced cost of maintenance. One of the features of the new capability is to group all your interfaces into a minimal number of registrations. This reduces maintenance and allows you to control groups of interfaces easily.

The Inbound Web Services now supports two Web Service Classes:

  • SOAP - Traditional XAI and IWS based services based around the SOAP protocol. These services will be deployed to the Oracle WebLogic Server.
  • REST - RESTful based services that are now registered for use. These services are NOT deployed as they are used directly using the REST execution engine.

Inbound Web Service Business Object

For REST Services, a new optimized maintenance function is now available. This facility has the following capabilities:

  • Multiple Services in one definition. It is now possible to define multiple REST services in one registration. This reduces maintenance effort and the interfaces can be enabled and disabled at the Inbound Web Service level. Each REST Service is regarded as an operation on the Inbound Web Service.
  • Customizable URI for service. The URL used for the REST Service can be the same or different than the operation.
  • Business Object Support. In past releases, Business Objects were not supported. In this release, there are some limited support for Business Objects. Refer to the Release Notes and online documentation for clarification of level of support.
  • Open API Support.  This release introduces Open API support for documenting the REST API.

For example, the new Inbound Web Services maintenance function for REST is as follows:

Example REST Inbound Web Service definition

Active REST Services are available to the REST execution engine.

Open API (OAS3) Support has been introduced which provides the following:

  • Documentation of the API in various formats. The documentation of the REST based API based upon the meta data stored in the product.
  • Ability to authorize Inbound Web Services directly in Open API. It is possible to authorize the API directly from the Open API documentation. Developers can check the API prior to making it active.
  • Multiple formats supported. Developers can view payloads in various formats including Model format.
  • Ability to download the API. You can download the API directly from the documentation in Open API format. This allows the API to be imported into Development IDE's.
  • Ability to testing inline. Active API's can be tested directly into the documentation.

The following are examples of the documentation:

API Header including Authorization (Note: Server URL is generic as this server is NOT active).

Open API Support - Authorization

Operation/API List:

Open API Support - URL List

Request API with inbuilt testing facility:

Open API Support - API Request

Response API with response codes:

Open API Support - API Response

Model Format:

Open API Support - Model List

For more information about REST support, refer to the online documentation or Web Services Best Practices (Doc Id: 2214375.1) from My Oracle Support.


Subscribe to Oracle FAQ aggregator