Oracle BI Tools

on Friday, March 23, 2012

Oracle Business Intelligence Foundation Suite is a complete, open, and integrated solution for all of your enterprise BI needs, including reporting, ad hoc queries, OLAP, dashboards and scorecards. The Oracle Business Intelligence Foundation suite includes the following products: Oracle Business Intelligence Enterprise Edition, Oracle Business Intelligence Publisher, Oracle Essbase, and Oracle Scorecard and Strategy Management.

Oracle Business Intelligence Enterprise Edition 11g (OBIEE) is a comprehensive business intelligence platform that delivers a full range of capabilities—including interactive dashboards, ad hoc queries, notifications and alerts, enterprise and financial reporting, scorecard and strategy management, business process invocation, search and collaboration, mobile and disconnected analytics, integrated systems management and more. OBIEE 11g is based on a proven Web-based service-oriented architecture that integrates with an organization’s existing information technology (IT) infrastructure for the lowest total cost of ownership and highest return on investment. OBIEE 11g provides complete, relevant insight to everyone in an organization, resulting in improved decision-making better-informed actions, and more-efficient business processes.

Oracle Business Intelligence Suite Standard Edition One is a complete, integrated BI system designed for deployments from 5 to 50 users. It includes proven, leading BI and data warehousing technology that delivers a full range of analysis and reporting capabilities, Oracle Warehouse Builder for ETL, and Oracle Database—all in one easy to install package.

Oracle Essbase is the market-leading OLAP server for interactive, forward-looking analytics at the speed of thought. Essbase provides rapid modeling of alternative scenarios and streamlines the management reporting, forecasting, and variance analysis process.

Oracle Business Intelligence (BI) Publisher (formerly XML Publisher) is an enterprise reporting solution for authoring, managing, and delivering highly formatted documents such as operational reports, electronic funds transfer documents, government PDF forms, shipping labels, checks, sales and marketing letters, and much more.

Oracle Scorecard and Strategy Management is an application that enables organizations to define strategic goals and objectives that can be cascaded to every level of the enterprise. Key Performance Indicators (KPIs), ensure that individuals are tracking the right metrics in their dashboards and reports to achieve better business performance.

Oracle Real-Time Decisions (RTD) combines both rules and predictive analytics to power solutions for real-time enterprise decision management. It enables real-time intelligence to be instilled into any type of business process or customer interaction.

Advantages of using XML Reports

on Saturday, March 17, 2012

Choose your Design Tool
Xml Publisher Report formats can be designed using Microsoft Word or Adobe Acrobat – tools most users are already familiar with. There is no proprietary design studio component required, meaning no extra cost and no extra learning curve.
Data from Anywhere
Xml Publisher can accept and format any well-formed Xml data, as well as generate the Data. It can therefore be integrated with any database. Xml Publisher also allows you to bring data In from Multiple Data Sources into a Single Output Document.

 
Deliver to Anywhere
Deliver your content via Printer, E-Mail, Fax, Webdav, or publish your report to a portal. The Delivery Manager’s open architecture allows for easy implementation of custom delivery channels, as well.
Communicate with the World
Report Layouts can be created for any combination of 185 languages and 244 territories. These Layouts are converted to Industry-Standard files for easy In-House translation or delivery to third party translation providers. Because each translation is a separate file, modifications can still be made to the Layout without impacting translations. Xml Publisher also offers Advanced Bidirectional and Font Handling Support.

  
Unsurpassed Performance
Xml Publisher is based on the W3c Xsl-Fo Standard and it is the Fastest, Most Scalable Implementation in the world today. It can handle very large data inputs and generate output in less time, using very low levels of CPU time and memory.
Open Standards and Easy Integration
Xml Publisher is built on Open Standard technologies. It is a J2ee application that can be deployed to any J2ee container. Data is handled as Xml and the Layout Templates created in the desktop applications are internally converted to Xsl-Fo, another W3c standard. Outputs generated by the application are also industry standards such as Pdf, Rtf and Html. The delivery protocols are Internet Printing Protocol (Ipp), Webdav, Ftp, As2.

Account Receivables - Receipt API

on Sunday, March 4, 2012

AR_RECEIPT_API_PUB.CREATE_CASH
Use this procedure to create a single cash receipt for payment received in the form of a check or cash.
AR_RECEIPT_API_PUB.APPLY & AR_RECEIPT_API_PUB.APPLY_IN_DETAIL
Use these procedures to apply the cash receipts from a customer to an invoice, debit memo, or other debit item.
AR_RECEIPT_API_PUB.UNAPPLY
Use this procedure to unapply a cash receipt application against a specified installment of a debit item or payment schedule ID.
AR_RECEIPT_API_PUB.CREATE_AND_APPLY 
Use this procedure  to create a cash receipt and apply it to a specified installment of a debit item.
AR_RECEIPT_API_PUB.REVERSE
Use this procedure to reverse cash and miscellaneous receipts.
AR_RECEIPT_API_PUB.APPLY_ON_ACCOUNT
Use this procedure to apply a cash receipt on account.
AR_RECEIPT_API_PUB.UNAPPLY_ON_ACCOUNT
Use this procedure to unapply an on-account application of a specified cash receipt.
AR_RECEIPT_API_PUB.ACTIVITY_APPLICATION
Use this procedure to create an activity application on a cash receipt, including Short Term  Debit (STD) and Receipt Write-off applications.
AR_RECEIPT_API_PUB. ACTIVITY_UNAPPLICATION
Use this procedure to create a reversal of an activity application on a cash receipt including Short Term Debt and Receipt write-off.
AR_RECEIPT_API_PUB.CREATE_MISC
Use this procedure to create a miscellaneous receipt.
AR_RECEIPT_API_PUB.APPLY_OPEN_RECEIPT
Use this procedure to apply a cash receipt to another open receipt. Open receipts include unapplied cash, on-account cash, and claim investigation applications.
AR_RECEIPT_API_PUB.UNAPPLY_OPEN_RECEIPT
Use this procedure to reverse a payment netting application on a  cash receipt.