Subscribe: Blogs.oracle.com Recent Posts (all languages)
http://blogs.oracle.com/readingLists/oracleblogs.xml
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
business suite  business  cloud service  cloud  community  data  oracle business  oracle  partner community  service  soa  suite 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Blogs.oracle.com Recent Posts (all languages)

Oracle Bloggers



Welcome to Oracle Blogs Welcome to the Oracle blogging community!



Last Build Date: Tue, 21 Feb 2017 07:14:51 +0000

Copyright: Copyright 2017
 



A New Wave of Mobile Engagement

Tue, 21 Feb 2017 07:14:51 +0000

Recently, we talked about the ascension of chatbots and how to engage mobile customers in both a timely and personalized, manner.  However, we have yet to address why either of these topics is, and will continue to be, a driving success factor for both enterprises and small businesses. To say that these advancements are a result of living in a Mobile-First world would be only a partial answer.  Mobile phones have been around for decades, and yet only very recently have we started to use chatbots and advanced customer engagement techniques like location targeting in a business setting.  What's changed?  The answer is that the scale and the technology that surrounds the mobile ecosystem have advanced far enough that its now beneficial, and even necessary, to use these new technologies in order to gain a competitive advantage and achieve a positive ROI.  We just published an iPaper that discusses this topic in detail and we encourage you to read it.  A brief abstract of the paper is below: Abstract: By 2021, there will be 10 billion connected mobile devices.  That will be enough for every man, woman, and child on Earth to have at least one. This explosive mobile growth has created a huge demand for mobile services, and developers have created tons of apps to fill these service needs.  As a result, mobile users are now accustomed to accessing services on-demand, from transferring money, to ordering an Uber, to submitting a vacation request through their company's HR app. As the on-demand economy scales, customers expect fast and accurate service from their apps.  If they don't get it, they simply switch to another app.  In this very large, low-entry, hyper-competitive, on-demand market, both small and enterprise-level businesses fight for customer share-of-mind and wallet.  Often, the only way these businesses can remain relevant is to create timely and useful "mobile moments" (real-time, intent-driven interactions that require only a glance—yet deliver information users can consume and take action on immediately), either by providing a user with the quickest and most accurate way to consume information (i.e. responding to a query in-app with a chatbot instead of linking to an answer), or by providing a personalized response based on a user's actions (i.e. using location targeting to create a relevant, engaging offer when a user walks into a store.)  If certain businesses don't use these new mobile technologies to create and capitalize on mobile moments, they risk losing out to competitors who will gladly step in to fill any on-demand service gap. What's made it so easy to compete?  Mobile development, testing, and deployment technology has become more powerful and easier to use.  With low code and even no-code interfaces, these mobile technologies can help companies build, test, and deploy chatbots, codeless apps, or microsites in minutes using nothing but a browser. These mobile platforms also are built with open standards and with API-First development in mind so creating more robust applications and connecting them to system back-ends becomes easy.  In addition, Analytics technology has matured so that businesses now can engage with mobile users on a personal level.  Understanding why customers have gone quiet within an app, targeting them, and re-engaging them with personalized information has allowed SMBs to mine the long tail efficiently and to compete alongside enterprises for additional customer share and profit. Increased competition makes using new mobile technologies even more of a necessity for any business that wants to stay ahead. Download and read this iPaper, follow us @OracleMobile, and to join the conversation on LinkedIn.[...]



Free Oracle SOA Suite 12c & BPM Suite 12c On-demand Training & Free SOA Partner Community

Mon, 20 Feb 2017 16:17:00 +0000

View this message in a Web browser Free Oracle SOA Suite 12c & BPM Suite 12c On-demand Training & Free SOA Partner Community Dear Integration Expert,We would like to invite you to become hands-on trained in the latest versions of Oracle SOA Suite 12c and BPM Suite 12c – free of charge! Community Registration Step 1: Free SOA & BPM Partner Community Registration For regular information, including free trainings and free certifications, become a member in the SOA & BPM Partner Community. Please first login at Oracle Partner Network and then visit SOA Partner Community registration page. If you have any questions, please contact the Oracle Partner Business Center. Within a week we will process your registration and grant you access to our community workspace, including the community training calendar. Step 2: Free SOA Suite 12c & BPM Suite 12c On-demand Trainings As a SOA Partner Community member, you can access our training calendar for the latest free SOA Suite 12c and BPM Suite 12c on-demand trainings: [...]



Workshop in Vancouver - Venue has changed

Mon, 20 Feb 2017 15:18:30 +0000

I arrived well in Canada seeing the longest immigration line ever - but luckily as the immigration process by itself is very efficient it didn't take over an hour.  Vancouver sees to be a very nice city - only the weather could be a bit better I'm looking forward to the "Upgrade / Migrate / Consolidate... [Read More]



Integrating with Oracle Cloud to Streamline Business Processes

Mon, 20 Feb 2017 11:22:31 +0000

Redstone is a Platinum level system integrator and value added reseller focusing on Oracle’s Digital Experience and Cloud solutions. Client Testimonial "The Oracle Cloud has enabled us to better connect many facets of our business and expand our use of technology.  We are now able to seamlessly integrate our web experience management solution with our cloud-based document storage solution.  Additionally, we are able to expand the solution footprint by connecting third-party applications through a RESTful API. We have always utilized Oracle products to improve our customer’s businesses, and now we have modernized our own business with Oracle Cloud.” ​~John Klein, Redstone Content Solutions, United States. Challenges Facing Redstone Maximize productivity and streamline workflow by enabling internal staff, customers and partners to easily and securely sign documents in the cloud through a web interface Empower project teams and sales reps with anywhere/anytime/any device content access to enhance customer and partner collaboration Improve business productivity by enabling web development team to access, store, and host web content in a ‘single source of truth’ repository Benefits Provided by Oracle Cloud ​ Implemented Oracle Documents Cloud, Oracle Sites Cloud, Oracle Process Cloud and Oracle Application Container Cloud in order to maintain compliance and adhere to security regulations Improved business process efficiency with the ability to create web content in Oracle Sites Cloud and storing in Oracle Documents Cloud.  This enhancement has eliminated the risk of duplicate content and prevents incorrect data from being shared with the public via our website. Read the complete case study here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: Redstone,Process Cloud Service,PCS,Cloud,PaaS,SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress[...]



From AngularJS to Oracle JET at DevNexus

Sun, 19 Feb 2017 13:36:49 +0000

I'm going to DevNexus this week. There'll be a NetBeans booth and several NetBeans community members in attendance, drop by and come and chat about NetBeans, Apache, etc!

Also, I'll be talking about Oracle JET:

https://devnexus.com/s/devnexus2017/presentations/17974

I'll take an AngularJS/Ionic application Matt Raible created and talked about recently at Jfokus and I'll show how that application looks and how it is structured when created via Oracle JET. I'll discuss the similarities/differences and advantages/disadvantages. Here's the repo where I am working on this:

https://github.com/GeertjanWielenga/jet-hello-world

So, if you're exploring alternatives to AngularJS/Ionic, come to the session and see the approach you can take with JET to create web or mobile applications. The pic on the left is Matt's AngularJS/Ionic app, on the right is my JET app:

(image)




Process Cloud Service –> Quickstart apps by Niall Commiskey

Sun, 19 Feb 2017 12:43:09 +0000

Nice feature this... As the docs says - Choose a QuickStart App to quickly create an application and learn about Process Cloud Service. QuickStart Apps include all the implementation details needed to play and deploy them. Use these applications as a ready-to-use application to deploy or as a starting point to adapt by making changes such as editing task titles, modifying the web form, or adding new task actions. Read the complete article here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: PCS,Process Cloud Service,Cloud,PaaS,Niall Commiskey,SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress[...]



Process Cloud Service – Web Form Design Approaches by Antonis Antoniou

Sat, 18 Feb 2017 15:00:09 +0000

