Subject: How to Create New Inventory Stock Locator.
Step1: Navigation: Application Developer > Flexfields > Key > Values
Search with following Details. Click on Find
Step2:Click
on “+” button and Create New Entry. Click on Save.
Step3:
Navigation: Inventory > Setup > Transactions > Organization > Stock
Locators.
Click on New Button.
Enter all these 3 new locator entries. Save the Transaction.
Subject: Need to fetch Sales Order Shipment Shipping Cost Query.
Navigation: Supply Chain Execution > Inventory Management > Shipment > Manage Shipment > Enter Order No and Search
SELECT
SUM(UNIT_AMOUNT) SHIPPING_COST
FROM
WSH_FREIGHT_COSTS WFC,
WSH_DELIVERY_DETAILS WDD
WHERE WFC.DELIVERY_DETAIL_ID=WDD.DELIVERY_DETAIL_ID
AND WDD.SOURCE_HEADER_NUMBER='1531' --SO ORDER NUM
Subject: We need to do setup for auto approve PR and PO.
Step1: We need to check which Job is assigned to the PR/PO Preparare.
Navigation: Global HRMS Manager > People > Enter and Maintain > Search your User Name > Click on Assignment Button.
Note: IF the PR/PO Preparare not have registered in Global HRMS as an employee than He/She can not create PR/PR
Step2: Check the Oracle USer has assigned the Employee User or Not.
Navigation: System Administrator > Security > User > Define > Search with User Name.
We can check the Global HRMS person assigned to Oracle User. If not assigned please assign it.
Step3: Need to assign User Job for Approval Assignment.
Navigation: Purchasing Super User > Setup > Approval > Approval Assignment > Search with Job.
Add the document type for 'Approve Purchase Requsition' & 'Approve Standard Purchase Order'
Now prepare PR and PO it will automatically be approved after creation.
