Oracle Geeks

Below are some of the  commonly used short cut keys which which will help in navigating the application. Clear Block               F7 Clear Field                F5 Clear Form               F8 Clear Record            F6 Commit                    Ctrl+S Copy                       Ctrl+C Cut Ctrl+X Delete Record Ctrl+Up Display Error Shift+Ctrl+E Duplicate Field Shift+F5 Duplicate Record Shift+F6 Edit Ctrl+E Enter Query F11 Execute Query Ctrl+F11 Exit/Cancel Query F4 Help Ctrl+H Insert Record Ctrl+Down List of Val...

Invoice Price Variance Process Accounting: Note: Below Working and results are only applicable where Purchase Orders and Invoice are not routed through LCM Module. For LCM Enabled Items IPVs are routed and transferred to Inventory directly from LCM. Invoice Price Variance is variance between the invoice price and the purchase price for all inventory and work in process related invoice distributions. Payables records invoice price variances when the invoices are matched, approved, and posted. This Article covers the detail Accounting for Oracle Invoice Price Variance Process and also its effect on item Unit Cost in Inventory. Let's Put up a scenario here. We will be receiving an item in Inventory which has currently no On Hand Balance or Unit Cost in Inventory. We Booked a Purchase Order for Quantity 100 at Unit Price of BDT 10 . We did the Receipt of the booked Quantity 100 at 01-August-2014 and receipt delivery was made on same date with all quantity acce...

Here is the link to file I prepared last year related to Issues and Resolutions in Oracle eAM Module. This File has detail steps to reproduce the issue and its resolution. I hope this effort help you guys out. Thanks. https://drive.google.com/file/d/0B3IFGMdLl2W4N0gwaG5kZVdaMFU/edit?usp=sharing

Inter Org Transfer Accounting: Inter Org Transactions can be used to Transfer Items from One Organization to Another Organization. Such Transactions can be performed using Direct Transfer or using In transit Shipment. We can also use Internal Requisition for such transfers, but in that case Freight charges are not supported. In transit Transfer:   Material is transferred between Organizations in 2 steps. The Sending Organization release shipment from its Organization which is to be received by receiving Organization Using Receipt Functionality. FOB point options can be set if Transfer type is set to In Transit. Receipt : The shipping organization owns the shipment until the destination organization receives it. So Ownership of material is transferred to receiving Organization at point of receipt. In this case, all cost related to freight would be covered by the sending Organization Until material is received in receiving Organization. Such Cost related to Freights is a...