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

R12 : Cash Management & SLA

Posted on May 22nd, 2008 by Sanjit Anand ||Email This Post Email This Post

dgreybarrow-2What two program responsible for creating events in R12 CM

They are

  • bank account transfers
  • bank statement cash flows

Once events created and the accounting program is run, the journal entry setup and the accounting configurations are referenced to produce journal entries. The journal entries are then transferred to GL which had visibility upto source transactions. This way CM user can drill down from the transaction level to the journal entry details.


dgreybarrow-2How it is differ from R11i

In 11i release Cash Management produced journal entries for bank statement activity based on simple rules and sent them to the GL interface

dgreybarrow-2A bit on Bank account transfers

For those who are new to R12, should note The bank account transfer functionality of R12 is one in which you can take action on the projected closing balances calculated by the system. This is integrated with the Payments application that allows you to send payment instructions to the bank in a variety of payment formats.

Posted in Cash Management, Release12 | 2 Comments »

R12 :Bank Statement Reconciliation

Posted on May 22nd, 2008 by Sanjit Anand ||Email This Post Email This Post

We already aware for changes for new Bank Account Model feature of R12.

Lets investigate how bank model drive some changes in Bank statement Reconciliation.

1….R12, Bank Transaction Codes is linked to multiple sources.

In 11i each bank transaction code had to be linked to a single source, such as Accounts Payable. This could create an issue if the bank was using the same transaction code to report back a payment that was initiated from an application other than Accounts Payable. With this enhanced changes link with bank transaction code to sources can easily manage and this way you can assign a priority number which can be used in the auto reconciliation for sequencing.

2..Another feature is Reconciliation tolerances.This R12 feature is moved from the system level to the bank account level. This moves simply means that each bank account can manage unique set or reconciliation tolerances. The options for setting tolerance is still distinct for at both manual and auto reconciliation. You should also note auto reconciliation tolerances is unique with sources, that mean each source like AP,.AR,CM, and Open Interface can have there own level.

3… Most important,now it is possible to use the same bank account, created in the centralized model, in multiple organizations, the bank statement reconciliation can also done across Operating Units.

dgreybarrow-2Underline Setup

Most of setup is now attached at Bank level which includes your Transaction codes. There is provision to manage and assign transaction code to multiple transaction sources.

Another changes you can see in R12 accounts Control in which you can easily manage reconciliation control parameters.


Post of your Intrest

Posted in Cash Management, Release12 | No Comments »

News: Citibank Japan and Oracle cash management solutions

Posted on May 21st, 2008 by Sanjit Anand ||Email This Post Email This Post

This is not Oracle acquisition news, rather yet another Big news this morning locally in Singapore for partnership with global bank Citibank Japan and Oracle for enhancing the Oracle Global Cash Management System,that provide a integrated solution for managing Cash Management for global manufacturing operations, retail, transportation, financial services sector of Japanese clients.

“Oracle Global Cash Management System” is SOA based product of Oracle Japan used for managing group corporate finance, fund management and financial risk management, financial transaction management function.

Some of the important Fund management features that product offers are : centralized group of companies in the financial management of pooling funds, payments to suppliers to pay a centralized agency, balances between group companies to make the difference between the settlement and netting capabilities.

“Oracle Global Cash Management System” available for local clients since October 1, 2007 with price tag 15 million yen for 4-user license,supported with most of available platforms(AIX, Solaris, HP-UX, RedHat Linux, Windows).

read this entire story

As need for banking Integration is greatly felt in corporate world, and Lets hope, this might bring some more banking functionality in next releases of Oracle EBS ..what you say…

Posted in Cash Management, News, Oracle Treasury | No Comments »

XML based statement for Cash Management

Posted on May 21st, 2008 by Sanjit Anand ||Email This Post Email This Post

One of reader from Mid-east region asked one question “does Oracle support XML based Bank statement?”

It was/is really a new area , just brought attention this afternoon and I did manage to run through Oracle user guide as well as some of the release note of 11i Financial Family pack D(ce minipack H).

What I understood from Oracle Documentation is ..If your bank delivers previous day account statements in the IFX XML format, you can manage the XML bank statement by setting up Oracle XML Gateway to receive and process these bank statements using a secure internet connection.

Oracle XML Gateway is seeded product that comes in bundle and used to validates the XML messages if they follow IFX Release 1.2 specifications . Oracle CM does have predefined mapping rules that take care of loading apart from BAI or MT940 format.Once record is successful validated, Oracle XML Gateway push the data into bank statement open interface tables and kick the bank statement import program to transfer the bank statement information to Oracle Cash Management.This is integrated by workflow.

If you have plan to use XML statement feature of bank interface then you must requires Oracle XML gateway, Oracle advance queuing (AQ) product and Oracle Transport agent. The user guide have step by step procedure of enabling this out of box functionality.


  • Note:216560.1:About Oracle Cash Management in Financials Family Pack D

dgreybarrow-2Going Forward

