1 / 16

Extending Oracle Apps to Streamline Fixed Assets Processing

Extending Oracle Apps to Streamline Fixed Assets Processing. Brett Ford, VMware Inc. NorCal OAUG Training Day January 24, 2006. Introduction.

hedda
Télécharger la présentation

Extending Oracle Apps to Streamline Fixed Assets Processing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Extending Oracle Apps to Streamline Fixed Assets Processing Brett Ford, VMware Inc. NorCal OAUG Training Day January 24, 2006

  2. Introduction The standard Oracle FA Mass Additions process typically requires extra manual intervention and data entry. This presentation will demonstrate a few simple custom “extensions” which can be utilized to minimize manual intervention and streamline the FA Mass Additions process.

  3. Standard Mass Additions Process

  4. Prepare Mass Additions • Location • Asset Category • Depreciation Expense Code Combination • Asset Number • Tag Number • Manufacturer • Model • Serial Number • Assigned To • Queue Name • Date Place in Service

  5. Additional Issues • There can be a timing difference between when an asset is physically received and when the invoice is received and processed by Accts Payable. This often results in “off-line” asset tracking systems!

  6. Opportunities to Streamline • Minimize manual intervention in FA Mass Additions by capturing asset information in the Receiving transaction • Immediately record asset receipts into the Oracle Assets module by creating $0 mass additions from Receiving.

  7. More Opportunities to Streamline… • Streamline the “Prepare Mass Additions” process • Automate required fields • Facilitate “easy merge” • Automate the “Add to Asset” function

  8. Solution Components • Apps Config • DFF’s • PO Item Category • Receiving Transactions • Asset Locations • Value Sets • Concurrent Programs & Executables • Customize Mass Additions Folder

  9. More Solution Components • Custom view for “uninterfaced” Asset Receipts (track by rcv_trx_id) • Custom SQL to interface Asset Receipts to fa_mass_additions ($0 mass additions) • Custom SQL to automate the Prepare Mass Additions process • Custom SQL to add lines to existing asset

  10. Putting it all together…

  11. Net Result • Streamlined Fixed Assets process to facilitate faster, more accurate asset processing with minimal accounting resources • Accomplished with no customizations of standard Oracle code!

  12. Receiving DFF

  13. Map Asset Categories to PO Item Categories…

  14. Map Depreciation Expense Distributions to Employee HR Assignment

  15. Custom Mass Additions folder to facilitate merging

  16. Additional Info References • Streamlining Fixed Assets Mass Additions – Mark Schwerdt, Oakton Solutions Pty Ltd – OAUG Asia Pacific 2000 Conference For sample code or additional info E-mail bford@vmware.com

More Related