Feed aggregator

Cloning a PDB into a CDB having a active data guard setup

Tom Kyte - Fri, 2017-09-15 11:06
Hi Tom I have been trying to clone a pdb using database link into a cdb having dataguard setup using STANDBYS=ALL clause. But my replication stops . I tried changing the file_name_convert parameter at CDB level and still the new cloned pdb could not...
Categories: DBA Blogs

Creating Custom Search/Query Pages with Visual Builder

Shay Shmeltzer - Fri, 2017-09-15 10:39

There is built in functionality in Visual Builder Cloud Service (VBCS) that will let you attach an advanced filter to any table. This will give you the ability to define complex searches.

However, sometime people would want to create their own custom query pages. For example the default filter for a field searches for a letter in any place in the field - and maybe you just want to search for the first letter. Or maybe you want to display a nice selection list for filtering. There is a little trick that will let you achieve this, and I show it in the video:

The basic steps involve creating a new edit page with a new dummy business object. Then you add a table that is based on the real business object (the one with the data), and hook up the query of this table to the values of fields from the dummy business object. Then you add a button to do a "fetch all" on the table, and you are done.

At the end of the video you'll also see how to hook this page into your main menu.

Categories: Development

What's New in EBS 12.2.7?

Steven Chan - Fri, 2017-09-15 02:00

EBS 12.2.7 is the latest update to E-Business Suite 12.2. It includes functionality enhancements, error corrections, and statutory and regulatory updates in a consolidated suite-wide patch set.

Release 12.2.7 is cumulative and includes updates released previously for earlier EBS releases including 12.1.3, 12.0, and 11.5.10.  It includes bug fixes for the following major product areas:

  • Applications Technology
  • Asset Lifecycle Management  
  • Channel Revenue Management  
  • Financials
  • Human Capital Management  
  • Lease and Finance Management  
  • Logistics
  • Manufacturing
  • Master Data Management  
  • Order Management & Contracts
  • Procurement
  • Contract Lifecycle Management for Public Sector
  • Projects
  • Sales, Marketing, and eCommerce
  • Service Management  
  • Value Chain Planning

EBS 12.2.7 includes new functionality for the following major product families:

  • Iprocurement
  • Procurement
  • Project Procurement
  • Projects
  • Order Management  
  • Logistics
  • Manufacturing
  • Value Chain Planning
  • Asset Management

For a complete list of new features, refer to:

Related Articles

Categories: APPS Blogs

Using Cloud Foundry CUPS to inject Spring Security credentials into a Spring Boot Application

Pas Apicella - Thu, 2017-09-14 18:48
The following demo shows how to inject the Spring Security username/password credentials from a User Provided service on PCF, hence using the VCAP_SERVICES env variable to inject the values required to protect the application using HTTP Basic Authentication while running in PCF. Spring Boot automatically converts this data into a flat set of properties so you can easily get to the data as shown below.

The demo application can be found as follows

https://github.com/papicella/springsecurity-cf-cups

The application.yml would access the VCAP_SERVICES CF env variable using the the Spring Boot flat set of properties as shown below.

eg:

VCAP_SERVICES

System-Provided:
{
 "VCAP_SERVICES": {
  "user-provided": [
   {
    "credentials": {
     "password": "myadminpassword",
     "username": "myadminuser"
    },
    "label": "user-provided",
    "name": "my-cfcups-service",
    "syslog_drain_url": "",
    "tags": [],
    "volume_mounts": []
   }
  ]
 }
}
...

application.yml

spring:
  application:
    name: security-cf-cups-demo
security:
  user:
    name: ${vcap.services.my-cfcups-service.credentials.username:admin}
    password: ${vcap.services.my-cfcups-service.credentials.password:password}
Categories: Fusion Middleware

Ggsci interface

Tom Kyte - Thu, 2017-09-14 16:46
Hi Tom, I want to ask. Is there any ways to create ggsci interface? Like using netbeans or something. Thanks
Categories: DBA Blogs

Goldengate Integrated Replicat Parallel Execution

Tom Kyte - Thu, 2017-09-14 16:46
We're creating a bi-directional Goldengate replication environment between two Oracle databases... Goldengate 12.2 Oracle EE RDBMS 12.1 Both databases on a 2-node Exadata RAC We're using Integrated Extract and Replicat on both nodes. For p...
Categories: DBA Blogs