XML Bank statement is relatively a new area as far as advance countries like US,Europe, Australia, Singapore, Hongkong where presence of most of the global bank still prefer to provide in BAI or SWIFT format. If anyone get a chance to implement XML , its is good to share your thoughts …:)

Posted in Cash Management | 3 Comments »

Implementing SWIFT MT’s within EBS

Posted on May 20th, 2008 by Sanjit Anand ||Email This Post Email This Post

Companies to Banking partner connectivity and online information exchange has long been an issue for many reasons for so many years. Driven by tighter regulation and the need for better cash management and effective working capital management prompt Treasures to explore more areas so that they can get better insight into their cash positions and forecasts. As mention in last post globalization, Single instance strategy, global bank model, multi-cash feature provided by banks, centralization and standardization of finance processes that makes finance department to explore more in this area. Integration with any banking partner solutions either interacting with third party netting system or Sending a simple wire payment instructions to bank, you does requires a very tight integration with your accounting system.

Read the rest of this entry »

Posted in Cash Management, Oracle Application, Oracle Treasury | No Comments »

Managing Cash , EBS and SWIFT

Posted on May 18th, 2008 by Sanjit Anand ||Email This Post Email This Post

In last couple of years, IT and Internet open the new door not only to IT Finance Managers but also Corporate Treasurers .The role of treasurers is more demanded and expectation with their banking partner have been greatly increased Changing Banking Relationships, Single Bank Model ,globalization , SWIFT corporate access and XML and end to end Integration with In house accounting system are some of the key points that enforce treasury department to look options with usage of Technology by either in building custom online applications or integrated and modified products From commercial vendors of ERP.

Lets start the topic of Treasurer Dilemma for exploring Integration of Oracle ERP with SWIFT Network.Here is one of case where treasurers seeking information with Oracle.


– Currently using Oracle E-Business Suite and planning to generate e-files from AP and Treasury modules and transfer it to SWIFT.
– Came to know that many messages stating that Oracle is developing some applications that would help integrate the e-business suite with SWIFT.
– As Oracle Treasury has the ability to generate MT 100. ( Assume AP has this functionality).

Read the rest of this entry »

Posted in Cash Management, Oracle Application, Oracle Treasury | 2 Comments »

Oracle EBS & SWIFT

Posted on May 17th, 2008 by Sanjit Anand ||Email This Post Email This Post

Read this

Whenever the Bank Intergation is required , the very first term would come in mind is SWIFT , a very similar way as EDI sort of messaging servics that Financial sectors are using .So let explore what is SWIFT and how many of these can be potenially targetted for Integration .

double-arrow-28 What is a S.W.I.F.T?

S.W.I.F.T. (or SWIFT) stands for Society for Worldwide Interbank Financial Telecommunication. It is a non-profit organization comprised of member financial institutions. It was established in 1973 by European bankers who needed a more efficient and secure system for inter bank communications and transfer of funds and securities. Until then, all inter bank communications were by telephone, telex, courier, or mail.

double-arrow-28 Swift Messages

SWIFT messages are preset and referred to by category numbers called MT numbers. Through this network (a.k.a. SWIFTnet) information can be exchanged using special crafted messages known as Message-Types (MT).

Read the rest of this entry »

Posted in Functional, Oracle Application | 4 Comments »

Step by Step : ‘AuditTrail’

Posted on May 16th, 2008 by Sanjit Anand ||Email This Post Email This Post

Previous Post:

greyBarrow Steps by step: Enabling audit trial

As per the below example the ‘Define An application user’ is a user table name for FND_USER,the same steps you can follow for your own tables.

Read the rest of this entry »

Posted in AOL, EBS Suite, Oracle Application, Tool | No Comments »

Are you seeking auditing ability in EBS…use ‘AuditTrail’

Posted on May 15th, 2008 by Sanjit Anand ||Email This Post Email This Post

greyBarrowWhat is an AuditTrail?

An AuditTrail is one of functionality for retaining a history of changes to data. What ,who and when can be identified on a particular table or column if the functionality is enabled.

When you enter or update data in your forms, you change the database tables underlying those forms. An audit trail tracks which row in the database was updated at what time, and which user was logged in using the associated form(s).

If you are seeking auditing ability to track changes on a particular table of Oracle this post might helpful to you.

greyBarrowEnabling the Functionality of AuditTrail

You can turn AuditTrail on or off (Yes or No). Normally the default setting is No (Off). When you enter or update data in your forms, you change the database tables underlying the forms you see and use. AuditTrail tracks which rows in a database table(s) were updated at what time and which user was logged in using the form(s). Also..

  • Several updates can be tracked, establishing a trail of audit data that documents the database table changes.
  • AuditTrail is a feature enabled on a form-by-form basis by a developer using Oracle’s Application Object Library.
  • All the forms that support AuditTrail are referred to as an audit set. You should also note not all forms may be enabled to support AuditTrail.
  • To enable or disable AuditTrail for a particular form, you need access to Oracle Application Object Library’s Application Developer responsibility.
  • Users cannot see nor change this profile option.
  • This profile option is visible and updatable at the site and application levels.



