Leveraging noetixviews to migrate custom 11i reports to release 12 l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 42

Leveraging NoetixViews to Migrate Custom 11i Reports to Release 12 PowerPoint PPT Presentation


  • 92 Views
  • Uploaded on
  • Presentation posted in: General

Leveraging NoetixViews to Migrate Custom 11i Reports to Release 12. Joe Dahl, Solution Consultant . Agenda. The Challenge Applications Data Structure Changes 11i -> R12 The Solution NoetixViews What we see companies doing about reporting. About Noetix. BI solutions experts since 1994

Download Presentation

Leveraging NoetixViews to Migrate Custom 11i Reports to Release 12

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Leveraging noetixviews to migrate custom 11i reports to release 12 l.jpg

Leveraging NoetixViews to Migrate Custom 11i Reports to Release 12

Joe Dahl, Solution Consultant


Agenda l.jpg

Agenda

  • The Challenge

    • Applications Data Structure Changes 11i -> R12

  • The Solution

    • NoetixViews

  • What we see companies doing about reporting


About noetix l.jpg

About Noetix

BI solutions experts since 1994

Offices in North America, Europe and South Asia

Certified with all leading BI Platforms

Recent Product Awards: KMWorld, eWEEK, DMReview

1400+ customers globally

PARTNERSHIPS


Noetix s history of dedication to oracle applications reporting l.jpg

Noetix’s History of Dedication to Oracle Applications Reporting

Noetix Analytics

Noetix Generator for Cognos

NoetixViews for PeopleSoft

Noetix EUL Generator

Noetix incorporated

Noetix for Siebel

1995

1996

1997

1998

1999

2000

2001

2002

2003

2004

2005

2006

2007

2008

2009

1994

Noetix Platform

Noetix Generator for BusinessObjects

Noetix Dashboard

NoetixViews

Noetix Generatorfor Oracle BI


Noetix business intelligence l.jpg

Noetix Business Intelligence


Noetix supports the full spectrum of reporting needs l.jpg

Noetix Supports the Full Spectrum of Reporting Needs

Enterprise Models

Strategic

Common Dimensions

Performance Management

Packaged ETL

Enterprise-wide

Data Integration

Analytics / KPIs

Near Real-time

Operational Reports

Summarized Data

Ad hoc query

Historical Trending

Real-time

Drillable Reports

Detailed Data

Database Views

Application Security


Operational reporting l.jpg

Operational Reporting


Everything starts with a query l.jpg

Everything Starts with a Query

  • ETL routines

    • To replicate the data, to transform it into a different model, and usually to create stored aggregations

  • Reporting tool’s repository

    • Discoverer EUL, OBI EE Server, BO Universe, Cognos Framework Mgr. Model

  • Database views

    • Virtual transformation of data into a denormalized model without replicating the data

    • For direct access

  • The information in this presentation is applicable to all approaches


Reporting tool repositories l.jpg

Reporting Tool Repositories

NoetixWebQuery

Noetix Dashboard

OracleDiscoverer

OracleBI Suite EE

Cognos8 BI

Business Objects WebIntelligence

ETL

Business areasBusiness models

Virtualtables

Models /Packages

Universe

Other data models

Oracle E-Business Suite

EBS Tables


Common data access layer l.jpg

Business areasBusiness models

Virtualtables

Models /Packages

Universe

Other data models

Business areasBusiness models

Virtualtables

Models /Packages

Universe

Other data models

Shared Metadata

Common Data Access Layer

NoetixWebQuery

Noetix Dashboard

OracleDiscoverer

OracleBI Suite EE

Cognos8 BI

Business Objects WebIntelligence

ETL

Oracle E-Business Suite

DatabaseViews

  • Common business terminology

  • Improved maintainability

EBS Tables

  • Reuse complex SQL logic

  • Improved “time to query”


Subject areas l.jpg

Subject Areas

  • Funds Disbursement

  • Suppliers & Trading Community Architecture

  • Banks & Trading Community Architecture

  • Subledger accounting

