[OAUGNet]-Re: OM - Consignment

[<nagamohan.uppara@gmail.com>]

Subbu,
There is way to create an internal requisition based on the sales order
instead of starting the process from internal requisition itself. Meaning
instead of creating internal requisition and converting to ISO, you can
auto-create an internal requisition from sales order and update the source
information in the sales order. Take a look at the package
oe_delayed_requests_util.auto_create_internal_req for example. This code
does not work as is, but gives you an idea. I tested this and works great. 

You have to create a HR location (based on customer address) and a
subinventory (if you want a subinventory for each customer) on the fly. Also
associate this location to the customer's ship to site (creates a record in
po_location_associations_all). This will enable creation of internal req
automatically. All this you can plug into order header workflow for a
specific order type. I blogged about this (based on this thread) at
http://www.oraclebusinessapps.com.

This will help avoid your extension to do subinventory transfer in workflow.

Also when customer consumes (pay-as-you-go model), are you creating one more
order automatically so that your COGS can get hit and revenue can be
generated?

Thanks
Nagamohan


-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Subram
Subbu
Sent: Sunday, May 18, 2008 10:39 AM
To: OAUG Net listserver
Subject: [OAUGNet]-Re: OM - Consignment


Matt,
Thanks for the information. Our pick release is a custom process and there
are lot of customizations that we have around OM and Inventory. Since our
orders are created into Oracle using a third party system we cannot create
internal requisitions and create internal orders.

We are planning to use the sub inventory called consignment approach.

When we create a sub inventory called consignment the orders get created
automatically and the pick release happens automatically (all custom
processes).
When the pick release happens we want to move the material into consignment
sub inventory and ship the product to the customer with the paper work.
Invoicing will not happen as the workflow will be customized to do sub
inventory transfer.

When the customer consumes the product than there will be a process that
creates invoice into AR and the product moves from consignment sub inventory
into the regular warehouse.

Our AR process (billing is also customized heavily) so that we can leverage
the custom process.

Can you let me know if we have to create a sub inventory called consignment
how we can configure the applications.

Any documents will help.

Thanks again
Subbu

> To: OAUGNet@oaug.com
> Subject: [OAUGNet]-Re: OM - Consignment
> Date: Tue, 13 May 2008 10:09:20 -0400
> From: vxsmimmcp@SUBARU.com
>
> I have implemented this sort of consignment several times. I always use
> a separate inventory organization for the following reasons:
>
> 1) If you're using an actual costing model, separate organizations let
> you track consigned inventory values in separate GL accounts.
> 2) It allows you to use subinventories for something else. For example,
> a separate subinventory for each customer (not saying I'd do it, but
> maybe if the requirements make sense). Or perhaps a poor man's status
> control ( i.e., AVAILABLE, DAMAGED, INSPECTION, etc )
> 3) Its more in line with standard functionality. For example, if you
> ever want to track intransit to/from consigned locations or do
> transportation planning or ASCP, you'll be better off if these locations
> are inventory organizations rather than subinventories.
>
> Hope this helps,
> Matt
>
> mcpeakm@tempus-consulting-group.com
>
>
>
> -----Original Message-----
> From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Subram
> Subbu
> Sent: Tuesday, May 13, 2008 9:45 AM
> To: OAUG Net listserver
> Subject: [OAUGNet]-OM - Consignment
>
>
> Hello All,
>
> I am looking for an implementation document/process flow for customer
> consignment.
>
> After some research I found out that there are 2 ways you could do
> this.
>
> 1. Create an new inventory org called consignment (Through Internal
> Reqs/Internal Orders) 2. Create a new sub inventory called consignment
> and do sub inventory transfer when pick release happens.
>
> Wanted to know if anyone that implemented consignment can share their
> experiences.
>
> Thanks
> Subbu
>
> _________________________________________________________________
> With Windows Live for mobile, your contacts travel with you.
> http://www.windowslive.com/mobile/overview.html?ocid=TXT_TAGLM_WL_Refres
> h_mobile_052008
> #############################################################
> This message is sent to you because you are subscribed to the mailing
> list .
> To unsubscribe, E-mail to:  To switch to the FEED
> mode, send any message to  To switch to the
> DIGEST mode, E-mail to  To switch to the INDEX
> mode, E-mail to  Send administrative queries to
> 
>
>
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing list
.
> To unsubscribe, E-mail to: 
> To switch to the FEED mode, send any message to 
> To switch to the DIGEST mode, E-mail to 
> To switch to the INDEX mode, E-mail to 
> Send administrative queries to 
>

_________________________________________________________________
Make every e-mail and IM count. Join the i'm Initiative from Microsoft.
http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ MakeCount
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>