The internal name for this profile option is AUDITTRAIL:ACTIVATE.

greyBarrow Setting Up AuditTrail(>11i )

You can choose to store and retrieve a history of all changes users make on a given table. Auditing is accomplished using audit groups, which functionally group tables to be audited. For a table to be audited, it must be included in an enabled audit group.

greyBarrowThe steps for setting up AuditTrail include:

Yuu need to verify Select Privileges on SYS.DBA_TABLES

Have your database administrator grant SELECT privileges on SYS.DBA_TABLES to the APPLSYS account. Normally, this step would Normally taken care during the installation of Oracle.

greyBarrowDefine Audit Groups

This is very very important.These are groups of tables and columns, where you do not necessarily need to include all the columns in a given table. You enable auditing for audit groups rather than for individual tables. You would typically group together those tables that belong to the same business process (for example, purchase order tables see at the end).

A given table can belong to more than one audit group. If so, the table is audited according to the highest “state” of enabling for any of its groups, where Enabled is the highest, followed by Disable Dump Data, Disable No Growth, and Disable Purge Table, in that order.

Navigation: Security -> AuditTrail -> Groups

greyBarrowDefine Audit Installations

You choose the registered Oracle IDs at your site that you want to audit. This allows you to audit across multiple application installations. When a table is added to an audit group, auditing will automatically be enabled for all installations of the table for which audit is enabled.

Navigation: Security -> AuditTrail -> Install

greyBarrowRun the Audit Trail Update Tables Report to Enable Auditing

Your AuditTrail definitions (and auditing) do not take effect until you run the Audit Trail Update Tables Report. If you change any of your definitions later, you must rerun this program. You run the Audit Trail Update Tables Report from the standard submission (Submit Reports) form.

greyBarrowAudit Trail Update Tables Report

This program creates database triggers on the tables in your audit groups for your installations. It also creates shadow tables, one for each audited table, to contain the audit information. If you have changed your audit definitions or disabled auditing for an audit group, the program drops or modifies the auditing triggers and shadow tables appropriately.

The program also builds special views you can use to retrieve your audit data for reporting.

You can check SQL*Plus to see if the Shadow Tables have been created or not. Shadow Table name is the same 26 Characters of the Table being audited followed by a suffix of “_A” ,suffix of “_AI” for Insert Triggers, “_AU” for Update triggers , “_AD” for Delete Triggers,suffix of “_AIP” for Insert Procedures “_AUP” for Update Procedures and “_ADP” for Delete Procedures.

greyBarrow AuditTrail Limitations

These are limitation of AuditTrail:

  • Your table should consist of maximum 240 columns
  • You cann’t use the column for audit trail whose data type is LONG, RAW, or LONG RAW
  • Your audit group must include all columns that make up the primary key for a table; these columns are added to your audit group automatically.
  • Once you have added a column to an audit group, you cannot remove it.
  • AuditTrail requires two database connections. If your operating platform does not automatically support two database connections
    (e.g., VMS or MPE/XL), then add the environment variable ‘FDATDB=<database connect string>’ to your environment file.
  • Because the structure of the audited table may change between product versions, AuditTrail does NOT support upgrading existing shadow tables or audited data. Before an upgrade, you should archive the shadow tables and perform all necessary reporting on the audited data.
  • Oracle recommended Disabling AuditTrail feature Prior to Upgrade to higher version.
  • If your plan is to use some auditTrail on table which name is bit longer(> 26 characters), you can’t achieve this. As there is Bug(#3872242
    ) reported by Oracle that restrict you from this, as AuditTrail Update Tables Errors out on audited tables that are > 26 characters.

Sometime back we found while enabling this on these tables.


greyBarrowWhat are the primary Auditing Tables?



Customer has set the profile “Sign-on: Audit Level” to FORMS to collect information about the forms sessions at a particular time .
By default the value for this profile was USER.
Since he has set the value to Forms can he collect the User related information

Yes you can …
If the profile “Sign-on: Audit Level” is set to FORMS then it will collect Form sessions information in addition to user session information.
So you will get information related to User session as well as forms session. There is no harm in setting this profile value to FORMS.

Posted in AOL, EBS Suite, Oracle Application, Tool | 1 Comment »

MOAC :”Multi-Org Preferences”

Posted on May 12th, 2008 by Sanjit Anand ||Email This Post Email This Post

MOAC allows users of a single responsibility to perform task in multiple operating units without having to switch responsibilities.Out of Box functionality of MOAC, there is something called “Multi-Org Preferences”.

dgreybarrow-2What is “Multi-Org Preferences”?

Multi-Org Preferences allows you to control the list of operating units to which you have access.

Lets say you have around 20 OU’s divided into three major Region (North America, Europe and APAC). Lets say within APAC region you are responsible for all 7 OU’s within Region.

Read the rest of this entry »

Posted in R12, Release12, Technical | 5 Comments »

« Previous Entries