Feed aggregator

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

Hidora_Endpoints_MongoDB

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-4.0.2.50187.20180905T1454Z-1.x86_64.tar.gz

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-4.0.2.50187.20180905T1454Z-1.x86_64.tar.gz /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-4.0.2.50187.20180905T1454Z-1.x86_64.tar.gz

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-4.0.2.50187.20180905T1454Z-1.x86_64/conf

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

mongo.mongoUri=mongodb://127.0.0.1:27017/?maxPoolSize=150
 mongo.ssl=false
 mms.centralUrl=http://xxx.xxx.xx.xx:8080

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

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

Access to the OPS Manager application through the following URL:

http://public_ip:8080

MongoDB_UI

 

You need to register for the first time.

MongoDB_Register

 

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

MongoDB_URL

Then configure your email settings.

MongoDB_EmailSettings

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

Finish by the OPS Manager versions configuration.

MongoDB_Version_Management

 

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

MongoDB_OPSManager

 

 

 

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
Oracle
415.595.1584
matt.torres@oracle.com
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.

Trademarks

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
650.506.1891
bill.rundle@oracle.com
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.

Trademarks

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
Oracle
+1.202.904.1138
katie.barron@oracle.com
Kristin Reeves
Oracle
+1.925.787.6744
kris.reeves@oracle.com
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.

Trademarks

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/10.146.0.2} <======> No organization [qwiklabs-gcp***]{privatenet-us-vm/172.16.0.2}

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

VPC:
Firewall:


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/172.16.0.2}.
Note: (as firewall allow icmp/ssh). No need to do on firewall.

opun@ubuntu-test:~$ ssh 172.16.0.2
opun@172.16.0.2'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 10.146.0.2
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    10.146.0.2       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;

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

ERROR WITH IMPORT OPERATION IN DATABASE 11G RELEASE 1 AND DEVELOPER 10G

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 2.7.0.0.0 is available

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

Oracle Utilities Customer To Meter 2.7.0.0.0 and Oracle Utilities Customer Care And Billing 2.7.0.0.0 are now available for download from Oracle eDelivery Cloud. These new releases are based upon Oracle Utilities Application Framework 4.3.0.6.0 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.3.0.6.0, 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.

Oracle Retail Industry Forum 2018 Convenes European Retail Leaders to Share Insights and Strategies for Continued Growth and Innovation

Oracle Press Releases - Tue, 2018-09-18 10:00
Press Release
Oracle Retail Industry Forum 2018 Convenes European Retail Leaders to Share Insights and Strategies for Continued Growth and Innovation Over 110 European Retailers from 26 Countries Expected to Attend Conference in Budapest

Redwood Shores, Calif.—Sep 18, 2018

Oracle Retail will convene a European community of retail leadership at the Oracle Retail Industry Forum (ORIF) in Budapest Hungary with a program tailored for retailers by retailers and an opportunity for strategic networking to continue discussions on strategies and successes.

“Oracle Retail Industry Forum is about bringing together our retail community to foster continued growth and innovation. We are pleased to showcase local customer success stories. Within the forum, we highlight real software, delivering real value,” said Chris James, vice president of Europe, Oracle Retail.

At Oracle Retail Industry Forum, retail executives gather to share deep domain expertise and best practices on the mission-critical applications that are core to their businesses and their success. Program content is focused on customers providing perspectives on identifying and overcoming complex industry challenges.

Retail speakers include:

  • Delphine Brabant, Head of Buying/Product IT Department, ÏDKIDS Community

  • Bhavesh Chavda, Enterprise Architect, John Lewis

  • Andrew Parr, IT Director, Wyevale

  • Mathilde Paul, Chef de Projet Chez, Auchan

  • Piotr Pawlowski, Strategic IT Director, CCC, S.A

Retail continues to be mercurial as consumers react and adapt to technological developments, in order to help customers navigate shifting attitudes and customer behaviors Oracle will reveal the findings of a global consumer research report.

“For us, the Oracle Retail Industry Forum is a critically important event because the focus on the European community. We view Oracle as an important partner and our collaboration with Oracle is a key part of our strategy,” said Platinum Sponsor Gabor Tozser, Chief Executive Officer, Quickborn. “Oracle’s solutions have the capabilities that we believe are supporting critical retail capabilities without which retailers will not succeed today.”

Oracle will be joined by 11 strategic solution integrators as sponsors for ORIF in Budapest. These partners contribute to and help deliver success within our community. Our partner community includes platinum sponsor Quickborn; gold sponsors Accenture, Logic, Retail Consult and Veltio; and Adyen, Cognira, First Friday, HRS, OLR and SkillNet as silver sponsors. 

For more information about how Oracle is committed to empowering organizations through best-in-class, industry-specific business solutions, visit oracle.com/retail. To learn more about Oracle Retail Industry Forum 2018, go to www.oracle.com/goto/orif18. Registration is limited to retailers and our sponsor community.

Contact Info
Matt Torres
Oracle
4155951584
matt.torres@oracle.com
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.

Trademarks

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

  • 4155951584

[BLOG] Introduction to Hadoop Security

Online Apps DBA - Tue, 2018-09-18 07:07

Security is one of the important things that anyone working on Hadoop or wish to learn Hadoop should know. Visit: https://k21academy.com/hadoop18 and learn about: ✔Hadoop Security Overview ✔Why is security important for Hadoop ✔ What Kerberos is and how it relates to Hadoop & much more… Security is one of the important things that anyone […]

The post [BLOG] Introduction to Hadoop Security appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Oracle Leads the Market with Growth by Revenue in iPaaS

Oracle Press Releases - Tue, 2018-09-18 07:00
Press Release
Oracle Leads the Market with Growth by Revenue in iPaaS Oracle iPaaS market share by revenue grew 270 percent between 2016 and 2017, according to Gartner report1

