r12 using web adi to upload oracle assets

Release 12_Using WEB ADI to

Upload Oracle Assets

Suzana Ferrari

Senior Principle Consultant

DARC Corporation

sferrari@darc.com

Session ID# 8000

• Consulting Services• Program Management, Functional, Technical,

Architecture

• Production Support• 24x7 Functional & Database

• Organizational Change Management• Communications, Documentation, Training

• Accelerators for Interfaces and Conversions• Mergers & Acquisitions• Global Consolidation

Speaker’s Qualifications

• Certified Expert Consultant, Oracle E-Business Suite R12 Financials

• Implementing Oracle Applications for over 10 years (USA, Canada, UK)

• Project Manager on several successful implementations and upgrades

Agenda

• WEB ADI Overview

• WEB ADI and MS 2007

• WEB ADI: Defining Layout• WEB ADI: Defining Layout

• WEB ADI: Creating a Document

• Legacy Data

• Create Assets Upload

• Upload Summary and Reconciliation

• Q&A

WEB ADI Overview

• Web based integration tool used with Microsoft Excel

formatted spreadsheet

• Data validated against Oracle valid values

• Multiple integrators that determines product and

functionalities provided

• Assets Wizard functionality is provided by the Assets product

WEB ADI and MS 2007

• Enable macro settings (Metalink Note - 1077728.1)

• Browser settings to be modified for Excel interface

• ActiveX Controls and plug-ins Settings

• If you are running Web ADI version BNE.D or later, you do • If you are running Web ADI version BNE.D or later, you do

not need to perform this step

• If you are running a version of Web ADI prior to version BNE.D,

you must change your Internet Explorer security settings to

allow a spreadsheet to be created on your desktop

• In case document fails during upload - in Internet Explorer 7 or

8 enable the 'Allow status bar updates via script' option in the

browser

WEB ADI: Defining Layout

• Responsibility

• Fixed Assets Integrator

• Oracle Web ADI

• Integrator: Fixed Assets – Additions

• Select existing layout

• Update; Duplicate; Create

• Define Fields

• Update to meet your company needs and standards

Defining Layout: Steps1. Access the Define Layout Page

2. Select Define Layout

3. Select Integrator - Fixed Assets – Additions

4. Look for in LOV

5. Find Integrator and Click on Go5. Find Integrator and Click on Go

6. Select the Layout

7. Define Layout

8. After you select the existing layout to modify, click on

9. Name the new layout and Click Apply

10. Find the new Layout and Update

11. Select the Layout and Define Fields

12. Update to meet your company needs and standards

13. When complete, click on Apply

Layout: Integrator

Integrator Layouts

Naming New Layout

Layout Default: Required Fields

Layout Default: Optional Fields

Layout Default: Optional Fields

Layout Default: Optional Fields

WEB ADI: Creating a Document

Steps1. Using Fixed Assets Integrator responsibility, navigate to

Additions

2. Select a Corporate Book you want to upload

3. Select Excel version from LOV3. Select Excel version from LOV

4. Select Layout you defined (or use seeded)

5. Review and Click on Create Document

6. Click for Options and select Download File

7. You might receive Security Warning

8. Excel will open

9. Wait until spreadsheet is completed

10. Save the spreadsheet as ‘Excel Macro-Enabled Workbook’

Fixed Assets Integrator

responsibility, navigate to

Additions

Select a Corporate Book you

want to upload

Select Excel version from LOV

Select Layout you defined (or use

seeded)

Review and Click on Create

Document

File Download

Excel Opens

Spreadsheet

Excel Macro-Enabled Workbook’

Legacy Data 1. Gather GL Accounts balances per account combination

2. Reconcile data to GL control accounts

3. Clean up the new saved file

4. Add columns

5. Assign assets to a valid category listed5. Assign assets to a valid category listed

6. Assign assets to a valid locations listed

7. Assign Asset Key to each Asset

8. To each asset, assign valid depreciation account

9. To each asset, assign valid # of units

10. Upload Data

11. Reconcile Mass Addition Interface Table uploaded assets to

the assets on ADI Template

Create Assets Upload

1. Use Upload from Oracle Excel Menu to upload data

2. Select valid upload parameters

3. Document is uploaded to server

4. You will receive confirmation once upload completed

Oracle Excel Menu to upload

data

Select valid upload parameters

Document is uploaded to server

Upload Confirmation

Upload Summary and

Reconciliation

1. Bring Oracle Assets to Desired Period

2. Define WEB ADI Layouts 2. Define WEB ADI Layouts

3. Reconcile upload files to legacy data / TB balances

4. Create WEB ADI Document for layout

5. Unprotect sheet, insert rows and upload assets data

6. Upload Assets Data to Oracle

7. Run Report - Asset Additions Report

8. Reconcile total upload amounts with data provided

Upload Summary and

Reconciliation

9. Reconcile by Category

10. Run: Create Accounting – Assets; Do not Post to GL10. Run: Create Accounting – Assets; Do not Post to GL

11. JE Analysis

12. Reconcile JE to data uploaded

13. Run TB

14. Adjust JE

15. Run Depreciation

ConclusionConclusion

Q&AQ&A

Please take a moment…

• If you haven’t turned in your entry form • If you haven’t turned in your entry form

• please hand it in now

Thank you!

Suzana Ferrari

sferrari@darc.com

sales@darc.com

877-476-7151