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

Assess your aptitude for Project Leadership

Posted on November 30th, 2007 by Sanjit Anand ||Email This Post Email This Post

I get across a nice article for leadership skill. In fact there are a variety of skills and personality characteristics that make a great project leader. The article nicely describes the list of indications that he/she may not be well suited to be a project manager.

These are the 10 signs that you aren’t cut out to be a project manager.

  1. You are a poor communicator
  2. You don’t like to document things
  3. You prefer the details
  4. You don’t work well with people
  5. You don’t like to manage people
  6. You don’t like to follow processes
  7. You like to execute and not plan
  8. You prefer to be an order taker
  9. You are not organized
  10. You think project management is “overhead”

Read the Entire post:10 Things Blog,CNET Tech Republic

10 signs that you aren’t cut out to be a project manager

Posted in Blogroll, Misc | No Comments »

OracleApps Epicenter :1,00,000+ and Counting

Posted on November 30th, 2007 by Sanjit Anand ||Email This Post Email This Post

Today I noticed, sometime in this month the count meter from Statcounter/Sitemeter crossed over the 1,00,000 Page view mark. It was indeed an important milestone for my contribution to the Oracle community through this platform. It’s not bad. In that time in spite of tight timeline I manage to wrote about more than 135 blog post with around 1,000+ comments, which I responding offline or online. Currently, this blog gets about 600 visits and 1700-1800 page views (aka hits) each week days and nearly 400+ during weekends. I hope the next 1,00,000 views comes very sooner.A big thanks to everyone visiting and reading my blog .




Posted in Blogroll, Misc | 1 Comment »

A bit on Oracle’s business flow

Posted on November 27th, 2007 by Sanjit Anand ||Email This Post Email This Post

Do you know in Oracle EBS there are more than 30+ pre-defined integrated process flows available to cater today’s competitive marketplace, where speed, value & Simplicity are important factors to drive the implementation cycle. These concepts are fully aligned with the method enhancements, in the following ways:

  • Time required to implement is reduced by using the pre-seeded assets in the delivery (Speed). This is achieved by pre-seeded, pre-tested, certified deliverables for faster implementation.
  • The focus on solving customer business processes brings value to the customer instead of talking about product features and functions (Value).
  • Key performance indicators identified with each Flow also brings value in that they provide a means to measure the leverage points of the flows (Value).
  • Starting with a pre-tested flow, and avoiding a lengthy analysis of the current environment, provides a simple way to begin any Oracle Applications implementation (Simplicity).

Some of the important business flow’s with oracle applications are:

Posted in Methodology/Process | 2 Comments »

R12 : Suppliers & Trading Community Architecture

Posted on November 26th, 2007 by Sanjit Anand ||Email This Post Email This Post

Read this :

In earlier post,we have seen supplier has been moved into TCA model. Comparing to 11i version, three new AP tables containing supplier unique data been introduced. They have the links to TCA tables:


And more important we understood three old PO Vendors tables obsolete, by Views provided for backward compatibility

Here is data model .This will really helps to understand while designing integration with EBS R12.


Posted in EBS Suite, Oracle Payable, R12, Release12 | 9 Comments »

Know the Changes because of R12 Oracle Payment Module (Fund Disbursement) in EBS

Posted on November 26th, 2007 by Sanjit Anand ||Email This Post Email This Post


As we know , fund disbursement functionality has been moved from Oracle payables to new Payment module, which provides these functionality like;

  • Creation & validation of payments
  • Aggregation of payments into files
  • Format & transmission of files

where as selection & approval of invoices remains in Payables itself.

It is very important to understand some of important changes impact while upgrading 11i to r12 to some of the custom reports if they are based out of R11i10 version schema model.


greUnderstand some of the changes because of Funds Disbursement(Oracle Payment)

Some of the important changes can be summarized as:12tablechangespayment

Will take some more discussion on Oracle Payments some other day.:)

Posted in Oracle Payment Module, Release12 | 13 Comments »

R12 : Bank & Trading Community Architecture(TCA)

Posted on November 26th, 2007 by Sanjit Anand ||Email This Post Email This Post

Read this:


dgreybarrow-2Three key CE tables now as:

  • CE_BANK_ACCOUNTS for bank accounts
  • CE_BANK_ACCT_USES_ALL for account uses by Operating Units & Legal Entities
  • CE_GL_ACCOUNTS_CCID for bank account use accounting data

dgreybarrow-2TCA and Bank

The TCA party model is being used to model banks and bank branches as parties with the associated attributes of Relationships, Address, Contact and Locations. The TCA tables used by Cash Management for modeling Banks and Bank Branches are listed below:


The HZ_ORGANIZATION_PROFILES table stores additional attributes of banks and bank branches along with the history of changes made to Banks and Bank Branches. The contact person at the bank, bank branch and bank account is defined as a party in HZ_PARTIES, while the contact details will be stored in HZ_CONTACT_POINTS (stores contact methods), HZ_ORG_CONTACTS (stores the contact’s title) and HZ_ORG_CONTACT_ROLES (stores the contact’s purpose or role). The address details of Banks and Bank Branches will be in HZ_LOCATIONS (stores addresses) and HZ_PARTY_SITES (stores party sites).