Redwood Shores, Calif.—Sep 18, 2018

Oracle today announced that it has achieved the highest market share by revenue in Gartner’s “Market Share Analysis: Integration Platform as a Service, Worldwide, 2017” report1. This report follows Oracle being named a Leader in Gartner’s 2018 “Magic Quadrant for Enterprise Integration Platform as a Service” report2 in April.

“We believe our market share demonstrates the value Oracle Cloud Platform delivers to thousands of enterprises every day,” said Amit Zavery, executive vice president of development, Oracle Cloud Platform. “Our comprehensive iPaaS offering has eliminated the barriers between various Oracle and third-party ERP, HCM, and CX applications to provide a seamlessly connected business spanning cloud and on-premises. This comprehensive and easy-to-use offering, combined with strong synergy with the rest of the Oracle Cloud portfolio, continues to help our customers successfully transform and evolve their businesses by leveraging modern integration technologies, including artificial-intelligence and machine learning-powered services.”

“GE leverages Oracle Integration Cloud to streamline commercial, fulfilment, operations and financial processes of our Digital unit across multiple systems and tools, while providing a seamless experience for our employees and customers,” said Kamil Litman, vice president of software engineering, GE Digital. “Our investment with Oracle has enabled us to significantly reduce time to market for new projects, and we are excited about Oracle’s autonomous cloud capabilities.”

Oracle’s iPaaS offerings include Oracle Integration Cloud, Oracle Data Integration Platform Cloud and Oracle SOA Cloud, all part of Oracle Cloud Platform. Oracle Integration Cloud is a simple and powerful integration platform targeting ad hoc integrators with tools such as process automation, while Oracle SOA Cloud delivers a high-control platform for specialist integrators. With more than 100 adapters, customers can quickly integrate and scale Oracle, third-party, and on-premises applications, APIs, people and devices. Additionally, Oracle has many other cross-PaaS offerings that can be combined with Oracle’s iPaaS services to deliver greater productivity.  Those services include Oracle Data Integration Platform Cloud, to support real-time data streaming, batch data processing, and enterprise data quality and governance; and Oracle API Platform Cloud, for API-first design and management. Oracle API Platform Cloud, leveraging Apiary’s unique API-first design tool used by over 300,000 developers and 400,000 APIs, is designed to eliminate the complexities associated with transforming on-premises API solutions into the cloud, so companies can thrive in the digital economy.

Oracle also previously announced autonomous capabilities across its entire Oracle Cloud Platform portfolio, including application and data integration. This includes self-defining integrations that help customers rapidly automate business processes across different SaaS and on-premises applications, as well as self-defining data flows with automated data lake and data prep pipeline creation for ingesting data (streaming and batch).

1. Gartner, “Market Share Analysis: Integration Platform as a Service, Worldwide, 2017,” by Bindi Bhullar, Massimo Pezzini, Keith Guttridge, Elizabeth Golluscio, Eric Thoo, August 7 2018

2. Gartner, “Magic Quadrant for Enterprise Integration Platform as a Service,” by Keith Guttridge, Massimo Pezzini, Eric Thoo, Bindi Bhullar, Betty J. Zakheim, April 18, 2018

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.

Contact Info
Nicole Maloney
Oracle
1.650.506.0806
nicole.maloney@oracle.com
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.

Trademarks

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

Nicole Maloney

  • 1.650.506.0806

Oracle Forms V Oracle APEX Check List

Tom Kyte - Tue, 2018-09-18 03:06
Oracle Forms has some strength and is still the best BackOffice tool from ORACLE from my Point of view. Here are some issues that I miss with APEX. Maybe you already have these Options in 18.x.? Can you check this list: 1. 100% accessiblity for...
Categories: DBA Blogs

Display blob pdf

Tom Kyte - Tue, 2018-09-18 03:06
Dear, I have table lob_table( id number ,doc blob ,namefile varchar (200)) I would like to display blob doc who is pdf file and print it in sqldeveloper. i have create this procedure is it corrects ? CREATE OR REPLACE PROCEDURE PROC2 AS...
Categories: DBA Blogs

The Future of Single-Discipline User Group Conferences

Tim Hall - Tue, 2018-09-18 02:46

It’s just my opinion, but I think the days of the single discipline user group conference are numbered…

The big company flagship conferences will still happen, as they are more about hype and marketing, but I’m not sure what the future holds for regular user groups that want to stay with a single focus.

I don’t know many people who work on a single technology anymore. I certainly don’t know many people who would be allowed to go to a separate conference per technology they work on. That means they need to pick a subset of events, or not get involved. Either way they are being sold short.

I’m starting to think multi-discipline events like Riga Dev Days make a lot more sense. Even Oracle have gone this route with the Oracle Code events, which are multi-discipline, with an Oracle spin of course. These types of events are not without their issues too, as there has to be a limit on the content for each discipline and there can be scheduling clashes, but I think it makes it a lot easier for people to cover their bases with less conference visits per year.

There are some really strong user groups out there, but for those that are struggling, I wonder if widening the net would help? This could affect the enthusiasm of some sponsors, but it may open new opportunities too.

What do you think?

Cheers

Tim…

Update: As per comments and twitter discussion, people have cited successful “single-discipline” conferences. There will always be winners and losers, and I think many of these probably do have quite a diverse range of material, with a common thread running through them. This is how I think of Oracle Code, a diverse collection of subjects loosely woven together by an Oracle thread.

If someone has hit upon a winning formula that is still specialist, I’m not suggesting they change what is currently working for them. For those that are struggling, maybe now is the time for something different?

The Future of Single-Discipline User Group Conferences was first posted on September 18, 2018 at 8:46 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Pages

Subscribe to Oracle FAQ aggregator