Oracle Process Cloud Service uses a standards-based technology called "Web Forms" for defining the user interface in business processes. It's based on standards such as XHTML, CSS and JavaScript and allows business analysts and developers to create an end-user interface by just using the browser. There are three approaches that can be employed when designing web forms: Form-First: You can follow a "Form-First" approach where you create the form first before any data elements are defined and you let PCS by just drag and dropping components from the component palette to the page. Oracle PCS will automatically generate the schema that defines the data required by the web form. The schema that is automatically generated by Oracle PCS is based on the web form controls added to the web form and can be located under "Business Types" section. When you assign the web form to a human task activity, the schema generated by Oracle PCS will automatically be used to define the human task data structure. Data-First: A data-first approach implies a bottom-up approach where you create a web form based on data sources or business objects by just drag and dropping the objects on the form to create controls. Oracle Process Cloud Service uses a standards-based technology called "Web Forms" for defining the user interface in business processes. It's based on standards such as XHTML, CSS and JavaScript and allows business analysts and developers to create an end-user interface by just using the browser. There are three approaches that can be employed when designing web forms: Form-First: You can follow a "Form-First" approach where you create the form first before any data elements are defined and you let PCS by just drag and dropping components from the component palette to the page. Read the complete article here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: PCS,Process Cloud Service,Cloud,PaaS,Antonis Antoniou,SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress[...]



Build Your Nest When Picking With New WMS Functionality

Fri, 17 Feb 2017 19:25:03 +0000

For you Warehouse Management Systems (WMS) license plate number (LPN) people, we bet you have some business processes that require material to be stored in nested LPNs. To wit, finished goods would be stored on a pallet, the pallet would contain boxes, and the pallet would be the outermost LPN while the boxes would be the nested LPNs. In the WMS product, prior to 12.2.5, you could only pick from innermost LPN which would require the nested LPN to first be unpacked for the material to be picked from it. That leads us to exciting news! 

In 12.2.5 warehouse pickers now have the flexibility to pick materials packed in multiple levels of LPNs (inner LPNs or the outer parent LPN) for any picking task, if the total quantity inside the nested LPN is within the tolerance limit. The mobile picking page UI can be used to select and load any material packed in multiple levels of LPNs for an independent or bulk task. The LPN list of values in the pick load page will display inner LPNs as well as the outer LPN for each nested LPN hierarchy. There is no change in the allocation logic to pick from the parent LPNs i.e. for LPN allocation modes, the allocation engine will split the task and allocate innermost LPNs only.

Review 12.2.5 Nested LPN Pick - Feature Overview (Doc ID 2205427.1) for more details on this new functionality.

(image)

This is a a great new feature for you warehouse pickers! Check it out and enjoy your nesting.



Oracle Cloud Platform Test Drive March 8th 2017 Oslo Norway

Fri, 17 Feb 2017 12:50:47 +0000

Invitasjon til Hands-On PaaS og IaaS Workshop Oracle og Sysco inviterer til Cloud Test Drive: PaaS og IaaS hands-on workshop. Vi tror på bedre læring ved å prøve ut  tjenestene i praksis, og har plukket ut en knippe tjenester som er relevante innenfor integrasjon, prosess, Java og mobil. Seminaret passer for alle, og kanskje ekstra godt for arkitekter og de på forretningssiden som ønskerå få et godt overblikk. Ingen ekspertise eller erfaring kreves – ta med egen PC. Vi har valgt ut tjenestene Integration Cloud, Process Cloud, Mobile Cloud, Java Cloud og Compute Cloud. Dere vil også få en demonstrasjon av den kommende API Platform Cloud - hvor Oracle har mye spennende på gang etter  oppkjøpet av Apiary. Seminaret er lagt til dagen før OUGN konferansen – vi ønsker å tilby en hel dag til å prøve ut disse tjenestene - og man trenger en rask og stabil internettforbindelse. Dette blir en  perfekt oppladning til konferansen. For details please visit the registration page here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: Cloud Test Drive,Sysco,SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress[...]



Client Certification for Oracle Database 12.1.0.2/12.2.0.1

Fri, 17 Feb 2017 10:39:35 +0000

I've received a question about client certification for Oracle Database 12.2.0.1 the other day.And this reminded me on this very helpful MOS Note: MOS Note: 207303.1Client / Server Interoperability Support Matrix for Different Oracle Versions  It spans the client interoperability back to the... [Read More]



Webcast: "Ready or Not: Applying Secure Configuration to EBS"

Fri, 17 Feb 2017 08:06:00 +0000

(image) Oracle University has a wealth of free webcasts for Oracle E-Business Suite.  If you're looking for our latest updates on the EBS Security front, see:

  • Ready or Not: Applying Secure Configuration to Oracle E-Business Suite (26 minutes)

It's a new world - one where secure configuration is no longer optional and you must reduce your attack surface.  Eric Bing, Senior Director Product Development, shares that going forward, many Oracle E-Business Suite security features will now be turned on by default. To further assist you with deploying Oracle E-Business Suite securely, we are now providing a Secure Configuration Management console.  Under certain conditions, access to Oracle E-Business Suite will be limited until your Applications DBA or System Adminstrator corrects or acknowledges the errors and warnings in the console.  Come to this session to learn about the new Secure Configuration Management console and our guidelines for auditing, monitoring and securing your Oracle E-Business Suite environment and sensitive data. This material was presented at Oracle OpenWorld 2016.




What's New With Oracle Certification - February 2017

Fri, 17 Feb 2017 05:43:51 +0000

Stay up to date with the Oracle Certification Program, view exams released into production, get information on current promotions, and learn about new program announcements below. Exam Updates: Coming soon in production. 1Z0-338 | Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials 1Z0-342 | JD Edwards EnterpriseOne Financial Management 9.2 Implementation Essentials 1Z0-343 | JD Edwards EnterpriseOne Distribution 9.2 Implementation Essentials 1Z0-345 | Oracle Policy Automation Cloud Service 2017 Implementation Essentials 1Z0-347 | Oracle Order Management Cloud 2017 Implementation Essentials View all certifications. Are You Ready to Add Oracle Certification to Your Resume? Oracle Exam Prep Seminars are certification prep tools that guide you through the topics and objectives you can expect to be tested on. See a preview of Java SE 8 Exam Prep Seminars. Java SE 8 Programmer I Java SE 8 Programmer II NEW Oracle Certification Program Online Support Oracle certification program online support has a new look and helps you get the answers to your common certification questions right away. Learn more. Test Your Knowledge In the January/February issue of Oracle Magazine, Inside OCP. Test your knowledge with sample questions you may encounter when taking "Oracle Database 12c: Installation and Administration" (1Z0-062), "Upgrade to Oracle Database 12c" (1Z0-060), or "Oracle Database 12c: Performance Management and Tuning" (1Z0-064) exam. See questions. Upcoming Retirements: May 31, 2017 1Z0-528 | Oracle Database 11g Security Essentials 1Z0-515 | Oracle Database 11g Data Warehousing Essentials 1Z0-529 | Oracle Enterprise Manager 11g Application Quality Management Essentials Explore Oracle Certification today![...]



Comma separated search and search with checkboxes in Oracle APEX

Thu, 16 Feb 2017 22:30:00 +0000

When you have a classic report in Oracle Application Express (APEX) and want to make it searchable you typically add a Text Item in the region, enable Submit on Enter and add a WHERE clause to your SQL statement.Here’s an example:Your SQL statement probably looks like this:select CUSTOMER_ID, CUST_FIRST_NAME, ... [Read More]



IoT Cloud Service Real Time Analytics: From Sensor Data to Business Value by Luc Bors

Thu, 16 Feb 2017 21:13:31 +0000

This session will show you how to use Oracle IoT Cloud Service for Real Time Analytics. You'll learn how to connect devices to the IoT Cloud Service and how to display sensor data from those devices in a web application. You'll also learn how to use the stream explorer analytics capability of IoT Cloud Service to analyze the data that is retrieved from devices connected to Oracle IoT Cloud Service, including how to implement stream exploration and how to add filtering. Finally, you will learn how to publish the analyzed stream and show the results in a web application. Watch the free on-demand training here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: IoT,Internet of Things,Cloud,PaaS,SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress[...]



Delaying Your Move to the Cloud due to Security Concerns? Oracle Database Security Training Can Help!

Thu, 16 Feb 2017 20:35:56 +0000

