Devendrakumar Rajendran - A Blog to Oracle Financials World

How to enable multi currency feature in Advanced pricing module? Enable following profile options Multi currency installed - Set to 'Yes' @ Site Level Multi currency usage - Set to 'Yes' @ Application Level  (Advanced Pricing) Pls. note that once you enable above profile options, oracle has recommended not to disable again this may lead to data corruption issue or malfunction of program behavior. You can go to multi-currency conversion list, to define base currency and conversion currency details at line details Conversion type can be specified -user rates, corporate rates, fixed rates, EMU rates, and so on., Conversion date type should be - pricing effectivity date or fixed date Currency base rounding factor is automatically captured based on precision defined in FND_currencies Go to price list screen You can view new field(Multi currency conversion) is enabled for all the existing pricelist. You can link your multi currency conversion list

Sub Inventory transfer is used to move materials from one sub-inventory to another within same organization. This is especially used to 1. Adjust on-hand quantities between sub-inventories 2. Transfer to another sub-inventories for specific business need like additional sales 3. Damages/expiry products can be moved to non-asset sub-inventories to discard it from inventory valuation report and so on., Key elements 1. From sub inventory 2. To sub inventory 3. Organization 4. Inventory item 5. Transact quantity 6. Transact unit of measure 7. Transaction type 8. Transaction action 9. Transact Reference 10. Transact date 11. Lot Number Open Interfaces mtl_transactions_interface - is used to populate sub inventory transfer details mtl_transaction_lots_interface - is used to populate lot details for particular sub inventory transfer Base Tables mtl_material_transactions - is used to get all type of material transactions like sub-inventory transfer, inter-org tra