The new table CE_BANK_ACCOUNT stores bank account attributes while the CE_BANK_ACCT_USES_ALL table stores the bank account use attributes specific to Operating Unit (AR, AP) and Legal Entity (Treasury).

The accounting data pertaining to the bank account use will be stored in the CE_GL_ACCOUNTS_CCID table.

All of the bank, branch and bank account related attributes in AP_BANK_BRANCHES and AP_BANK_ACCOUNTS_ALL tables will be upgraded to HZ_PARTIES and the new tables in Cash Management.

Within TCA model, here is various attributes how they fits inside the model.



Posted in EBS Suite, Oracle Payable, R12, Release12 | 2 Comments »

Commonly used SCM Jargons

Posted on November 26th, 2007 by Sanjit Anand ||Email This Post Email This Post

Commonly used SCM Jargons.

  • Lead Time – is the time between the initiation of any process of production and the completion of that process. E.g. lead time for ordering a new car from a manufacturer may be anywhere from 2 weeks to 6 months. In SCM, lead time reduction is an important part of most of the manufacturing companies.
  • Cycle-Time – The time elapsing between a particular point in one cycle or production and the same point in the next cycle
  • Safety Stock / Buffer Stock – is a term used to describe a level of stock that is maintained below the cycle stock to buffer against stock-outs. Safety Stock or Buffer Stock, exists to counter uncertainties in supply and demand
  • Advanced Ship Notice (ASN) – is the notification the supplier sends the manufacturer in reaction to the pull signal notifying the material in on the way and confirming inventory will be replenished to meet the requirement.
  • Electronic Data Interchange (EDI) – is the exchange of electronic data between business partners who use a number of different hardware and software solutions. The exchange can involve documents such as sales orders, invoices, and advanced shipping notices (ASN).
  • Vendor-managed inventory (VMI) – is a family of business models in which the buyer of a product provides certain information to a supplier of that product and the supplier takes full responsibility for maintaining an agreed inventory of the material, usually at the buyer’s consumption location
  • Logistics Management :The management of transportation operations of all types,including tracking and managing every aspect of vehicle
    maintenance, fuel costing, routing and mapping, warehousing,communications, EDI implementations, traveler and cargo handling, carrier selection and management, accounting.

    • Logistics is –
      • Key to Supply Chain Management
      • Often performed by a 3PL or 4PL
      • Begin to contribute large portion to the organization costs
  • 3PL (Third Party Logistics) – is a outsourced or “third party” logistics services to a company for part, or sometimes all of their supply chain management function. Third party logistics providers typically specialize in integrated warehousing and transportation services that can be scaled and customized to customer’s needs based on market conditions and the demands and delivery service requirements for
    their products and materials
  • Lot Sizing – is simply a size or quantity in a lot. But plays a very important role in a supply chain. One key decision of production planning is the batch or lot size
  • Inventory Turns – often referred to as stock turns, turns, and stock turnover. This measures the number of times invested in goods to be sold or used over in a period
  • Replenishment Time – is time required to replace the consumed stock.
  • Supply Planning – is the ability to use the distribution plan, inventory plan, sourcing plan, and materials plan to determine the best way to meet demand. Supply planning encompasses the allocation and deployment of resources, as well as facilitating order promising.
  • Production Planning – Planning is the ability to create a plan of record from the requirements of the demand, supply and capacity plans. Production planning (PP) encompasses the allocation and deployment of resources to optimize plant capabilities
  • Demand Planning – is simply put is foreseeing the actual demand or requirement of the market. It is used to monitor & make sure the “health” of a supply chain

Posted in Functional, Oracle Manufacturing | No Comments »

R12 SLA: Analyzing Subledger Accounting

Posted on November 25th, 2007 by Sanjit Anand ||Email This Post Email This Post

As in last post about subledger accounting we understood with this new feature:

  • All accounting performed before transfer to the GL.
  • and this is achieved by user setup who can do by definable accounting rules.

At the data level, it’s a big change for all the subledgers, though there is a first generation changes we have noticed sometime when 11i Payables where concept of “Accounting Events ” introduced first time and accounting performed at subledger level first before moving into GL.

The same idea has been incorporated in new sub ledger accounting model , indeed a was a real need because of some uneven functionality likes:

  • Inconsistencies in Accounting Generation like Summary vs. Detail
  • Direct to General Ledger vs. Open Interface
  • Inconsistent Drilldown from General Ledger
  • Also it has been seen inconsistent Mechanisms for controlling Accounting as certain options has been used in existing version:
    • flex builder
    • Account Generator
    • Automatic Offsets

