Oracle ASCP Implementation Roadmap

Oracle ASCP Implementation Roadmap

Is it a way to get rid of Excel in a Global Supply Chain Planning team?
After implementing Oracle ASCP, can we expect a benefit on inventory and customer service levels?

This road map proposes a way to gather all of the planning data into one system (Oracle ASCP).
It highlights the business processes because planning is based on processes.
It emphasizes flow management because planning is all about flow management.

Oracle ASCP is the tool you need: flexible enough to be adjusted to your processes and your material flow management method.

Oracle ASCP Implementation Key Success Points

3 main points you need to keep on mind:

Global Plan: World Wide & Across Systems

Because you sell across the world, because planning is global: your world wide supply chain should be interfaced with Oracle ASCP:
– All of the distribution centers (main DCs, regional DCs) are linked to Oracle ASCP and their inventory position and on-going transactions are replicated. Whatever the supply chain choices: self owned facility or logistic partner.
– An EAI system is used to manage real time interfaces based either on web services or file transfers.

Building such an EAI system requires a strong collaboration between the different IT teams. The project in itself is a medium sized project: the basic architecture and the first interfaces can be built within 4 to 6 months.
This architecture allows gathering the planning data and is critical to avoid Excel consolidation of the supply chain data.


Close the Loop

Any missing piece of data will break the Supply Chain system and generate a wrong MRP calculation. As a consequence Excel would be back to fill the gap!
For example: the lack of in-transit quantities results in a fake demand during the transportation time. Or the lack of forecast related to service parts will result in shortages…


Reliable Processes

When implementing an ERP system one of the first lesson learned is the importance of Master Data Management: MDM teams and processes are established.
These processes should be complete: any Master Data and all of their dependencies. For example: Item Costs and Planning/Purchasing Sourcing rules should be taken care.
These processes should be global: manual or automatic consistency should be ensured across systems when creating a new product or a new customer.


As described by the APICS CPIM certification, processes are key in the planning system. The different process levels ensure a smooth decision system across the management levels of the company.
For example, managing capacities in a plant requires anticipated decisions when it comes to temporary or permanent hiring. This anticipation is prepared by the Sales & Operation Planning process. Decisions  being applied at the Master Production Schedule level.

Strategic Inventory Positionning and Material Flow Management

Managing the material flow is key. Any method is good: Lean, TOC or Demand Driven MRP. These methods deeply impact the planning processes. They ensure keeping lead times and priorities under control. They avoid the MRP bad effects like simultaneous shortages and excess inventory in a product family. They are the only means to speed up the material flow and increase the service level.

The role of decoupling buffers:picture11

On one side, managing the material flow results in a drastic simplification in the data model.
On the other side, Oracle ASCP is highly flexible and can be adjusted to different processes.
As a result, Oracle ASCP can easily support a lean process, for example.



Get the best from Oracle Quality

Not only Oracle Quality offers a means to manage your Quality records and can be fully compliant with your Quality standards but it can be used to improve your Quality processes:
Minimize your workload and paper work and streamline your Quality processes
Standardize your Quality Management Processes across all of your organizations
Manage Quality KPIs in a consolidated way.

Traceability and Quality Standard Compliance: the basics you require!

What would be a basic (and still powerful) setup for Oracle Quality?
First establish your inspection points: receipts, work order operations and final inspection, repair, maintenance, ad-hoc inspections… Secondly, devise and create the inspection plans and attach them to every component, sub-assembly or product. When possible, group them by item family. Finally, grant access rights to allow the Inspectors using the Inspection Plans.

Quality Inspectors immediately can record inspection results, accept or reject lots. Their work is simplified by using sampling and specifications:
Oracle Quality automatically proposes the right sample quantity during inspection. This is based on standard AQL levels. The lot is accepted or rejected accordingly.
Specifications can be assigned to every inspection point to automatically accept or reject a measurement.

Oracle Quality is fully integrated with Purchasing, Discrete and Process Manufacturing (and other modules) it is easy to implement and highly customizable. Quality records are stored in the system and managed in a secured and auditable way.

Minimize your workload and paper work

The Quality team workload is often critical. It’s with worth reducing it. Oracle Quality offers several means to achieve this purpose.
Non Conformance Management:
Oracle Quality allows to create a workflow to manage non-conformances from rejected lots to MRB decisions and disposition tracking. You can either use the pre-seeded workflow provided by Oracle or customize your own workflow.
In both cases one unique integrated system is used by your Quality team to manage inspection and non-conformances.
This approach can be extended to CAPA’s and Audits.

Skip lot inspections

After establishing strong quality processes with your suppliers, you can build and apply skip lot rules to skip inspections when allowed. You get a full traceability of skipped lots. Your quality team saves time and concentrates on the critical products.

