Posted on February 14th, 2008 by Sanjit Anand ||
Email This Post
As usual APIs facilitate integration with complementary third party , in-house developed, or legacy applications. These APIs are standard in Oracle Process Manufacturing in various releases.
The benefits of OPM APIs are same usual:
- Automate data collection from plant devices
- Reduce custom interface code
- Provide easier software upgrades
- Allow connection to legacy systems
- Eliminate manual data entry and errors
So here are the List of APIs for Integration in OPM (Adopted)
- Production / POC
- Start Resource Usage
- End Resource Usage
- Close Batch
- Cancel Batch
- Release, Certify, and Close Step
- Post Resource Transaction
- Incremental Resource Transaction
- Timed Resource Transaction
- Costing
- Item Cost
- Resource Cost
- Allocation Definition
- Burden Details
- Formula
- Create Formula
- Insert Ingredients, (By)Products
- Create Formula Usage Rules
- Inventory
- Create Item
- Create Lot
- Create Item/Lot UOM Conversion
- Create, Adjust, or Move Inventory
- Change Lot Status or QC Grade
- Quality
- Assays
- Specifications
- Samples
- Sample Labels
- Results
You can see the more details for API’s and underline API name either document Part No# A83748-01 or you can check in the responsibility IREP
Posted in OPM | 1 Comment »
Posted on February 14th, 2008 by Sanjit Anand ||
Email This Post
Obvious question was asked by yet another reader after this post?
“What are the modules that come under the umbrella of OPM ? “
Th answer is OPM includes OPM Process Planning, Product Development(which includes Formula,Recipe,Quality), Production, Financials(Costing,MAC), Logistics, Regulatory Management etc. These are products which come under this umbrella..
- OPM Cost Management
- OPM Formula Management
- OPM Intelligence
- OPM Inventory Management
- OPM Laboratory Management
- OPM Master Production Scheduling
- OPM Material Requirements Planning
- OPM Production Management
- OPM Purchasing Management
- OPM Quality Management
- OPM Capacity
- OPM Sales Management
- Oracle Financial
Is there any difference from Oracle Discrete Manufacturing?
Yes, there is ..If you came from Discrete manufacturing background, these are one -to-one mapping between modules.

.. OPM history
The history of Oracle OPM is one decade old, This is worth to know about OPM Life Cycle.

Next would like to provide some more information for OPM API’s availability….
Posted in OPM | 1 Comment »
Posted on February 13th, 2008 by Sanjit Anand ||
Email This Post
Aberdeen Group, has recently published one report for “ERP Options for Process Related Industries “, Here is the link for free report.
What you should know about Oracle OPM products
Oracle OPM designed exclusively for catering the business need for process manufacturers industry like:
- Consumer Packaged Goods
- Food, Beverage, Health and Beauty, Household Products
- Industrial Products
- Chemical, Pharmaceutical, Petroleum, Metals, Mining, Paper and Glass
The difference between Discrete and Process manufacturing can be best understood in my previous post.
Oracle OPM product Strengths
For those who are very new or not aware to Oracle OPM product, here are some of high points of Operational Functionality that product offered.Moreover there is significant changes has been seen in age of internet that has re-defined the operation of the supply chain(SCM) thus Oracle OPM Products too.
Please Check with Oracle OPM Page, to see what are the recent changes has been incorporated. based out of my exposure very long time back, these are the functionlity that product had.
- Lot Traceability :In this some features like Lot/Sub lot,Forward/Backward Genealogy,Status Control
,Grade Control,Lot Expiration,Allocation for Shelf Days
- Multiple Formulas (Bills) :These are typically used for formulas for production, costing planning, MSDS,Effectivities By Date for Seasonality,Effectivities by Quantity,Scaling,Alternate Routings,
Scrap factors and theoretical yield
- Support for A and V type Formulas : All three kind of formula like well suited here:
- V Bills are constructive- Multiple ingredients one product
- A Bills are destructive- One ingredient, multiple products
- A Bills support co-products and- by-products
- Ingredient Substitutions
- The features like mass ingredient substitutions for formulas
- Designed for ingredient substitutions in manufacturing orders (batches)
- Manufacturing variances for substitutions tracked and reported.
- Dual UOMs functionlity
- Item specific UOMs
- Count to Mass
- Count to Volume
- Mass to Volume
- User defined UOM types
- Lot specific UOMs
- Dual UOM Types
- Fixed
- Defaulted with tolerance
- No relation
- Uses
- Sell by count, invoice by weight
- Dry pounds, wet pounds
- % solids, % moisture
- Specification Matching Functionlity
- Some of the great features like
- QC Specs and Results : This may be based out of vendor,customer,plant or by lot
- There was yet another feature for customer spec matching.
- Regulatory Compliance
- Material Safety Data Sheets (MSDS) are configurable, also formulas for MSDS
- Other features are flexible Costing, which can be either processIf Costing (Standard,Actual) or Organization Level basis (Warehouse,Item)
Related article
Posted in OPM | 2 Comments »