On addition of a single column, performance of query drastically impacted

Tom Kyte - Thu, 2017-09-14 16:46
Hi, On addition of a single column, performance of a query has drastically impacted (40 secs from 0.0002 secs). Oracle has changed earlier plan and picked plan that takes more time. Change : new column added to a query in select clause : dsi...
Categories: DBA Blogs

Oracle SQL background process

Tom Kyte - Thu, 2017-09-14 16:46
Hi Tom, I have bit knowledge (aware of defination) on PGA and SGA. But I would like to know, when the sql is triggered from client tool(toad). -> background process uses Shared pool memory OR pga memory for performing SYNTAX and SYMANTIC check...
Categories: DBA Blogs

Clustered Index and primary keys

Tom Kyte - Thu, 2017-09-14 16:46
I have question on clustered index I read from documents that whenever primary key is created, it creates clustered index along with it, and it sorts the rows in the table in the same order as the clustered index(on the actual disk), I didn?t unde...
Categories: DBA Blogs

Unjustified memory consumption of windows server equal to SGA_MAX_SIZE in 12.2.0.1 (with manual MM)

Tom Kyte - Thu, 2017-09-14 16:46
Hi, I just installed the latest Oracle 12.2.0.1 Enterprise Edition and I noticed something different with 12.1.0.2 regarding the memory consumption of the Windows Oracle RDBMS Kernel Executable. The database is installed on a Windows server 201...
Categories: DBA Blogs

Demo App for REST enabled SQL

Kris Rice - Thu, 2017-09-14 15:34
Getting Started  The new Oracle REST Data Services SQL over REST.  How to enable that is on my last blog post here: http://krisrice.blogspot.com/2017/09/ords-173-beta-introducing-rest-enabled.html cURL Examples The simplest way to test this new feature out is with a curl command sending over the SQL. $ curl -X "POST" "http://localhost:9090/ords/hr/_/sql" \ -H "Content-Type:

Q1 FY18 GAAP EPS UP 19% TO $0.52 and NON-GAAP EPS UP 12% TO $0.62

Oracle Press Releases - Thu, 2017-09-14 14:04
Press Release
Q1 FY18 GAAP EPS UP 19% TO $0.52 and NON-GAAP EPS UP 12% TO $0.62 Q1 FY18 Cloud Revenues Up 51% to $1.5 Billion and Total Revenues Up 7% to $9.2 Billion

Redwood Shores, Calif.—Sep 14, 2017

Oracle Corporation (NYSE: ORCL) today announced fiscal 2018 Q1 results. Total Revenues were up 7% from the prior year to $9.2 billion. Cloud plus On-Premise Software Revenues were up 9% to $7.4 billion. Cloud Software as a Service (SaaS) revenues were up 62% to $1.1 billion. Cloud Platform as a Service (PaaS) plus Infrastructure as a Service (IaaS) revenues were up 28% to $400 million. Total Cloud Revenues were up 51% to $1.5 billion.

GAAP Operating Income was up 7% to $2.8 billion and Operating Margin was 31%. Non-GAAP Operating Income was up 11% to $3.8 billion and non-GAAP Operating Margin was 41%. GAAP Net Income was up 21% to $2.2 billion, while non-GAAP Net Income was up 14% to $2.7 billion. GAAP Earnings Per Share was up 19% to $0.52, while non-GAAP Earnings Per Share was up 12% to $0.62.

Short-term deferred revenues were up 9% compared with a year ago to $10.3 billion. Operating cash flow on a trailing twelve-month basis was up 8% to $14.8 billion.

“The sustained hyper-growth in our multi-billion dollar cloud business continues to drive Oracle’s overall revenue and earnings higher and higher,” said Oracle CEO, Safra Catz. “In Q1, total revenues were up 7%, GAAP EPS was up 19%, and non-GAAP EPS was up 12%. Oracle is off to a very, very strong start in FY18.”

“With SaaS revenue up 62%, our cloud applications business continues to grow more than twice as fast as Salesforce.com,” said Oracle CEO, Mark Hurd. “ERP is our largest and most important cloud applications business. We now have about 5,000 Fusion ERP customers plus 12,000 NetSuite ERP customers in the Oracle Cloud. That’s 30 times more ERP customers than Workday.”