Are you waiting on moving to the Cloud due to concerns about security? In Oracle's eleven critical cloud predictions to take into 2016, Oracle CIO Mark Sunday says, “Today, the #1 reason organizations are not moving to the cloud is security. However, tomorrow, security will be one of the most important drivers to move to the cloud.” A survey conducted by the Harvard Business Review Analytic Services (sponsored by Oracle) found the following: 62% thought security issues were the biggest barriers to expanding cloud adoption at their companies.  Almost 50% of those surveyed said data security is more difficult in the cloud. The Oracle Security Product Management team has developed a curriculum for database administrators, database developers and security administrators, with both on premises and cloud environments in mind. Oracle University instructors will guide you through terminology, compliance requirements and security features, along with suggested Oracle solutions to combat common security problems. Harness the ability to reduce security challenges by gaining the self-assurance you need to protect your data. Explore Recommended Training in a Variety of Flexible Learning Formats: 1) Introduction to Oracle Database Security This introductory training teaches you how to use Oracle Database features to help meet the security, privacy and compliance requirements of your organization. Develop a deep understanding of the security risks and Oracle solutions provided to help address those risks. 2) Oracle Database Security: Detective Controls Learn how to use Oracle Database administration auditing features to meet the compliance requirements of your organization. The current regulatory environment requires better security at the database level. Develop the skills to audit access to your databases and use the auditing and compliance features to monitor data access and confidentiality. 3) Oracle Database Security: Preventive Controls for Developers Learn how to use Oracle Database application features to meet the security, privacy and compliance requirements of your organization, as the current regulatory environment requires better application security at the database level. You'll learn how to secure access to your database applications, while using database features that enhance data access and confidentiality. Get started today! [...]



Oracle Data Integrator Cloud Service - In the News

Thu, 16 Feb 2017 19:27:03 +0000

Oracle Data Integration recently announced the availability of Oracle Data Integrator Cloud Service (ODICS).  In case you missed the earlier announcement you can check the news out in this entry.  Following the announcement ODICS has received the validation of the data integration market. ODICS brings together disparate data for enterprises to power cloud-based data warehousing and analytics. Below are some of the news coverage about how the market and customers are viewing the latest cloud offering from Oracle. Oracle Data Integrator Cloud launched for data integration Oracle helps customers integrate data in the cloud Oracle expands data integration cloud offerings Oracle connects the data swamps Oracle launches cloud service Oracle Launches Oracle Data Integrator Cloud Oracle Beefs Up IoT Cloud Oracle Launches 4 New IoT Cloud Applications; Also Releases Data Integrator Cloud for Enhanced Data Integration Oracle Launches Data Integrator Cloud Service Oracle rolls out cloud data integration system for real-time analytics New Oracle Cloud Data Solution To Boost Real-Time Analytics Oracle launches new service that can integrate disparate data to drive real-time analytics Oracle is red, violets are blue, we hope you'll integrate biz analytics in our cloud soon Oracle looks to the cloud for easier enterprise data integration Oracle Adds Data Integrator Cloud Service to Cloud Platform Portfolio Oracle Launches Data Integrator Cloud Oracle Fleshes Out Cloud Data Strategy Oracle, Ivanti Announce New Data Integration Cloud Services Oracle Expands Cloud Platform Capabilities Cloud Services Can Boost Productivity, But Are They Safer? Oracle Launches Data Integrator Cloud Service Oracle Launches Data Integrator Cloud For Easier Enterprise Data Wrangling BRIEF-Oracle Corp expands Oracle cloud platform's data integration offerings with launch of Oracle data integrator cloud Oracle launches data integration cloud service [...]



Big Data Lite 4.7.0 is now available on OTN!

Thu, 16 Feb 2017 19:21:54 +0000

The latest release of Big Data Lite is now available on OTN!  This 4.7 release contains key components of Oracle's big data platform.  It has demos, tutorials and more.  Listed below are the products/features that are installed: Oracle Enterprise Linux 6.8 Oracle Database 12c Release 1... [Read More]



Oracle JET at Transfer Solutions (Part 2)

Thu, 16 Feb 2017 15:37:14 +0000

I attended an excellent session about Oracle JET by Lai Ho Yueng and Maresa Bunschoten, from Transfer Solutions in Leerdam in the Netherlands. Transfer Solutions, an Oracle partner, regularly hosts free knowledge sharing sessions. Some time ago, I was invited to talk about Oracle JET (as described here in part 1) and in the meantime developers at Transfer Solutions are using Oracle JET to create mobile and web products for their customers.

Before the break, Maresa did a thorough overview of Oracle JET and all that it provides:

(image)

She started by talking about the difference between web, mobile, and hybrid development and then discussed how Oracle JET covers all of these paradigms from the same codebase. 

After the break, Lai showed an application that makes use of offline features in Oracle JET, based on a real application in production at a client site.

(image)

And it was clear that NetBeans IDE was a handy tool to use for JavaScript development, especially the integration with the Chrome browser, demonstrated by Lai.

(image)

It was a good event, with around 30 attendees. Clearly the message of Oracle JET as a toolkit for mobile and web development is spreading!




Can I Customize EBS on Oracle Cloud?

Thu, 16 Feb 2017 14:40:18 +0000

You can customize your Oracle E-Business Suite environment running on Oracle Cloud in the same way as you are used to doing on-premises. In addition, you can migrate your Oracle E-Business Suite Release 12.2 or 12.1 customizations to Oracle Cloud, whether you are performing a lift and shift either to Oracle Compute Cloud Service only, or to Oracle Compute Cloud Service and Oracle Database Cloud Service. When customizing an Oracle E-Business Suite instance running on Oracle Cloud or on-premises, you must always follow our development guidelines. Be aware that there are differences in the customization standards between Oracle E-Business Suite Release 12.2 and Release 12.1.  For the official guidelines and more information on Release 12.2 customizations, refer to the following documents: Oracle E-Business Suite Release 12.2 Developer's Guide Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1) For the official guidelines and more information on Release 12.1 customizations, refer to the following document: Oracle E-Business Suite Release 12.1 Developer's Guide The Oracle E-Business Suite Development Tools image, available from the Oracle Cloud Marketplace, can be used to provision an Oracle E-Business Suite Release 12.2 or 12.1 development environment in the Oracle Compute Cloud Service. This environment is then available for creating and managing customizations. You may optionally choose to use the Oracle Application Management Suite to manage and apply custom patches to an Oracle E-Business Suite Release 12.2 or Release 12.1 environment running either on-premises and in the Oracle Cloud. Note that the following support implications apply to customizations when running Oracle E-Business Suite either on Oracle Cloud or on-premises: Support Implications for Your EBS Customizations References Getting Started with Oracle E-Business Suite on Oracle Cloud (Note 2066260.1) Oracle E-Business Suite on Oracle Cloud Landing Page Oracle E-Business Suite Learning Subscription Oracle E-Business Suite on Oracle Cloud White Paper Related Articles Getting Started with EBS on Oracle Cloud EBS Deployment Options on Oracle Cloud Using EBS Development Tools in Oracle Compute Cloud EBS Lift and Shift Part 1: From On-Premises to Oracle Compute Cloud EBS Lift and Shift Part 2: From On-Premises to DBCS and Oracle Compute Cloud Managing Oracle E-Business Suite Customizations on Oracle Cloud [...]



The OJVM Patching Saga - and how to solve it - Part V

Thu, 16 Feb 2017 14:06:08 +0000

Related Posts on"The OJVM Patching Saga - and how to solve it": Part I - The OJVM Basics Part II - Important Notes and Information Part III - The Mitigation Patch Part IV - What you may have missed ... [Read More]



Register and Attend! Advisor Webcast to Demystify Payment Terms & Due-Date Calculation Logic in Account Receivables

Thu, 16 Feb 2017 14:00:00 +0000

Are you a user who deal with various aging reports or collections based on the past due invoices? 
If yes, Join us for this one hour Oracle Advisor Webcast.

(image)
Register Now!


Schedule:

  • Tuesday , March 14, 2017 07:00 AM (US Pacific Time)
  • Tuesday , March 14, 2017 10:00 AM (US Eastern Time)
  • Tuesday , March 14, 2017 03:00 PM (Central European Time)
  • Tuesday , March 14, 2017 07:30 PM (India Standard Time)


