Friday, April 27, 2012

Customized Sales Order Cycle


For One my client which i did a project , the Sales order cycle was customized.
The Customer would first come to client, Client will Raise a SO against the customer.
A purchase order Will be raised against already approved Blanket Purchase order for the qtr.
The PO will be fulfilled by Contract Manufacturer.CM  Will ship the  product to third party Logistics .
3PL will be then responsible to ship the product to Customer premises.
Invoicing will be done by client and client will pay in turn pay to CM 
Following the business flow depicted in Diagram:


Wednesday, April 25, 2012

Business process


Reverse Logistics

As Functional consultant of oracle, we’ve got lot of technical documents on forms and navigation for application. But as a Functional consultant we need to know the business process , how does the business work. If we have clear understanding of the business process, the turnaround time for issue resolution can drastically come down, as functional consultant won’t have to rely on customer’s testing.
I would like to share the business process a company here which is into semiconductor related component manufacturing in hi tech industry.
The item manufactured by company are mission critical and that is why if the customer is asks for item return , the items are first shipped to customers place and returns of the item takes place afterwards .
The entity which ship the item is called 3PL( third party logistics)
The entity which takes return of goods from customer is called 3PR (third party Repair).
These 2 entity are partners for the company. These will be different company , external to customer, bound by business  agreement.There fore we cannot use same Oracle production instance for these outside business entity. We do not want to expose our production related data to outside world, even if they are business partner. But still we have to provide the data for which they need to take action.
This is achieved by B2B messaging system where partner is B2B enabled.
If partner is not B2B enabled than we send and receive  flat file messages.
Here 3PR is non B2B enabled partner and 3PL is B2B enabled partner.
Messages exchanges takes place on Rosetta net standards
Following are the Reverse logistics operations  which takes place between the various entity:
 
1.       Adjustment 4B3
2.       Depot Transfer
3.       FG_Shipment
4.       Inventory Variance 4C1 3PL
5.       Inventory Variance 4C2 3PR
6.       Move Order
7.       Site Transfer
8.       RMA cycle

 Each of these Process is explained in upcoming posts



Wednesday, March 14, 2012

Quote to sales order in orale application

In Quote to order cycle following steps are involved

1.Create a quote- Quote number generated in draft Status(hdr and line)-



Nav: Negotiation>quick quote

2.Get (submit for ) internal approval - status of hdr and line is Pending internal approval- Nav: Action>progress quote > Submit draft eligible

3.Get customer acceptance quote work flow completes -before acceptance quote will be in in pending customer acceptance



Nav : actions> customer aeptance




4.sales order gets created in entered status -Quotes heder/line data populates in SO header /lines



After Quote is accepted by customer we can create Sales order Agreement out of it and create relase which can be converted to Sales order.

Thursday, December 15, 2011

Oracle Application-Order to cash Learnings

Take always from O2C
· Order Management is Workflow driven module
· Currency defaults in SO from
o Set of books in 11i
o Ledger in R12
· Importance of OM cycle is we can break any point in the cycle and start again after some time from the point we stopped
· OM cycle ends with booking the order , after that shipping execution starts
· Advanced pricing offers following additional features on pricing
o Secondary price list
o Modifiers
o Qualifiers
o Price breaks
o Dynamically or statically calculate the price on line and apply
· You can create a SO in Local currency bur invoice the customer in different currency by conversion feature in Price list.
· Different type of Workflow used in OM based on order types
o Bill only
o Ship only
o RMA
o Correction (Retro billing)
o ISO
· In price list set up –grouping number
o 1 & 1 represents And condition
o 1& 2 condition represents Or condition
· We can enter the price in SO line for a item in following 2 Scenarios
o Manual modifier (automatic check box is unchecked in Modifier)
o “All item price list”
· Fulfillment set is group of lines that should be invoiced together.
· Pick Release difference
o Form Shipping transaction –will be released by picking release rule for the Organization
o From Release sales order form –we can manually give any release rule.
· Only if SO line is closed then you can invoice the SO line
· Only in following 3 condition Pick release can fail
o Inventory Periods closed
o Tractable quantity not there(on hand)
o Hold applied
o Org is not reservable
· Diffrence between 2 methods of pick release
o Concurrent-When there are multiple users performing transaction in same form , all can run parallel.
o Execute now-Only one user allowed at one time.
· Item set ups over writes all other parallel set up (Eg cogs account)
· Retro billing-When you have closed order line and customer says he wants to change the price and you want to honor that ,retro billing allows to change the price on line invoiced line.
· Condition mandatory for retrobilling-
o Line should be closed and invoiced.
o In the same price list items should have a different price other than invoiced price.


Wednesday, December 14, 2011

Oracle application-Receving

when you receive any item in your inventery (either from expected receipts or receiving) Receiving transaction processor fires which updates inventery and accounts for respective actions

Wednesday, January 6, 2010

Open ears

Yersterday i went to one of my non regular shop for getting pulse, as in regular shop the cost sky high. Expecting a good bargain in the wholesale shop i was not very much surprising to see only Rs 2 diffrence from my regular shop. For last few months the cost of these basic commodities have been reaching the peak.That to in India where people are mostly vegitarian and pulse comes as stable diet.It is really a kind of irony, who would agree we are basically a agrarian economy, where 70% of population still depands on agricultre. The pulse rate is Rs 80 and the farmers dont get more then 30. given the kind of investment they do , the return seems meagre.
After purchasing it as i was just about to leave out of aggravation i just asked the shopkeeper'Bahiya ye dal ka rate come hoga ki nahin". To that he gave me an anwer which was a really eyeopener.He Said we should not have reelected the govt.They should be terrified if they are not(as they are not 'coz they came again to power), they can rig any thing to get swell there pocket.
And picture was clear to me, who is pocketing the diffrence .
some time u never know who can teach u what.
jst keep ur ears open.