Oracle eBS R12 customers can co-exist with Fusion Accounting Hub

Uncategorized
| Nov 23, 2012
Existing Oracle eBS customers who are on R12 can leverage the features of Fusion General Ledger and extensive reporting capabilities of Oracle Fusion without re-implementing or upgrading the entire sub-ledger system to Fusion ecosystem through a co-existence configuration setup using Fusion Accounting Hub (FAH).
Oracle Fusion Accounting Hub, comes embedded with Essbase multidimensional cube that can be leveraged to derive business benefits through BI analytics, Smartview reporting, Financial Studio reporting, Account Monitor and Account Inspector and a very intuitive Allocation Manager for creating Allocation rules.
Using GoldenGate, a seamless integration between Oracle eBS and FAH has been provided. GL actual (more...)

Fusion Applications Security

Uncategorized
| Nov 15, 2012
The Fusion security architecture in Fusion is quite different from EBS and relates to real world scenarios better. Fusion security is externalized from Applications and moved to standardized Fusion Middleware, OPSS and LDAP.

Management of enterprise users and roles in fusion applications is done via Oracle Identity Manager (OIM). OIM manages this data in a database and keeps it in sync with the LDAP directory.

Management of enterprise users and roles in fusion applications is done via Oracle Identity Manager (OIM). OIM manages this data in a database and keeps it in sync with the LDAP directory. OAM is authentication, (more...)

Oracle Fusion Install – On premise (Bare Metal, OVM) or Hosted

Uncategorized
| Aug 21, 2012
Whoever is implementing Oracle Fusion will definitely have to answer the following question; 
Do you need to have the Oracle Fusion environment hosted on your premises or do you want to host with a third party or host this in Oracle via the Saas or OnDemand model?
To add some more complexity, Oracle provides you with option either to install the application on 'bare metal' or leverage Oracle Virtual Machines (OVM) to host all components.
Our experience has been that the fastest and easiest way to get going is if you use hosting service of Oracle or some third-party. However, the (more...)

Oracle Fusion Applications – Next generation in ERP

Uncategorized
| Aug 21, 2012

Oracle Fusion Apps is the next generation in ERP space. It's completely web-based and takes in the best in class of all products under the Oracle umbrella. Some truely world-class features include the following:
- co-exist with third party legacy applications, thereby giving huge business benefits where customers have already invested heavily in legacy applications and want to plug and play Fusion Apps with existing system.
- Best in class user roles and responsibility features. Truely amazing if we compare this with R11i and R12 stack of products.
- Complete web-based solution, so no hassles of installing client thin or (more...)

Invoice Image Processing Architecture in Fusion Payables

Uncategorized
| Dec 29, 2011

Fusion Payables is tightly integrated with Oracle Document Capture (ODC), Oracle Imaging and Process Management (IPM), Oracle Content Management and Oracle BPEL process Manager to provide a seamlessly integrated solution supporting the entire payables cycle starting from scanning of physical invoices, invoice image recognizition using OCR to pre-populate invoice header, routing of (more...)

Reference Data Set

Uncategorized
| Dec 18, 2011
This is a new concept that has come in Fusion. Reference Data sets are logical groups which provides the enterprise to decide which business unit access the reference data groups, such as grades, locations, AR & AP payment terms, departments, and jobs. Oracle provides a default Reference Data set which can be used across all Business units. However, we can define our own Reference data sets, to partition the data from effectively.
E.g. in R12 we had to live with the entire list AR payment irrespective to the fact whether one OU was using it or not. however, in (more...)

Google map in Fusion Apps

Uncategorized
| Dec 9, 2011
Now we can locate all our employees, suppliers, customers addresses in Fusion through Google Maps.

Business Units and Shared Service model in Fusion Procurement

Uncategorized
| Dec 9, 2011

Business Units (BU) definition: A business unit is a unit of an enterprise that performs one or many business functions that can be rolled up in a management hierarchy. A business unit can process transactions on behalf of many legal entities. Normally, it will have a manager, strategic objectives, a level of autonomy, and responsibility for its profit and loss. (1)

Prior to Oracle Fusion (more...)

Payables Hold Release Workflow

Uncategorized
| Apr 28, 2011
In R12 Oracle Payables integrates with Oracle Workflow to provide a resolution of user releasable holds through workflow. A new transaction type called “Payables Hold Resolution” (APHLD) in AME has been introduced in R12 for the same. There has been a business requirement to release the AP invoice holds, especially the matching holds based on an approval mechanism. In R12 of Payables, this feature has been provided so that, we can send the invoice lines on hold to approvers before the hold is released. As usual the seeded AME objects can be extended to accommodate different approval groups, rules and (more...)

Open Account AP Balance Listing

Uncategorized
| Feb 11, 2011
As per Metalink Note 604739.1, the AP Trial Balance has been replaced by the Open Account AP Balance Listing in R12. This report is a variation on the more general Open Account Balances Listing, and shows basically the outstanding amount (liability) for all open AP invoices. The balance should match your AP liability account(s) in General Ledger. Users can create their own layout and publish their custom reports using Oracle XML Publisher.

R12: You can make a payment run across multiple OU’s

Uncategorized
| Nov 18, 2010
In R12, the payments process has undergone quite a bit of change. Earlier in R11i, one could only process payments for one OU, because the internal (disbursing) bank was associated to an OU. However, in R12, internal banks are set for an LE which could be in turn associated to one or more OU's. Hence, its possible that while doing a payment run, you can process all invoices from your internal bank across invoices raised under different OU's.