“In a couple of weeks, we will announce the world’s first fully autonomous database cloud service,” said Oracle Chairman and CTO, Larry Ellison. “Based on machine learning, the latest version of Oracle is a totally automated “self-driving” system that does not require human beings to manage or tune the database. Using AI to eliminate most sources of human error enables Oracle to offer database SLA’s that guarantee 99.995% reliability while charging much less than AWS.”

The Board of Directors also declared a quarterly cash dividend of $0.19 per share of outstanding common stock. This dividend will be paid to stockholders of record as of the close of business on October 11, 2017, with a payment date of October 25, 2017.

Q1 Fiscal 2018 Earnings Conference Call and Webcast

Oracle will hold a conference call and webcast today to discuss these results at 2:00 p.m. Pacific. You may listen to the call by dialing (816) 287-5563, Passcode: 425392. To access the live webcast, please visit the Oracle Investor Relations website at http://www.oracle.com/investor. In addition, Oracle’s Q1 results and Fiscal 2018 financial tables are available on the Oracle Investor Relations website.

A replay of the conference call will also be available by dialing (855) 859-2056 or (404) 537-3406, Passcode: 82330974.

Contact Info
Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@oracle.com
Deborah Hellinger
Oracle Corporate Communciations
+1.212.508.7935
deborah.hellinger@oracle.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE: ORCL), visit www.oracle.com/investor or contact Investor Relations at investor_us@oracle.com or (650) 506-4073.

Trademarks

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

"Safe Harbor" Statement

Statements in this press release relating to Oracle's future plans, expectations, beliefs, intentions and prospects, including statements regarding the growth of our cloud applications business compared to competitors and the announcement regarding our new autonomous database cloud service, are all "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect our current expectations and our actual results, and could cause actual results to differ materially. We presently consider the following to be among the important factors that could cause actual results to differ materially from expectations: (1) Our cloud computing strategy, including our Oracle Cloud SaaS, PaaS, IaaS and data as a service offerings, may not be successful. (2) If we are unable to develop new or sufficiently differentiated products and services, or to enhance and improve our products and support services in a timely manner or to position and/or price our products and services to meet market demand, customers may not buy new software licenses, cloud software subscriptions or hardware systems products or purchase or renew support contracts. (3) If the security measures for our products and services are compromised or if our products and services contain significant coding, manufacturing or configuration errors, we may experience reputational harm, legal claims and reduced sales. (4) We may fail to achieve our financial forecasts due to such factors as delays or size reductions in transactions, fewer large transactions in a particular quarter, fluctuations in currency exchange rates, delays in delivery of new products or releases or a decline in our renewal rates for support contracts. (5) Our international sales and operations subject us to additional risks that can adversely affect our operating results, including risks relating to foreign currency gains and losses. (6) Economic, geopolitical and market conditions can adversely affect our business, results of operations and financial condition, including our revenue growth and profitability, which in turn could adversely affect our stock price. (7) We have an active acquisition program and our acquisitions may not be successful, may involve unanticipated costs or other integration issues or may disrupt our existing operations. A detailed discussion of these factors and other risks that affect our business is contained in our U.S. Securities and Exchange Commission (SEC) filings, including our most recent reports on Form 10-K and Form 10-Q, particularly under the heading "Risk Factors." Copies of these filings are available online from the SEC or by contacting Oracle Corporation's Investor Relations Department at (650) 506-4073 or by clicking on SEC Filings on Oracle’s Investor Relations website at http://www.oracle.com/investor. All information set forth in this press release is current as of September 14, 2017. Oracle undertakes no duty to update any statement in light of new information or future events. 

Talk to a Press Contact

Ken Bond

  • +1.650.607.0349

Deborah Hellinger

  • +1.212.508.7935

September 2017 Updates to AD and TXK for EBS 12.2 Now Available

Steven Chan - Thu, 2017-09-14 13:27

We have been fine-tuning the administration tools for E-Business Suite 12.2 via a series of regular updates to the Applications DBA (AD) and EBS Technology Stack (TXK) components:

We have now made available a twelfth set of critical updates to AD and TXK. We strongly recommend that you apply these new AD and TXK updates at your earliest convenience:

They must be individually downloaded from My Oracle Support, as shown by this example for AD:

Refer to the following My Oracle Support knowledge document for full installation instructions and associated tasks:

What's New in this Patchset?

