Contact Us

All Financials Functional Documents
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.


List of various functional articles covering topics like Oracle General Ledger, Oracle Receivables, Oracle Payables etc

User Rating: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive

What do I mean when I say Transaction Write-Offs?

If a customer’s transaction is outstanding for a longest period and we have no clue as to if the customer is going to pay or not, we cannot trace the customer and now we want to write-off that transaction. This is also called as Bad Debts.

How to enter bad debts in Oracle Receivables?

As per Oracle Receivable’s standard functionality: There is no such term in Receivables as Bad Debts. Receivables suggests that we “adjust” the particular transaction.  Adjustments is type of write off that will address our Bad Debt scenario.

These are setup and transactions steps for creating and entering Bad Debt Adjustments

Setup Steps:

  1. Create a Receivables Activity with Adjustment type, adjustment is called a receivable activity because it write offs the outstanding balance on customer.
  2. Assign Approval Limit of user to write off amounts. Obviously we cannot let anyone just write off the outstanding balance so we have to define the user’s limit.

Transaction Steps:

  1. Query the transaction to write off
  2. Adjust the transaction

Here are the details for Setups:

Read More Comment (2) Hits: 1675

Recent comments

  • We offer you several tools that will help you better services and complete the corrections made to your texts.
  • We offer you several tools that will help you better services and complete the corrections made to your texts.
View other comments

User Rating: 0 / 5

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

R12 Payment Manager (New Module)

  • 11i Payment Workbench is replaced with Oracle Payments
  • Oracle centralized all disbursement activities into one application to reduce redundancy across the apps
  • Oracle Payments also manages the interfaces between E-Business Suite products and financial institutions such as banks and credit card processors
  • Utilizes a dashboard to guide users to take actions on payments
  • Utilizes payment templates that have the ability to fully automate the payment process from selection of invoices, to printing or electronic transmission


  • Payment Dashboard

Monitor the progress of the recent pay run processes

Highlight any payment processes that require attention and automatically prompt to take appropriate actions

Shortcuts and tabs for initiating, reviewing and adjusting proposed funds disbursements.

  • Payment Templates
  1. Templates provide a way to store section criteria, payment attributes, and processing rules that can be reused for single pay runs or scheduled pay runs.
  2. EBS will update the dates based on information in the template
  • Pre-defined payment instructions
  • Includes the invoice selection criteria
  • Includes instructions on how validation failures are going to be handled.
  • Payment Submission R12
  1. Select Payment Template
  2. Run Cash Requirements Report <optional>
    1. By Submitting  Single Request by Entering Payment Process Name <similar to Batch Name in 11i>
    2.  View Selected Invoices online

b. Oracle will automatically generate the Scheduled Payment Selection Report

    Which is the equivalent to the Preliminary Payment Register in 11i

  1. Add Invoices, Update Amounts or Unselect Invoices to be paid
  2. Submit Payment
  3.  Format Payment
  4.  Print/Transmit Payments
  5.  Confirm Payments
  6.  Run the Payment Register


Multi-Org Access Control’ (MOAC)

Multi-Org or multiple organization access (MOAC) is basically the ability to access multiple operating units from a single application responsibility. In Release 11i, when one had to enter or process data for multiple operating units, one had to login to different responsibilities because each responsibility could only access one operating unit. If one was managing Payables for Sweden, Norway and Finland one needed to define three different responsibilities. In Release 12, one would create a Security Profile and assign as many operating units as you required. One can tie that security profile to a single responsibility using a profile option called “MO: Security Profile”.

Benefits of MOAC_

  • Access multiple operating units within a single application responsibility
  • Responsibilities are assigned a Security Profile which is a group of Operating Units
  • Assignment is through the profile option ‘MO: Security Profile’ set at the Responsibility Level
  • MOAC Setup includes-
    • Define Operating Units in HR
    • Define Security Profile composed of Operating Units
    • Run Security List Maintenance Program
    • Assign Security Profile to Profile Option
    • Profile Options
    • MO: Operating Unit

    - Used when Multi-Org is NOT enabled

    - On upgrade, assigned operating unit of 11i responsibility

  • MO: Security Profile

    - Assign security profile name at User or Responsibility level

  • MO: Default Operating Unit - Assign default operating unit

R12 General Ledger new feature

  • We can generate simultaneous Accounting for Multiple Reporting Requirements by defining legal entities and the setup needed to address each accounting and reporting requirement using the Accounting Setup Manager.
  • Centralized Accounting Setup- is a central location to define accounting-related setup across all financial applications.
  • Enhanced Reporting Currency Functionality and support all journal sources.
  • Improved Processing Efficiency:

•   Simultaneous Data Access to Multiple Legal Entities and Ledgers

•   Simultaneous Opening and Closing of Periods for Multiple Ledgers

•   Cross-Ledger and Foreign Currency Allocations

•   Simultaneous Currency Translation of Multiple Ledgers

