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.
Subject: How to print error/success transaction detail in log and output file of the concurrent program.
Resolution:
We can use the below syntax in plsql code to generate log and output file with transaction details. User can append any number of transaction fields in the same syntax line using pipe seperator.
--FND Log--
FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: '||l_error);
--FND Output--
FND_FILE.PUT_LINE(FND_FILE.OUTPUT,xxtlm_rec.inventory_item_id||' Item Updated Successfully');