"Due Date" provides a timeline for follow-up and actions that should be taken at each interval in requesting payment from a sponsor on a specific past due invoice(s). We will disclose the underlying calculation that derives the due date and how the same can be leveraged based on the "Payment Term" setups.

Topics Include:

1. Advantages of accurate Due Date

2. Payment Term - classifications & defaulting hierarchy

3. Cutoff Days concept in R12

4. Due Date derivation logic & influencing factors

5. Identifying Past Due invoices

6. Known issues & recommended solutions

Follow our My Oracle Support Receivables - EBS (MOSC) community.

You can access recorded webcasts on My Oracle Support Knowledge Document:
Oracle E-Business Suite Advisor Webcast (Doc ID 1455369.1)




Oracle Cloud Platform Test Drive March 22nd in Madrid and March 23rd in Barcelona

Thu, 16 Feb 2017 11:26:59 +0000

Evento: Hands-on para explorar los nuevos servicios de Oracle en la nube El Cloud ha llegado para quedarse y sabemos que su departamento de IT escogerá la manera más óptima de acceder a él. Nuestro objetivo es enseñarle cómo combinar las tecnologías on-premise con herramientas nacidas en Cloud, para conseguir una arquitectura híbrida que le proporcione lo mejor de ambos mundos. Por este motivo avanttic y Oracle hemos organizado una sesión práctica, a través de la cual tendrá acceso a varios de los Servicios Cloud del PaaS de Oracle y dónde expertos profesionales le guiarán en esta inmersión en el cloud: definiendo procesos, configurando integraciones y desplegando aplicaciones. Los escenarios propuestos no serán complejos y no se precisa experiencia previa. Utilizando su propio portátil podrá conocer cada servicio y cómo encajan en un ecosistema moderno e híbrido. ¡Le invitamos a disfrutar de esta experiencia o a compartir esta invitación con alguien del equipo de arquitectura o de desarrollo de su organización! Madrid Miércoles, 22 Marzo 2017 Barcelona Jueves, 23 Marzo 2017 For details please visit the registration page here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: Cloud Test Drive,Avanttic,SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress[...]



Training Thursdays: DTrace for Comprehensive Tracing and Diagnostics

Thu, 16 Feb 2017 09:57:31 +0000

DTrace is a comprehensive, advanced tracing tool for troubleshooting systematic problems in real time.  DTrace allows administrators, integrators and developers to dynamically and safely observe live systems for performance issues in both applications and the operating system itself. DTrace is one of the many topics you can learn about in the Oracle Linux advanced administration training. You can take these courses as follows. Oracle Linux 7: Advanced Administration Training-on-Demand: Start training straight away, following lectures at your own pace through streaming video and booking time to get hands-on experience when suits your schedule. Live-Virtual Event: Attend a live event from your own desk, no travel required. Events are added to the schedule to suit different time-zones. Events on the schedule include 20 and 27 March and 24 April 2017 in English and 15 May 2017 in French. In-Class Event: Travel to an education center to attend a class. In-class events on the schedule include:  Location  Date  Delivery Language Brisbane, Australia 20 March 2017 English Sao Paulo, Brazil 8 May 2017 Brazilian Portuguese Hamburg, Germany 27 March 2017 German Munich, Germany 6 March 2017 German Milan, Italy 3 April 2017 Italian Johannesburg, South Africa 6 March 2017 English Miami, FL, United States 24 April 2017 English Belmont, CA, United States 8 May 2017 English Columbus, OH, United States 22 May 2017 English Roseville, MN, United States 22 May 2017 English Oracle Linux 5 & 6 Advanced Administration Training-on-Demand: Start training straight away, at your own pace. Live-Virtual Event: Events on the schedule include 13 March and 24 April 2017. In-Class Event: Travel to an education center to attend a class. In-class events on the schedule include:  Location  Date  Delivery Language Sao Paulo, Brazil 19 June 2017 Brazilian Portuguese Munich, Germany 8 May 2017 German Auckland, New Zealand 27 March 2017 English Pretoria, South Africa 26 June 2017 English Irving, TX, United States 22 May 2017 English Resources: To register for a course or learn more about the Oracle Linux curriculum, go to http://oracle.com/education/linux Using DTrace with Oracle Linux - 18 minute demo DTrace Downloads Oracle Linux Documentation [...]



Reminder: Upgrade Microsoft Vista Before April 2017

Thu, 16 Feb 2017 08:06:00 +0000

(image) Microsoft is ending support for Windows Vista on April 11, 2017.  The official support dates are published here:

Windows Vista is certified for desktop clients accessing the E-Business Suite today.  Our general policy is that we support certified third-party products as long as the third-party vendor supports them.  When the third-party vendor retires a product, we consider that to be an historical certification for EBS.

What can EBS customers expect after April 2017?

After Microsoft desupports Vista in April 2017:

  • Oracle Support will continue to assist, where possible, in investigating issues that involve Windows Vista.
  • Oracle's ability to assist may be limited due to limited access to PCs running Windows Vista.
  • Oracle will continue to provide access to existing EBS patches for Windows Vista.
  • Oracle will provide new EBS patches only for issues that can be reproduced on later operating system configurations that Microsoft is actively supporting (e.g. Windows 7, Windows 10)

What should EBS customers do?

Oracle strongly recommends that E-Business Suite customers upgrade their desktops from Windows Vista to the latest certified equivalents.  As of today, those are Windows 7, 8.1, and 10

Related Articles




Giovanni Jaramillo Gains Confidence With SQL Certification

Wed, 15 Feb 2017 22:24:27 +0000

(image) Oracle Certification gives your more confidence in your knowledge and abilities. Just ask Giovanni Jaramillo!

With nearly 20 years experience  under his belt, Giovanni decided to try out certification. Even with all his experience, he found benefit in earning the certification. Read about his experience in his own words below.

I echo Adrienne's comments.  I have exactly 20yrs experience as an Oracle Developer but only until 3yrs ago did I decide to get a certification.  My first one was the Oracle SQL Expert : OCE (at the time there wasn't the Oracle SQL Associate).  So not only did I dive into the pool, I had no choice but to go into the deep-end with the expert exam.  After studying for 4 months for it, and passing it on my first attempt it really opened my eyes to how much more vast Oracle SQL is and I immediately felt more confident about the rules of SQL.  That confidence built and then the next year I studied again for 4 months and studied "smarter" for the OCA (Oracle Certified PL/SQL Associate) exam.  Both exams were hard (SQL Expert was harder).

Now I have one more to take: OCP : Oracle Certified Professional for Advanced PL/SQL.  Deciding on either the 11g or 12c exam.  But what the certifications have given me is more confidence and also complimentary attributes to my resume, thus allowing me to increase my salary as I am starting to see a few more job postings where it says "Oracle Certification preferred" or "Oracle Certified Professional required".

Share your own story or begin your certification path today! 




10 CLOUD Application Development Trends for the Future

Wed, 15 Feb 2017 21:24:42 +0000