•   Financial Reporting Across Ledgers

•   Automatic Journal Copy

•   Streamline Automatic Posting

•   Streamline AutoReversal Criteria Setup

•   Streamline Consolidation Mappings

•   Replacement for Disabled Accounts

  • Data Security:

•   Data Security across Legal Entities and Ledgers

•   Management Reporting Security

•   Prevent Reversal of Journals with Frozen Sources

•   Prevent Reversal of Unposted Journals

•   Control Accounts

•   Definition and Setup Security

• Auditability for Journal Line Reconciliation

• Entered Currency Reporting and Analysis

• Foreign Currency Recurring Journals

• Intercompany Balancing Support for Encumbrances

• Integration with Subledger Accounting

• Intercompany feature enhanced: This is now part of Oracle Advanced Intercompany System     product.

• Account Analysis and Drilldown is a new web-based interface that allows to easily review and analyze general ledger financial data. 

• GL Standard Reports Integration With XML Publisher

• New Terms: Ledger replaces Set of Books. A group of Ledger is called Ledger set, in a Ledger Sets, user can simultaneously-

  • Open/Close Periods
  • Create Journals
  • Translate and Revalue Balances
  • View Information
  • Submit Standard Reports
  • Submit Financial Statements

Sub Ledger Accounting Flow Chartà

Accounting Setup Manager in R12- There is a single page for setups-



R12 Account Payables new feature

  • Legal Entity: New addition to the Oracle E-Business Suite that enhances the ability to manage one’s legal corporate structure and track data from the legal perspective.
    Read More Comment (0) Hits: 3734

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

In large implementations with large transaction base in GL, it is very common to get java.lang.OutOfMemoryError" errors in the Output Post Processor log of the Subledger Accounting program Account Analysis Report. This report produces the output in BI Publisher.

To resolve this, you need to implement the steps below
1. Navigate to XML Publisher Administrator responsibility

2. Click Administration->Configuration

Read More Comment (6) Hits: 11600

Recent comments

  • Guest - coach factory outlet

    coach factory outlet http://www.coachfactoryoutletonlineeo.com
  • Guest - coach outlet online

    welcome to coach outlet online
  • Guest - louis vuitton uk

    thank you http://www.louisvuittonoutletuki.co.uk
View other comments

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

This article contains step by step implementation guide with examples for EBiz Tax in R12.

IMPORTANT - To view this article, you must have access to http://docs.google.com

It will take upto a minute for this document to load.

Read More Comment (29) Hits: 55033

Recent comments

  • Guest - issue with OM

    Hi Anil, <br />Have you come across any situtation where in the hold is released and not able to view the hold from front end . but when we pick release the order on the pick release debug we see the following error <br />We had implemented EBTAX and updated the tax codes on the open sal...
  • Guest - Bhavika

    Hi, been seeing lot of documents and blogs about you....deep it going...i like the knowledge sharing by you...this was great document in oracle apps for ebusiness tax....can you prepare few more giving examples for EMEA regions too Thanks Bhavika
  • Guest - R. Narasimhan

    Hi Anil Your article seems to be very nice, Could you please either share the document or send me the download link. By the way, if you could provide some detail on configuring subledger accounting for E-Biz Tax, that will be wonderful. Thanks & Best Regards S.R. Narasimhan...
View other comments

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

Very often the GL Super Users create manual journals either directly from the screens or using the Web ADI to upload the journals straight into General Ledger. However account codes used in these manual journals are secured via value set security and the cross validation rules. But this level of security is not enough. For the sake of an example, the GL Users must not be allowed to tamper with the amount of expenditure a company has made on Office Furniture for their offices. Let us say that all the GL Account segment value Office Furniture related expenses are 5115.

A feature named Third Party account is a feature of R12 which helps keep the Subledger like Payables or Receivables in sync with General Ledger.

The control account functionality of 11i is now called Third Party account in R12. Some accounts should only be entered via the Subledger, and not be allowed for manual journal creation in GL. Hence for those entries, we can enable the qualifier to flag those as Third Party account.
In the value set definition screen, query the segment value as shown in image below. In this case, the Account Segment value is 5115. Against the segment qualifier, in Third Party Control Account, select value = Supplier, because in this example we will control the charges to this account segment via Payables whilst ensuring that Supplier details are specified. In other words, this configuration will ensure that you cannot put a charge against office supplier into GL unless you have specified the Supplier from whom the goods were purchased.

Read More Comment (17) Hits: 45601

Recent comments

  • The Third Party Control Account characteristic in the Oracle E-Business group enables corporation to continue comprehensive balances, by third party for an explanation code amalgamation.
  • Guest - NICE

    Hi ,<br /><br />Had one query ,will this have a impact on vendor ledger when i am passing the jv with specific vendor and site.
  • Guest - Harold Schmitt

    thanks for the clear explanation on control accounts..
View other comments

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jan 2017  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  2  3  4  5  6  7  8

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner