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

Techies Curious about XBRL? – Learn from these sessions

Posted on August 29th, 2008 by Sanjit Anand ||Email This Post Email This Post

Two useful sessions from youtube for beginners for understanding XBRL.


tick How XBRL Works :This Video by Charls Hoffman explaining the essence of XBRL. He took a typical financial statement footnote and demonstrates how its text can be structured for meaning.

tickXBRL in Plain English : Informative introductory video has lots of fun graphics and a cheerful narrative.

dgreybarrowEarlier Post

Posted in XBRL | No Comments »

Back to Basics: Notes from Financial Reporting & XBRL

Posted on August 29th, 2008 by Sanjit Anand ||Email This Post Email This Post

dgreybarrow-2What is XBRL (eXtensible Business Reporting Language) is:XBRL

This is an international market driven corporate reporting information format standard

  • XBRL is a freely available electronic language for business reporting.
  • A platform for corporate reporting standards
  • A tool that can enhance the quality and efficiency of business reporting
  • A way to enhance the analysis of information contained within business reports
  • An information standard designed specifically to enhance business information exchange
  • Good is that this is available on a royalty free basis
  • This is based on accepted reporting standards
  • A market reality with broad and accelerating regulatory adoption around the world
  • The key components of:
    • Technology = XML-based specification (information format)
    • Language / dictionary = (information)
    • Terms by jurisdiction (US, Germany,Ireland, Singapore,Japan,….)

dgreybarrow-2Why this is getting popular in accounting world

  • Because this provides a database-like structure, using text files
  • This defines a collection of financial facts for a specific report, industry, and jurisdiction (taxonomy)
  • Facilitates the data exchange between proprietary systems
  • Promotes the re-use of data with far less effort

You can download a copy of Deloitte’s XBRL pod cast from here. You can also download a copy of their Technology Predictions 2008 Report from the same page and refer page 14 for XBLR Information.

High point of the documents is authorities are pushing to make XBRL mandatory for the submission of tax returns and financial reports. In the US the SEC already has 40+ big companies filing XBRL tagged reports.APAC countries like China and Singapore they already started.The UK Government plans to make XBRL mandatory by 2011.

dgreybarrow-2ERP Products -XBRL-enabled Products

  • ORACLE : Oracle EBS as GL FSG
  • PeopleSoft
  • SAP mySAP financials
  • Microsoft Business Solutions Navision

dgreybarrow-2The New is XBRL Specification 2.1 & Oracle General Ledger 11i/R12

XBRL Financial Reporting is supported in General Ledger (GL) through its Financial Statement Generator (FSG).

You can map XBRL Elements to FSG Row Sets.

Map XBRL Elements to FSG Row Sets

As per metalink note 602332.1, Oracle does not support XBRL 2.1.

Currently on version 2.0 of the taxonomy is supported by Oracle in FSG’s. Lets hope XBRL 2.1 will be available by sometime early in 2009.

dgreybarrow-2Similar post

dgreybarrow-2Suggested Reading

Improving XBRL Implementation & Interoperability
This white paper provides some technical insights into the improvements made to XBRL in the 2.1 version of the standard. It is primarily aimed at IT professionals that need to advise or make decisions about the use of XBRL. Download

dgreybarrow-2Reference notes

  • Note:239123.1 :XBRL Support in Oracle General Ledger
  • Note 277877.1 :Setup Checklist for eXtensible Business Reporting Language (XBRL) FSG reports
  • Note:297280.1 :FSG Reports Using XML Publisher

Posted in XBRL | 2 Comments »

Dunning and EBS R12

Posted on August 25th, 2008 by Sanjit Anand ||Email This Post Email This Post

Quick notes for Dunning Letter in EBS R12.

  • tick The AR Dunning Letters is obsolete in R12.
  • tick The AR Collections Workbench is obsolete in Release 12.
  • tick You will need to install the Oracle Advanced Collections application.
  • tick The basic Collections functionality is available in Oracle Advanced Collections without any extra cost.
    • However, if you wish to use the more complex functionality in the Oracle Advanced Collections, you will need to pay for license cost.
  • tick In R12 Advanced collections, you will now need to run Oracle Advanced Collections Dunning Plans instead.
  • tick To using the Dunning Plan basic functionality you donot requires Oracle Advanced Collections license.
  • tickThe Dunning process in R12 Collections is based on Scoring. You can set it up so that a particular score is associated to a Dunning Letter Plan. Then only allow that one customer to get that score.
  • tick Dunning Plans in Advanced Collections replace Dunning Letters in 11i AR , thus dunning Plans will need to be setup.
  • tickStaged Dunning Letters does not exist in R12 Collections rather can be used the Standard Dunning Plans in R12 of Collections. However, for a more complex timing and use of Dunning letters you will want to setup the highly configurable Strategies and send your letters in this manner.
  • tickCustomer interactions and correspondence, transaction processing, and dunning activities are consider as basic functionality whereas scoring, collections strategies, enhanced payment and promise processing, automated promise tracking, and automated collector work assignment are consider as advance feature of product.
  • tickIn R12, dunning functionality is executed by XML Publisher.
  • tickThese are some of seeded template for Dunning in R12.tempalte

