Oracle Apps Tutorial: Changes in R12.2 for Supply Chain Management (Part 1)

Unlike the other product families (Financials, Projects, HR), Supply Chain Management has been busy with enhancements in the R12.2 release.  Because Order Management has a lot of changes, I’m dividing my discussion into two posts.  This first post will cover the changes to Advance Pricing, Electronic Kanban (new product), Inventory, Sales Contracts, and Service Contracts.  […]


Oracle Apps Tutorial: Using Dual Unit of Measure (UOM) in Oracle EBS Inventory

With the merging of inventory module from process manufacturing into the EBS inventory module, EBS inventory now has the ability to track item in two units of measures (UOM).  The EBS inventory module has always been able to convert from the primary UOM to another UOM.  But when you viewed your on-hand balance, you only saw […]

Oracle Apps Tutorial: New in R12: The Introduction of Inventory Material Statuses

When you upgrade to R12, you will notice a Material Status field on the organization parameters, item, lot, locator, and sub-inventory forms.   You’ll also see it on the Material Workbench when you query on-hand quantity.  The Material Status field will allow you to control which transactions can be performed against that item.  I think the […]

Oracle Apps Tutorial: R12 Changes to Inventory Item Attributes and Inventory Organization Parameters

I wanted to share with you the R12 changes to item attributes and inventory organization parameters because I feel these configurations are at the heart of all Supply Chain modules.  These configurations will determine how items are planned, purchased, built, costed, ordered, and shipped.  The R12 changes to the item attributes and inventory organization parameters […]

Oracle Apps Tutorial: How to Easily Modify Account Generator Workflows by Using Custom Functions

On January 19, 2012, in Oracle E-Business Suite, Oracle Inventory, Oracle Payables, Workflow, by ssutphin

If you are using any of the Purchasing, Payables, or Order Management and don’t like the accounting, you can modify the Account Generator workflow to achieve your desired results.  Unfortunately modifying a workflow is not a common skill set amongst Oracle developers.  To overcome this, I have put together a simple way to modify the […]


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: Five Options When Using Oracle Project Manufacturing

In this post, I wanted to look at five different Project Manufacturing options.  Each option uses different modules to capture cost, generated revenue, and invoice the customer.   The basic options are: Using Seiban Projects Using Indirect Projects Using Contract projects to recognize revenue Using Contract projects to recognize revenue and to invoice the customer Using […]


Oracle Apps Tutorial: Using Project Manufacturing to Integrate Projects with Supply Chain

Unlike most modules, that create transactions and maintain master data, the only purpose of the Project Manufacturing module is integration.  It establishes the rules to associate projects, tasks, expenditure types, and organizations (POET) to Supply Chain master data and transactions.  To understand the different integration points let’s first look at a typical supply chain cycle. […]


Oracle Apps Tutorial: Overview of the Order to Cash Cycle in Oracle R12

There are four high-level processes in the Order to Cash cycle.  The first is processing the order, the second is processing the invoice, the third is recognizing the Cost of Goods (COGS), and the last is processing the cash receipt. Order Processing There are five steps to processing an order: 1.       Enter an order 2.       […]

Oracle Apps Tutorial: How Subledger Accounting Event Classes Map to Inventory, Purchasing, and Cost Management Module Transactions

This is my third post on the details of Subledger Event Classes in the Oracle E-Business Suite.  In my previous post, I discussed how the relationship between the Subledger Event Class and the transactions in the Payables module.  In this post, I’ll discuss the relationship of Cost Management Event Classes and the transactions in the […]

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!