Showing posts with label setup for order management. Show all posts
Showing posts with label setup for order management. Show all posts

November 18, 2016

Back to Back(B2B) process is used for items that are not typically stocked nor manufactured. In an environment where lead times are often only a matter of 24 hours, the B2B process improves efficiency of the three steps above, by closely linking the Sales Order and the Purchase Order together.

The B2B process automates the creation of a supply order (PO) when a sales order is booked. The supply order is hard pegged (hard-reservation) to the sales order that it is supplying so that once the PO is received, the items are not inadvertently taken by another order or demand. Where the sales order line is within the process, can be visible at all times so that customer service inquiries can be answered. 

This process is also called Supply to Order.

1. Customer orders items (OM).
2. Purchase those items from the supplier (PO) and receive them into the warehouse.
3. Ship those items to the customer (OM).

Create a B2B Item

Go to Inventory > Items > Master Items and define the item as follows :
Enter item name and description.
From Tools > Copy From, apply the Purchased Item template.




 In the Purchasing tab, enter a value in the List Price field.


 In the General Planning tab, set the Make or Buy flag to Buy


 In the Work in Process tab, make sure the Build in WIP flag is checked


  In the Order Management tab, check the Assemble to Order flag (ATO).


Save, and assign to Organization M1
B2B item must be created at item validation org.
Same item in same item validation org cannot be both stock item and a B2B item

Define Sourcing rule for the item

Sourcing rules can be set up in PO to default sourcing information such as the supplier from which the item is purchased.


Assign the item to the price list


Back to Back Order Flow

Create Order

Go to OM > Orders, Returns > Sales Orders.

Create a sales order with Order Type Mixed and enter the B2B item created in previous step in the lines for any quantity.
Book the order. Note down the Order Number


 The line status will move to Supply Eligible (flow_status_code SUPPLY_ELIGIBLE).


Place cursor on the line and go to Actions > Progress Order > Select Create Supply Order - Eligible to progress the workflow of the line 
 

The line status will now show PO-ReqRequested/External Requisition Requested (flow_status_code PO_REQ_REQUESTED).

OM has inserted a record in the PO requisitions interface table.



Go to Purchasing > Reports > Run and run the concurrent program Requisition Import with the Import Source parameter = CTO. Leave the other parameters as default. The concurrent program can also be run from OM > Orders, Returns > Requisition Import.
Go to View > Requests and verify that the Requisition Import has completed successfully.


The line status of the sales order line will now show PO-ReqCreated/External Requisition Open (flow_status_code PO_REQ_CREATED)

From the sales order line, go to Tools > Scheduling > Reservation Details > 'Supply' tab. Verify that the order line is reserved against the requisition. Note down the requisition number seen in this window.



Go to Purchasing > Requisitions > Requisition Summary.

In the Find Requisitions window, enter requisition number found in the previous step and click on Find.
Verify that the status is Approved



Go to Purchasing > Autocreate.
From Edit > Clear > Record, clear any query criteria that may be defaulted like buyer, requester etc.
Enter requisition number and click Find.
  


Check the checkbox to the left of the line, and click on Automatic. Enter the Supplier and Supplier site such as the following and click on Create


 Once the PO created, enter the supplier and site details and once everything is OK, approve the PO


The line status of the sales order line will now show PO-Created/PO Open (flow_status_code PO_CREATED)


From the sales order line, go to Tools > Scheduling > Reservation Details > 'Supply' tab. Verify that the order line is reserved against the PO


Go to Purchasing > Receiving > Receipts.

Enter Purchase Order number and click on Find.
In the Receipts window, check the checkbox to the left of the line and enter and save the receipt

Go to Purchasing > Receiving > Receiving Transactions Summary.

Enter the Purchase Order number and click on Find.
Click on the Transactions button.
Verify a Receive and Delivery transaction. This means that the B2B item has been received into Inventory.


The line status of the sales order line will now show Awaiting Shipping (flow_status_code = AWAITING_SHIPPING).

On the sales order line, Tools > Scheduling > Reservation Details will now show that the item is reserved against Inventory in Subinventory = FGI (PO has been received in this subinventory).

The line can now be pick released, shipped and invoiced to the customer.

This completes the Back to Back Order workflow.

Useful queries

Once you progress the order after Supply Eligible step, use below query to find whether the data inserted to requisition interface or not