List of seeded Template (ref:source)

  • tickIt is anticipated that Dunning Letters can be delivered via e-mail, fax or print.
  • tickIEX is application code 782 is product code for Advance Collections.
  • tickDunning Plans include aging bucket parameters for all data levels (customer, account, bill-to, transaction) in Oracle Advanced Collections. That mean A collections manager can configure dunning plans that look at the oldest aged invoice for each customer, along with the score, and have the system send different dunning letters to customers in each aging bucket.This was first Released 11i.IEX.H.
  • tickA migration white paper and migration scripts will be provided to Oracle Receivables Workbench customers moving to Oracle Advanced Collections.

dgreybarrow Metalink Reference Note:

  • Note 389443.1:Migrating to Oracle Advanced Collections An Overview for Oracle Receivables
  • Note:454908.1:Migrating to Oracle Advanced Collections: An Overview for Oracle Receivables Users
  • Note:727659.1:How Do You Setup Dunning Plans Now That You’ve Installed R12 Advanced Collections?
  • Note:557452.1: What Products need to be Licensed/Installed for Collections to Compile Properly?
  • Note:726427.1 :Cannot Print/Email/Fax Dunning Letters in R12, Why?
  • Note 289801.1 :About Oracle Advanced Collections Mini-pack 11i.IEX.H

Posted in Oracle Receivable, R12 | 5 Comments »

Oracle E-Business Suite R12.1 – Release Content Documents Available

Posted on August 23rd, 2008 by Sanjit Anand ||Email This Post Email This Post

Oracle E-Business Suite R12.1 release likely to announced sometime by Sept’08 OOW Event.

The reason ..RCD’s for Oracle E-Business Suite Release 12.1 are now available on Metalink. According to Metalink note 561580.1 – this document contains links to the published Release Content Documents for Oracle Applications, E-Business Suite Release 12.1.These RCD communicate information about new or changed(Delta) functionality introduced between Release 12.0.4 and 12.1

There are 15 RCD’s available as listed below: BigNews

  1. Asset Lifecycle Management
  2. Financials
  3. Human Resources
  4. Logistics
  5. Manufacturing
  6. Marketing and Sales
  7. Master Data Management
  8. Order Management & Contracts
  9. Procurement
  10. Projects
  11. Service
  12. Supply Chain Planning
  13. Aerospace, Defense, and Transportation
  14. Financial Services

Lets hope formal announcement for release date would be at Open World in September. Should be guess Product will be avaible by sometime Oct 08.

Metalink Note

  • 561580.1: E-Business Suite Release 12.1: Release Content Documents

Posted in News | 5 Comments »

Incompatibility and Request Sets

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

ISD team of client side was struggling with such requirement.

Scenario :They have two request set name say ‘X’ and request set name ‘Y’.

Their requirement was to make these two incompatible to each. So that when X runs Y should wait for X to complete or vice versa?

This might be very similar requirement for other so thought to bring into post.

dgreybarrowLets understand ….. “INCOMPATIBLE”


So left hand side figure , is what defined in

Lets revisit in Oracle Context..

INCOMPATIBLE means: Two incompatible reports or request set are not allowed to run in parallel. Incompatible reports /program can only run sequentially, the first one must terminate before the other is allowed to start.

So, it can happen that a report is pending for a long time, when it is waiting for the incompatible report to finish.

In Oracle Context you have to know that INCOMPATIBLE type may be global or domain . If you choose Domain, the incompatibility is resolved at a domain-specific level. If you choose Global, then this concurrent program will be considered globally incompatible with your concurrent program, regardless of which domain it is running in.Make sense.. Lets take a look how documentation define:

dgreybarrowExample of Program Incompatibilities

You can understand like this: Oracle General Ledger’s Posting program,which is used to post journal entries.

If the Posting program’s incompatibility with other concurrent programs were not enforced, other financial reports running simultaneously with the Posting program could contain incorrect account balance information.

dgreybarrowDefinition of incompatible type “Domain” VS “Global”

If you choose Domain, the incompatibility is resolved at a domain-specific level.

If you choose Global(Fyi..The concept of “Global” incompatibilities was introduced with Patch 2364876), then this concurrent program will be considered globally incompatible with your concurrent program, regardless of which domain it is running in.

You can define a concurrent program to be globally incompatible with another program that is, the two programs cannot be run simultaneously at all; or you can define a concurrent program to be incompatible with another program in a Conflict Domain. Conflict domains are abstract representations of groups of data.