Impact of Release 12 to your 11i queries:

Very little  complete rewrite


Funds disbursement l.jpg

Funds Disbursement


Funds disbursement13 l.jpg

Funds Disbursement

  • Moved from Payables to new Payment module

    • Creation & validation of payments

    • Aggregation of payments into files

    • Format & transmission of files

  • Selection & approval of invoices remains in Payables


Funds disbursement changes l.jpg

Funds Disbursement Changes


Suppliers trading community architecture l.jpg

Suppliers & Trading Community Architecture


Suppliers tca l.jpg

Suppliers & TCA

  • Supplier, supplier site, & contact information migrated to TCA tables

  • Three new AP tables containing supplier-unique data, with links to TCA tables

    AP_SUPPLIERS

    AP_SUPPLIER_SITES_ALL

    AP_SUPPLIER_CONTACTS

  • Three old PO Vendors tables obsolete

    • Views provided for backward compatibility


Supplier changes l.jpg

Supplier Changes


Banks trading community architecture l.jpg

Banks & Trading Community Architecture


Banks data in r12 l.jpg

Banks Data in R12

  • Setup in Cash Management (CE)

    • Bank, bank account setup

    • Shared with Payables, Receivables, Treasury, & Payroll

  • Banks & bank branches now represented as TCA parties

    • 11i AP bank data moved to TCA HZ_PARTIES table

  • Three key CE tables

    • CE_BANK_ACCOUNTS for bank accounts

    • CE_BANK_ACCT_USES_ALL for account uses by Operating Units & Legal Entities

    • CE_GL_ACCOUNTS_CCID for bank account use accounting data


Bank data in tca l.jpg

Bank Data in TCA


Subledger accounting l.jpg

Subledger Accounting


Subledger accounting22 l.jpg

Subledger Accounting

  • All accounting performed before transfer to the GL

  • User-definable accounting rules

  • At the data level, it’s a big change for all the subledgers, though there is a first generation in 11i Payables “Accounting Events”


Receivables accounting in 11i l.jpg

Receivables Accounting in 11i

  • Final accounting data not generated prior to transfer to GL

    • Distribution level information GL

  • Three distinct distributions tables

    • Invoices / Credit Memos / Debit Memos / …

      • Accounting class & amounts, but not debits & credits

    • Receipts & Adjustments

      • Unapplied, applied

      • Both debits & credits

    • Misc. Cash Receipts

      • Both debits & credits

  • “View Accounting” is a report against distributions


Payables accounting in 11i l.jpg

Payables Accounting in 11i

  • Accounting data generated and stored in “Accounting Events” tables prior to transfer to GL

    • Run “Create Accounting” to populate accounting events tables

    • Accounting event tables  GL


Subledger to ledger reporting in 11i l.jpg

Subledger to Ledger Reportingin 11i

  • Complete, final accounting only available in the GL

    • All debits and credits

    • All journal entries

    • All balances

  • Challenge: Difficult to link summarized accounting data with source details


Release 12 subledger accounting l.jpg

Release 12 Subledger Accounting

  • All subledger accounting data generated and stored in shared SLA tables prior to transfer to GL

    • Run “Create Accounting” to populate SLA tables

  • User can “View Accounting” only after “Create Accounting” is run


Distribution links sample data l.jpg

Distribution Links Sample Data

Distributions

SLA Je Lines

Distribution

Links


Tie it all together l.jpg

Tie It All Together

  • Data flows from distributions, thru distribution links and SLA tables, to GL

  • Three key stages

    • Distributions (before accounting applied)

    • SLA (before transfer to GL)

    • GL

  • Three key views of the data

    • Distributions only

    • Tie distributions to SLA to GL

    • Tie GL back to distributions


The noetix solution l.jpg

The Noetix Solution


The information gap l.jpg

The Information Gap

Query, Reporting and Analysis Tools

Generic Templates

Additional costs

Additional resources

Additional delay

70% of BI

implementation

costs & delay

M a n u a l M a p p i n g

M a p p i n g R e w o r k

