Account groups are used to monitor key accounts in General Ledger
Account groups are used only in General Ledger
SmartView Reports
Users can view, import, manipulate, distribute, and share data
Comprehensive tool for accessing and integrating Enterprise Performance Management, Business Intelligence, and General Ledger content from Microsoft Office products
Ability to create and refresh spreadsheets to access real-time account balances and activity
Oracle Transactional Business Intelligence
Included as part of the Oracle Cloud Apps licenses and does not need any additional setup
Provides you real-time and Self-service reporting solution in Fusion
OBIEE answers provide users with an ability to access the out of the box functional subject areas
Users can create reports by simply dragging and dropping columns to create reports
Creation of OTBI Reports
In OTBI, fusion has already given the predefined views that fetch data from the Balance cubes
Users just need to select the appropriate view/Subject area
Users can add filters, custom formulae and use the different views which are provided
Save and Run the Report
BI Publisher Reports
Enables to design and create report layout templates with the more common desktop applications.
With a single template, it can generate reports in many formats (PDF, RTF, Excel, HTML, and so on) in many languages.
Dramatically reduces report maintenance, enabling power business users to adjust report templates without the involvement of IT resources.
Creation of BI Publisher Reports
Create a Data model based on a SQL query
View and Save the Sample Data of the Data Model
Create a Report based on the Data Model
Design a Template/Layout
Save and Then Run the Report
Custom Layout Templates
All reports delivered with Oracle Fusion Applications include at least one predefined layout template Defines the presentation components and maps the elements from the data model to these components
Types of templates
RTF
Templates created using BI Publisher’s layout editor
eText template-specifically for electronic data interchange (EDI) and electronic funds transfer (EFT)
Custom Layout Templates – RTF
We can create our own custom RTF template by performing below steps: –
Create a data model – Generate the XML data file for the data model – Save the XML Data file locally – Open word and load XML data – Design the RTF template – Save the RTF file – Create a report/extract based on the data model – Upload the RTF template created against that report layout
Enterprise Scheduler Job
A program that you run to process data and, in some cases, generate output as a report, extract file or executing some actions like validation of a document, accounting, purging/ deletion of certain data/document etc.
Users can submit these jobs as an adhoc process, or it can be automated to be run at a certain time
We can group related jobs in a job set to be executed in a defined sequence