They can correspond to other group identifiers, such as sets of books, or they can be arbitrary.

dgreybarrowConcurrent Conflict Domains Concept

As per Oracle system admin user guide, If two programs are defined as incompatible with one another, the data these programs cannot access simultaneously must also be identified.

In other words, to prevent two programs from concurrently accessing or updating the same data, you have to know where, in terms of data, they are incompatible. A Conflict Domain identifies the data where two incompatible programs cannot run simultaneously.

In Oracle Applications, data is stored in database tables that belong to a particular application. Each table may also contain information used to determine what conditions need to be met to access the individual records. These conditions may consist of one or more of the following data groupings:

  • Set of books : This is based out of underline profile option i.e..GL_SET_OF_BOOKS
  • Multiple Operating units :This is based out of underline profile option MO_OPERATING_UNIT)
  • Multiple Orgs :This is based out of underline profile option ie. INV_ORGANIZATION_ID Manufacturing Applications
  • HR may use business group as a conflict domain
  • Fixed asset may use Fixed asset dep. book(FA)

A conflict domain is an abstract representation of the groupings used to partition your data. There is no limit to the number of domains that can be defined, but excessive domains may hurt performance.

dgreybarrowMore on Oracle Conflict Domains

A conflict domain is a set of related data stored in one or more ORACLE schemas and linked by grants and synonyms. Do not confuse logical databases with your ORACLE database. The ORACLE database contains all your Oracle Applications data, with each application’s data usually residing in one ORACLE schema. You can think of a logical Defining database as a line drawn around a set of related data for which you wish to define concurrent program incompatibilities. In other words, logical databases determine which concurrent programs cannot run at the same time.Make sense:)

dgreybarrowProfile Options as part of standard setup

  • Concurrent:Conflicts Domain :This option identifies the domain within which all the incompatibilities between programs has to be resolved.
    The profile can be set at Site, Application, Responsibility and User levels.This can be an operating unit name, a legal entity name, or a set of books name as the domain name. You are allowed to define as many as domains as you need. Since you cannot delete conflicts domains, you should keep the domains to a necessary minimum.


Navigate to Concurrent > Conflicts Domains

dgreybarrowHow its Conflict Domains Works with conflict resolution manager

tickAll programs are assigned a conflict domain when they are submitted. If a domain is defined as part of a parameter the concurrent manager will use it to resolve incompatibilities. If the domain is not defined by a parameter the concurrent manager uses the value defined for the profile option Concurrent:Conflicts Domain.

tickLastly, if the domain is not provided by a program parameter and the Concurrent:Conflicts Domain profile option has not been defined the ‘Standard’ domain is used. The Standard domain is the default for all requests.

tickAll programs use the Standard conflict domain unless a value is defined for the profile option Concurrent:Conflicts Domain or a conflict domain is defined through a program parameter.

tickEach request submitted uses parameters which identify the records that it will access.

tickFor programs that are defined with incompatibility rules an additional parameter (conflict domain parameter) is used. The conflict domain may be set automatically based on such variables as a login ID, set of books, or the organization the user is working in. The conflict domain parameter may in some cases be selected in the parameters field of the Submit Requests form. Once the parameter is determined the Conflict Resolution Manager (CRM) uses the domain to ensure that incompatible programs do not run simultaneously in the same domain.

Read the rest of this entry »

Posted in AOL | 1 Comment »

IBAN – Insights

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

The European Committee establishes IBAN1 standards for Banking Standards (EBS) and the International Organization for Standardization (ISO).

IBAN provides an international standard account identifier for identifying an account held by a financial institution, in order to facilitate
automated processing of cross border transactions through:

  • Automatic processing of foreign bank account identifications
  • Uniform validation of foreign bank account identifications
  • Easy routing of transactions

The IBAN can be implemented without modification to domestic account numbers or account number formats. This is achieved by creating a standard prefix after which the domestic account number can sit unchanged.

Posted in Cash Management | No Comments »

Oracle Implementation Options

Posted on August 13th, 2008 by Sanjit Anand ||Email This Post Email This Post

A typical ERP Deployment for any Global company typical consider as Global, Regional or Local Deployment , which can be best understood as:

  • Global ERP -Corporations with common business areas that are seeking to centralize management and standardize business processes across geographies and divisions
  • Regional ERP -Corporations that operate in group of regional businesses which need to meet unique requirements of particular markets and comply with statutory or legal requirements
  • Local ERP -Corporations with significantly different business areas having significantly different business process requirements

Read the rest of this entry »

Posted in Implementations | 4 Comments »

R12 Balancing API

Posted on August 13th, 2008 by Sanjit Anand ||Email This Post Email This Post

