Search 800 + Posts

Apr 16, 2014

How to handle SHIP_FROM_ORG_ID in Oracle iStore

iStore does not expose warehouse (ship_from_org_id) field in the Customer UI pages such as the Shopping Cart nor the Checkout pages.  Therefore, iStore does not have any logic to populate this information to the underlying ASO schema (ASO_SHIPMENTS.ship_from_org_id).
Only the Quoting application exposes this field on the Quoting Forms UI.  The ASO schema (Order Capture) is shared by iStore and the Quoting modules.

In EBS we have profile option ASO: Default Ship From Org , as per R11i behavior iStore refer this profile option to drive value of a warehouse during normal pricing call or whenever item gets added to cart or during checkout

but in R12i  this behavior is completely changed and istore no longer  refer this profile to drive value of warehouse during pricing call or when ever  item gets added to cart or during checkout.But iStore still refer this profile option during ATP call.

iStore defaults warehouse (ship_from_org_id) on the Sales Order during cart to Order conversion using the OM Defaulting rule for the attribute "warehouse".   However, this defaulted value will not be saved to the iStore side.

If there is a business need to use the warehouse in custom pricing attribute sourcing for iStore, we can execute that by means of simple customization. We can consider below 2 opions...

1. Create a custom sourcing rule for the request type ASO to source the value from the profile option using  FND_PROFILE.value('ASO_SHIP_FROM_ORG_ID') in the PL/SQL sourcing rule 

2.Use Custom Hooks APIs to Populate aso_shipments.ship_from_org_id  when a new cart line is being added using  ASO user hook (ASO_QUOTE_CUHK package body).  Add the logic in create_quote_pre (first time when cart was created) or update_quote_pre.

Hope that helps , for any additional information fee free to write me back at

1 comment:

  1. Thanks for sharing the fabulous information to the general public. We have the cleaning services in Sydney for the benefits of people at range able price. Our services are given below, please must visit…
    Lounge Cleaning Services in Sydney
    Sofa and Carpet Cleaning Services in Sydney