What to Convert in GL: Balance or Transaction Detail

Uncategorized
| Aug 21, 2010
A key question which all consultants face while handling GL conversion is what to convert, whether to convert the prior period balances or to convert the detailed transactions.
Typically most organisations while converting GL from a legacy system bring in only the balances data and very rarely do we bring in the transactions details. The reasons for the same is as follows:
1. Usually there is a change in COA while moving from legacy GL to Oracle GL, hence the code combination would never be the same in legacy and Oracle.
2. Drill down from Oracle GL to Oracle sub-ledger (more...)

Retainage and Retainage Release in Or…

Uncategorized
| Jan 7, 2010
Retainage and Retainage Release in Oracle Payables for a Complex Purchase Order

Retainage represents funds withheld from payment to ensure that the contractor finishes work as agreed. The buying organization releases these funds only after verifying that the contractor has fulfilled all contractual obligations. Retainage is also called "retention" or "contractual withholds".
With Oracle's Complex Work feature, contract administrator can negotiate retainage terms with the contractor and capture these as part of the contract. These terms include Retainage Rate and Maximum Retainage Amount.

Retainage Rate
The Retainage Rate determines the percentage of the amount requested that will be withheld before (more...)

Recording a Refund of a Prepayment or Advance

Uncategorized
| Nov 18, 2009
The other day someone asked me how to do we collect a refund from an employee to whom we have made an advance payment (prepayment). There are a couple of approaches that can be used. The same approach applies to refund from suppliers as well.
Approach 1: Invoice to retire the prepayment and then Debit Memo for refund.
Step1: Create a standard invoice and apply the remaining amount of prepayment to it.
Step2: Then enter a debit memo and pay it with a Refund payment in the Payments window.The result will be that the outstanding prepayment / advance (more...)

Too many Managers spoil the project

Uncategorized
| Jul 19, 2009

All of us in our childhood must have heard of the proverb "Too many cooks spoil the broth". If too many people try to take charge of a task, the end product might be ruined. This applies to any task like an implementation project as well.An easy way to identify if the project is going awry is when you find many people following up to find the status of the job being done. In one of my earlier projects there was one developer writing a piece of code and there were four managers chasing the poor lady for updates (more...)

Learn using Sub Ledger Accounting (SLA) in R12 Oracle Payables

Uncategorized
| Dec 7, 2008

Sub Ledger Accounting (SLA) is a Rule-Based accounting engine that defines how journal entries are generated in sub-ledger transactions in Oracle sub-ledger applications. However, SLA also supports external applications generating accounting information which ultimately needs to be transferred to Oracle General Ledger. Before we get into SLA we need to know few of the basic concepts like event types, event class, etc.

Event Class - classifies transaction types for accounting rule purposes. E.g. in Payables, following are possible event classes: Invoice, Debit Memo, Prepayments, Refunds and Payments.

Event Type - for each transaction type, defines possible actions with accounting (more...)

Payables Duplicate Invoices

Uncategorized
| Nov 9, 2008

A common requirement that is there in almost all Payables department is to identify potential duplicate invoices. The standard Oracle report 'Invoice Audit Listing' is not effective when it comes to list down potential duplicate invoices. The 'Invoice Audit Listing' is more of a listing and the payables manager has to spend time and effort in analysing this report. Also, not to mention when it comes to performance this report takes quite a while to complete if you mention a very old 'Begin Invoice date'.

A common requirement that comes to my mind is to report all invoices which are (more...)

Indian Megavendors

Uncategorized
| Sep 3, 2008

The other day i was reading an article in http://specials.rediff.com/money/2008/aug/13slide1.htm on India's top three IT companies. As per this article, Gartner has come out with a report in which they predict that, Tata Consultancy Services, Infosys Technologies, and Wipro Technologies, collectively referred as 'India-3,' will emerge as the next generation of IT service megavendors. These vendors are increasingly being considered for strategic service deals, and will augment or, in some cases, replace today's acknowledged megavendors by revenue -- IBM Global Services, Accenture and EDS -- in this space by 2011, says Gartner.

Obviously this means there will (more...)

Importing Payments and Paid Invoices into Oracle – Oracle needs to provide an API

Uncategorized
| Aug 31, 2008
How many of us had a requirement of importing paid invoices and their corressponding payment details to Oracle? I would say many. But strangely till date there in no straight forward method to import payments into Oracle. I feel its time that Oracle comes up with a standard process like an API to handle this business need.
There are a few workarounds to this scenario. A direct update of Oracle base table is one but this comes with the risk of losing support from Oracle.
The other, more robust way would be to use the manual payment feature of Oracle (more...)

Oracle E-Business Tax: Regime to Rate Flow in Oracle R12

Uncategorized
| Aug 11, 2008

In Oracle Release12, there has been some very significant changes, one among them being how we define tax. E-Business Tax is now a single point where we define our taxes for all the sub-ledger modules. In this article I will try to do a sample Tax setup using the Regime to Rate Flow of Oracle E-Business Tax in the Tax Manager responsibility.

Creating a Tax Regime

In Oracle E-Business Tax, a Tax Regime is the system of regulations for the determination and administration of one or more taxes.

  1. Navigate to the Create Tax Regime:

• Navigation: Tax Configuration àTax (more...)