New feature of General Ledger in R12

Accounting Setup Manager
The ledger is a basic concept in Release 12. The ledger replaces the 11i concept of a set of books. It represents an accounting representation for one or more legal entities or for a business need such as consolidation or management reporting. Companies can now clearly and efficiently model its legal entities and their accounting representations in Release 12. This seems to be a major area in getting success of the shared service center and single instance initiatives where many or all legal entities of an enterprise are accounted for in a single instance, and data, setup, and processing must be effectively secured but also possibly shared.
Now, legal Entities can be mapped to entire Ledgers or if you account for more than one legal entity within a ledger, you can map a legal entity to balancing segments within a ledger.
While a set of books is defined by 3 C’s,
  1. chart of accounts
  2. functional currency
  3. accounting calendar,
The addition in this list the ledger is defined by a 4th C: the accounting method,
This 4th C allows you to assign and manage a specific accounting method for each ledger. Therefore, when a legal entity is subject to multiple reporting requirements, separate ledgers can be used to record the accounting information.
Accounting Setup Manager is a new feature that allows you to set up your common financial setup components from a central location.
What is Accounting Setup Manager
Accounting Setup Manager is a new feature that streamlines the setup and implementation of Oracle Financial Applications. The Accounting Setup Manager will facilitate the setup required for simultaneous accounting for multiple reporting requirements.
With the Accounting Setup Manager, you can perform and maintain the following common setup components from a central location:
  • Legal Entities
  • Ledgers, primary and secondary
  • Operating Units, which are assigned to primary ledgers
  • Reporting Currencies, which is an enhanced feature
  • Subledger Accounting Options. This is where you define the accounting methods for each legal entity subledger transaction and associate them to the ledger where the accounting will be stored.
  • Intercompany Accounts and Balancing Rules
  • Accounting and Reporting Sequencing
  • Both Intercompany and Sequencing
Will discuss some more granular details in some other post.
Subledger Accounting (SLA)
As discussed in couple of earlier post GL is integrated with SLA to enable a unified process to account for subledger transactions and post data to GL, and to provide a consistent view when drilling down from GL to subledger transactions. You can read here.

Enhanced Foreign Currency Processing by Reporting Made easy
GL has added new features and enhanced existing features to support foreign currency processing , they are mainly as:
  • In R12, MRC feature is enhanced with a feature call Reporting Currencies. That mean it will now support multiple currency representations of data from any source, including external systems, Oracle or non-Oracle subledgers, and Oracle General Ledger journals and balances.
  • The second one is in reporting to view balances view balances that were entered in your ledger currency separate from those balances that were entered and converted to the ledger currency.The change in R12 is that balances entered in the ledger currency are maintained separately from balances converted to the ledger currency for use in Reporting and Analysis.
Here’s an example. Assume we have a ledger and the ledger currency is USD.
I enter and post two journals; one in 1,000 US Dollars, and another in 500 British Pounds that gets converted to 1200 US Dollars.
In Release 11i, I can review the 500 GBP and the 1200 USD that results from converting the 500 GBP, and the total 2200 USD which is the USD balance in the Cash Account. The $2200 is the sum of the $1000 entered in USD and the $1200 converted from the 500 British Pounds. However, I view that a 1000 USD were entered directly in USD.
In Release 12, I can view the 1000 USD by performing an account inquiry on the Cash account for balances entered only in the ledger currency. The amounts entered in foreign currencies that were converted to the ledger currency will not be included in the balance. Of course, if I want to retrieve all balances in USD, both the entered as well and the converted, I can still do that in Release 12.

Common Questions in GL(General Ledger) R12

GL- Questions
1. What are the application objects that support View Accounting and Drilldown?
GL_Import_Reference_Table (modified) For Example Invoices imported from Payables into GL goes to these tables from GL_Inerface table.
GL_SL_LINK_ID
GL_SL_LINK_TABLE
GL_JE_LINES (modified)
GL_SL_LINK_ID
GL_SL_LINK_TABLE
New views in the database:
FA_AEL_GL_V
FA_AEL_SL_MRC_V
FA_AEL_SL_V
2. Where in Oracle General Ledger 11i can Drilldown be accessed?
You can drilldown from GL Account Inquiry window and the GL Journal Entry and GL Journal Inquiry windows.
(N) Tools -> Drilldown Open the Journal entry in GL and go to Tools – drilldown, its shows u the origin of the journal entry. It is used only for viewing the origin of the journal entry.
3. What are the Release 11i Sub-ledger drilldown features?
Expanded Subledger drilldown to other subledgers.
View Accounting Lines window.
4. What are recurring invoices? What are AP setup steps?
Some times suppliers would not be sending any invoices, but still the payment have to be made to him. Ex: rent, lease rentals. In this situation we have to create invoice every period wise. For that purpose we have to create one recurring invoice template. Template means with one master copy creating the multiple invoices. Here we are creating the one invoice master copy is formally known as recurring invoice or recurring invoice template.
Setup: 1) Create one special calendar
2) Create one full distribution set
3) Enter payment terms in the recurring invoice window
4) Enter the template no., first invoice amount, special invoice amounts.
Recurring Entries are of 3 types-
1. Standard,
2. Skeleton,
3. Fornulae Based
In GL Module
1.Define Formula Batch (e.g. ABC Rent batch)
2.Enter Lines (Here u have both Debit as well as Credit lines)
3.Generate Recurring period
4.Review Journal Batch
5.Post the batch
1. Standard Recurring Journal: It is used for same accounts & same amounts e.g.
Utilities Dr
Cash Cr
2. Skeleton Recurring Journal: It is used for same accounts but for different amounts, e.g.
Recurring Fee Dr
Cash Cr
3.Formule Based Journal: It is used for different accounts with different amounts, e.g.
Salaries Dr
Cash Cr
5. If any conflict occurs in FSG who will override; Column Set or Row Set?
The override component is row set. However some times it depend on the column set also.

Introduction to seo

Introduction to seo

   This document is intended for webmasters and site owners who want to investigate the issues of seo (search engine optimization) and promotion of their resources. It is mainly aimed at beginners, although I hope that experienced webmasters will also find something new and interesting here. There are many articles on seo on the Internet and this text is an attempt to gather some of this information into a single consistent document.

   Information presented in this text can be divided into several parts:
   - Clear-cut seo recommendations, practical guidelines.
   - Theoretical information that we think any seo specialist should know.
   - Seo tips, observations, recommendations from experience, other seo sources, etc.

1. General seo information

1.1 History of search engines
   In the early days of Internet development, its users were a privileged minority and the amount of available information was relatively small. Access was mainly restricted to employees of various universities and laboratories who used it to access scientific information. In those days, the problem of finding information on the Internet was not nearly as critical as it is now.

   Site directories were one of the first methods used to facilitate access to information resources on the network. Links to these resources were grouped by topic. Yahoo was the first project of this kind opened in April 1994. As the number of sites in the Yahoo directory inexorably increased, the developers of Yahoo made the directory searchable. Of course, it was not a search engine in its true form because searching was limited to those resources who’s listings were put into the directory. It did not actively seek out resources and the concept of seo was yet to arrive.

   Such link directories have been used extensively in the past, but nowadays they have lost much of their popularity. The reason is simple – even modern directories with lots of resources only provide information on a tiny fraction of the Internet. For example, the largest directory on the network is currently DMOZ (or Open Directory Project). It contains information on about five million resources. Compare this with the Google search engine database containing more than eight billion documents.

   The WebCrawler project started in 1994 and was the first full-featured search engine. The Lycos and AltaVista search engines appeared in 1995 and for many years Alta Vista was the major player in this field.

   In 1997 Sergey Brin and Larry Page created Google as a research project at Stanford University. Google is now the most popular search engine in the world.

   Currently, there are three leading international search engines – Google, Yahoo and MSN Search. They each have their own databases and search algorithms. Many other search engines use results originating from these three major search engines and the same seo expertise can be applied to all of them. For example, the AOL search engine (search.aol.com) uses the Google database while AltaVista, Lycos and AllTheWeb all use the Yahoo database.

What is Seo, Why SEO

What SEO Is

Search Engine Optimization refers to the collection of techniques and practices that allow a site to get more traffic from search engines (Google, Yahoo, Microsoft). SEO can be divided into two main areas: off-page SEO (work that takes place separate from the website) and on-page SEO (website changes to make your website rank better). This tutorial will cover both areas in detail! Remember, a website is not fully optimized for search engines unless it employs both on and off-page SEO.

What SEO Is Not

SEO is not purchasing the number #1 sponsored link through Google Adwords and proclaiming that you have a #1 ranking on Google. Purchasing paid placements on search engines is a type of Search Engine Marketing (SEM), and is not covered in this tutorial.
SEO is not ranking #1 for your company's name. If you're reading this tutorial, you probably already know that ranking for popular terms is darn near impossible, but specific terms, such as a company name, is a freebie. The search engines usually are smart enough to award you that rank by default (unless you are being penalized).

Who Uses SEO

If a website is currently ranked #10 on Google for the search phrase, "how to make egg rolls," but wants to rise to #1, this websites needs to consider SEO. Because search engines have become more and more popular on the web, nearly anyone trying to get seen on the web can benefit from a little SEO loving.

stock market dealer

Stock Markets always remembers us Bull and Bear. But there are many other people who are not so familiar to common investors. Following is the brief introduction of those special people in the market:
Bear
A bear is a dealer on a stock exchange , currency or commodity market, who expects prices to fall.
A bear market is one in which a dealer is more likely to sell securities, currency of goods without having them. This is know as selling short or establishing a bear position. The bear hopes to close (or cover) such a short position by buying in at a lower price the securities, currency or goods already sold. The different between the purchase price and original sale price represents the successful bear’s profit.
A concerted attempt to force prices down by a powerful bear (or a group of them) by resorting to sustained selling is called a bear raid.
Bull
A dealer on a stock exchange, currency or commodity market, who expect prices to rise is called a bull.
A bull market is one in which a dealer is more likely to be a buyer than a seller, even to the extent of buying for his or her own account and establishing a bull position.
A bull with a long position hopes to sell the purchases at a higher price after the market has risen. A bull position or long position occurs when the bull owns securities.
Chicken
Chicken are afraid to lose anything. Their fear overrides their need to make profits and so they turn only to money-market securities or get out of the markets all together.
While it’s turn that you should never invest into something over which you lose sleep, you are also guaranteed never to see any return if you avoid the market completely and never take any risk.
Jobber
A jobber is an independent dealer in securities. He purchases and sells securities in his own name. He is not allowed to deal with non-members directly.
Pig
Pigs are high-risk investors looking for the one ‘big’ score in a short period of time. Pigs buy on hot tips and invest in companies without doing their due diligence.
Pigs get impatient, greedy, and emotional about their investments, and they are drawn to high-risk securities without putting in the proper time or money to learn about these investment vehicles.
Professional traders love the pigs, as it is often from their losses that the bulls and bears reap their profits.
Stag
A stag is a speculator who buys a large amount of shares in a new issues of shares (like as IPO-Initial Public Offering) if he thinks the price is likely to rise above the offer price when trading in that scrip begins on the stock exchange. A
Stag indulges in this kind of speculation with the hope to sell soon at profit