What is sub ledger mean for a non finance person?

  • A new transactional application that generates accounting impact
  • Used to store detailed information not needed for a general ledger
  • Sub ledgers post summarized activity to a general ledger periodically to maintain centralized account balances for the company

With these accounting at this level the respective sub ledgers & General Ledger is tied out, as below.


bluHow Receivables Accounting happen in 11i

As we know the final accounting data not generated prior to transfer to GL as only distribution level information is passed to GL.

In 11i , we know three distinct distributions tables for invoices / Credit Memos / Debit Memos have to capture accounting class & amounts information but not debits & credits.

    • Receipts & Adjustments
      • Unapplied, applied
      • Both debits & credits
    • Misc. Cash Receipts
      • Both debits & credits
  • As we know “View Accounting” is a report against distributions to see the accounting information.


purpHow Payables Accounting happen in 11i

We know accounting data generated and stored in “Accounting Events” tables prior to transfer to GL in Payable. Once Transaction get completed it was need to run the “Create Accounting” process which basically populate data into accounting events tables.Then the actual line information move takes place from accounting events table to General Ledger Tables.The existing 11i accounting Process is can be best understood by figure below.


red1Subledger to Ledger Reporting in 11i

It means complete, final accounting only available in the GL

  • All debits and credits
  • All journal entries
  • All balances

The only issues in pre R12 versions was to link summarized accounting data with source details.

greHow it is resolved in Release 12 Subledger Accounting

All sub ledger accounting data generated and stored in shared SLA tables prior to transfer to GL , and this is achieved by running “Create Accounting” to populate SLA tables(Very very similar to Payable events). Once this can be done , user can “View Accounting” only after “Create Accounting” is run and completed successfully.

Transferring Accounting information from AP/AR to GL in R12

The Create Accounting process has similar options, you can create accounting in Final or Draft mode and if Final mode is selected, the Transfer to GL parameter can be used to automatically transfer the accounting created by the corresponding run. When the Create Accounting process transfers the journal entries to GL it only transfers the accounting created by the process that calls it. If there is accounting created by the online option = Final or a previous Create Accounting program that was not transferred, that accounting will not be transferred. The Transfer Journal Entries to GL program needs to be ran separately to transfer any accounting created online or created by a previous Create Accounting process that did not transfer the entries.

redIs/was link an issue in 11i?

Yes, From Distributions to SLA

  • Create Accounting process
  • Applies accounting rules
  • Loads SLA tables, GL tables
    Creates detailed data per accounting rules,stores in SLA “distribution links” table


SLA Distribution Links Table

  • Must join through to get true Distribution ==> SLA journals matches
  • Holds finest granularity of accounting data
  • Multiple distributions may be aggregated into a few SLA journal lines


and Final picture looks like:


purpSLA Key attribute :Something called Event Model ? What is all about?

Event Model are basically definition of the sub ledger transaction types and there life cycle.

It has three levels

  • Event Entity: Highest level, often 1 per sub ledger application
  • Event Class: classifies transaction types for accounting rule purposes
  • Event Type: for each transaction type, defines possible actions with accounting significance.

It is very important that applications must tell SLA when an event has occurred.When a user runs the SLA Create Accounting program, it processes all events with the appropriate status

we have notice some of event classes in Payable and Receivable.

  • Payables
    • Invoice
    • Debit Memo
    • Prepayment
    • Payments
    • Refunds
  • Receivables
    • Invoice
    • Deposit
    • Receipt
    • Bill Receivable

and typical event Types are like

  • AP Invoice Events
    • Validated
    • Adjusted
    • Cancelled
  • AR Receipt Events
    • Created
    • Applied
    • Unapplied
    • Updated
    • Reversed

Posted in EBS Suite, R12, Release12 | 16 Comments »

Oracle – Check It out

Posted on November 21st, 2007 by Sanjit Anand ||Email This Post Email This Post

small is site, maintained & hosted by Oracle Corporation. It provides documentation on everything from industry trend analysis to application integration.The majority of the documents are submitted by Oracle partners companies .You can get wide range of topics, including data warehousing, ERP, grid computing, mobility, integration, electronic invoicing, software testing, BI, and much more. There are some good research documents on the site, really helpful.

Check it out.

Url :

Posted in Misc | 1 Comment »

Whats different EAM and Fixed Asset?

Posted on November 20th, 2007 by Sanjit Anand ||Email This Post Email This Post

Whats different EAM and Fixed Asset?

In Short, EAM – Enterprise Asset Management – deals mostly with asset management (physical – not financial) . Typical example are:

  • optimizing inspections
  • improving efficiency of work order and preventative maintenance programs
  • asset tracking from purchases through warranties
  • implementing effective equipment-based maintenance schedules to reduce downtime

Whereas Fixed Asset will achieve many of the same goals for financial management (streamlining, cost reductions etc.) , this mostly deal with deprecaition , disposal etc .

Posted in Oracle Asset, Oracle eAM | No Comments »

« Previous Entries