Feed aggregator

Oracle EMEA Infrastructure & IaaS Partner Community Forum 25th-26th April 2017

The 2017 Oracle EMEA Infrastructure & IaaS Partner Community Forum will be  taking  place on 25th and 26th April in Malaga, Spain. Come learn and share your experiences to extend IT...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Building Custom EBS Mobile Apps with REST

Steven Chan - Wed, 2017-03-15 02:04

EBS Approval mobile app screenshotOver 20 EBS mobile apps are available today for E-Business Suite 12.1 and 12.2.  These apps are available for iOS and Android and cover functional areas such as Approvals, Expenses, Timecards, iProcurement, Sales Orders, Inventory, and much more.  These apps are documented here:

What's New

Our mobile apps have just gone through a refresh cycle (a.k.a. "Release 6.1") along with updates to all of the server-side libraries.  These updates are transparent to end-users and backwards-compatible with previous mobile app releases (e.g. "Release 6.0"). 

The latest versions of all of these apps use APIs that are documented in our Oracle Integration Repository.  These APIs are newly-published as REST services.  This means that you can now use these APIs to build your own custom mobile apps for EBS.

New guidelines for building your own mobile apps for the E-Business Suite are published here:

 

Categories: APPS Blogs

Building Custom EBS Mobile Apps with REST

Steven Chan - Wed, 2017-03-15 02:04

EBS Approval mobile app screenshotOver 20 EBS mobile apps are available today for E-Business Suite 12.1 and 12.2.  These apps are available for iOS and Android and cover functional areas such as Approvals, Expenses, Timecards, iProcurement, Sales Orders, Inventory, and much more.  These apps are documented here:

What's New

Our mobile apps have just gone through a refresh cycle (a.k.a. "Release 6.1") along with updates to all of the server-side libraries.  These updates are transparent to end-users and backwards-compatible with previous mobile app releases (e.g. "Release 6.0"). 

The latest versions of all of these apps use APIs that are documented in our Oracle Integration Repository.  These APIs are newly-published as REST services.  This means that you can now use these APIs to build your own custom mobile apps for EBS.

New guidelines for building your own mobile apps for the E-Business Suite are published here:


Categories: APPS Blogs

12.2 Moving Tables Online (Real Cool World)

Richard Foote - Wed, 2017-03-15 01:41
One of the really cool new features introduced in Oracle Database 12c Release 2 is the capability to MOVE tables ONLINE, while maintaining all the associated index structures. This was possible for table partitions in Oracle Database 12c Release 1 but only for Indexed Organized Tables before then. Rather than show a demo that just moves a table, […]
Categories: DBA Blogs

Best Way to Write SQL in Java

Gerger Consulting - Wed, 2017-03-15 01:17

Many of us struggle writing SQL in Java. ORM tools such as Hibernate often generate SQL statements that result in poor application performance. Surely, there must be a better way to write SQL in Java.



Attend the free webinar by Java Champion Lukas Eder to learn the best way to write SQL in Java. Find out how you can use SQL as a type safe domain specific language in Java.

Sign up for the free webinar.

Categories: Development

Iceland, Iceland, Baby

Scott Spendolini - Tue, 2017-03-14 18:37

Alright, stop!  Collaborate and listen!  Ok, I’ll be the one to take my own advice here and stop...

Later this month, I’ll be heading to Reykjavík, Iceland to deliver our 3-day training class “Developing Desktop APEX Applications”.  This class will be open to the public and costs about $2500 per student, so anyone is welcome to sign up. You’ll have to make your way to Iceland, of course.

Miracle logo1

Here’s a brief overview of what we’re going to cover:

This 3-day course is an introduction to developing web applications using Oracle Application Express, or simply APEX. The course starts out with an overview of data model of the application that student will build. It then transitions to the SQL Workshop portion of APEX, where basic database object management concepts are addressed.

The bulk of the remainder of the class focuses on building an APEX application, starting with the core components that make up the foundation of the application. Students will then build several forms and reports, which allow user interaction with the data. Next, additional types of forms and reports will be introduced, as well as more advanced techniques used when managing them. The course will conclude with a review of the basic security attributes of an application as well as how to prepare and deploy it to a production environment.

The course will run from March 28th through March 30th, and will be held in a location TBD in Reykjavík. More details, as well as the course outline and a link to register can be found on Miracle’s site here: http://miracle.is/en/building-apex-applications/

Advanced Compression Options in Oracle 11g

Tom Kyte - Tue, 2017-03-14 17:26
Hi Chris/Connor, Can you please share any document on Advanced Compression Options in Oracle 11g. I have searching on this and getting only theoretical stuffs. Could you please share any reference, blog to study on this to understand its use on OL...
Categories: DBA Blogs

Umlaut characters converted to junk while running PL/SQL script

Tom Kyte - Tue, 2017-03-14 17:26
Hi, I have procedure with umlaut characters in it. Below is the sample. CREATE OR REPLACE PROCEDURE procPrintHelloWorld IS BEGIN DBMS_OUTPUT.PUT_LINE('? a A, O, U, a, o Hello World!'); END; / When procedure is created through sql ...
Categories: DBA Blogs

Expdp and impdp

Tom Kyte - Tue, 2017-03-14 17:26
I have a requirement to export a full database using EXPDP and import only three schemas using remap_schemas to a different schema than the original. How can I achieve that?
Categories: DBA Blogs

Clarification of "snapshot too old" error message

Tom Kyte - Tue, 2017-03-14 17:26
Hi, I was going through Tom's book and came across "snapshot too old" section. In the section small undo tablespace is created and below block is run. Below block generates error message "snapshot too old". As per my understanding,the column values...
Categories: DBA Blogs

Web Service

Tom Kyte - Tue, 2017-03-14 17:26
A client of mine asked me posted one or more plsql functions as webservice. Which oracle tool should I use? Thanks from Italy Hi Connor, "posted" is a mistake. They want to access them via web service. Sorry for my poor english. Mass...
Categories: DBA Blogs

Reclaim the free space by truncate/Drop partition from partition table having LOB column

Tom Kyte - Tue, 2017-03-14 17:26
Hi Team, I have one partition table having almost 300GB data with LOB column which contains the 90-95% data of total table size. Partition table having 130 partition created and out of it currently 20 partition having the data. Partition table hav...
Categories: DBA Blogs

db_link and synonym

Tom Kyte - Tue, 2017-03-14 17:26
Hi Tom, I have two databases <b>wombat</b> and <b>foo</b>. Womabt has two users craig and denver. I have created a private db_link with the same name in each users of <b>wombat</b> to connect to <b>foo</b> as follows : owner DB_LINK ------ ...
Categories: DBA Blogs

ORA-12547: TNS: lost contact error in ORacle Linux 7.x

Tom Kyte - Tue, 2017-03-14 17:26
Hi, I am running Virtualbox in Mac OS (sierra) . In VB, i have installed Oracle LInux 7.x as guest OS. In guest OS i am trying to install Oracle 12c. After installing the software, I try to create a database using the dbca command. On running ...
Categories: DBA Blogs

Redo log, why minimum of 2

Tom Kyte - Tue, 2017-03-14 17:26
Hi Tom, Please let me clear that why the mini redo log groups is 2?/ Regards, Gyan
Categories: DBA Blogs

UTL_FILE FRENAME between 2 mounted directories

Tom Kyte - Tue, 2017-03-14 17:26
My question has been asked already at https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9533980100346684832 Anyway I cannot understand why I can create in that directory a file using FOPEN, why I can copy it, why I can remove it ...
Categories: DBA Blogs

Default Password Hashes for 11g Oracle Database

