jump to navigation

What is Oracle ASCP? April 30, 2007

Posted by Muhammad Habib in Oracle Applications.

(I was searching about ASCP, but could not find. At last I got the details from Oracle Documentation. I want to share …)

Oracle Advanced Supply Chain Planning (ASCP) is a comprehensive, Internet-based planning solution that decides when and where supplies (for example, inventory, purchase orders and work orders) should be deployed within an extended supply chain. This is the supply planning function. Oracle ASCP addresses the following key supply planning issues:


■ How do I plan my supply chain in the least amount of time possible?

■ How do I minimize the number of plans and iterations?

■ How do I plan my entire supply chain?

■ How do I involve my trading partners?

■ How can I access my plan from anywhere?

■ How do I keep improving my plans?

■ How can I plan all manufacturing methods?

The key capabilities of Oracle ASCP are:

Holistic Optimization, Planning, and Scheduling. Oracle ASCP can plan all supply chain facilities simultaneously. Short-term detailed scheduling and long-term aggregate planning are supported within a single plan. This single plan also supports multiple manufacturing methods, including discrete, flow, project, and process manufacturing.

Finite Capacity Planning and Scheduling. Oracle ASCP generates feasible supply chain plans that consider both resource and material constraints.

■ Optimization. Users can easily configure Oracle ASCP to optimize specific business criteria. No programming is necessary to access Oracle ASCP’s powerful mathematical optimization capabilities.

■ Backward Compatibility. Oracle ASCP’s component architecture allow it to be deployed against any combination of Oracle 11 and Oracle 11i transaction systems.

Workflow-Driven Exception Messaging. Oracle ASCP’s exception messages alert planners to critical issues across the extended supply chain. Workflows that drive these exceptions route data to and feedback from trading partners as required, thus effectively involving them in the supply chain planning process.

Global Accessibility. Oracle ASCP’s database-centric architecture stores plan data in a central planning server database. These data are accessible from Oracle Advanced Supply Chain Planning anywhere via a simple browser. It is possible for multiple planners to simultaneously access data from a single plan.

Integrated Planning and Execution. Oracle ASCP’s Advanced Planner Workbench user interface not only displays plan results, but also allows planners to execute planning recommendations. Planners do not have to move to the transaction system to perform plan execution.

Simulation Capability. Oracle ASCP allows many types of changes to supply, demand, plan options, and resource profiles to simulate changing business conditions. You can generate a plan considering all the changes that have been entered via the Planner’s Workbench. Unlimited numbers of scenarios can be simulated and compared using online planning, copy plans, and exceptions. Examples of the types of changes are firming, changing sources, modifying quantities and dates, modifying priorities, modifying resource availability, modifying supplier capacity, and modifying objective weights.


Protected: Configuration of Oracle Application server 10g April 28, 2007

Posted by Muhammad Habib in Oracle Application Server.
Enter your password to view comments.

This content is password protected. To view it please enter your password below:

What is the difference b/w OLAP & OLTP, why do we keep warehouse on different server then of OLAP? April 24, 2007

Posted by Muhammad Habib in Dataware Housing.

OLTP databases provide real time accesses to its data which is being updated by other transactions. OLTP databases contrasts earlier databases that allowed updation in batch modes as all updations were provided in one go.(database Replication can be considered so).

In case of OLTP there is no such boundation and all updations can be done anytime and other users will automatically see your changes.

OLAP provides analytical processing capabilities on an OLTP database. This provides a real time analytical view of the database. Historically OLAP suffered since it would slow down OLTP database considerably. However with faster h/w and better algorithms, it’s now practical.

Data Warehouses contain historic & non operational data that is not required for day to day working of the operations. For example you purchased a pair of Shoes from a branded store 10 years ago. Chances that you will come back reclaiming your money are very less ;-).

Such data is transferred to special database known as Warehouse. If it would have being in the OLTP database then it would have consumed storage and WORSE will make transaction processing very very slow. Since best database algo’s are log(n) where n is the amount of data. As ‘n’ grows so is the time complexity.

Hence it makes sense to keep such historic data separate for analysis purposes.

Random but unique April 11, 2007

Posted by Muhammad Habib in Oracle General.
add a comment

We can generate random + unique number with the query..

( SELECT empno FROM emp
ORDER BY dbms_random.value )
WHERE rownum = 1