This patchset includes a large number of critical fixes for stability issues that will affect all customers.  It also includes the following new features:

  • 21095487 PARALLEL DEGREE FEATURE IN ADA API FOR OPTIMIZE_INDEX
  • 24521812 BACKPORT SEED DATA DUAL ROW SET IMPLEMENTATION TO CUP8
  • 24800535 1OFF:12.1.3:NEW VARIABLE AIX_MAXDATA_1G IS REQUIRED FOR ADRELINK IN AIX PLATFORM
  • 24823193 PREPAREPHASE.PM CONTAINS MISPELLING OF "SYNCHRONIZING
  • 25449103 AD:CLEANUP REPORTED ERROR FOR SYS.AD_GRANTS.CLEANUP
  • 25469830 SEED VPD POLICY - STATEMENT_TYPE=INSERT & UPDATE_CHECK=FALSE
  • 25608421 CTX_DDL.ADD_SDATA_SECTION API CALL MISSING IN AD_CTX_DLL API
  • 25662204 SYNC THEME FILES ON CUT-OVER
  • 25747383 AD:CLEANUP REPORTED ORA-44311: SERVICE EBS_PATCH NOT RUNNING
  • 25928667 Issue with LIBPATH in APPSORA.CMD
  • 25985045 AD:PECAPREP.SQL FILE FAILING WITH ORA-28115 ERROR (BUG#25983773)
  • 26004435 FWDPORT ONE-OFF BUGFIX # 25720619 TO DELTA 9 AND DELTA 10
  • 26049966 UPDATE ROBOCOPY USAGE FOR WINDOWS IN DELTA_SYNC_DRV.TXT
  • 26117566 Re-link fails with CYGWIN Version 2.8.0
  • 26137712 AD:CLEANUP REPORTED ERROR FOR SYS.AD_GRANTS.CLEANUP
  • 26299900 FMW_HOME\WEBTIER\OUI\BIN\SETUP.EXE MISSING AFTER FS_CLONE
  • 26314055 AD:CLEANUP REPORTED ERROR FOR SYS.AD_GRANTS.CLEANUP
  • 26371653 AD.RLNK: Relink makefile error for adadmin_wapper.exe - AutoBuild
  • 26443057 AD: FCET AD_MANUAL_STEP_HISTORY_F1.SQL REQUIRED IN AD.C.DELTA.10

Related Articles

Categories: APPS Blogs

A Guide to Attending Oracle OpenWorld and JavaOne for Free

Shay Shmeltzer - Thu, 2017-09-14 11:32

This title seems like a click bait, but I'll try and show you that this is actually possible. (Especially if you act fast).

A pass to both conferences is not a cheap item, and with training budgets shrinking you might be running into problems getting approval to expense this to your company. But here are a couple of tricks you can use to get free access to OOW/JavaOne. Some would get you a full pass and some will get you into specific areas and sessions.

Full Pass

Be a Speaker

Well we are a bit late to the call for papers at this point, but you might still be able to become a co-speaker if you have a good customer story to tell that shows how you are using the product/technology that a talk is about. Oracle is always looking to feature customer stories in our sessions - it is always better when a customer shares their real live success. Look up the content catalog and locate sessions on products that you are successfully implementing - ping the speaker and they might want to add you as a co-speaker.

Apply for the Oracle Excellence Awards

We are late for getting in this year, but keep an eye for this for next year. Winners get a free pass to OOW. Details here.

JavaOne Special Discount

Right now you can get 50% off your JavaOne ticket price if you use this code DJFS2017. Register here https://www.oracle.com/javaone/register.html

Other Passes

So full pass might be hard to get for free, but you can get in on a big chunk of the action for free using 

The Discoverer pass

A Discoverer pass lets you into the exhibit halls and various keynotes. Getting into the exhibit hall is great if you want to meet product managers and learn about the latest versions (and upcoming versions too). Most of the PMs are going to do shifts at the Oracle Demoground in their product pods - so hang out there and you'll be able to chat with us.

Usually a Discoverer pass is $75 - but since you are reading this blog, you can get one for free - use the code CDFR2017. Register here.

Oracle Code

Want to get into some technical sessions - this year we are bringing Oracle Code back to San Francisco during OOW - and you can get into this part of the conference for free. Reg here:

https://developer.oracle.com/code/sanfrancisco-oct-2017

See you at the conference in a couple of weeks.

 

 

 

Categories: Development

Benefits of Exetuvie Dashboards for Call Centers

Nilesh Jethwa - Thu, 2017-09-14 08:54

Managing a call center is no easy feat, hence, business intelligence tools such as an executive dashboard can be tremendously helpful.

Call center management needs constant attention. Managers should focus on the latest performance metricsand important industry KPIs. Taking these into consideration, arming company executives with a reliable call center dashboard is worth its weight in gold.

Keeping a watchful eye on all the activities of the call center that you’re managing can help you increase overall productivity, and business intelligence tools should will play a major role. Not only will you be able to reduce handling times significantly but also be able to meet the obligations of your service level agreements hassle-free.

With the industry of call centers being one of the most competitive these days, providing clients with the highest level of service is the ultimate goal and you can assure service quality when you have an executive dashboard in your arsenal.

It works by increasing the visibility of real-time metrics that are crucial to your business. With a dashboard app, you can access vital information immediately and address any issues before they become potentially damaging to your company.

In any call center dashboard, there are several performance metrics that you have to pay close attention to and here are some of them:

Read more at http://www.infocaptor.com/dashboard/executive-dashboard-analytics-for-call-centers

The Insurance of Oracle APEX - Can Your Low Code Framework Do This?

Joel Kallman - Thu, 2017-09-14 08:27
Oracle Application Express (APEX) runs wherever the Oracle Database runs.  I've said these words to thousands of customers and partners for the last 15 years.  So why should you care?  Simple.  Peace of mind.

Last evening, Amazon Web Services tweeted the following announcement:

"Use Amazon RDS for Oracle with Oracle APEX versions 5.0.4 & 5.1.2 to build applications within your web browser."

Now, one might think I'm daft for even mentioning AWS on my blog, but I think this presents an opportunity to emphasize two very important points about Oracle APEX:

  1. While I believe that Oracle Cloud is superior for running your Oracle APEX applications, if for some reason you need to not run it on the Oracle Cloud at some later date, you have that choice.
  2. Oracle APEX is not exclusively a cloud-only solution.  You can run it in the Oracle Cloud (my preference), you can run it on AWS, you can use a number of other hosting providers, you can run it with other infrastructure providers, but you can also choose to run it on-premises.  And you can change your mind among these options whenever you wish.  This is very powerful.

Oracle Application Express is a part of every Oracle Database Cloud Service from Oracle, including:

There are other cloud services coming from Oracle later this year which will also include and feature Oracle APEX.

If you think that the Oracle Database is only good for storing data (i.e., a "bit bucket"), you'd be wrong.  If you're unfamiliar with Oracle APEX, please check out this Simple Guide to Oracle APEX.  From bespoke applications in the Oracle Cloud & on-premises to Oracle ERP Cloud PaaS Extensions using Oracle APEX, our customers and partners are really killing it with the Oracle Database and Oracle APEX.


P.S.  Kudos to Amazon for referencing it as Oracle APEX and not Oracle Apex!

Oracle 12c Service Broker for Pivotal Cloud Foundry

Pas Apicella - Thu, 2017-09-14 00:21
The following example is a PCF 2.0 Service Broker written as a Spring Boot application. This is just an example and should be evolved to match a production type setup in terms oracle requirements. This service broker simple creates USERS and assigns then 20M of quota against a known TABLESPACE

It's all documented as follows

https://github.com/papicella/oracle-service-broker




Categories: Fusion Middleware

Deterministic functions and Virtual Columns

Tom Kyte - Wed, 2017-09-13 22:26
It seems that ?DETERMINISTIC? means exactly what I think (or some of the non-oracle sources on the internet) think it does. I expected this script to fail either on the create function, create table or when running the select statements. I would ha...
Categories: DBA Blogs

Join of two tables and want first row of matching records in second table

Tom Kyte - Wed, 2017-09-13 22:26
I have two tables <code>create table g ( a int, d date); with this data in it: insert into g values ( 1, to_date('01/15/2004','mm/dd/yyyy')); insert into g values ( 2, to_date('01/15/2004','mm/dd/yyyy')); insert into g values ( 3, to_dat...
Categories: DBA Blogs

Selecting column dynamically

Tom Kyte - Wed, 2017-09-13 22:26
Is there a way to write a SQL which selects the number of columns based on the data available .. Say i am trying to post the number of lines inserted on a table per hour on a day .. So when i run the select between 03:00-04:00 hr it should give...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator