Oracle Apps Tutorial: How to Reconcile Inventory Activity to the General Ledger

When reconciling Inventory to the General Ledger, we need to know how Inventory is integrated with the General Ledger and how Inventory calculates inventory value.  Inventory integrates with GL using cost elements and material distributions.  WIP integrates with GL using cost elements and WIP distributions.  Cost elements define the elemental level that Oracle tracks and […]

Oracle Apps Tutorial: How to Process Transactions During Period-End Close

To efficiently and effectively perform a period-end close in Oracle, you need to know the flow of transactions and journal entries from each module.  To ensure all the transactions are processed and accounted for in the General Ledger, you will need to perform the following processes in order.  The list below encompasses the most common […]

Issues When Upgrading Oracle Apps from 11i to R12

If you are starting or thinking of starting your Oracle R12 upgrade, you are probably wondering what type of issues other companies had with their upgrade.  It’s been about six months since I was the project manager on a 11i to R12 (12,1.1) upgrade.  Here’s a list of the modules that were upgraded: General Ledger […]

3 Steps to Reconcile Oracle Projects to Oracle General Ledger – Step 3

Step 3: Finding permanent and timing variances To find permanent and timing variance, we need to understand the processes for each type of flow.  The figure and tables below detail how the accounting flows for cost categories and the variances you could find when reconciling. Uncosted and Costed Flow [singlepic id=1 w=320 h=240 float=center] Variances […]

3 Steps to Reconcile Oracle Projects to Oracle General Ledger – Step 2

Step 2: Comparing balances at the GL source and category level Now that you have an apples-to-apples comparison for your project and GL information, what happens when you still have a variance?  Then you need to go down one more level and add the GL source and category to both sets of data.  This will […]

3 Steps to Reconcile Oracle Projects to Oracle General Ledger – Step 1

Step 1: Getting an apples-to-apples comparison Let’s get started on step 1 by looking at the common data elements in financial reporting and project reporting.  Here is where we will add the information that is typical to a financial report to the information that is typical to a Projects report.  This will give us a […]

3 Steps to Reconcile Oracle Projects to Oracle General Ledger

You are reviewing reports from both Projects and the General Ledger. You discover that sometimes the reports equal but other times they do not. You would like a checklist and some guidelines to solve this puzzle. You can put together the pieces of the puzzle by first understanding the flow of accounting entries to and […]

 

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!