Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications


Posted on February 14th, 2008 by Sanjit Anand ||Email This Post 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 »

What are OPM Products ..

Posted on February 14th, 2008 by Sanjit Anand ||Email This Post 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.

difference OPM and Discrete

.. 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 »

ERP Options for “Process Related Industries” -Aberdeen Report

Posted on February 13th, 2008 by Sanjit Anand ||Email This Post Email This Post

Aberdeen Group, has recently published one report for “ERP Options for Process Related Industries “, Here is the link for free report.

double-arrow 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.

double-arrowOracle 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)

double-arrowRelated article

Posted in OPM | 2 Comments »

API’s or Open Interface

Posted on February 12th, 2008 by Sanjit Anand ||Email This Post Email This Post

I was recently asked by a reader if I would be willing answer his questions, which was :

“Most of us are / have had worked with API’s & Open Interfaces. Both do the similar job, but have we ever wondered why would we use API’s when it can be done using Open Interface or vice versa? And, which is better” ?

….So, here you go.

..My dear friend, there is hardly any difference the way both is working,do check my previous post. Anyway here is back to basic :

OIT APIWhat are Open Interfaces?
The term Open Interfaces actually refers a programming interface, usually a database table, that automates the execution of Oracle APIs.

Open Interfaces provide a single, simple interface for a specified business procedure.

What are the Oracle APIs?

These are called as a collection of “Black Box” interfaces that provide programatic access into the Oracle ERP database.

The term API refers to stored procedure driven interfaces, where you call a stored procedure to perform an action within an Oracle Module, and the data from your external application is passed through the stored procedure’s parameters.

Why use Open Interfaces?

  • In EBS one Open Interface may run many API calls.
  • Open Interface run asynchronously.
  • The good is that if there is failure of record, they remain in the table until either fixed or purged.
  • They automate the interface into the APIs.
  • This requires less work and less code as few SQL DML would simply .

Why use APIs?

  • When there is no corresponding Open Interface.
  • Normally all Oracle APIs run synchronously, and provide immediate responses, therefore machism to be provided to handle such situation.
  • That requires custom error handling routine.
  • This may requires lot more effort as these need fine grain control approach.

Remember, the APIs are also used by the front end screens, and in the same way, will require all the appropriate prerequisites to be implemented.

Important to note, you cannot use APIs as an alternative to implementation.

Releated Post:

Posted in API Integration | 10 Comments »

The world of Oracle API

Posted on February 12th, 2008 by Sanjit Anand ||Email This Post Email This Post

There are 3 types of APIs exist in EBS.

double-arrowPrivate APIs : Private API’s are one which Oracle normally using internal, development purpose only. Details are not provided to anyone outside of the immediate development environment, nor are they intended for use by anyone outside of the e-Business Suite development environment.

double-arrowPublic APIs : These are designed for customers and Oracle consultants to integrate non-Oracle systems into Oracle e-Business Suite or to extend the functionality of the base products. Oracle does not support public APIs unless they are published in a reference manual.

double-arrowPublic, published APIs : These are one which Oracle guaranteed to remain valid from release to release, and patches will not alter the API behaviour. Public, published APIs are supported by Oracle to the same extent as released software.

Is there any way find out whether a standard API is PUBLIC or not in Oracle Application?

Yes, there is way, what you have do ,once you are able to find the information for API from irep, the next you have to find the file name and then you need to pull all information from specification header to know which one is public.

Take a simple case, you need to find API FND_USER_PKG which is defined in file AFSCUSRB.pls

logon to Unix box, and release this sort of command

grep -i public $FND_TOP/patch/115/sql/AFSCUSRB.pls

api's world

Based on the above result one can determine whether API is PUBLIC or not.

Simple example for checking AR Public APIs for finding the status

grep -i public $AR_TOP/patch/115/sql/ARXPRELB.pls
grep -i public $AR_TOP/patch/115/sql/ARXPRELS.pls
grep -i public $AR_TOP/patch/115/sql/ARXPRECS.pls
grep -i public $AR_TOP/patch/115/sql/ARXPRECB.pls

Important to Note:

For non-published APIs, Oracle expressly does not provide any guarantees regarding consistency of naming, usage, or behaviour of any API (public or private) between releases.

It Might be possible that a patch could alter any characteristic of any non-published e-Business Suite API.

Where are APIs located ?

For Oracle release 10.7, the APIs are located in the operating system directories such as:


For Oracle release 11 and release 11i, the APIs are located in the operating system directories:


where xxx represents the release 110 or 115.

Is there any tracking mechanism for API versions in different Applications releases?

As confirmed by some time back by Oracle support team , there is no such database object in Oracle Applications that keep such kind of information.

