What is ship_to_org_id and ship_from_org_id in Oracle Order Management

Thsi Post is for Oracle Apps (Order Management).

ship_from_org_id column in Oracle Order Management application means warehouse from where you ship the goods to customer.Please keep in mind ship_from_org_id should be an Inventory organization (Because you want to ship the goods and if you don't define your warehouse as Inventory org then how you will able to ship the from from there ) , Technically , if you define and organization and not mark it as Inventory Org , then in Order Management Waregouse column ( lines level) , your organization will not appear , till you mark it as Inventory org and assign items to it.

Ship_to_org_id is the location where you actually want to ship the good , this is possibly be your customer's place and it can be or can't be an Inventory org.

Important table and view to look into for this are
1.SHIP_TO_ORG_ID
hz_parties
hz_cust_accounts
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_SITE_USES_ALL

2.SHIP_FROM_ORG_ID
org_organization_definitions
HR_ORGANIZATION_INFORMATION


No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...