Current Position:Home > IStore Determine ship_from_org_id  before selecting ship to address

IStore Determine ship_from_org_id  before selecting ship to address

Update:11-30Source: network consolidation
Advertisement
Hi I need to determine default Ship_from_Org_id( usually determined by defaulting rules) in Order capture module before placing order. Is there any API in Order Management or Order Capture to determing the ship_from_org_id based on defaulting rules. I need to determine this for each item in the line.
please help this is urgent..

The Best Answer

Advertisement
Oh! The fun of using Order Capture.
Unfortunately there is no way of doing this using API. I am assuming you need this for Checking Availability. We have discussed this at length with the Order Capture development team at Oracle. Here is the solution we implemeted at a fortune 100 company, recently.
1. We added a flexfield at the order capture line level, and defaulted the Ship From Org from mtl_system_items.source_organization_id (?).
2. We added a trigger on the MSC_??? (I don't remember the name of the table right now, but if you are interested I can send you the complete solution, this table is the equivalent to mtl_demand_interface now) table to change the warehouse to the warehouse in the aso_quote_lines.attribute?? .
3. We wrote a defaulting rule in OM to default the Ship From from this flexfield (sequence 1) (this may or may not be necessary in your case).
This solution can be impletemented in a day. Its not the prettiest way of doing it :-), but it worked great. It also took care of the problem where you could not put the source warehouse at a model level, or cascade the warehouse/request date from the model to the option/option classes.
If you need more details on this write to me at [email protected], I should be able to send you all the details.
regards
Pankaj
Neocortex, Inc.
Oracle Application Consultants
  • IStore Determine ship_from_org_id  before selecting ship to address Update:11-30

    Hi I need to determine default Ship_from_Org_id( usually determined by defaulting rules) in Order capture module before placing order. Is there any API in Order Management or Order Capture to determing the ship_from_org_id based on defaulting rules.

  • URGENT-iStore creates new ship to address on checkout-no permission to user Update:11-30

    We are running into issue of when iStore is checking out, it is creating a new ship to address for custoemer. User role does not have a permission to create contact/ship to/bill to address. It only creates ship to address. What should be causing this

  • Ship to address in iStore Update:11-30

    Hi Does anyone know if we can make 'COUNTY' field required when customer creates ship to address on the fly. This is just for US only as county concept is more appropriate for US. Please respond ThanksI am not sure if this can be derived via setup, h

  • Selecting appropriate tax code based on Item and Ship to Address Update:11-30

    In the US, there is the ability to denote an Item's tax liability on the Item master. There is also the ability to denote tax code on the ship to address. In the US, some states tax products; some states tax maintenance; and some states tax services.

  • Issue in Canada Ship To Address.. URGENT Update:11-30

    Hi All, We added Ship to Address Form in Ship To Page in iStore . 115.10.2 If I click on 'Continue Checkout' button , then it redirects to same page wiht the following errors Address Line 1 is required Field and Province is Required Field Please any

  • How to enable the 'Ship-To Address' field only in 'display ' mode in the SC Update:11-30

    Hello, We would like the 'Ship-To Address' field to be locked for change mode in the SC. Regards, LinaHi , If you wish to hide or show fields, proceed as follows(through screen variants): 1. Determine the screen variant, for example, BBP_SC(For shopp

  • Defaulting  taxcode on ship to address on BP via UI Update:11-30

    Hi, I would like to default the tax code field in the matrix on the right side of the BP addresses tab when the user clicks the "define new" option on the left matrix for a ship to address.  The user wants the value to default to the entry they

  • Table holding Delivery shipping/billing address information Update:11-30

    All, Which table holds the shipping and billing addresses for a delivery? In my query below, I have retrieved the shipping / billing address attached to the order line referenced on any one of the delivery detail lines. But there are multiple deliver

  • SRM 7.0 Ship-To Address Update:11-30

    All, I am trying to determine how I can build and maintain a list of delivery addresses in SRM 7.0. I realize tht all company codes have an address which can be used as a deliver to address, but in 5.0, you could use the transaction "Maintain Address

  • Multiple Ship To Address in a Purchase Order Update:10-11

    Can we have multiple ship to adresses in a Purchase Order in SAP Business one.SAP does not give you an option to select different ship to addresses in purchase orders unless you are using a drop ship warehouse. Thanks MurtuzaRead other 3 answers