with OBI EE, Cognos, and

separatesnottyΛογισμικό & κατασκευή λογ/κού

25 Νοε 2013 (πριν από 3 χρόνια και 7 μήνες)

156 εμφανίσεις

Operational Reporting for R12
with OBI EE, Cognos, and
Business Objects

Mike Hoover

Product Specialist

Noetix Corporation

Agenda


Release 12 Overview


Report Migration


Key Reporting Issues


Noetix Solution
-

The Alternative


Q & A

R12 Functional Enhancements (Part 1)


Enhanced User Interface


Release 12 still relies heavily on Oracle Forms,

but the interface has been streamlined and given

a cleaner look


Single Accounting Engine



Shared subledger accounting engine stores
accounting entries in subledger tables that are
standard across all products creating a single version
of the truth


Global Financial Management


Users can be assigned to multiple operating units and
processes, and transactions can span operating units



R12 Functional Enhancements (Part 2)


Converged Inventory Module



The data model for process manufacturing and
discrete manufacturing has been converged in a
single model



Infrastructure Upgrade



Most Release 12 users will upgrade at least to Oracle
Database 10g and some components of Oracle Fusion
Middleware



Accelerated Implementation



Oracle accelerators can significantly reduce

Release 12 implementation time


Overall Goal of Enhancements


The Goal


Real time, role
-
based information with a common data
model as a foundation for a single source of truth
across the enterprise



The Implications


Changes in the underlying data management
infrastructure can have a significant impact on
reporting


Key Reporting Issues


More than a dozen changes have an impact on
reporting


The conversion from “sets of books” to “ledgers”


Funds disbursement processing moving from
Payables to the new Payments application


Tax calculations centralized in the new E
-
Business
Tax application


Check and letter processing information now in
Oracle BI Publisher tables


Bank and supplier information now in the Trading
Community Architecture (TCA)


Bank setup moving from Receivables to the Cash
Management application

Reports Will Break


Report integrity a constant, costly challenge

V11.5.10

R12

Reporting from Both 11
i
and Rel. 12

V11.5.10

R12


Re
-
implementing to
address configuration
imperfections


Some data may not
migrate


Global consolidation


Multi
-
instance
environments no
longer needed

How big is the problem?

What did it take for Noetix to Upgrade?


Analyze the Oracle R12 documentation per
module to identify any significant changes.


Functionally test all views in R12 to identify
all affected views.


Design and implement required functional
updates


Create new views


Obsolete views


add/modify columns


add/modify profile options

What did it take Noetix for our Upgrade?

34

14

3

Accounts Payable

56

32

8

Accounts Receivable

58

7

6

Fixed Assets

58

48

10

General Ledger

60

9

0

Purchasing

View Count

Modified

New

Total Effort ~ 10 person years


Validated and modified nearly 750 views


Across 24 modules


Upgrade Protection

R12

[ reports written against
database tables ]

[ reports written against
Noetix views ]

V11.5.10

R12

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”

Tie It All Together


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


Three key stages


Distributions (before accounting applied)


SLA (in draft or final form)


GL


Three key views of the data


Distributions only


Tie distributions to SLA to GL


Tie GL back to distributions


Subledger Accounting


Report
Migration Needs


How do I reconcile my AP Invoices to the GL
Journal Entries and distributions?



11
i

and Release 12 Reports

View Changes

11i GL_Je_AP_Inv_Dist_Details

Release 12 GL_Je_SLA_AP_Inv_Dist

GL_Sets_Of_Books

GL_Ledgers

PO_Vendors

AP_Suppliers

PO_Vendor_Sites_All

AP_Supplier_Sites_All

AP_AE_Headers_All

XLA_AE_Headers

AP_AE_Lines_All

XLA_AE_Lines

AP_Accounting_Events_All

?????

XLA_Events

XLA_Event_Classes_TL

XLA_Event_Types_TL

XLA_Transaction_Entities

XLA_Distribution_Links

The Impact?


Some 11
i

queries will easily migrate to Rel. 12


Some with no changes at all


Some will need table name changes


Some 11
i

queries will need moderate attention


Data moved to TCA will require query re
-
writes


Customer correspondence will require re
-
writes


Basic reports can remain the same


Some 11
i

queries won’t migrate 1:1 to Rel. 12