The modern world is about using services on the fly, reusing and focusing on the tasks at hand. For example, If you're starting your own business with a great idea, your focus should be on developing the idea - not on the surrounding operational challenges. Allow the experts to provide you the support services to help you develop the concept. Here are the steps you would take:  First, you would look for infrastructure on lease and pay for the use, interiors and infrastructure based on your needs. You would then decide how the business runs and renew the investment based on returns. The renewal is elastic and can be increased or decreased  Second, you would reuse a common set of rules, platform and policies which are defined benchmarks. This includes parking policies and security policies, instead of reinventing the wheel to build one. Third, you would focus on your idea and reusing available vendor services to grow your idea. Within the software world, we're seeing a similar paradigm shift.   As a developer/organization, your objective is to focus on developing the business idea, task or solution than focusing on operational challenges. There are infrastructure and platform experts who will bring these services, continuously updating and innovating to build a better solution. a) The infrastructure on the storage, compute, database and servers can be procured through the cloud. This is broadly called as IAAS (Infrastructure as a Service). This is elastic usage based on the demand and is scalable for high demands. b) The development tools, integration tools and UI tools can also be automated via the cloud. Java Cloud Service and Integration Cloud services would empower you with the platform required for developing the code. This is broadly called as Platform as a Service. Image courtesy of blog.crmit.com c) The software which caters to the solution (HCM, Finance, GRC, EPM, and more) is key for customers and probably runs on the IAAS and PAAS. This is called Software as Service.  As the developer or consultant, your key focus area is on the SAAS, which are solutions you're developing for the customer to leverage the platform components. Traditionally, the development requires you to set up the server and infrastructure and install the tools to maintain the versions and compatibility. You then get started on the coding and manage the operational and development efficiency. Within the new era of Cloud development, here are 10 trends: 1. The developer will focus on writing code, and the infrastructure and platform will be provided to him default. For example, there will be database as a service and Java as a service available, which is a managed service. 2. The entire code development lifecycle from IDE to versioning to debugging will all be managed via cloud tools. 3. DevOPS will be the preferred platform of delivery. Given that cloud modules have modular releases, agile types of delivery will be the development focal point. 4. Developers need to be multi-skilled and able to develop the application. They need to have a firm grasp of the device, analytics, domain and programming. Reskilling developers on new cloud platforms is now a mandate for the future. 5. The focus will be on enriching the [...]



Free Oracle SOA Suite 12c & BPM Suite 12c On-demand Training & Free SOA Partner Community

Wed, 15 Feb 2017 20:12:20 +0000

View this message in a Web browser Free Oracle SOA Suite 12c & BPM Suite 12c On-demand Training & Free SOA Partner Community Dear Integration Expert,We would like to invite you to become hands-on trained in the latest versions of Oracle SOA Suite 12c and BPM Suite 12c – free of charge! Community Registration Step 1: Free SOA & BPM Partner Community Registration For regular information, including free trainings and free[...]



Release 12.1 Customers: The Affordable Care Act Employer Information Reporting 2016 Phase 2 patch is now available on My Oracle Support!

Wed, 15 Feb 2017 18:00:13 +0000

(image) Oracle EBS Benefits Development is pleased to announce that
Patch 25250989
:R12.BEN.B - ACA 2016 Employer Information Reporting Phase 2
is available for download from My Oracle Support for Release 12.1 customers.

This patch is cumulative so it includes ACA 2016 Reporting Phase I. This latest patch includes changes to accommodate 2016 information return reporting requirements for Release 12.1 customers needing to file their information returns with the IRS using EBS Standard or Advanced Benefits.

For full details on what is delivered in Patch 25250989:R12.BEN.B along with setup and processing instructions, please consult the functional readme Document 2226266.1 - 2016 Employer Shared Responsibility Reporting Under the Affordable Care Act - Phase 2 Patch Functional Readme for Release 12.1 Customers on My Oracle Support.

More information about the Affordable Care Act can found on My Oracle Support in Document 2007993.2 – Information Center: Oracle HRMS (US) – Affordable Care Act (All Application Versions). This page provides information on the Employer Shared Responsibility Provisions and Reporting as well as other Affordable Care Act information by providing links to the following documents on My Oracle Support:

  • Document 2052173.1 - US HCM & Benefits Affordable Care Act High Priority Alert
  • Document 2052175.1 - Oracle EBS US Benefits & HCM Affordable Care Act Mandatory Patches
  • Document 2188907.1 - Oracle Advanced and Standard Benefits Affordable Care Act Setup for Employer Reporting




JET Composite Components XVI - Components in Form Layouts

Wed, 15 Feb 2017 15:43:16 +0000

Introduction A common use for Composite Components is to create enhanced input components that address specialized use cases. A good example of this might be a specialized input component for entering IP Address formats. With this kind of component you would want to be able to use it everywhere that a normal JET input* type could be used. This article discusses the pattern that you can adopt to make this happen. What's the Problem? To illustrate this process I'm going to use an example form from a little application that I'm building. This is a wizard based UI that, guess-what, helps you to create CCAs. Here's an early version of one of the screens: This form uses a classic oj-form-layout to responsively align the fields:
In this screen we can see a couple of version related fields. Right now these are simple oj[...]



SOA & BPM Community Newsletter February 2017

Wed, 15 Feb 2017 11:43:46 +0000

Dear SOA & BPM Partner Community, Oracle acquired Apiary the leading solution for API Design and Governance. Together with Oracle API Cloud Service to secure, consume, monetize and analyze APIs, are a winning solution for the digital economy. During the PaaS Partner Community Forum you will learn more about latest updates on the API Cloud Platform including a hands-on training. In case you can not make it to Split, every months we offer free on-demand Bootcamps for SOA Suite 12c and BPM Suite 12c, for details please visit the community training calendar (membership required). Special thanks to Robert and Phil, they just published the first book on Oracle Integration Cloud Service. You are interested to publish a book, read the authors journey and let us know we are happy to support! For additional Integration books visit our wiki here. Thanks to the community for sharing all the SOA articles: For Each activity for processing batches & Scheduling Orchestration Integrations & Hybrid IT Integration Use Cases Poster & Integration OUGN SIG & Getting the best Oracle API information with Swagger and a pinch of NodeJS & API Management "Cool Apps" by Denver Metro RTD & Complex Composites Simplified & Building OSB 12c releases on resource level using Maven & Service Bus 12c QuickTip: Fix HTTP 403 on calling SOAP/REST Proxy Services. To keep track with all the latest updates of Process Cloud Service make sure to follow the blog from Antonis Antoniou. To get a head start of Process Cloud Service read the introduction post from Andreas Chatziantoniou. Special thanks to Marcel for his article series on Business Activity Monitoring (BAM). BAM is key to show business value to the stakeholder and can be used in SOA Suite and BPM Suite scenarios: Impact of ACM Implementation on BAM & Filtering/grouping in BAM by ‘specific’ metrics & Fool BAM with database hack & Populating BAM using JMS & BAMCommand. Thanks to the community for sharing all the BPM articles: PCS Web Form Tips and Tricks – Part 1 & Actionable Email Templates in Oracle Process Cloud Service by Antonis Antoniou & ADF Autogeneration from Oracle BPM Human Tasks & WfMC Awards submission open for Excellence in Case Management In our last section Architecture & PaaS4SaaS the UX team highlights the extension of HCM SaaS solutions with Application Builder Cloud Service. For a short summery of our key monthly information watch the Fusion Middleware & PaaS Partner Updates on YouTube. The February edition of the PaaSPartner Update contains details about the community conference, developer gateway & code events and the upcoming community webcast about Mobile Cloud Service and Chat Bots on February 28th 2017. See you in Croatia! Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #soaCommunity! My personal goal is to reach 10.000 partner community members, therefore I need your support! Please make sure that you invite your teams to join the SOA & BPM Partner Community and the WebLogic & Developer Partner Community. To read the newsletter please visit http://tinyurl.com/PaaSNewsFebruary2017 ([...]



Webcast: "Planning Your Upgrade to Oracle E-Business Suite 12.2"

Wed, 15 Feb 2017 08:04:00 +0000

(image) Oracle University has a wealth of free webcasts for Oracle E-Business Suite.  If you're looking for help with planning your upgrade to EBS 12.2, see:

Anne Carlson, Senior Director Applications Technology, discusses key upgrade planning considerations, combining lessons learned from customers with practical advice from Oracle’s Development, Consulting, and Support organizations. Understand how to build the business case, identify needed time and resources, prepare business and IT staff for changes, plan for required system changes, create an effective test strategy, and more. This material was presented at Oracle OpenWorld 2016.




node-oracledb Session at DeveloperWeek, San Francisco 2017

Tue, 14 Feb 2017 23:54:38 +0000

I just finished my session on node-oracledb at DeveloperWeek on Pier 27 in sunny, fantastic San Francisco. I'm in my old neighborhood, enjoying a familar view of the Bay Bridge from the speaker room window. There is a big hum around me from sessions and demo booths as developers are networking and learning. If you... [Read More]



SQLcl Commands In SQL Developer

Tue, 14 Feb 2017 20:43:38 +0000

