What it takes to integrate OPM with ASCP

Posted on November 7, 2011 by Sandeep Chatterjee

Before R12, customers on Oracle Process Manufacturing (OPM) usually used OPM MRP as the planning engine though there are customers who have successfully integrated OPM with Advanced Supply Chain Planning (ASCP). With R12, OPM MRP is now obsolete and is replaced by unconstrained ASCP in a centralized setup. Another significant change has been the inventory convergence for Discrete Manufacturing and Process Manufacturing. In 11i, OPM organizations are different from Discrete organizations and hence for integration with other modules, a 1:1 mapping needs to be done for OPM and Discrete Organizations. With R12, this is now not required. Read More… →

Posted in EBS - Functional, Oracle, Oracle_Applications | Leave a comment

Cost Manager Concepts in Oracle Inventory

Posted on August 17, 2011 by Neocortex Staff

Cost Manager Concepts in Oracle Inventory

Cost Manager is a Process that scheduled to run by default after every 5 minutes. At schedule interval, it runs and spawns ‘Actual Cost Worker’ process for each Inventory Organization in which there is a transaction in past 5 minutes. The process ‘Actual Cost worker’ processes Material Transactions and creates accounting entries for the material transactions.
Read More… →

Posted in EBS - Functional, Oracle, Supply Chain | Leave a comment

Accounting Entries for Invoices

Posted on August 17, 2011 by Neocortex Staff

We will discuss here how accounting entries are generated with accounts affected in Payables.
For example, there is a business case
We do an arrangement with a supplier that we will buy some services from him at the cost of $100.

Read More… →

Posted in EBS - Functional, Financials, Oracle | Leave a comment

Duplicate Suppliers, How to avoid and get rid of, if they are already there

Posted on August 10, 2011 by Neocortex Staff

Oracle maintains uniqueness among suppliers with Supplier Numbers. It is possible that one supplier exist in the system with two similar names. For example, the Supplier name ‘ABC and Co’ can also be entered as ‘ABC & Co.’ Special care should be taken to maintain suppliers so that there should be no duplicate.
Read More… →

Posted in EBS - Functional, Financials, Oracle, Supply Chain | Leave a comment

Thinking of R12? Go for an Enhanced Upgrade

Posted on August 10, 2011 by Sandeep Chatterjee

Call it the bane or boon of an ERP system, companies do not have a choice but to upgrade to a higher version. There are various factors which drive the decision to upgrade namely de-support of the current system by the ERP vendor, availability of new features in higher version which have the potential to give a strategic edge. Typically companies choose the upgrade path to avoid the de-support problem and hence what it finally does is a pure as-is technical upgrade. This has multiple benefits in the sense that it is least risky and also can be done in a shorter timeframe. But once in a while it makes sense to have a look at the new features which can bring efficiencies in the process.
Read More… →

Posted in Oracle, Upgrades | Leave a comment

Linear Programming Models: Oracle Strategic Network Optimization is the Answer

Posted on August 10, 2011 by Sandeep Chatterjee

Remember those Linear Programming Problems in College? We used to find an optimized solution based on certain constraints. Some of the popular methods of solving these were Graphical, Simplex and Big-M Method. Also, there were software programs available to minimize the computation efforts.
Read More… →

Posted in Oracle, Supply Chain | Leave a comment

Is Pull Production the final word?

Posted on August 10, 2011 by Sandeep Chatterjee

Typically when we talk about improvements on the shop floor, we hear a lot about Pull Production. Originating from the Toyota Corporation, pull production is a process that aims to arrange an organization so that customer preference or orders are what cause materials to be “pulled” through a system.
Read More… →

Posted in Oracle, Supply Chain | Leave a comment

Collaboration: The way forward for High Tech Industry

Posted on August 10, 2011 by Sandeep Chatterjee

In his classic best-seller ‘The Goal’, Eliyahu M. Goldratt discusses about the three fundamental ways of making money for a going concern namely,
1. Increase throughput (the rate at which the system generates money through sales)
2. Reduce Inventory (all the money that system has invested in purchasing things which it intends to sells)
3. Reduce Operational expenses (all the money the system spends in order to turn inventory into throughput)
Read More… →

Posted in Supply Chain | Leave a comment

Doing Business in Brazil: An ERP Perspective

Posted on August 10, 2011 by Sandeep Chatterjee

The name ‘Brazil’ in our minds is synonymous with Soccer and Samba. To minimize the impact of US slowdown, more and more companies are turning to the BRIC economy which has strong fundamentals. While it is yet another country, there are unique legal requirements which need to be taken care of while doing business in Brazil. Oracle E-Business Suite offers a set of Brazil Localization Modules to cater to these requirements.
Read More… →

Posted in Brazil | Leave a comment

Resolving the “ORA-12514: No TNS Listener” error with Oracle XE

Posted on May 14, 2009 by Nikunj Sanghvi

I faced this particularly nagging error with a personal install of Oracle XE (Oracle Database 10g Express Edition) on my Windows XP laptop:

ORA-12514:No TNS Listener

The SQL Command prompt that came with Oracle XE would work but none of the other tools like Toad, SQL Plus or even the Oracle XE Database Homepage which would open in a browser window would work.

The final resolution after a lot of research seemed to be painfully simple: Read More… →

Posted in EBS - Technical, Oracle | 4 Comments