All APIs are owned and managed by different product groups within Oracle.

Normally each release comes with either product update notes, or and “About” note. You would need to review these documents for each E-Business Product.

The most comprehensive are the family pack “About” notes, as they in turn reference each individual product “About” note, which lists things like “Changes”.

Posted in API Integration, EBS Suite | 14 Comments »

Revenue Recognition : Governance

Posted on February 11th, 2008 by Sanjit Anand ||Email This Post Email This Post

The Revenue Governing Bodies are:

  • U.S. GAAP: Generally Accepted Accounting Principles, set of guidelines upon which companies report their financial results for consistency
    • FASB: Financial Accounting Standards Board is the primary driver of GAAP, with inputs from the AICPA, the SEC, Top Accounting Firms.
    • AICPA: American Institute of Certified Public Accountants, issues Statements of Positions (SOP), which outline the AICPA’s interpretations and application of GAAP.
  • SEC: US Securities & Exchange Commission, regulates companies listed on the US Stock Exchanges and publishes Staff Accounting Bulletin’s (SAB), which are their interpretations of GAAP

Outside the US, most countries have their own Standards Board, and mostly adhere to the International Accounting Standards. These vary slightly from US GAAP.

Other Governing Bodies

  • SOX: Sarbanes-Oxley- 2002 US Law to protect investors by requiring strict controls on processes affecting financial results
  • ICR: Internal Control Review, Companies generally response to the act focusing on 2 of the 66 sections of the Sarbanes-Oxley… auditing to controls

For the US Public Listed company its important to meet accounting & reporting requirements issued by the US Securities & Exchange Commission (SEC) when presenting its financial results to investors.

Posted in Oracle Receivable | No Comments »

PO: Tips and useful Query

Posted on February 11th, 2008 by Sanjit Anand ||Email This Post Email This Post

The consultant life while working at client site is not easy during ERP transformation projects, many times it’s required to provide some adhoc query for extract to ends users, therefore it is important to have a cheat sheet so that such untimely things can be easily handled in sort span. Hope these query and tips useful to all Inhouse IT personals who is part of Implementation Project team.

1. You need to list out all Internal Requisitions that do not have an associated Internal Sales order.

Internal Requisitions without Sales order

2. You want to display what requisition and PO are linked(Relation with Requisition and PO )

Requisition and PO

3. You need to list out all cancel Requisitions

Cancel Requisition

4. You need to list those PR which havn’t auto created to PO.(Purchase Requisition without a Purchase Order)

PR without PO

5. You need to list all information form PR to PO …as a requisition moved from different stages till converting into PR. This query capture all details related to that PR to PO.

PR to PO

6.Identifying all PO’s which does not have any PR’s

PO without Requisition

7. Relation between Requisition and PO tables

Here is link:


What you have to make a join on PO_DISTRIBUTIONS_ALL (REQ_DISTRIBUTION_ID) and PO_REQ_DISTRIBUTIONS_ALL (DISTRIBUTION_ID) to see if there is a PO for the req.

8.You need to find table which hold PO Approval path…

These two table keeps the data:


9. List all the PO’s with there approval ,invoice and Payment Details

List PO’s with Approval , invoice and Payment info

Read the rest of this entry »

Posted in Oracle Purchasing | 29 Comments »


Posted on February 7th, 2008 by Sanjit Anand ||Email This Post Email This Post

Enter your e-mail address to receive notifications when there are new posts

Posted in Oracle Application | Comments Off on Subscribe

Happy Lunar new year

Posted on February 6th, 2008 by Sanjit Anand ||Email This Post Email This Post

chinesenewyearTomorrow is Chinese New Year(February 7, 2008) ,the Year of the Rat. According to Wikipedia, the rat “was welcomed in ancient times as a protector and bringer of material prosperity.”

I wish a very happy Chinese New Year (Gong Xi Fa Cai…).

Have a safe, and prosperous year ahead.

Posted in Blogroll, Uncategorized | 2 Comments »

R12 AGIS : What makes “Advanced” – Part II

Posted on February 3rd, 2008 by Sanjit Anand ||Email This Post Email This Post

Thanks to David, who pointed me a node for process that makes Intercompany settlement easy.

For more details , here are the link:

A note on “Reconciliation process”

Reconciliation process is automated to easily reconcile intercompany receivables and intercompany payables account balances. The process helps user to identify account balances difference and to research the cause of difference. The reconciliation process supports drilldown to General Ledger journal details and subledger transaction details to investigate the reason of balance difference. The underline report have capablity to show:

  • Details by Reconciliation Summary
  • Details Reconciliation Summary by Source
  • Details Reconciliation Summary by Journals

Posted in InterCompany | 1 Comment »

« Previous Entries Next Entries »