Many of you might not know that most of what you can do in SQcl, can also be done in SQL Developer version 4.2. In fact, it’s the same code that handles running statements/scripts in SQLcl as it is in SQL Developer’s SQL Worksheet. Assuming of course, that you use THIS button. Runs queries through the... [Read More]



FMW SOA Monitoring Module is released. (Supports 11g and 12c)

Tue, 14 Feb 2017 17:32:33 +0000

WLSDM SOA Monitoring, Diagnostics & Report Modules SOA Smart Dashboards Monitoring BPEL Engine (Only 11g) BPEL Engine Dashboard (Historical – Only 11g) Monitoring Composite Performance Monitoring Callback and Invoke Monitoring Composite Faults Monitoring Deployed Composites Trend Summarizing Composite List & Endpoint URIs SOA Notifications and Alarms BPEL Engine Notifications Composite Performance Notifications Callback and Invoke (DLV_MESSAGE) Notifications Composite Faults and Errors Notifications SOA Reports Reporting SOA BPEL Engine Reporting SOA Composite Performance Reporting SOA Callback and Invoke (DLV_MESSAGE) Reporting SOA Composite Faults and Errors Get WLSDM here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: Monitoring,SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress[...]



JET Composite Components XV - Translations

Tue, 14 Feb 2017 15:48:08 +0000

Introduction Once you start to get serious about building truly reusable components, the issue of language support will come to the fore. The JET components that you use within your CCA will of course do the right thing based on the language and locale settings of the application, however, what about your own resources? Background on Translatable Strings in JET In the context of a JET application, an application developer will usually define translatable resources using the following steps: Create a /resources/nls folder under /js Create one subfolder under this nls folder for each supported language / region Define the default bundle with a particular name (e.g. myappstrings) in the /nls folder Define corresponding translated versions of myappstrings in each language subdirectory Configure the requirejs ojL10n plugin to merge the custom bundle (myappstrings) with the built-in JET bundles This is all covered in detail in the documentation. Reading this, however, you might notice two particular issues which have a direct bearing on Composite Components. The configuration of the application bundle merging is done within the main application code (usually main) You can actually only merge one custom bundle into JET Both of these restrictions make it impossible for a Composite Component to magically merge its strings into the default JET bundle for access via oj.Translations.getTranslatedString() and oj.Translations.gerResource(). So what should you do? Steps to Apply Translations to Your Composite Components Defining Your Bundles I'd recommend that you define a single resource bundle file for your Composite component, there would be little need to have more that one. The base bundle in your default language should be placed in a suitable subdirectory of your composite component. To keep things consistent, I'd recommend using /resources/nls as the subdirectory. This /nls directory would then contain further subdirectories for the required language / region combinations. Thus, should your component support english as the base language, along with german and french you might end up with the following folders and files: /js /components /acme-coyote-tracker loader acme-coyote-tracker.json acme-coyote-tracker.html acme-coyote-tracker.css acme-coyote-tracker /resources /images paintedDesert.png /nls acme-coyote-tracker-strings /de acme-coyote-tracker-strings /fr-FR acme-coyote-tracker-strings The actual formatting of the translation bundles will be exactly the same as that shown in the doc for the main application bundles. Referencing Your Resources Once you have the bundles set up, you can still use default JET functionality to do the heavy lifting for you and to load the correct bundle for the current language in use (be that based on the HTML lang setting or oj.Config.setLocale()). In your Composite Component viewModel[...]



NetBeans and Apache (Part 2)

Tue, 14 Feb 2017 11:37:01 +0000

Since the various announcements about NetBeans transitioning to Apache, what's been going on and what's the current status? Before reading on, take a look at the following: James Gosling on NetBeans and Apache NetBeans and Apache (Part 1) NetBeans Apache Incubator Proposal Well, if you're asking "what's been going on?" it simply means you're not part of the discussion, which is a simple step-by-step process to be part of: https://cwiki.apache.org/confluence/display/NETBEANS/How+to+Participate After following the above, you'll be on the NetBeans Apache developer mailing list and be able to follow the process as it happens. Right now, weekly updates are provided on the process. In short, Oracle is going through the process of making sure that the NetBeans repositories that are targeted at being donated to Apache do not contain anything that should not be donated. For example, Oracle cannot donate files that are not Oracle's to donate. The repositories contain code going back 20 years, since NetBeans has existed since 1995/96, and are therefore full of potential accidental reusages of code that may or may not belong to Oracle, e.g., that could be forks of the JDK, for example. All files are being examined for such instances, including missing copyright notices, and similar potentially problematic areas. Which repositories are we talking about? How long will all this take? Scroll to the end of the page here for details: https://cwiki.apache.org/confluence/display/NETBEANS/Apache+Transition The aim is for NetBeans 9 to be released as a top level Apache project together with the release of JDK 9. Prior to that, i.e., in order to move out of the Apache Incubator, there needs to be at least one release of NetBeans done from within the Apache incubator, i.e., NetBeans IDE 8.2.1 or NetBeans IDE 8.3. So, those are tight deadlines we're aiming for, though all sides are clear about what we're targeting and focused on meeting those deadlines. Things are looking good and, speaking for myself, I'm happy that we're going through such a thorough process, since the end result will be clear and comprehensive to everyone involved. And, guess what, the Apache NetBeans community already has a new website in place, clearly a work in process though it's awesome we have it at this stage already, with thanks especially to Chris Lenz from Leipzig who is leading this project: netbeans.apache.org If you're out there and interested in joining in and keeping in touch with the process, go here to get started: https://cwiki.apache.org/confluence/display/NETBEANS/How+to+Participate [...]



Deploying Oracle Service Bus (OSB) Projects with Configuration Files in FlexDeploy by Greg Draheim

Tue, 14 Feb 2017 09:47:51 +0000

OSB Configuration files allow the developer to manage environment specific values during deployment.  FlexDeploy supports the use of these configuration files and extends them to using tokens in the configuration file that will get replaced with configured properties from FlexDeploy.   This way we do not need to generate a customization file for every environment where we are going to deploy the project.  We can have one configuration file that will work across environments. My example is built using JDeveloper and SOA 12.2.1.  I have an OSB project named ValidatePayment that is acting as a proxy service for a SOA service: The ValidateBS when I run locally, refers to localhost: When I deploy this to our shared development environment, I want to replace http://localhost.flexagon:7001/ with http://soalt05.flexagon:7001/.  When I deploy to production, I want the URL to be http://soa.flexagon.com/.  To accomplish this I add a property to my OSB Deploy workflow in FlexDeploy.  First, I will show the full workflow for the OSB deploy.  Since FlexDeploy has smart plugins, the deploy workflow is a simple 1 step process to import the OSB project: Read the complete article here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: OSB,Oracle Service Bus,FlexDeploy,SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress[...]



Updated: Database Partitioning with EBS Whitepaper

Tue, 14 Feb 2017 08:05:00 +0000

Partitioning allows a single database table and its associated indexes to be broken into smaller components depending on the table and choice of index partitioning methods.  This can sometimes improve performance of large EBS databases significantly. Several E-Business Suite modules take advantage of database partitioning right out of the box, and custom partitioning is also possible.

Our Applications Performance Group has just released a major update to their best-practices white paper on EBS database partitioning:

(image)

The new white paper covers:

  • Partitioning fundamentals and references to key partitioning resources
  • Relationship between partitioning and compression
  • Principles for effective partitioning of EBS tables
  • Definitions of seeded vs. custom partitioning
  • Benefits of partitioning
  • Considerations when evaluating partition designs
  • Identifying objects that might be good candidates for partitioning
  • Implementing and testing partitioning
  • And most useful: lots of concrete examples with benchmarks!

Over 90% of this whitepaper has been rewritten, so you should check out this new edition even if you've downloaded an earlier version.

Related Articles




Monday Spotlight: It's About Security - Oracle Exadata SL6

Mon, 13 Feb 2017 20:19:17 +0000