select * from po_requisitions_interface_all
where interface_source_line_id = &order_line_id
and interface_source_code = 'CTO';

Read More

December 2, 2015

Oracle Order Management Setups

Oracle Order management is one of the most important part of the oracle EBS. The Order Management Application provides many flexible features enabling you to set up your system to begin processing order information. These orders can be created in Oracle Order Management Suite as well as in some other front-desk application. We can integrate these applications with Oracle Order Management for keeping a controlled track of orders and proper business flow. We can create different types of orders using this application can be for inventory stock items or for services.
You must define your business order policies, such as how you classify your orders, as well as various control features prior to processing orders within the application.
Important Setup Steps for Order Management
Click on the links to go to individual setup steps

Step Optional or Required
1. Define multiple organizations in Oracle Inventoryrequired
2. Setup Multi-Org (Multiple Organization) Access Controloptional
3. Define key and descriptive flexfieldsrequired under certain conditions
4. Define inventory organizations (warehouses), parameters, subinventories, and picking rules in Oracle Inventoryrequired
5. Define Profilesrequired
6. Setting OM System Parametersrequired
7. Define invoicing information, Payment Termsrequired under certain conditions
8. Define your sales representativesoptional
9. Define Tax Featuresrequired
10. Define Quickcodesrequired under certain conditions
11. Define header and line processing flowsrequired
12. Define Document Sequences for Order Numberingrequired
13. Define Order Import Sourcesrequired under certain conditions
14. Define the units of measurerequired
15. Define item informationrequired
16. Define the items that you sellrequired
17. Define the configurations that you sellrequired under certain conditions
18. Define price listsrequired
19. Define customer profile classesrequired under certain conditions
20.Define information on your customersrequired
21. Define item cross referencesrequired under certain conditions
22. Define your sourcing rulesoptional
23. Define Order Management Transaction Typesrequired
24. Set up Cost of Goods Sold Accounting flexfield combinationrequired under certain conditions
25. Define Processing Constraintsoptional
26. Define Defaulting Rulesoptional
27.Define Credit Checking Rulesrequired under certain conditions
28. Define Automatic Holdsrequired under certain conditions
29. Define Attachmentsoptional
30. Define Freight and Special Charge Typesoptional
31. Define shipping parametersrequired
Read More

January 7, 2013

Order Management: Profile Options

During implementation, you set a value for each user profile option to specify how Order Management controls access to and processes data.

Profile Categories

