Java Stored Procedures and SQLJUTL2.INVOKE

BEFORE:


I was having trouble accessing Java Stored Procedures from an Oracle 12c client:

java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00201: identifier 'SQLJUTL2.INVOKE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
    at oracle.jdbc.driver.T4CTTIfun. (more...)

R12.1 Statutory Patch Released for Australia Oracle Payroll

Attention Australia Oracle Payroll customers:  Statutory updates effective from 01-JUL-2015 for Australia legislation have been released in the R12.1 Patch 21238399:R12.PER.B.          

This patch includes:
     • HELP tax scale changes (includes late change)
     • SFSS tax scale changes (includes late change)
     • PAYG Tax table changes (these are no longer changed with update)
     • Senior Australian Tax Rate Changes (these are no longer changed with update)
     • (more...)

Save the date For Oracle OpenWorld 2015

This year Oracle OpenWorld will be held October 25–29, 2015 in San Francisco

Choose from more than 2,500 sessions, tailor your schedule to get exactly the information you need. In addition to sessions, check out hundreds of Oracle partners, Oracle technology demos run by the experts who helped build the products, and get hands-on in labs where we can dig into the details.

Check back soon for more details

View sessions
Register now to receive
(more...)

Modern Marketing Tour, 11 juin 2015. Et si vous passiez au marketing digital agile et rentable ?

Et si vous passiez au marketing digital agile et rentable ?

Une plateforme marketing intégrant les services tout en enrichissant les données clients centralisées fait entrer l’entreprise dans l’ère du marketing digital. Fini les cloisons entre équipes web, email, papier… Une stratégie marketing globale devient possible avec une relation client personnalisée et un ROI rapide.

« Avec l’explosion des données, des réseaux sociaux, de la mobilité… et du permission (more...)

Join the Virtual Cloud Summer Camp!

With Oracle’s Cloud Platform-as-a-Service you will be quickly gaining skills on how to rapidly provision or scale a development and testing environment and on how to develop and collaborate anytime and anywhere by accessing the same environment.

Join the Oracle Cloud Developer Evangelists team and Oracle Experts in a Virtual Cloud Summer Camp engineered for developers.

Register todayhere.

We will be running 5 free webinars that will be covering topics such as how (more...)

Personnalisation et ROI au programme de l’Oracle Marketing Tour

L’expérience utilisateur est essentielle dans la réussite d’un service ou d’un produit. Elle a besoin d’être renouvelée et repensée pour conserver une certaine attraction. Avec les avancées digitales et technologiques, les marketers tendent de plus en plus à revisiter l’expérience client par la personnalisation.


Cependant, tout comme la R&D, expérimenter de nouveaux concepts coûte cher et ne rapporte pas de ROI rapidement. C’est pourquoi on se retrouve généralement dans une situation hiérarchique conflictuelle entre les (more...)

New Oracle eBook: Social Selling

Why is social selling important and valuable to both sales and marketing? Download this new Oracle eBook

Be an Advisor, Not a Sales Person!

60% of buying decisions are made prior to speaking to a sales person. Learn how to achieve bigger and more profitable deals for your organization. Read the article here

Applying a Retail Best Practice to Improve Field Service

How do you design field services to give retail customers everything they want? Applying retail best practices to improve the experience. Read here

BPM 12c Gateways (Part 5 of 5): Event-based Gateway by Antonis Antoniou

clip_image002My last article on gateways is on the event-based gateway, another type of gateway supported by Oracle BPM 12c to provide divergence in processes.
The event-based gateway is very similar, conceptual wise, to the exclusive gateway in the sense that we can have various outgoing sequence flows but only one branch is followed. The operational difference though is that, as its name suggests, the event-based gateway uses events for defining the branching conditions and decisions (more...)

New Knowledge Article: Interactive Reporting 11.1.2.4 with Internet Explorer 11

The following new My Oracle Support (MOS) Knowledge Article is available, that provides information for Oracle BI+ Interactive Reporting (IR) 11.1.2.4 with Microsoft Internet Explorer (IE) 11:

Limited Support for Interactive Reporting 11.1.2.4 in
Internet Explorer 11 by using Enterprise Mode to Emulate IE 10

Doc ID 2015779.1


Additional Information ...

For information on Oracle Support Policy for IE 11 with Enterprise Performance Management (EPM), refer to:

Policy (more...)

New Cloud Control 12.1.0.5 is available

The new version of Oracle's Cloud Control 12c Release 5 is available for download as of today. Some of the new features include Hybrid Cloud Computing but also the support for RMAN incremental rolling forward backups (cross platform, cross Endianness) to decrease downtime for Transportable Tablespaces and Full Transportable Export/Import migrations.

Find it here on OTN:

http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html

Oracle Enterprise Manager Cloud Control 12c Release 5 (12.1.0.5) New!


Enterprise Manager (more...)

Increase predictability with Oracle Field Service Cloud

Who says predictability is boring? To achieve mobile workforce excellence you need to predict and forecast all kinds of service events - the good news is now you can and you can improve CX at the same time!

View & Share the original video »

Ansprechend auf allen Kanälen: Cross-Media-Marketing

Werbung nervt? Techniker und Einkäufer sind allergisch gegen Marketing? Nein! Aktuelle Studien zeigen, dass B2B-Entscheider für gezielte und relevante werbliche Kommunikation heute offener sind, denn je. Auffallend hoch ist dabei das Vertrauen in starke und bekannte Marken. Auf einem zunehmend unübersichtlichen und komplexen Markt stehen diese klar für Orientierung und Qualität.

Allerdings sieht zielführendes Marketing heute ganz anders aus, als noch vor wenigen Jahren. Der Grund: Im Web-Zeitalter ist die Zahl der möglichen Kommunikationswege explosionsartig (more...)

Ansprechend auf allen Kanälen: Cross-Media-Marketing

Werbung nervt? Techniker und Einkäufer sind allergisch gegen Marketing? Nein! Aktuelle Studien zeigen, dass B2B-Entscheider für gezielte und relevante werbliche Kommunikation heute offener sind, denn je. Auffallend hoch ist dabei das Vertrauen in starke und bekannte Marken. Auf einem zunehmend unübersichtlichen und komplexen Markt stehen diese klar für Orientierung und Qualität.

Allerdings sieht zielführendes Marketing heute ganz anders aus, als noch vor wenigen Jahren. Der Grund: Im Web-Zeitalter ist die Zahl der möglichen Kommunikationswege explosionsartig (more...)

Groovy Tuesday: Threshold Errors and Setting Field Values

This article is a quick tip that I discovered whilst writing a script for an unrelated testcase.

When writing integrations you don't not always know how much data you are going to get back from an API. You'll test it of course, and hopefully get some good ideas based on its specification, but we all know if complexity and variation can get in, then they will.

So whilst you should ensure your calls limit the (more...)

New Enterprise Manager Release Allows Customers to Manage Their Hybrid Cloud from a Single Interface

Oracle is today announcing Oracle Enterprise Manager 12c Release 5, which simplifies the journey to the cloud.  For the first time, you will be able to manage your hybrid cloud as one, from a single pane of glass.

According to a recent Computerworld survey, cloud consumers are struggling with security issues, integration headaches and performance concerns in public and hybrid cloud environments.

The latest release of Oracle Enterprise Manager addresses these concerns through new (more...)

New Enterprise Manager Release Allows Customers to Manage Their Hybrid Cloud from a Single Interface

Oracle is today announcing Oracle Enterprise Manager 12c Release 5, which simplifies the journey to the cloud.  For the first time, you will be able to manage your hybrid cloud as one, from a single pane of glass.

According to a recent Computerworld survey, cloud consumers are struggling with security issues, integration headaches and performance concerns in public and hybrid cloud environments.

The latest release of Oracle Enterprise Manager addresses these concerns through new (more...)

Oracle Inventory製品に関するヘルス・チェックを行うInventory アナライザのご紹介

アナライザは、Oracle Inventory製品の設定、マスタ、在庫取引データの不整合を検出し、さらに重要パッチの適用状況をチェックします。
データ不整合の問題は、既知の26個の問題(うち、WIPモジュール関連3個、原価管理モジュール関連2個)を検査し、問題を検出した場合はその対策を提示しま す。

画面: Inventoryアナライザ出力イメージ(抜粋)

Sample


また在庫取引のパフォーマンスに関わる重要なプロファイルの設定状況や、未処理取引(エラー/処理中)のレコード数をカウントします。

在庫取引のトランザクション・データは日々膨大な量が発生します。 そのため、日次で本スクリプトを実行し、在庫取引のトランザクション・データをチェックすることにより、 データ不整合に起因する様々な問題の未然予防を実現します。

本スクリプトでは、HTML形式でレポートを出力します。お使いのデータベースに対し、 デー タの削除、更新、削除は一切行わない安全なスクリプトで す。 また実行時間も数秒で完了するので、シ ステムへの負荷も少ないツー ルです。

以下よりスクリプトをダウンロードできます。
Inventory Analyzer : Health Check For Common Inventory Data Issues, Critical Patches, And Setups (Doc ID 1499475.1)

Decrypt WebLogic Passwords in a Domain

I was trying to connect to a WebLogic data source using SQL Developer when I realized that I do not remember the password for the schema user. Since WebLogic encrypts the passwords it store in the config files, I had to find a way to decrypt them. Here are the commands you can use in WLST to do this and you can use them for any passwords in the domain.

domain = "<path>"
service = (more...)