Sets in Oracle Order Management

This video post is about Sets available in Order Management , here I will talk about the

1. Fulfillment Set
2. Ship Set.
3. Arrival Set. available in Oracle Order Management.

How to Add/Remove order lines to sets.

How to Progress the lines that are part of set.

For In depth analysis about Sets Please refer my 5-parts Series on Sets in Order Management.

Quote to Order Flow in Oracle Sales Quotes (Oracle Application)

Oracle Sale Quote is another system that offers excellent opportunity for the sales guys to create/follow up and play with the Sales Quotes as per the customer requirement and needs. Once Quote is approved it can be converted into Sales Order(in Order management) with Single click of mouse.

In this blog I will explain some of important features available in Oracle Sale Quote.

Note – Please Note that there is no workflow associated with Oracle Sales Quote, off course we do have Approval workflow for Quotes (Integrated with AME)

Open the Sales Quote,
1.    Enter Header
2.    Enter lines.

Initially Sales Quote Status will be “Draft”.

 

Sales Quotes in Oracle Order Management.

In this blog I will explain in brief about Quotes Functionality Offered by Oracle Order Management Suite. Topics that I will cover here are

1. Setup
2. Defaulting Rule & Generation of Defaulting Rule (When Required).
3. Profile setup.
4. Transaction Type.

Data Flow from Quotes to OM Order.


Oracle Quotes offers limited capability to create Quotes and Progress it through the Negotiation phase and finally creates Sales Order.In case your Organization has complex / advance quoting needs you should Implement Oracle Sales Quoting.

Auto Scheduling in Oracle Order Management.

This Video Presentation is about Auto Scheduling in Oracle order Management, and what are the different ways to Setup the Auto Scheduling

Here I will explain how we can Trigger auto scheduling from

1.OM Profile Option OM:AutoSchedule
2.Tools Menu .
3.Transaction Type Setup
4.Sales Order line
5.Sales Order Header
6.Schedule Order Concurrent Program

Query to get open sales order lines(in Oracle Apps) , where line workflow is Purged/Deleted.

Select Line_Id, flow_status_code,ordered_quantity,shipped_quantity, fulfilled_flag, invoice_interface_status_code
From Oe_Order_Lines_All l
where open_flag = 'Y'
And not Exists
(Select 1 From Wf_Items W
Where W.Item_Type='OEOL'
and w.item_key = to_char(l.line_id));

Manual Scheduling in Oracle Order Management Line Flow

In this video Presentation I will talk about the Manual Scheduling Workflow Sub-Process available in Oracle Order Management.
In Order Management Order line workflow we have 3 type of Scheduling Sub-Process.

1. Schedule – Line
2. Schedule - Line, Manual
3. Schedule - Line, Deferred

 today I will talk about Ist and 2nd.

 In Schedule – Line, Scheduling is Online- that means as soon as we Book the Order Scheduling happens, but in Schedule – Line Manual Scheduling , scheduling is Manual , as soon as we book the Sales Order Scheduling workflow activity will not be Trigger,

 Please Refer the Below YouTube demo for

1. How to Modify the Oracle Order line workflow to Add Manual Scheduling Sub-Process.
2. How to Progress line with the Manual Schedule -Subprocess with "Schedule Order" concurrent Program

YouTube Demo

Custom Hooks to Implement Freight Terms as Pricing Qualifier in iStore

User Hooks are a feature that allows customizing the application in a way that is less invasive and that can be easily disabled for diagnosing problems with the customization. Hooks are code that is conditionally executed by some application packages. The condition is that the hook has to be enabled.

Hook calls are interleaved in some of ASO APIs, mostly on public APIs. There are two types of Hooks:
Pre-processing Hooks: Are hooks that execute (if enabled) before the API does any actual processing. These are good for modifying/adding information so the API can proceed with that change in place. These hooks are of type B (from Before)
Post-processing Hooks: Are hooks that execute (if enabled) after the API did all processing. Post hooks are usually good for cleanup of a pre-hook or for further processing after the vanilla API has finished work. These hooks are of type A (from After).
Below are the Steps to Implement Custom Hooks in ASO .
Requirement for Implementation in my Case - In my example I want to use Freight Terms at the iStore to be used as Qualifier to derive the item price in Shopping Cart in iStore, but Freight Terms is not supported as Qualifier for iStore ,and to fulfilfill this requirement , I have implemented custom hook to used Freight Terms as Qualifier from the iStore.
Implementation Steps

not possible to query workflow information: Item Type (OEOH) / Item Key (xxxxx)

One or both of the following values is invalid so it's not possible to query workflow information: Item Type (OEOH) / Item Key (xxxxx). Try selecting the "Status Monitor" tab to search for a different workflow.

Oracle Order management raised above error if you try to view the workflow status for a particular item type(says OEOH) and item key(Order Header ID) combination and no such records exists for item_key in wf_items table.


ORA-01403: no data found ORA-01403: no data found