Oracle General Ledger

Things to Ponder:

• If you try to enter an unbalanced journal, Oracle GL will either reject the transaction or force the transaction to balance by posting the difference to a suspense account.
  

Oracle PIM

Oracle Product Information Management (also called Advanced Product Catalog) has three main product components:

1. PIM Data Hub
2. PIM Data Librarian
3. Product Data Synchronization for GDSN and UCCnet Services

Oracle PIM Data Hub , an enterprise data management solution that enables customers to centralize all product information from heterogeneous systems, creating a single product repository that can be leveraged across all functional departments.

PIM Data Librarian is a new product released in May'05, offers an easy-to-use HTML/Windows interfaces for creating, managing, consolidating, enriching and standardizing product information. Provides secure way to share product info within enterprise and with partners.

All business rules in PIM are based on one important concept - Primary Hierarchy which classify products in Primary Item Master Catalog.

Attributes & Attribute Groups

You can define upto 70 attributes per attribute group but there can be unlimited attribute groups.

Concurrent Programs in PIM:

• Bulkload Program For Spread Sheet Upload
• Item/Item Revision Implement Pending Changes Concurrent Program
• Import Catalog Items - Java Concurrent Program to Bulkload items from the interface table.
• Item Org Import - Item Organization Assignment Import
• Item People Import
• Purge Item People Interface Lines - Purge Program for Item People Interface Lines
• Item/Item Revision User-Defined Attributes Concurrent Program - For importing User Attributes for Items and Item Revisions
• EGO Item Import Batch Matching Concurrent Program - EGO Bulk matching engine of the item import process
• Purge Item Massupdate Temporary Tables - Mass update Temporary table purge program
• Optimize Item Catalog Text Index
• EGO Spreadsheet Java Concurrent Program - EGO Java Loader to Bulkload Item, BOM Attrs, User-Defined Attrs, UCCnet Attrs
• Item Catalog Text Index Build - Create/Rebuild Item Catalog Text Index
• EGO Setup Default Organization for User
• Catalog Categories Assignment Open Interface - Import Catalog Categories Assignments from the Open Interface table
• User-Defined Attribute Groups View (AGV) Compilation Executable

PL/SQL Errors

In PL/SQL, a warning or error condition is called an exception.

Some Predefined Exceptions

• VALUE_ERROR Exception is raised whenever PL/SQL runtime engine tries to execute a numeric FOR loop and either the low or high expression in the loop’s header evaluates to NULL. Use the COUNT method to ensure that the FOR loop is executed only when there is something in the collection. Here is the sample code:
  IF names_in.COUNT > 0 THEN
  FOR indx IN names_in.FIRST .. names_in.LAST
  
• ZERO_DIVIDE Exception - Program attempts to divide a number by zero.
  
• DUP_VAL_ON_INDEX Exception - Program attempts to store duplicate values in a database column that is constrained by a unique index.
  

Profile Options - AOL

There are four possible levels at which system administrators can view and update a profile option value: site, application, responsibility, and user.

• FND: Enable Cancel Query [ Yes (default) / No ] - Option to cancel the form query if taking long time
• Concurrent: Active Request Limit - Limits the number of requests that may be run simultaneously by each user or for every user at a site. If you do not specify a limit, no limit is imposed. Users cannot see or update this profile option. This profile option is visible and updatable at all four levels.
  

Multiple Reporting Currencies

Multiple Reporting Currencies (MRC) is an Oracle General Ledger feature that allows you to report in your functional currency and in one or more foreign currencies. You do this by defining one or more reporting sets of books, in addition to your primary set of books. You can set up multiple reporting SOBs and associate them with a primary SOB.

Your primary functional currency is the currency you use to record transactions and maintain your accounting data; the currency in which you transact most of your business and the one you use for legal reporting.

A reporting functional currency is a currency other than your primary functional currency for which you need to report accounting data.

If you only need to report balances in a currency other than your primary functional currency, the General Ledger Translation feature is probably sufficient.

You need MRC when:

1. You operate in a country whose unstable currency makes it unsuitable for managing your business. As a result, you need to manage your business in a more stable currency and still be able to report your transactions and account balances in the unstable local currency.
2. Your company is multinational, and you need to report financial information in a common functional currency other than that of the transaction or your primary functional currency.
3. You operate in a country that is part of the European Monetary Union (EMU), and you want to concurrently report in Euro in preparation for the pan-European currency.
   
   

Tables Info - Cost Management

CST_ITEM_COSTS

• Inventory_Item_ID
• Cost_Type_ID
• Organization_ID
• Item_Cost

CST_ITEM_COST_DETAILS

• Inventory_Item_ID
• Cost_Type_ID
• Cost_Element_ID
• Organization_ID
• Item_Cost

Period End Close - General

Periods represent non-overlapping consecutive date ranges. Every Financials customer needs to successfully close the accounting books each period.
General Steps
Here are some guidelines, from a general perspective, how you can perform the close process for every subledger:
a) Complete transactions
b) Create accounting
c) Reconcile transactions
d) Post to General Ledger
e) Reconcile accounting
f) Close period

Step b), Create Accounting, is a new step in Release 12, as it is an SLA feature. The accounting can be created immediately online, or can be run as a process in the background e.g. as a batch job at a time that matches your business needs.
The important thing to note, is that the accounting is not the distribution on the transaction. The final accounting by SLA could result in different accounting entries being generated based on the accounting rules you have configured. Therefore, you need to ensure that all your accounting for your transactions is created before you post to General Ledger, in order to update the balances correctly.

In Release 11i, when you close your periods in each of the subledgers, Oracle General Ledger will automatically create the balancing lines for journals posted to General Ledger. This changes in Release 12 as subledger accounting creates the balancing lines at the time you account for the subledger transactions.

The subledger accounting journal represents your REAL accounting and the balancing lines are created as part of these subledger accounting journals. When you close a period in Release 12, you’re actually closing subledger accounting. The journals can then be posted to the general ledger to update the GL balances.

Period End Close Dependencies