Zero paper using the Electronic Signature

Oracle Quality allows you to track and sign off Quality records in a secured and auditable way. The Electronic Record and Electronic Signature tool is 21 CFR part 11 compliant. Any Quality record can be stored, secured and retrieved for audits.
ERES is a very strong and stable tool. Once the rules are established and setup there is no way to escape to them.
Despite of a slight increase of time at sign-off this drastically reduces the amount of paper in your facilities, secures your quality records and facilitates any kind of audits.

Streamline your processes

Highly customizable Oracle Quality sticks to your Quality processes and helps improving them. A few examples in the Quality area:
Track your customer complaints
by creating an ad-hoc plan fulfilled by your customer services
Manage complex Inspection instructions
by referring to or replicating your Quality documentation in Oracle Quality
Manage Calibration and Maintenance
Either by building specific collection plans
Or by using Enterprise Asset Management and Quality together.

Build Standard Quality Processes

To support your company processes, create your typical inspection plans and typical non-conformance workflow:
. By using child plans build your Non Conformance Workflow: nonconformance event, MRB decision and disposition, corrective action tracking.
. Use statuses to open and close non conformances and actions.
. Add email alerts and customized reports. As an example, a customized report can be launched from a plan to print out a claim letter to your supplier.
Make this a standard by saving your plans as templates in your master org. Train your Quality Managers to create a new plan from these templates. Be sure your Quality Managers can easily get an IT support to solve new questions or potential issues.
Based on this approach, all of your organizations have the same Quality plan structure. Only the list of inspection points is adjusted to the organization parts. Non-conformance Management, Complaints management is the same across all of your organizations with the same statuses, disposition codes…

Manage Quality KPI’s in a consolidated way

Based on standard processes and inspection plans you can now build your monthly KPI’s. As all of your plans have the same statuses and same codes it’s easy to get statistics by product line, supplier and facility.
You can use the Quality reports to generate your KPI’s or work with your BI team to generate them. Using your BI tool makes the calculation automatic and global allowing reports by facility and for your company.


Building this level of solution requires a business and IS team working together in a project oriented approach. Except for Month-end customized reports it’s fully standard. However, it needs to be considered as technical setup: SQL scripts are part of it.
In a few months a project team made from Quality Managers and Oracle Consultants can move your solution from a set of inspection plans to compliant and global quality procedures based on high standards.

Oracle ASCP Training

End user training: 2 days

End users need to know how Oracle ASCP works as part of Oracle e-Business Suite and as part of the Planning Processes. The Workbench is their daily tool: this training provides the clues to use it on a daily basis. Interactions with other modules and Master Data Management are considered and finally how to use Oracle ASCP for simulations.

  • Oracle ASCP presentation
    • Oracle ASCP part of an ERP system: information flow
    • Planning logic and levels (Demand Management, MRP, CRP, DRP)
    • ASCP Architecture
  • The Workbench
    • Navigate in Workbench and understand the different levels of information
    • Create and manage queries and folders
    • Validate and Release orders
    • Exception management
  • Master Data
    • Item Attributes
    • Bills of Materials, Routings
    • Sourcing Rules
    • Calendars
  • Processes
    • Demand Management and Forecast consumption
    • Purchasing Process: from the Oracle ASCP Workbench till the suppliers
    • Shipping process: IR/ISO
    • Manufacturing Process: from the Oracle ASCP Workbench to work orders
    • Capacity Management and Simulation tools

Project team training: 4 days

Oracle ASCP training including the daily usage, setup, administration, interfaces with other systems and a road map for a global project implementation.

  • Oracle ASCP presentation
    • Oracle ASCP part of an ERP system: information flow
    • Planning logic and levels (Demand Management, MRP, CRP, DRP)
    • ASCP Architecture
  • The Workbench
    • Navigate in Workbench and understand the different levels of information
    • Check and validate the planned orders
    • Release orders
    • Workbench preferences
  • Data Collection
  • Plan Options
  • Master Data
    • Item Attributes and Categories
    • Bills of Materials, Routings
    • Sourcing Rules
    • Calendars
  • Global Order Promising
    • Setup
    • Demand Classes
  • Exception Management
    • Exception Setup
    • Exceptions
  • Legacy Data Collection: Building a Global Plan
  • Processes
    • Demand Management and Forecast consumption
    • Purchasing Process: from the Oracle ASCP Workbench till the suppliers
    • Shipping process: IR/ISO
    • Manufacturing Process: from the Oracle ASCP Workbench to work orders
    • Capacity Management and Simulation tools
  • Road map for an Oracle ASCP Project Implementation