Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Introduction to Oracle MAF (Mobile Application Framework)

Posted on July 27th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In June 2014, Oracle unveiled Oracle Mobile Application Framework.

Oracle Mobile Application Framework is a hybrid mobile framework that enables developers to rapidly develop single-source applications and deploy to both Apple's iOS and Google's Android platforms.

Features include support for multiple integrated development environments, including Oracle JDeveloper and Eclipse (through Oracle Enterprise Pack for Eclipse); support for multiple development languages, support for Apache Cordova plug-ins; and support for applications developed under Oracle ADF Mobile.

Oracle recommends that new mobile application development be done with the new Oracle Mobile Application Framework. Some Key Highlights Includes:

  • Build Once, Run on Multiple-Platforms
  • Simpler UI development
  • Java, JavaScript, and HTML5-based application development
  • Choice of development tools
  • Offline-capable: SQLite with Encryption
  • Full Access to Native Device Features
  • Modular, Reusable Components

Oracle MAF – Business Benefits

  • Increase mobile development speed
  • Eliminate mobile skills shortage – use existing skill sets
  • Complete solu)on out of the box
  • Extensible

Here is Oracle Mobile Application Framework Architecture [ Adopted from www.Oracle.com ]

Oracle Mobile ApplicationFrameworkArchitecture

Here is YouTube lesson, for More insights.

Additionl Note

Posted in Centrestage, Emerging Technologies, Technical | No Comments »

R12.2 :Modulus Check Validations for Bank Accounts

Posted on July 12th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

The existing bank account number validations for domestic banks only check the length of the bank account number. These validations are performed during the entry and update of bank accounts.With R12.2 the account number validations for United Kingdom are enhanced to include a modulus check alongside the length checks.

  • Modulus checking is the process of validating bank account numbers in conjunction with the Banks Sort Code.
  • A new concurrent program "Load UK Domestic Account Validations Data" has been provided to load modulus validation data files.

Notes The feature can be disabled by using a Cash Management System Profile (CE: Disable Bank Validations).

If you compare , you can understand this way :

Existing validations:
The sort code should have 6 numeric digits
The bank account number should have 6 numeric digits

New Validation:
The combination of Sort Code and Account Number should pass a modulus check.

Modulus check methods are prescribed by VocaLink (BACS technology partner)
Modulus checking ensures sort code and account numbers are compatible before submitting BACS payment instructions.

dgreybarrow BANK ACCOUNT VALIDATION - THE BASICS

A modulus check is an arithmetic check that establishes whether there is a valid link between a given sort code and account number range.

Modulus checking is a vital process within bank account validation for Bacs submissions, ensuring that errors arising during the capturing of data are flagged for the payer's attention to enable them to correct them before they are submitted, thus avoiding costly returned transactions.

So far, There are 3 types of modulus checks that are performed on the UK bank accounts. These are:

  • Mod 10– Standard 10 modulus check
  • Mod 11– Standard 11 modulus check
  • DblAl– Double alternate modulus check.

This feature enhances the existing UK bank account validation model by introducing modulus check validation.

A modulus check will be performed during the creation and modification of the bank accounts and will also be applied on the importing of bank accounts through public APIs.

dgreybarrow HOW THIS WORKS

When the bank accounts are entered, the system will now invoke a new modulus check in addition to the existing length check (8 digits) for validating the UK bank accounts.

The modulus algorithm applied on the bank accounts depend on the bank sort codes and is part of the sort codes published by Vocalink.

dgreybarrowIMPLEMENTATION: UK BANK ACCOUNT VALIDATION

Implemenation Process can be best understood as below:

UK Validation Bank

In order to use the new validation model, customers need to upload the latest modulus weight table file and Sorting & Substitution data file published by Vocalink.

These concurrent programs allow customers to upload the latest version of these files. Vocalink publish updates to these regularly. Customers can register via Vocalink website to be alerted when a new version has been published.

This Consist of 4 steps process

1) Download 2 files from the VocaLink site:

a) Click on Modulus weight table data (.txt valid from 18/11/13)
Save the file : valacdos.txt [ This will be one the parameter ]