Well, not really.  If you read my co-worker Gurmeet's Blog, you’ll see the Exadata SL6 is one incredible machine.  However, I want to talk about a very important aspect of the Exadata SL6 that I don’t think is getting enough play: its security features. We’ve been fighting the security battle for years now and it has become a booming business estimated at $445 billion in 2016.  You could even say that hackers are the new mafia.  But that’s just the business side of cyberattacks.  There’s also state-sponsored cyberattacks.  It’s really cyberwarfare and it’s playing out every day around the globe with every credit card transaction, every mobile phone call and every social media interaction.  Somewhere, someone is being cyberattacked while you read this.  It’s estimated that it costs the healthcare industry $200,000[1][2] every minute of every day worldwide. Now, I’m not trying to be alarmist.  But we need to talk about this. For decades, we’ve worked hard to protect our data centers by attempting to keep people out.  And that worked for a while. It’s much like the castles and keeps of the middle ages. Build a big, strong wall and keep the bad guys out.  However, much like those castles and keeps, building a strong wall around the data center has failed.  The castles had large doors or gates which had their own vulnerabilities.  So, they built moats. But even then, there were bridges so that the people could get in and out.  For today’s data center, we have layers of firewalls and Web servers.  And just like those bridges and gates, today’s Web servers are the gateways to commerce. Just like the keeps and castles of yesteryear, the strategy of “build a strong wall” has failed. Back then, spies, disguised infiltrators and even “backdoors” did the castles in.  Today, we have IoT and laptops and software bugs.  You can’t protect the perimeter enough when the very devices your people are using are the infiltration mechanisms.  So, we have to protect the entire data center.  There are three areas that need to be addressed or “Pillars of Protection”.  These are people, platform and data.  People are the most obvious risk and also might be the hardest to protect against.  Overly simple passwords and social engineering attacks, as well as spam, make it all too easy to get access to user accounts.  There are mechanisms to protect against this, but I’m going to leave that for another day.  Protecting the platform is critical. Software security vulnerabilities (CVEs) are going to be there.  We’ve seen many of them recently. Dirty COW being a particularly bad one.  So, you are now constantly patching CVEs in your data center.  But there are a few of problems with that. 1.)   You aren’t patching all your severs.  I know this because the vulnerabilities being exploited are more than a year old [...]



Where do you specify the Date Format Mask

Mon, 13 Feb 2017 16:32:00 +0000

When reviewing Oracle APEX applications I often see hardcoded date or timestamp formats.You can define your date formats in multiple places in your application. In your item or column attributes, as part of your code e.g.TO_CHAR(sysdate, ‘DD-MON-YYYY HH24:MI’) or if you want to make it more reusable you might create a... [Read More]



OGG Custom Adapters: How to include a unique identifier for every record in custom adapter?

Mon, 13 Feb 2017 16:07:25 +0000

  1. Add redo attributes to be captured by the primary Oracle extract process, so that there will be additional tokens written in the trail for each captured record.
    a) Add the user token. Now use the actual @GETENV() in extract parameter file to retrieve those desired attributes.Then inject the combination of redo seqno and rba of the actual source record into the trail file.  The redo seqno and rba will be unique for each single source record.  
    Note: In case of RAC source system, one additional attribute: redo thread id, can also be added to achieve uniqueness across all RAC instances.
    b) Add in the mapping specification of each captured table, particularly in the TOKENS clause.  
    Refer to documentation: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_datainteg.htm#GWUAD468,  section 12.13.1 Defining Tokens should help.  
    For eg: TABLE src.table, TOKENS ( redoseq = @GETENV(‘RECORD’, ‘FILESEQNO’), redorba = @GETENV(‘RECORD’, ‘FILERBA’), redothread = @GETENV(‘TRANSACTION’, ‘REDOTHREAD’) );
  2. Once the trail for that table should now contain those extra attributes for each source DML record, the Big Data / Application Adapter component can retrieve it via the op.getToken(userTokenName) API invocation, and the custom implementation can do whatever it wants with it.




JET Composite Components XIV - A Pattern for Multi-view Components using ojModule

Mon, 13 Feb 2017 15:27:21 +0000

Introduction In general, one would expect components to be fairly limited in scope and only have to define a single UI (albeit one that might be reasonably dynamic as discussed in this previous article). However, the occasion may arise where the component needs to be more complex and maybe needs some scoped sub-views. A good example of this might be a wizard-style UI in which you need to encapsulate several distinct "pages" to step though, into a single component. This article outlines an approach you can take to implementing this kind of Composite Component by leveraging the capabilities of JET modules (ojModule). I would emphasize that this approach is only needed when your sub-views within the Composite Component all need their own viewModels. If all you want to do is define a number of views all based off of the Component viewModel then you can stick to Knockout templates to switch the UI. What's The Problem? For this scenario I want to package up the module views and viewModels as part of the Composite Component. So for example I might have the following file structure: /js /components /ccdemo-wizard loader ccdemo-wizard ccdemo-wizard.css ccdemo-wizard.json ccdemo-wizard.html /modules /views ccdemo-wizard-page1.html ccdemo-wizard-page2.html ccdemo-wizard-page3.html /viewModels ccdemo-wizard-page1 ccdemo-wizard-page2 ccdemo-wizard-page3 Normally when using ojModule, the location of the views and viewModels for a named module are global to the application and defined by convention as /js/views and /js/viewModels respectively. Now obviously, a particular Composite Component cannot go around changing the default load locations for modules, that would possibly break the consuming application. So we need to find a way to direct ojModule to load each wizard page from within the Composite Component folder structure. As well as that requirement, we need to ensure that the life-span of each viewModel that makes up the wizard pages matches that of the Composite Component as a whole and that we can successfully use multiple instances of the component concurrently without running into problems. The Approach The approach I'm recommending here fulfills all of these requirements by taking advantage of the viewModelFactory capability of ojModule. The use of a factory to create the viewModel for a particular module is then coupled with a facility, also supported by ojModule, for a modules viewModel to expose a method to generate or otherwise obtain the view portion dynamically. Using these two capabilities together we can load the view and viewModels we want to use from anywhere, including within the Composite folder structure. Let's step through th[...]



Converting ADLs to implement end to end JSON in SOA Suite 12.2.1 -PART I by Luis Augusto Weir

Mon, 13 Feb 2017 14:56:36 +0000

There is no doubt that web [Rest] APIs have become extremely popular and its usage has gone well beyond just building APIs in support of mobile apps. We can see the adoption of resource-oriented architectures (ROA) by probably all SaaS vendors who provide out-of-the-box APIs as the means to connect and interact with their cloud applications. Take for example the Oracle Cloud. To discover and consume publicly available Oracle SaaS APIs, all one need to do is browse the Oracle API Catalog Cloud Service (which is publicly accessible) and just select the Swagger definition for any given API. But (as you probably already know) the adoption of web APIs hasn't stopped there.  With the increased popularity of Microservice Architectures , initiatives such as Open Legacy ,  and node based frameworks like loopback and sails (to name a few), API-enabling system of records is becoming a lot easier. This is putting a lot of pressure in software vendors to quickly modernise their integration suites to natively support the technology-stacks and patterns prevalent in these type of architectures. For example, if an organisations mobile application needs to interact with a system of record (on premise or the cloud) that already exposes a web API, the integration stack should be capable of supporting JSON over HTTP end-to-end without having to convert to XML back and forth. Not only is this impractical but introduces more processing burden to the core stack... Luckily for many Oracle's customers and Oracle Fusion Middleware / Oracle PaaS practitioners like myself, with the latest release of Oracle SOA Suite (12.2.1) , one of the many new features introduced is the support for handing JSON end-to-end.  I don't want to understate the importance of this as with such feature it is possible to use BPEL for example to orchestrate several APIs (all in native JSON and also in-memory with the new SOA in-memory feature) and therefore deliver coarse grained business APIs that actually perform. For me this represents an important milestone for Oracle SOA Suite as it shows the departure from traditional SOA tech-stack and into SOA 2.0 (as I like to call it) as the suite is now better suited to support the adoption of ROA, microservices, IoT, and so on. Having worked with SOA Suite since 10.1.3.1 this is very exiting. Read the complete article here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: SOA Suite 12c,Luis Weir,JSON,ADLs,SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress[...]



Introducing Oracle Data Integrator Cloud Service (ODICS)!

Mon, 13 Feb 2017 13:21:31 +0000

We are pleased to announce and welcome Oracle Data Integrator Cloud Service (ODICS)!  Read the press release:  Oracle Launches Cloud Service to Help Organizations Integrate Disparate Data and Drive Real-Time Analytics. Overview Oracle Data Integrator Cloud Service (ODICS) delivers high-performance data movement and transformation capabilities with its open and integrated E-LT architecture and extended support for Cloud and Big Data solutions. Oracle Data Integrator Cloud Service provides all of the functionality included in Oracle Data Integrator Enterprise Edition in a single heterogeneous Cloud Service integrated with the Oracle Public Cloud. Providing an easy-to-use user interface combined with a rich extensibility framework, Oracle Data Integrator Cloud Service improves productivity, reduces development costs and lowers total cost of ownership among data-centric architectures. Oracle Data Integrator Cloud Service is fully integrated with Oracle Platform as a Service (PaaS) offerings such Oracle Database Cloud Service, Oracle Database Exadata Cloud Service and/or Oracle Big Data Cloud Service to put data and value at the center of the enterprise. Oracle Data Integrator Cloud Service is open and standards-based such that it can work with 3rd party systems as well as Oracle’s solutions. Cloud E-LT Architecture for High Performance Oracle Data Integrator Cloud Service's E-LT architecture leverages disparate relational database management systems (RDBMS) or Big Data engines to process and transform the data. This approach optimizes performance and scalability and lowers overall solution costs. Instead of relying on a separate, conventional ETL transformation server, Oracle Data Integrator Cloud Service’s E-LT architecture generates native code for disparate RDBMS or big data engines (SQL, HiveQL, or bulk loader scripts, for example). The E-LT architecture extracts data from the disparate sources, loads it into a target, and executes transformations using the power of the database or Hadoop. By leveraging existing databases and big data infrastructures, Oracle Data Integrator Cloud Service provides unparalleled efficiency and lower cost of ownership. By reducing network traffic and transforming data in the server containing the target data, the E-LT architecture delivers the highest possible performance for Cloud environments. Heterogeneous Cloud Support Oracle Data Integrator Cloud Service provides heterogeneous support for 3rd party platforms, data-sources, data warehousing appliances and Big Data systems. While Oracle Data Integrator Cloud Service leverages optimizations for Oracle Database and Big Data Cloud Services to perform E-LT data movement, transformation, data quality and standardization operations, Oracle Data Integrator Cloud Service is fully optimized for mixed technologies including: sources,[...]



Oracle Database 12.2 for Exadata/SuperCluster available

Mon, 13 Feb 2017 09:28:22 +0000

Oracle Database 12.2.0.1 on-premises for Exadata and SuperCluster is now available for download from Oracle eDelivery/SoftwareCloud. Connect to eDelivery and login: Search for: "Oracle Database" and mark "Oracle Database Enterprise Edition ..." . Click on "Select... [Read More]



Webcast: "EBS Technology: Latest Features and Roadmap"

Mon, 13 Feb 2017 08:06:00 +0000

(image) Oracle University has a wealth of free webcasts for Oracle E-Business Suite.  If you're looking for a summary of  recent updates from the Applications Technology Group, see:

Lisa Parekh, Vice President Technology Integration, provides an overview of Oracle’s recent advances and product strategy for Oracle E-Business Suite technology. This is the cornerstone session for Oracle E-Business Suite technology. Come hear how you can get the most out of Oracle E-Business Suite by taking advantage of the latest user interface updates and mobile applications.  Learn about systems administration and configuration management tools for running Oracle E-Business Suite on-premises or in the cloud, and hear how the latest technologies can be used with Oracle E-Business Suite to improve performance, security, and ease of integration for your system. This material was presented at Oracle OpenWorld 2016.




Converting ADLs to implement end to end JSON in SOA Suite 12.2.1 -PART I by Luis Augusto Weir

Sun, 12 Feb 2017 11:40:37 +0000

There is no doubt that web [Rest] APIs have become extremely popular and its usage has gone well beyond just building APIs in support of mobile apps. We can see the adoption of resource-oriented architectures (ROA) by probably all SaaS vendors who provide out-of-the-box APIs as the means to connect and interact with their cloud applications. Take for example the Oracle Cloud. To discover and consume publicly available Oracle SaaS APIs, all one need to do is browse the Oracle API Catalog Cloud Service (which is publicly accessible) and just select the Swagger definition for any given API. But (as you probably already know) the adoption of web APIs hasn't stopped there.  With the increased popularity of Microservice Architectures , initiatives such as Open Legacy ,  and node based frameworks like loopback and sails (to name a few), API-enabling system of records is becoming a lot easier. This is putting a lot of pressure in software vendors to quickly modernise their integration suites to natively support the technology-stacks and patterns prevalent in these type of architectures. For example, if an organisations mobile application needs to interact with a system of record (on premise or the cloud) that already exposes a web API, the integration stack should be capable of supporting JSON over HTTP end-to-end without having to convert to XML back and forth. Not only is this impractical but introduces more processing burden to the core stack... Luckily for many Oracle's customers and Oracle Fusion Middleware / Oracle PaaS practitioners like myself, with the latest release of Oracle SOA Suite (12.2.1) , one of the many new features introduced is the support for handing JSON end-to-end.  I don't want to understate the importance of this as with such feature it is possible to use BPEL for example to orchestrate several APIs (all in native JSON and also in-memory with the new SOA in-memory feature) and therefore deliver coarse grained business APIs that actually perform. For me this represents an important milestone for Oracle SOA Suite as it shows the departure from traditional SOA tech-stack and into SOA 2.0 (as I like to call it) as the suite is now better suited to support the adoption of ROA, microservices, IoT, and so on. Having worked with SOA Suite since 10.1.3.1 this is very exiting. Read the complete article here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: SOA Suite 12c,Luis Weir,JSON,ADLs,SOA Community,Oracle SOA,Ora[...]



How Dev/Test in the cloud is accelerating delivery of Oracle Middleware projects by Matt Wright

Sat, 11 Feb 2017 18:47:34 +0000

The source of competitive advantage and value that an organization delivers to its end customers is increasingly defined by the software “systems” that underpin them. As a result, organizations find themselves in a digital race, where the speed at which IT can reliably deliver new features and innovations is what sets them apart from their competition. In an industrial company, avoid software at your own peril . . . a software company could disintermediate GE someday, and we’re better off being paranoid about that.” Jeff Immelt, CEO, General Electric These innovations are seldom delivered by pre-packaged business applications, whether running on-premise or delivered as Software as a Service (SaaS), but by custom solutions derived in-house. Yet, most organizations have neither the time nor funds to build these systems of innovation from the ground up. Instead, they are delivered by layering new capabilities on top of existing applications, an approach defined by Gartner as “Pace-Layered”. Oracle Middleware, such as the Oracle BPM Suite and Oracle SOA Suite provides the application glue to rapidly and continually combine these business apps, like puzzle pieces, into a custom integrated solution in order to deliver a seamless and unified experience to the customer. Yet even with this Pace-Layered approach, many IT projects are still failing to deliver either on-time or on-budget, with development teams often held back by their own IT organization. So how can you reduce the cost of the software you develop and decrease the time it takes to get it right? Research shows moving development to the cloud can initially reduce development time by an order of 11 to 20 percent. Organizations that fully embrace the cloud for Dev and Test are experiencing 30%+ time savings upon maturing their DevOps capabilities. Read the complete article here. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: Dev Test,Matt Wright,SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress[...]



Big Data SQL Quick Start. Machine Learning and Big Data SQL – Part 19

Sat, 11 Feb 2017 03:04:05 +0000

It's very frequent case when somebody talks about Big Data he or she also wants to know how to apply Machine Learning algorithms over this data sets. Oracle Big Data SQL provides the easy and seamless way to do this. Secret of this in Oracle Advanced Analytics (OAA) option, which has been existing for many... [Read More]



Big Data SQL Quick Start. Oracle Text Integration – Part 18

Sat, 11 Feb 2017 01:45:33 +0000

Today, we’ll focus on the integration of Oracle Text, the Full-Text Indexing capabilities from the Oracle database with documents residing on HDFS. Oracle Text has been available since years and has evolved to address today’s needs regarding indexing: 150+ document formats supported... [Read More]