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

Happy New Year 2012 To All My Readers

Posted on December 30th, 2011 by Sanjit Anand ||Email This Post Email This Post

Now we are entering into a whole New Year and what would be a better time to thank and wish blog readers than the wonderful New Year 2012?.

I take this opportunity to wish every reader of my blog a Happy, creative and Prosperous New Year 2012.

There are around two thousand e-mail subscribers and around 1 lakh views of this blogs each month across the globe. Hope the same kind of cooperation, comment and suggestion will be provided to us and that will further help to upgrade the standard of blog postings.

Posted in News | No Comments »

Mobile Version of Now Available

Posted on December 29th, 2011 by Sanjit Anand ||Email This Post Email This Post

I’m delighted to announce the mobile version of Oracleappshub is now available.

If you access this blog from an iphone, ipad, android or other mobile device, the site will automatically switch to the mobile version.

Simply type in the standard url of and you will be able to view and read the content easily on your handheld.

Read the rest of this entry »

Posted in News | 1 Comment »

“Refund” Payments Functionality in R12

Posted on December 29th, 2011 by Sanjit Anand ||Email This Post Email This Post

In previous Post you have seen the functional overview for Refund Functionality in R12. This post will give more insight.

dgreybarrowWHAT IS REFUND

Refund is kind of a single payment to a supplier or customer, usually to reimburse them for:

  • one or more credit/debit memos on their supplier account in Oracle Payables
  • one or more credit/debit memos on their customer account in Oracle Receivables

dgreybarrow SENARIOS …

In order to understand, presume you want to stop doing Business with a supplier

  • You have an overall $100 credit balance with the supplier,which consists of a Credit Memo of $250 and an unpaid Invoice of $150
  • The supplier sends you a $100 refund for the credit balance.
  • You enter a $100 Refund Payment (a $100 negative payment), and on the Select Invoices window, you select the outstanding invoice and credit memo.

Once you save the Refund Payment, the invoice and credit memo are marked as paid, and you have no outstanding documents for the supplier


  • You need to do a set up the bank account in which you will deposit the refund. This can be the same bank account you use to make payments.
  • Set up the appropriate cash account and, make sure cash clearing account is setup correctly
  • The Payables documents you select must be in the same currency as the refund currency, and the sum of the documents you select must
    equal the amount of the refund.

dgreybarrowTAKE AWAY

When you have debit/credit memo on a supplier or employee account (generally due to over payments or returns) which cannot be
matched directly to any existing open invoices, the supplier or employee may send you a refund for the memos. In that case, you can record the “refund” against those memo(s) by recording a “refund” type of payment in the Payment Workbench.

  • A Refund payment is a “negative” dollar amount payment issued to record the reimbursement received, and to clear the specified memo(s)
    (and possibly, invoices) from the Aging Report.
  • A Refund Payment can also be used to clear a credit balance on a supplier’s or employee’s account, and can consist of any combination of
    the following documents, as long as the sum is negative and equals the refund amount:

    • Invoices and/or Expense Reports
    • Debit and/or Credit Memos
  • Refund Payments can also be used to reimburse you for a Prepayment you paid to a supplier or employee that was later determined to be

    • If you receive a refund of a Prepayment, enter an invoice and apply the prepayment (if the Prepayment has not already been applied to an invoice),then enter a Debit Memo for the invoice.
    • You can then pay the Debit Memo with the Refund Payment.
  • Paying documents with a Refund Payment marks each selected document as paid, clears them from the Aging Report, and gives you a
    complete supplier/employee transaction history.
  • When you record a refund, Payables debits either your cash or cash clearing account, and credits either your expense or liability account,
    depending on whether you use cash or accrual accounting.
  • You can take discounts on payable documents (invoices/memos) that you mark as paid with a refund.


You can void a recorded Refund just as you would any other payment.

  • Query up, then select the Refund in the Payments Workbench window.
  • Choose the Actions button, and use the Void option in the Payment Actions window. You can then re-enter the refund and pay any open
    and applicable invoices/memos or prepayments for the supplier/employee.

Hope this helps you to understand the refund functionlity.

dgreybarrow Suggesting Reading

Posted in Oracle Payable | No Comments »

Refund Functionality in R12

Posted on December 28th, 2011 by Sanjit Anand ||Email This Post Email This Post