Profiles have been categorized so that they can be easily classified or grouped. The following table displays the profile categories and the profile options that belong to each one. Some profile options belong to more than one category and are indicated in the table below.
Profile Category Name Profile Option(s) 
ConfigurationsOM: Allow model  fulfilment without configuration;
OM: Configuration Quick Save;
OM: Copy Model DFF to child lines;
OM: Included Item Freeze Method;
OM: Party Totals Currency;
OM: Use Configurator;
Customer UsageOM: Add Customer;
OM: Add Customer (Order Import);
OM: Create Account Information;
OM: E-Mail Required on New Customers;
OM: Party Totals Currency;
OM: Sales Order Form: Restrict Customers
DebugOM: Debug Log Directory;
OM: Debug Level;
OM: Generate Diagnostics for Error Activities;
DeploymentOM: DBI Installation;
OM: Orders Purge Per Commit;
OM: New EDI Acknowledgment Framework;
OM: Printed Document Extension Class Name;
OM: Use Configurator;
Electronic MessagingOM: Change SO Response Required;
OM: Electronic Message Integration Event Sources
OM: New EDI Acknowledgment Framework;
OM: Order Accept State for XML;
OM: Run Order Import for XML;
OM: Send Acknowledgment for Change PO Response;
Forms UIOM: Add Customer;
OM: Administer Public Queries;
OM: Automatically Open Related Items Window;
OM: Contact Center Actions Menu Name;
OM: Cust Item Shows Matches;
OM: Display Actions Button vs. Poplist;
OM: Display Current Selections in Pricing/Availability;
OM: Enable Related Items and Manual Substitutions;
OM: Item View Method;
OM: Quick Sales Order Form: Auto Refresh;
OM: Quick Sales Order Form: Defer Pricing;
OM: Sales Order Form: Cascade Header Changes to Line;
OM: Sales Order Form: Refresh Method (Query Coordination);
OM: Sales Order Form: Restrict Customers;
OM: Sales Order navigation from Pricing/Availability form;
OM: Sales Orders Form preference;
OM: Scheduling Role;
OM: Show Line Details;
OM: Show Process Messages Flag;
OM: Use Configurator;
OM: View Cancel Lines;
OM: View Closed Lines;
OM: View Pricing & Availability Information in Related Items;
FulfillmentOM: Allow model fulfillment without configuration;
OM: Included Item Freeze Method;
OM: Over Return Tolerance;
OM: Over Shipment Tolerance;
OM: Population Of Buyer Code For Dropship Lines;
OM: Source Code;
OM: Under Return Tolerance;
OM: Under Shipment Tolerance;
OM: Automatically Interface Lines to IB on Fulfillment
HoldsOM: Modify Seeded Holds;
OM: Prevent Booking for Line Generic Holds;
InvoicingOM: Interface freight tax code from line;
OM: Invoice Numbering Method;
OM: Set Receivables Transaction Date as Current Date for Non-Shippable Lines;
OM: View Intercompany AR Invoice
Item UsageOM: Customer Item Shows Matches;
OM: Enable Related Items and Manual Substitutions;
OM: Item Flexfield;
OM: Restrict Customer Items for Line Level Ship To Address;
LogisticsOM: Sequence for TP Ship/Deliver Deadline;
OM: Source for TP Early Ship/Deliver Date;
Order ImportOM: Add Customer (Order Import);
OM: Import Multiple Shipments;
OM: Unique Order Source, Orig Sys Document Ref Combination For Each Customer;
PaymentsOM: Commitment Sequencing;
OM: Credit Card Privileges;
OM: Preserve External Credit Balances
Portal UIOM: Customer Service Feedback;
OM: Customer Service Report Defect;
OM: Records On Summary Page For External Users;
PricingOM: Charges For Backorders;
OM: Charges for included item;
OM: Charging Privilege;
OM: Discounting Privileges;
OM: Enable Group pricing for DSP lines;
OM: Item Change Honors Frozen Price;
OM: List Price Override Privilege;
OM: Negative Pricing;
OM: Promotion Limit Violation Action;
OM: Send Changed Lines to Pricing;
OM:Unit Price Precision Type;
OM: UOM Class for Charge Periodicity;
OM: Price Adjustment Modifier for AIA Order Lines
ReturnsOM: Customer Service Feedback;
OM: Customer Service Report Defect;
OM: Over Return Tolerance;
OM: Notification Approver;
OM: Return Item Mismatch Action;
OM: Return Unfulfilled Referenced Line Action;
OM: Under Return Tolerance;
SchedulingOM: Assign New Set For Each Line;
OM: Authorized To Override ATP;
OM: Auto Push Group Date;
OM: AutoSchedule;
OM: Enforce Shipping Method for Ship Sets;
OM: Schedule ATO Item Without BOM;
OM: Scheduling Role;
SecurityOM: Add Customer;
OM: Add Customer (Order Import);
OM: Administer Public Queries;
OM: Authorized To Override ATP;
OM: Cascade Service;
OM: Charging Privilege;
OM: Create Account Information;
OM: Credit Card Privileges;
OM: Discounting Privileges;
OM: List Price Override Privilege;
OM: Modify Seeded Holds;
OM: Scheduling Role;
OM: Authorized To Override ATP;
ServiceOM: Cascade Service;
Transaction EntryOM: Apply Automatic Attachments;
OM: Cascade Service;
OM: Configuration Quick Save;
OM: Copy Model dff to child lines;
OM: Default Blanket Agreement Type;
OM: Default Blanket Transaction Phase;
OM: Default Sales Transaction Phase;
OM: Default Salesrep;
OM: Display New Order After Copy
OM:Enforce check for duplicate Purchase Orders;
OM: Generic Update Constraints Apply to DFF?;
OM: Prevent Booking for Line Generic Holds;
OM: Return Item Mismatch Action;
OM: Return Unfulfilled Referenced Line Action;
UpgradeOM: Context Responsibility for Upgraded Orders;
OM: Notification Approver;

Navigate to System Administrator Responsibility
Profiles à System

Read More
Copyright © . Oracle Apps (SCM) . All Rights Reserved
Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here