< The Information Gap >

Custom Application Configuration

Enterprise Application (v1)

Enterprise Application (v2)


The information gap31 l.jpg

The Information Gap

Generated Content

Custom Application Configuration

Query, Reporting and Analysis Tools

Generic Templates

Generates configuration specific BI content

Noetix MetaBuilder

< The Information Gap >

Custom Application Configuration

No additional rework costs or delay

Enterprise Application (v2)

Enterprise Application (v1)


Information about your setup l.jpg

Information About Your Setup

Information about your enterprise application

Business Best Practices

Financials

Supply Chain

Configuration

User Interfaces

Human Resources

Manufacturing

Flexfields

Security

[Interrogated]

[Handcrafted]

Generated data

Business Views

Reports

Documentation

[Configuration-specific Views]

[Configuration-specific Answers]

[Configuration-specific Help]


What is a noetix view l.jpg

What is a Noetix view?

Your report

Noetix view of the database

HZ_PARTIES

HZ_CUST_ACCOUNTS

HZ_CUSTOMERS

Order Lines

Orders

ATO Flag

Booked Date

Customer

Customer No.

Item

Item Desc.

Line Status

Open Quant.

Order No.

Order Quant.

Project

Quantity

Organization

Order No.

OE_ORDER_HEADERS_ALL

Customer

Customer No.

OE_ORDER_LINES_ALL

PA_PROJECTS_ALL

OE_ORDER_LINES_ALL

Cust. Status

Booked Date

PA_TASKS

PA_TASKS

MTL_SYSTEM_ITEMS_B

Order Quant.

Open Quant.

MTL_SYSTEM_ITEMS_TL

Selling Org.

Oracle database tables

Flexfield column in the table

[Oracle EBS upgrade]

[doesn’t break]

[remaps view]

ATTRIBUTE1: “Customer Status”

Flexfield column in the view

Cust. Status


Oracle flexfields and noetix l.jpg

Oracle Flexfields and Noetix

Key FlexfieldBase Table Column Names

Key FlexfieldView Column Names

SEGMENT1

Company

SEGMENT2

Division

SEGMENT3

Cost Center

Descriptive FlexfieldBase Table Column Names

Descriptive FlexfieldView Column Names

ATTRIBUTE1

Web Site

ATTRIBUTE2

Preferred Vendor

ATTRIBUTE3

Approved Until


Product demonstration noetixviews l.jpg

Product DemonstrationNoetixViews


Noetixviews 5 8 7 financial cross functional views l.jpg

NoetixViews 5.8.7Financial Cross-Functional Views

NoetixViews for Oracle General Ledger

Payables

Receivables

Public Sector


Noetixviews 5 8 7 financial cross functional views37 l.jpg

NoetixViews 5.8.7Financial Cross-Functional Views

NoetixViews for Oracle Assets

NoetixViews for Oracle Payables

NoetixViews for Oracle Receivables


Noetix support for oracle sla payables receivables l.jpg

Noetix Support for Oracle SLAPayables & Receivables


The impact l.jpg

The Impact?

  • Some 11i queries will easily migrate to Rel. 12

    • Some with no changes at all

    • Some will need table name changes

  • Some 11i queries will need moderate attention

    • Data moved to TCA will require query re-writes, but the basic reports can remain the same

  • Some 11i queries won’t migrate 1:1 to Rel. 12

    • SLA may require new reports, queries & ETL routines


Reporting strategies we see l.jpg

Reporting Strategies We See

  • Best practice: Establish a metadata layer between queries and OLTP tables

    • Use common business terms for query objects, data element, & their descriptions

    • Persist this “business metadata” between database upgrades

    • Remap the “technical metadata” (SQL)

  • OLTP database views

    • Common data access layer

    • Usable by reporting & query tools, & ETL

  • Reporting tools’ metadata repositories

    • Map to data access layer in the OLTP database


Noetix business intelligence41 l.jpg

Noetix Business Intelligence


Slide42 l.jpg

Q & A


  • Login