SLA may require new reports, queries & ETL
routines


How does Noetix address the
problem?

MTL_SYSTEM_ITEMS


HZ_CUSTOMERS


OE_ORDER_LINES_ALL

OE_ORDER_HEADERS_ALL

MTL_SYSTEM_ITEMS_TL

PA_PROJECTS_ALL

PA_TASKS

What is a Noetix view?

Oracle database tables

Noetix view of
the database









Order Lines

ATO Flag

Booked Date

Customer

Customer No.


Item

Item Desc.

Line Status

Open Quant.

Order No.

Order Quant.

Project

Quantity

Organization

[remaps view]

[doesn’t break]

[Oracle EBS upgrade]

Cust. Status

ATTRIBUTE1
: “Customer Status”

Flexfield column

in the table


Your report









Customer

Selling Org.

Cust. Status

Open Quant.

Order Quant.

Booked Date

Order No.

Orders

Customer No.

Flexfield column in
the view

HZ_CUST_ACCOUNTS

OE_ORDER_LINES_ALL

HZ_PARTIES

PA_TASKS

NoetixViews Coverage

Oracle E-Business Suite 11i & 12.0
Financials
Discrete Manufacturing
Asset Lifecycle Management
General Ledger
Bill of Materials
Enterprise Asset Management
Payables
Work in Process
Receivables
Inventory
Service
Assets
Master Scheduling/MRP
TeleService
Cost Management
Install Base
Procurement
Quality
Depot Repair
Purchasing
Field Service
Process Manufacturing
Service Contracts
(LA)
Order Management
Product Development
Order Management
Process Planning
Projects
Process Execution
Project Costing
Human Resources
OPM Financials
Project Billing
Human Resources
OPM Inventory
Advanced Benefits
Grants
Payroll
(US, UK, CAN, & AUS legislations)
Project Manufacturing
Grants Proposal
Project Manufacturing
(LA)
Grants Accounting
EBS Administration
Application Object Library
Advanced Planning and Scheduling
Industry Verticals
Finanicals Interface Tables
Advanced Supply Chain Planning
US Federal Financials
Combine your set up with our
subject matter expertise

Business Views

Reports

[Configuration
-
specific

Views]

[Configuration
-
specific

Answers]

Object
Definition

Information about your
enterprise application

User
Interfaces

Security

Business
Rules

Financials

Business Best Practices

Supply Chain

Mfg.

Human
Resources

[Interrogated]

[Handcrafted]

Business Glossary

[Configuration
-
specific

Help]

Generated data

Reporting from both 11
i
and Rel. 12

[ reports written against
Noetix views ]

V11.5.10

R12

Some Customers
want both


Legacy data



Validation

Noetix Provides a Reporting Application
With Any Front End Tool

Noetix
HelpFile

OBI EE

Cognos

Discoverer

Oracle E
-
Business Suite

NoetixViews

Oracle

BI Server

Generate object definitions

Export UDML

Convert UDML to RPD




UDML


RPD

(Repository
Model)


Generate Oracle BI Answers




NoetixAnswers

Noetix Generator for Oracle BI

Supports Current Shipping Version

Noetix Generator for Oracle BI



Any product / tool that works
with the Oracle BI Server will
work with generated RPD file



Oracle BI Answers


Oracle Interactive
Dashboards


Oracle BI Publisher


Oracle BI Delivers


Oracle Briefing Books



Noetix Generator for Cognos

Oracle E
-
Business Suite

NoetixViews

Generates NoetixViews
Roles

Generate query
subjects

Publish packages

Cognos

Content Store


XML



Framework Manager


Report Studio


Query Studio


Content is published

into the Cognos
Content Store


Supports Cognos 8 BI environment

Noetix Generator for Cognos

Noetix Generator for Business Objects

Oracle E
-
Business Suite

NoetixViews

Generate security
groups

Business

Objects CMS

Generate object
definitions

Export universes


UNV



Universe Designer


InfoView


Web Intelligence


Desktop Intelligence


Crystal Reports



Support for BusinessObjects XI R2 and Edge Series Standard
(formerly Crystal Decisions Standard)

Noetix Generator for Business Objects

What’s In It for You?


Cost effective and faster time to market


Successfully meeting project goals


Proven, tested and patented


Questions & Answers