b) Click on Sorting code substitution data (.txt 1Kb valid from 13/06/05)
Save the file : scsubtab.txt [ This will be one the parameter ]

2) These two files must be Upload files to server

3) Then Import : From CM super user responsblity submit a program 'Load UK Domestic Account Validations Data’

4) Make sure System Profile Set - CE: Disable Bank Validations set to YES at site level

Posted in Cash Management | No Comments »

Oracle Adapters for Oracle Applications

Posted on July 7th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

The Adapter for Oracle Applications provides comprehensive, bi-directional, multi-modal, synchronous and asynchronous connectivity to the Oracle Applications. The Oracle Applications Adapter provides the necessary infrastructure to integrate Oracle Applications with the rest of your extended enterprise.

Oracle E-Business Suite Adapter(Fig 1) is based on a set of standards such as J2EE Connector Architecture (J2CA), Extensible Markup Language (XML), Web Service Invocation Framework (WSIF), Web Service Inspection Language (WSIL), and Web Service Definition Language (WSDL). The support for standards facilitates interoperability and eliminates vendor lock-in.

Oracle Adapters for Oracle Applications

Please note that Adapter for Oracle Applications is also informally known as Oracle E-Business Suite Adapter.

Oracle E-Business Suite Adapter provides the following features:

  • It leverages the Integration Repository to provide the information from the source of truth on integration.
  • It supports the widest range of integration interface types. They are
    • PL/SQL APIs :Through database level APIs, tables,and views, users can produce or consume either synchronously or asynchronously to Oracle Applications
    • Business Events,
    • Open Interface Tables :Interface tables enable you to insert or update data into Oracle Applications
    • Concurrent Programs :Concurrent programs enable you to move data from interface tables to base tables or execute any application logic.
    • XML Gateway Interfaces :Oracle Applications provides several pre-seeded business object documents (BODs) that follow the Open Applications
      Group (OAG) standard. These out-of-the-box implementations of OAG BODs are tightly integrated with Oracle Applications ’s internal workflows and APIs
    • e-Commerce Gateway Interface :Oracle e-Commerce Gateway provides a common, standards-based approach for Electronic Data Interchange (EDI) integration between Oracle Applications and third party applications.
    • Interface Views :Interface views help you to retrieve data from Oracle Applications using the application tables
  • It generates adapter metadata as WSDL files with JCA extension.
  • It works under the securely configured connection between Oracle E-Business Suite and Oracle Fusion Middleware using just the FND User name and password for authentication.
  • It leverages and supports Oracle User Management function security feature to allow only authorized users to access and execute APIs that they are exposed as Web services to update Oracle E-Business Suit applications.
  • It implicitly takes care of applications context without bothering about the complexities of initiating the same explicitly.
  • It supports multiple languages and multiple organization access control (MOAC) setup.
  • It uses a JDeveloper based design-time tool for dynamically browsing the Oracle E-Business Suite application interfaces and configuring the adapter metadata. The design-time tasks are wizard driven, user-friendly, and intuitive providing superior user experiences.
  • It provides the global transaction control support implementing two-phase commit by leveraging the underlying JCA standards compliant framework.
  • It supports multiple versions of Oracle E-Business Suite from the same instance of Adapter at design time as well as run time.
  • It provides flexfield support for PL/SQL APIs and Open Interface Tables so that flexfield information can be displayed at design time and run time.

Usage Note

Support for various versions of Oracle E-Business Suite has the following conditions:

  • Adapter for Oracle Applications supports only those versions of Oracle E-Business Suite Release 11i which work with OWF.G.Rollup 7 applied.
  • Adapter for Oracle Applications version 10.1.3.3 onwards supports Oracle E-Business Suite Release 12.0.
  • To enable the native Oracle E-Business Suite connectivity using J2EE data sources feature, the minimum requirement for Oracle E-Business Suite Release 11i is 11i.ATG_PF.H.Delta.6 (RUP6) and for Oracle E-Business Suite Release 12 is Release 12.0.4.

Posted in Tool | No Comments »

Page 1 of 11