Pete Finnigan - Tue, 2017-03-14 17:26
I often get Oracle Security related questions from people randomly sent to my inbox or occasionally on Social media and less on on this sites forum. I get questions on average probably 4 times per week in these ways. I....[Read More]

Posted by Pete On 14/03/17 At 06:16 PM

Categories: Security Blogs

Taste of KScope 2017 Webinars

Scott Spendolini - Tue, 2017-03-14 17:05

This Thursday, I’ll be participating in the Taste of KScope 2017 webinar series by presenting GET POST ORDS JSON: Web Services for APEX Decoded.  The webinar will begin at noon EDT on Thursday, March 16th.  The webinar is completely free, and you don’t need to be an ODTUG member to attend.

Here’s a summary of the abstract:

Web Services in the APEX world are becoming more and more popular.  However, there is still a lot of confusion as to what they are and how they could benefit the APEX developer.  After a review of the syntax and jargon associated with web services, this session will review and boil down web services to their basic components.  It will then demonstrate how APEX developers can start to use these powerful components - both to send and receive data from other sites.  

Not only will I be presenting this session at KScope later this year, but I’ve also done it a few times already, so most of the kinks are (hopefully) worked out.

You can register for the webinar here: https://attendee.gotowebinar.com/register/2300788935263147265

It's A Matter Of Perspective

Floyd Teter - Tue, 2017-03-14 14:09
So I suppose that if I'm going to blow the trumpet and announce the resurrection of this blog, I'd better write something meaningful...

I'm in Northern California at Oracle HQ this week. It's always fun to observe what's happening here in Silicon Valley.  For example, I can see the tech market is still good...lots of employment ads on billboards between the San Jose and San Francisco airports.  And the highly-publicized drought is clearly broken:  the area is as green as I've ever seen it.

I will say that I've also seen some divergent behavior in response to the breaking of the drought.  On one hand, I see lots of recently-installed xeriscape landscaping.  But on the other hand, I also see a bunch of recently repaired lawn grass - with lawn sprinklers watering every day.  I guess whether you're adapting with new water-wise landscaping or salvaging your lawn depends on your perspective.  Are drought-like conditions the new norm or is the weather in Northern California returning to normal after a long anomaly of dry weather?  I suppose it's all a matter of your perspective.

I see the same type of divergent behavior among SaaS customers.

Some customers see SaaS as driving a new business norm.  They embrace the trade-off of increasing simplicity to lower operational costs with the reduction in flexibility through business process customization.  Those customers see that they get more value from SaaS by accepting less flexibility in customizing the way they do business.

Other customers seem to simply look at SaaS as the latest trend to arrive in the enterprise tech world.  They're willing to have a vendor host their technology platform, but still want the flexibility to customize the software in order to make it fit their existing business processes.

It's possible for either type of customer to get what they want.  I'll maintain that the former type gets more value from SaaS than the latter.  But, in the end, I suppose the choice of adapting to the new norm or attempting to salvage what you had before really depends on your perspective.

Significant Improvement for WebLogic Start-Up Time on macOS Sierra

Andrejus Baranovski - Tue, 2017-03-14 11:59
I have faced really slow WebLogic start-up times after upgrade to recent versions of macOS Sierra. It turns out to be common problem related to JVM start-up on macOS systems, nothing to do with WebLogic itself. Solution is to register mapping between 127.0.0.1 and your computer name in hosts file, read more on Stack Overflow - Jvm takes a long time to resolve ip-address for localhost. This issue seems to appear with newer JVMs.

Originally WebLogic was starting up in 157 seconds:


After config was applied in hosts file, start-up time improved a lot, it is 24 seconds now:


Changes in hosts file - 127.0.0.1 was mapped with my computer name, along with localhost. Same applies for ::1 mapping:


You can get computer name in System Preferences -> Sharing:


Hope this hint will be useful for those developers, who are working on macOS.

Pages

Subscribe to Oracle FAQ aggregator