1. Find an organization which is WMS enabled
2. Take any item assigned to this org, make sure you have onhand present
3. Make sure you have your Pick and Put away rules defined for that org
4. If you are defining stratergy then assign those in the work rule bench also
5. Create a sales order
6. use the item and source it from the WMS enabled org
7. Do Release Sales order
8. Make sure during pick release, you keep Auto Pick confirm as No and Auto allocate as No.
9. Then run the Pick release by Execute Now/Concurrent
10. Go to shipping transaction form and copy the move order for this line
11. Now go to the WMS responsibility
12. Select Rules Simulation (Setup>Warehouse Configuration>Rules>Warehouse execution>Rule Simulation)
13. Select "Pick & Putaway" in the rule simulation form left panel, then Find Move Order button will be active
14. Click on Find Move order, enter the move order and click on Simulate.
15. Now you can see which Pick rule is used in Source Loc tab and Staging Putaway rule used in Destination Loc tab.
July 30, 2014
May 28, 2014
Run this script giving inventory org as the parameter
SELECT mp.organization_id,
MP.ORGANIZATION_CODE,
hl.address_line_1,
hl.address_line_2,
hl.address_line_3,
hl.town_or_city,
hl.country,
hl.postal_code,
HAOU.NAME,
HAOUBG.NAME BUSINESS_GROUP,
GSOB.SET_OF_BOOKS_ID,
GSOB.NAME SOB_NAME, /*gsob.short_name,*/
GSOB.CURRENCY_CODE,
GSOB.PERIOD_SET_NAME,
(SELECT SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' ||
SEGMENT4 || '.' || SEGMENT5 || '.' || SEGMENT6 || '.' ||
SEGMENT7 || '.' || SEGMENT8 || '.' || SEGMENT9
FROM APPS.GL_CODE_COMBINATIONS
WHERE CODE_COMBINATION_ID = GSOB.CHART_OF_ACCOUNTS_ID) CHART_OF_ACCOUNT,
HLE.NAME LE_NAME,
HLE.VAT_REGISTRATION_NUMBER,
HOU.NAME OU_NAME
FROM APPS.HR_ALL_ORGANIZATION_UNITS HAOU,
APPS.HR_ORGANIZATION_INFORMATION HRI,
APPS.MTL_PARAMETERS MP,
APPS.GL_SETS_OF_BOOKS GSOB,
APPS.HR_LEGAL_ENTITIES HLE,
APPS.HR_OPERATING_UNITS HOU,
APPS.HR_ALL_ORGANIZATION_UNITS HAOUBG,
APPS.HR_ORGANIZATION_INFORMATION HRIBG,
apps.hr_locations hl
WHERE HRI.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.ORGANIZATION_CODE IN ('V1')
AND HRI.ORG_INFORMATION_CONTEXT = 'Accounting Information'
AND GSOB.SET_OF_BOOKS_ID = HRI.ORG_INFORMATION1
AND HLE.ORGANIZATION_ID = HRI.ORG_INFORMATION2
AND HOU.ORGANIZATION_ID = HRI.ORG_INFORMATION3
AND HAOUBG.ORGANIZATION_ID = HLE.BUSINESS_GROUP_ID
AND HRIBG.ORG_INFORMATION_CONTEXT = 'Business Group Information'
AND HRIBG.ORGANIZATION_ID = HAOUBG.ORGANIZATION_ID
and haou.location_id = hl.location_id
;
Labels
- inventory (27)
- order management (25)
- Oracle WMS (21)
- WMS (8)
- Oracle Apps Interview question (7)
- order to cash (7)
- Interview QA (5)
- Setup for WMS (5)
- purchasing (5)
- Functional Interview (4)
- Picking (4)
- drop ship (4)
- item attributes (4)
- API (3)
- Shipping (3)
- profile options (3)
- Customization (2)
- LPN (2)
- MSCA Page setup (2)
- 11i vs R12 (1)
Connect With Me
Popular Posts
- Order to Cash Cycle Step by step hands on
- Oracle SCM Functional Interview Questions: Inventory
- Form Personalization in Oracle Apps
- Overview of Purchasing in Oracle Apps
- Oracle Inventory: Inventory Organizations
- Oracle SCM Functional Interview Questions : Order Management
- Oracle Order Management Pick Release Process
- Oracle Inventory Defining Organization
- Defining Shipping Method in Oracle
- Conversion in Oracle