OM ATO Setups in Oracle Apps R12
Purpose of the document is to provide good understanding and to build a test case for basic ATO Configurations in OM.
What is ATO (Assemble-to-Order) Manufacturing?
ATO simplifies the finished goods manufacturing process. These goods are standard products and are often configured by customers from Bills of material, where you can define available options for unique product configurations.
Based on forecasting, subassemblies are manufactured prior to receiving the customer order and when the order is received, the stocked subassemblies and components are assembled to make the finished products.
Order Management, WIP and Shipping modules support building and shipping of ATO configurations. A discrete job is created from a configuration.
Real time example- Laptop manufacturing company
Laptop requires Processor, Hard drive, key board, Monitor and Operating system.
Bill of Material can be defined for laptop computer as, you can define computer as ATO Model. A Model comes at the top of the configuration hierarchy, second comes the Option Class and then the Option item. Carrying case and keyboard are purchased items under the bill of laptop. Whereas processor, monitor and operating system are option classes and Intl I5, Intl I3 are optional items under option class processor.
It is possible that ATO model itself is component of another Bill of Material.
ATO Cycle
Outlining below setups required towards ATO Model.
Oracle Apps R12 Setup for ATO | |||
Step | Navigation | Data | |
Create ATO Model Item | Inventory Navigation- Items/Master Items | Item:- ORA CPU ATO | |
Description:- ORA CPU ATO | |||
Menu Tools -> Copy from Template:- ATO Model | |||
Click Apply and then click Done | |||
Save | |||
Organization Assignment to M1 and Save | |||
Create ATO Option Classes | Inventory Navigation- Items/Master Items | Item:- ORA ATP HARD DRIVE | |
ORA ATP HARD DRIVE | |||
Menu Tools -> Copy from Template:- ATO Option Class | |||
Organization Assignment to M1 | |||
Save | |||
Organization Assignment to M1 and Save | |||
Item:- ORA ATP PROCESSOR | |||
ORA ATP PROCESSOR | |||
Menu Tools -> Copy from Template:- ATO Option Class | |||
Organization Assignment to M1 | |||
Save | |||
Organization Assignment to M1 and Save | |||
Item:- ORA ATP MEMORY | |||
ORA ATP MEMORY | |||
Menu Tools -> Copy from Template:- ATO Option Class | |||
Save | |||
Organization Assignment to M1 and Save | |||
Create options for the ATO configuration | Inventory Navigation- Items/Master Items | Create below items and use Finished Good templete. Once done assign to organization as M1 | |
ORA ATP MODEM | |||
ORA ATP SGT HDD | |||
ORA ATP INTL I5 | |||
ORA SMSG DDR3 | |||
Pricing | |||
Assign Items to a Price List | Oracle Pricing Manager Vision Operations Navigation- Price List/Price List Setup | ORA CPU ATO | 1000 |
ORA ATP HARD DRIVE | 0 | ||
ORA ATP PROCESSOR | 0 | ||
ORA ATP MEMORY | 0 | ||
ORA ATP MODEM | 50 | ||
ORA ATP SGT HDD | 250 | ||
ORA ATP INTL I5 | 500 | ||
ORA SMSG DDR3 | 250 | ||
Inv Qty | |||
Receive Inventory | Inventory Navigation- Transactions/Miscellaneous transactions | ORA ATP MODEM | 100 |
ORA ATP SGT HDD | 100 | ||
ORA ATP INTL I5 | 100 | ||
ORA SMSG DDR3 | 100 | ||
Define Assemblies and Components | Bill of Material Navigation - Bills/Bills | Sign in by Master Organization and click on header | |
ORA ATP HARD DRIVE | |||
Main tab | |||
Item seq 10 | |||
component - ORA ATP SGT HDD | |||
Order management tab click optional | Qty-1 | ||
ORA ATP PROCESSOR | |||
Main tab | |||
Item seq 10 | |||
component - ORA ATP INTL I5 | |||
Order management tab click optional | Qty-1 | ||
ORA ATP MEMORY | |||
Main tab | |||
Item seq 10 | |||
component - ORA SMSG DDR3 | |||
Order management tab click optional | Qty-1 | ||
Define the ATO model | Bill of Material Navigation - Bills/Bills | Sign in by Master Organization and click on header | |
ORA CPU ATO | |||
Main tab | |||
Item seq 10 | |||
Component- ORA ATP PROCESSOR | Qty-1 | ||
Item seq 20 | |||
component - ORA ATP HARD DRIVE | Qty-1 | ||
Item seq 30 | |||
component - ORA ATP MEMORY | Qty-1 | ||
Item seq 40 | |||
component - ORA ATP MODEM | Qty-1 | ||
Verify BOM | Bill of Material Navigation - Bills/Intended Bills | Sign in by Master Organization and click on header | |
Enter item as ORA CPU ATO and click find | |||
Notice- The three Option Classes along with the Optional and Mandatory Item Click on the ++ sign to expand the BOM to its lower levels of components Verify that the Option Classes are as defined above. | |||
Copy the BOMs into Shipping Organization | Sign in by Master Organization and query the above created ATO BOM and Assembly BOM | ||
Organizations: | |||
Bill of Material Navigation - Bills/Bills | ORA ATP PROCESSOR | ||
Tools -> create common Bill Enter to Organization as M1 and enter item as ORA ATP PROCESSOR Note- it will submit concurrent request as Create Common Bills | |||
Repeat the steps for ORA ATP HARD DRIVE, ORA ATP MEMORY, ORA CPU ATO | |||
Step#1 - Create ATO Model Item
Inventory - Navigation: Items/Master Items
ORA CPU ATO
ORA ATP HARD DRIVE
ORA ATP PROCESSOR
ORA ATP MEMORY
ORA ATP MODEM
Step#2 - Assign Items to a Price List
Oracle Pricing Manager Vision Operations Navigation- Price List/Price List Setup
Step#3 – Receive Inventory
Inventory Navigation- Transactions/Miscellaneous transactions
Step#4 – Define Assemblies and Components
Bill of Material Navigation - Bills/Bills
Using a BOM Responsibility, you can either create the BOM in V1 Org. then copy it to M1, or to create it in M1 Org. and make it a Common BOM.
The BOM has to exist in both the OU (Validation Org.) and the Shipping Org.
The BOM has to exist in both the OU (Validation Org.) and the Shipping Org.
Step#5 –Define the ATO model
Bill of Material Navigation - Bills/Bills
Assign the earlier defined assemblies as components and also add ORA ATP MODEM which is not assembly.
Step#6 –Verify the BOM
Bill of Material Navigation - Bills/Intended Bills
The three Option Classes along with the Optional and Mandatory Item
Click on the ++ sign to expand the BOM to its lower levels of components
Verify that the Option Classes are as defined above.
Step#7 –Copy the BOMs into Shipping Organization
Bill of Material Navigation - Bills/Bills
Make the BOMs available to M1
Find the BOM and create common bill from tools menu
Enter to organization as M1 and click Ok.
Once submitted it will submit create common bills concurrent program.
This explains the required setups for ATO.
Testflow steps
Step#1 –Sales Order creation
Order Management Super User, Vision Operations (USA)
Navigation- Orders,Returns /Sales Order/ Select M1 as the Warehouse (Others tab)
Navigation- Orders,Returns /Sales Order/ Select M1 as the Warehouse (Others tab)
Enter line item as - ORA CPU ATO, qty
And then click on configurator, once clicked it will say configurator processing please wait.
You can see the configurator is opened in separate window.
Click + to expand the model and then select the desired components and finaly click finish.
Come back to the order you will see all the componenets added to the order
Step#2 –Book and progress the Order
Order Management Super User, Vision Operations (USA)
Navigation- Orders,Returns /Sales Order
Navigation- Orders,Returns /Sales Order
Book the order.
Once the order is booked click the ATO Model line and then right click and select progress Order (configure item will be inserted into oe_order_lines_all table)
Select Create configuration-eligible and click ok.
Configuration star item will be created in second line. Its ORA CPU ATO*223963 in our example
Now do the progress order on this configuration star item by doing right click.
Select create supply-eligible and click ok
Once clicked ok it will submit below requests in background.
This process runs a concurrent program that will push the data from OM to WIP.
Open the Assemble to order mass report and note the job number. Which is 256514 in our example.
Step#3 –Work in process job
Work in process Navigation- Discrete/discrete jobs
Enter job number and click find.
Change the status from unreleased to released and save.
Step#3 –Complete the transaction
Work in process Navigation- Material transactions /Completion transactions
Enter job number.
Please note the transaction should be WIP Completion, click continue
Enter subinventory, quantity and finally closed checkbox and finaly click done.
Come back to the order and see the order status is awaiting shipping.
Step#4 –Pick release and ship confirm the order
Order management super user Navigation- shipping/shipping transactions /launch pick release
Once pick confirmed please note the status of the line
Finaly ship the order
Once shipped you will see the status as shipped
This explains the ATO process in OM.
Thanks,
Ajay