There are two very distinct features in E-Business Suite Release 12 of AGIS.

  1. Automatic Balancing – When a transaction with multiple BSV’s is entered, the Balancing Process automatically generates the correct intracompany or intercompany accounting entries, depending on whether the balancing segments are in the same legal entity or in different legal entities. If the balancing segments values are in the same legal entity (intracompany accounting) the automatic Balancing Process uses Cross-Entity Balancing Rules to generate the balancing accounting entries. You can specify both the Debit Balancing Segment Value and Credit Balancing Segment Value for the balancing relationship; this new dimension allows you to define explicitly the accounts that should be used when any pair of balancing segments values are balanced against each other. If the BSVs are in different legal entities (intercompany accounting) the automatic Balancing Routine uses Intercompany Accounts setup to create the balancing accounting lines. You can setup several intercompany accounts for your intercompany activities, and select one as the default to be used for automatic balancing.
  2. Manual Intercompany Transaction entry – entry of intercompany transactions is enhanced . For all requestor(initiator) and recipient organizations, the legal entity information is displayed on each transaction. Intercompany accounting entries are generated automatically based on centralized setup. The requesting organization is able to create a single batch containing multiple recipient transactions across different ledgers, currencies and calendars, which are automatically submitted to all recipients for approval. When a batch is entered with multiple recipients, Oracle AGIS optionally prorates the distribution amounts for each recipient, based on the proportion of the transaction allocated to that recipient.

dgreybarrowBalancing : Difference (11i vs R12)

  • In 11, balancing journal entries were generated at posting time by the GL posting routine
  • In R12, the Balancing Routine (balancing API is called by GL and SLA): Generates balancing accounting entries for subledger journal entries at time accounting is created Generates balancing journal entries at posting time for all other journals.

dgreybarrowR12 Balancing API

Balancing API is triggered from Journal Posting process or from Subledger Journal Creation process. Once it is called it creates balancing journal lines automatically based on the setup for the combination of journal source and category.

Balancing has 3 elements :

  1. The Balancing API
  2. Intracompany Balancing Rules (Navigation: Setup->Financials->Accounting Setup Manager->Accounting Setups)
  3. Intercompany Accounts

The Intracompany Balancing Rules and Intercompany Accounts are used by the Balancing API to generate accounting lines for transactions that include multiple balancing segment values.

The Balancing API is called from the General Ledger at posting time for GL Journals, and from the Subledger Accounting Architecture during the accounting process for subledger transactions. Transactions originating in Payables and Receivables will be balanced using the Balancing API when SLA performs the accounting for them.

dgreybarrowTechnical Interest

Following two tables involved

    This table stores the ledger, journal source and category information for which the Intracompany balancing rules have been defined. These rules are used by the Intercompany Balancing API to balancing Intracompany journals. This table also gives the clearing balancing value option selected for a particular source and category.
    This stores the intracompany accounts defined between each trading and transacting balancing segment value. These accounts are used by the Intercompany Balancing API to balancing Intracompany journals
  • The table FUN_BALANCE_OPTIONS and the table FUN_BALANCE_ACCOUNTS are linked by a Template_id.
  • The posting program uses the package FUN_BAL_UTILS_GRP while creating the intracompany lines.The pls files for the package FUN_BAL_UTILS_GRP are fungbalutilb.pls and fungbalutils.pls. File location would be at $FUN_TOP/patch/<version>/sql.


Similar Post

dgreybarrowMetalink Note

  • 604441.1 :AGIS Setting Up Intracompany And Intercompany Accounting – An Example

Posted in InterCompany | 2 Comments »

LE/OU Question on Merger or De-Merger

Posted on August 10th, 2008 by Sanjit Anand ||Email This Post Email This Post

A reader query from Sreekanth Allamudi

Read the rest of this entry »

Posted in Oracle General Ledger | No Comments »

11i Setup for LE & OU

Posted on August 9th, 2008 by Sanjit Anand ||Email This Post Email This Post

Adding a New Operating Unit with LE , here are the steps you need to perform.


  1. Finalize the your organizational structure
  2. Finalize your COA Structure
  3. Finalize SOB criterion which depends on 3 C (Calendar , Chart of account and Currency)

dgreybarrowA Note for your COA and LE design

The COA must recognize the real world that the business operates in, and the entities through which its operations are carried out. It must meet the basic requirement that it should provide all financial information by ‘real’ legal entities (as opposed to organizational classifications of business units, divisions etc.). It also allows us to capture information along the dimension by which we hold ourselves out to the real world, and is extremely useful for tax and statutory reporting. The ‘real’ legal entity must be a balancing segment, i.e. it should be possible to extract a self balancing chart of accounts by legal entity. This may not be a requirement for a business division where BS (balance sheet) elements may not be shared and separate information may be required only for the P & L (Profit and Loss) accounts.

Read the rest of this entry »

Posted in Oracle General Ledger | No Comments »

« Previous Entries