In response to a reader’s query here is small note on EBS refund functionality.

dgreybarrow Refund processing for the Supplier and Employee

When a supplier or employee sends a refund for an invoice payment that have made, record the refund can be recorded in Payables. A refund closes out an outstanding credit balance, so you are actually making a negative payment for a credit balance. The credit balance can consist of the outstanding balance of any combination of the following documents, as long as the sum is negative and equals the refund amount:

  • Invoices
  • Debit memos
  • Credit memos
  • Expense report

Paying these documents with a refund records each document as paid, and gives you a complete supplier transaction history.

dgreybarrow Refund processing for the Customer

R12 There are two refund Options Available

  1. Initiation of a customer refund by application of a credit or unapplied cash to a refund receivables activity
  2. Automated refund generation based on credit memos generated by Auto invoice
    • Check refunds
    • Credit card refunds

In R12, the refund process has been automated for non-credit card transactions from Oracle AR module. For credit card transactions, refunds are applied to the same credit cards used on the transactions in Account Receivables. For non-credit card transactions, refunds are processed via AP. Receivables submit the refund request to AP, and in turn AP transacts refunds via Oracle Payments after gong through the approval process. To view the status of the refund, one can select the button “Refund Status” off the Receipt Application window which brings to the AP workbench. Following are the Refund process generated at receivable and then pass to payable to further processing and payment
Refund Processing

Those who does not use Oracle AR as receivable, the refund data with customer basic information are fed into the Payable invoice where Customer will be created as one time supplier with minimum setup and check will be generated against the invoices created from refund data.

In case if you need some more thoughts on setup and steps , drop me offline

Posted in Oracle Payable, Oracle Receivable | No Comments »

Fusion Application Security

Posted on December 14th, 2011 by Sanjit Anand ||Email This Post Email This Post

Oracle Fusion Applications is very secure and security approach consists of tightly coordinating the following aspects of security.

  • Role-based access control (RBAC)
  • Function security via OPSS
  • Standard Data security
  • Privacy
  • Access provisioning and identity management
  • Segregation of duties policies
  • Enforcement across tools, technologies, data transformations, and access methods

The Oracle Fusion Applications security approach supports a reference implementation of roles and security policies that address common business needs.

dgreybarrow Fusion Application Security Architecture

As a first step, you need to understand what security capabilities are offered by Fusion Application. The figure below illustrates the Fusion Application Security .

(Click on the image to enlarge it)


As per architecture you can see lot many security tools are been used . some of them as:

  1. Single Sign on
    • Oracle Access Manager (OAM)
  2. Identity Management Tools
    • Oracle Identity Manager (OIM)
    • OIM SPML Interface
    • Identity Governance Framework (IGF)
    • Oracle Virtual Directory (OVD)
    • Oracle Internet Directory (OID)
  3. Authorization Management tools
    • Authorization Policy Manager (APM)

Posted in Fusion Application | No Comments »

What is Oracle Applications Manager (OAM)?

Posted on December 12th, 2011 by Sanjit Anand ||Email This Post Email This Post

Oracle Applications Manager (OAM) is a sophisticated (aka web-based EBS management) tool that supports managing and monitoring of an Oracle Applications system from an HTML based central control console.

With Oracle Applications Manager, system administrators can view information on general system activity including the statuses of the database, concurrent managers and other services, concurrent requests, and Oracle Workflow processes.

OAM provides a summary of configuration changes, infrastructure usage, performance, required maintenance activities, potential security issues, status of business flows, and diagnostic test results. In addition, they can manage downtime and patching. System administrators can also start or stop services, and submit concurrent requests.

OAM utilities are generally available from two main screens: the Applications Dashboard and Site Map.

Among other tasks, Oracle Applications Manager can help you to:

  • Configure and administer your system :System Administrators can check the status of an EBS instance’s database, concurrent managers and other services, concurrent requests, and Workflow processes
  • Diagnose and correct problems
  • Manage patches – available free from OAM
  • Monitor and tune performance
  • Monitor system security
  • You can also manage initialization parameters and profile options
  • Recommended tool for making changes to AutoConfig


OAM is built into Oracle Applications and complements the features of Oracle Enterprise Manager and mostly used by DBA’s or system admin.

Addition Note

  • MetaLink Note: 387859.1 “Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12”

Posted in Tool | No Comments »