It has been suggested that Oracle E-Business Suite be merged into this article. (Discuss) Proposed since November 2010. Oracle Applications comprise the applications software or business software of Oracle Corporation. The term refers to the non-database and non-middleware parts of Oracle's software portfolio.
Oracle sells many functional modules which use the Oracle RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle Projects, Oracle CRM, Oracle Procurement, etc.
Oracle initially launched its application suite with financials software in the late 1980s. The offering as of 2009 extends to supply-chain management, human-resource management, warehouse-management, customer-relationship management, call-center services, product-lifecycle management, and many other areas. Both in-house expansion and the acquisition of other companies have vastly expanded Oracle's application software business.
Oracle released Oracle E-Business Suite (EBS/ e-BS) Release 12 (R12) - a bundling of several Oracle Applications applications - in February 2007. The release date coincided with new releases of other Oracle-owned products: JD Edwards EnterpriseOne, Siebel Systems and PeopleSoft. As of 2012 Oracle supports Release 220.127.116.11, Release 12.0.X, and Release 12.1.X of the Oracle E-Business Suite. The latest release of the software is called Oracle EBS R12.
ScopeOracle Corporation's application portfolio consisted as of 2012 of the following software suites and products:
- Oracle Fusion Applications
- PeopleSoft Enterprise
- JD Edwards EnterpriseOne
- JD Edwards World
- AutoVue (for processing CAD and graphics data)
- Master Data Management
- Oracle Applications >> Oracle E-Business Suite :
Oracle E-Business Suite
Oracle markets its home-grown software applications, including Oracle Financials, Oracle HRMS, Oracle CRM, etc. as parts of the "Oracle E-Business Suite". It makes the following enterprise applications available as part of Oracle eBusiness Suite:
- Asset Lifecycle Management
- Asset Tracking
- Property Management
- Customer Relationship Management
- Enterprise resource planning
- Financial Management
- Human Capital Management
- Project Portfolio Management
- Oracle Advanced Procurement
- Oracle Sourcing
- Product Life-cycle Management
- Supply Chain Management
- Supply Chain Planning
- Logistics & Transportation Management
- Order Management
- Price Management
- Discrete Manufacturing
- Process Manufacturing
Oracle Financial Applications
The Oracle E-Business Suite provides a set of financial applications used internationally in businesses. Oracle Corporation groups these applications into "suites", which it defines as sets of common, integrated applications designed to execute specific business processes.
RDBMS infrastructure and includes applications such as:
- Oracle Assets
- Oracle General Ledger
- Oracle Receivables
- Oracle Cash Management
Oracle Project Portfolio Management Applications
- Oracle Project Billing
- Oracle Project Collaboration
- Oracle Project Contracts
- Oracle Project Costing
- Oracle Daily Business Intelligence
- Oracle Project Management
- Oracle Project Portfolio Analysis
- Oracle Project Resource
Additional Oracle E-Business Suite products include:
- Oracle Bills of Material
- Oracle Capacity
- Oracle CRM
- Oracle Advanced Planning & Scheduling
- Oracle Business Intelligence
- Oracle Engineering
- Oracle HRMS
- Oracle Inventory
- Oracle Integrated Receiving (Brazil localization)
- Oracle MRP
- Oracle Order Entry
- Oracle Order Fulfillment (order to cash process)
- Oracle Payroll
- Oracle Purchasing
- Oracle Receivables
- Oracle TMS (Transportation/G-Log)
- Oracle Work in Process
- Oracle Process manufacturing
- Oracle Federal Administration
- Oracle Sales
- Oracle MRP
In 2007 Oracle launched a set of applications for mid-size businesses called Oracle Accelerate. Accelerate provides access to Oracle's ERP products through a local partner-network and packages the products to meet vertical industry requirements.
Oracle User Productivity kit (UPK)
The Oracle User Productivity Kit application provides a content-development, deployment, and maintenance platform.
- Oracle Fusion Applications :
Oracle Fusion Applications
Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management.
Oracle Fusion Applications were announced shortly after Oracle's US$18 billion acquisition spree of PeopleSoft, JD Edwards, and Siebel Systems in 2005.
Oracle Fusion Applications were envisioned and pitched as an Enterprise resource planning suite - a combination of features and functionalities taken from Oracle E-Business Suite, JD Edwards, PeopleSoft and Siebel product lines. The suite is built on top of the Oracle Fusion Middleware technology stack which leverages the Service-oriented architecture capabilities of Oracle Fusion Architecture.
Oracle Fusion is an ERP software which offers complete Business solutions for all the wings of Enterprise. Oracle has also come up with Cloud solutions under Fusion Apps.
It was finally launched (but not released) in September 2010.
- Oracle Fusion Middleware :
Oracle Fusion Middleware
Oracle Fusion Middleware (OFM, also known as Fusion Middleware) consists of several software products from Oracle Corporation. OFM spans multiple services, including Java EE and developer tools, integration services, business intelligence, collaboration, and content management. OFM depends on open standards such as BPEL, SOAP, XML and JMS.
Oracle Fusion Middleware provides software for the development, deployment, and management of service-oriented architecture (SOA). It includes what Oracle calls "hot-pluggable" architecture, designed to facilitate integration with existing applications and systems from other software vendors such as IBM, Microsoft, and SAP AG.
Many of the products included under the OFM banner do not themselves qualify as middleware products: "Fusion Middleware" essentially represents a re-branding of many of Oracle products outside of Oracle's core database and applications-software offerings - compare Oracle Fusion.
According to Oracle, by 2006 over 30,000 organizations had become Fusion Middleware customers, including over 35 of the world's 50 largest companies and more than 750 of the BusinessWeek Global 1000, with OFM also supported by 7,500 partners.
In order to provide standards-based software to assist with business process automation, HP has incorporated OFM into its "service-oriented architecture (SOA) portfolio".
Oracle leveraged its Configurable Network Computing (CNC) technology acquired from its PeopleSoft/JD Edwards 2005 purchase.
Oracle Fusion Applications, based on Oracle Fusion Middleware, were finally released in September 2010.
In January 2008 Oracle Universal Content Management won InfoWorld's "Technology of the Year" award for "Best Enterprise Content Manager", with Oracle SOA Suite winning the award for "Best Enterprise Service Bus".
In 2007 Gartner, Inc. wrote that "OFM has reached a degree of completeness that puts it on par with, and in some cases ahead of, competing software stacks", and reported revenue from the suite of over US$1 billion during FY06, estimating the revenue from the genuinely middleware aspects at US$740 million.
Oracle Fusion Middleware components
- Enterprise application server
- Oracle Weblogic Server
- Oracle Application Server
- JRockit (a JVM)
- Tuxedo (software)
- - and process-management
- BPEL Process Manager
- Business activity monitoring (BAM)
- business rules
- Business Process Analysis Suite
- Business process management
- Oracle Data Integrator (ODI): an application using the database for set-based data integration
- Enterprise connectivity (adapters)
- Oracle Enterprise Messaging Service
- Oracle Enterprise Service Bus
- Oracle Application server B2B
- Oracle Service Registry
- Oracle Web Services Manager (OWSM), a security and monitoring product for web services
- Application development tools
- Oracle Application Development Framework
- Oracle SOA Suite
- TopLink, a Java object-relational mapping package
- Oracle Forms services
- Oracle Developer Suite
- Business intelligence
- Oracle Business Intelligence 11g
- Oracle Business Activity Monitoring (Oracle BAM)
- Oracle Crystal Ball - enables stochastic forecasting and simulation using spreadsheet models
- Oracle Discoverer
- Data hubs
- Oracle BI Publisher
- Oracle Reports services
- Systems management
- Oracle Enterprise Manager
- Web services manager
- User interaction
- Oracle Beehive collaboration software
- Oracle Portal
- Oracle WebCenter
- Real-time collaboration
- Unified messaging
- Content management
- Oracle Imaging and Process Management
- Web content management
- Records management
- Enterprise search
- Digital asset management
- Email archiving
- Oracle Universal Content Management
- Identity management
- Enterprise Single sign-on
- Oracle Entitlements Server
- Oracle Identity Manager
- Oracle Access Manager
- Oracle Adaptive Access Manager
- Oracle Virtual Directory
- Grid infrastructure
- Services registry
- application-server security
- Oracle Web Cache
- Oracle Fusion Architecture :
Oracle Fusion Architecture
Oracle Fusion Architecture is a standards-based technology reference architecture or blueprint from Oracle Corporation for building applications. Oracle Fusion Applications is build on top of the Oracle Fusion Middleware technology stack using Oracle's Fusion Architecture as blueprint.
Oracle Fusion Architecture is not a product, and can be used without licensing it from Oracle.
Oracle Fusion Architecture provides an open architecture ecosystem, which is service & event- enabled. Many enterprises use this open, pluggable architecture ecosystem to write Oracle Fusion Applications, or even third-party applications on top of Oracle Fusion Middleware.
Oracle Fusion Architecture is based on the following core principles,
Model Driven: For applications, business processes and business information
Service & Event- enabled: For extensible, modular, flexible applications and processes
Information Centric: For complete and consistent, actionable, real-time intelligence
Grid-Ready: Must be scalable, available, secure, manageable on low-cost hardware
Standards-based: Must be open, pluggable in a heterogeneous environment
Oracle Fusion Applications that can be written on Oracle Fusion Middleware using the Oracle Fusion Architecture ecosystem, were released in September, 2010.
- Oracle SOA Suite :
Oracle SOA Suite
In computing, Oracle SOA Suite is a part of the Oracle Fusion Middleware family of software products.
Features include deploying, and managing SOAs. Oracle SOA Suite enables system developers to set up and manage services and to orchestrate them into composite applications and business processes. With Oracle SOA Suite's hot-plugable components, organizations can easily extend and evolve their architectures instead of replacing existing investments.
Oracle Corporation publishes product strategy, product details and customer stories relating to the SOA Suite at http://www.oracle.com/soa. As of November 2010 Oracle Corporation markets Oracle SOA Suite version 11g Release 1 Patchset 2 (18.104.22.168). As of January 2011 Oracle Corporation markets Oracle SOA Suite version 11g Release 1 Patchset 3 (22.214.171.124). As of April 2013 Oracle Corporation markets Oracle SOA Suite version 11g Release 1 Patchset 6 (126.96.36.199).
- Oracle BPEL Process Manager
- Oracle Web Services Manager, a security and monitoring product for web services
- Oracle Business Rules, contains a JSR 94 Business rules engine
- Oracle Business Activity Monitoring
- Oracle Enterprise Service Bus
- Oracle JDeveloper
NOTE: * Oracle Service Registry is commonly associated with SOA Suite installations, but is not licensed as part of SOA Suite. Typically, it is purchased as a component of the SOA Governance Suite.
- Oracle WebLogic Server :
Oracle WebLogic Server
Owned by Oracle Corporation, Oracle WebLogic consists of a Java EE platform product-family that includes:
- a Java EE application server, WebLogic Application Server
- an enterprise portal, WebLogic Portal
- an Enterprise Application Integration platform
- a transaction server and infrastructure, WebLogic Tuxedo
- a telecommunication platform, WebLogic Communication Platform
- an HTTP web server
Prior to co-founding WebLogic, Inc., in September 1995, Paul Ambrose and Carl Resnikoff had developed (pre-JDBC) Oracle, Sybase, and Microsoft SQL Server database-drivers for Java under the name dbKona, as well as a "three-tier" server to permit applets to connect to these databases.
This WebLogic 1.48 server had the name T3Server (a corruption of "3-Tier Server"). Concurrently, Laurie Pitman and Bob Pasker had worked on network-management tools written in Java. Pasker had written an SNMP stack in Java and a W32 native method for ICMP ping, while Pitman had worked on applets to display the management data.
The 1.48 server version had (among other hidden features) the ability to extend itself by modifying a dispatcher and adding a handler for different types of messages. Pasker talked Ambrose into sending him the source code for the server, and Pasker extended it so that applets could make SNMP and PING requests on the network, and display the results.
At this point, the founders worked together to pursue what eventually became the "Application Server".
In 1998, WebLogic appointed board member and angel investor Ali Kutay as President and CEO. Shortly there after, BEA Systems acquired WebLogic, Inc. in 1998, following which it became BEA WebLogic. Oracle acquired BEA in 2008, following which it became Oracle WebLogic. WebLogic servers has been included in Oracle Technology Product family. WebLogic show various editions, such as WebLogic Server Standard Edition, WebLogic Server Enterprise Edition, WebLogic Suite, and is supplemented with five WebLogic Suite Options and Application Server Enterprise Management packs.
Application Server versions
- 12c Release 1 (12.1.1) - Dec 2012
- WebLogic Server 11gR1 PS4 (10.3.5) - May 16, 2011
- WebLogic Server 11gR1 PS3 (10.3.4) - January 15, 2011
- WebLogic Server 11gR1 PS2 (10.3.3) - April 2010
- WebLogic Server 11gR1 PS1 (10.3.2) - November 2009
- WebLogic Server 11g (10.3.1) - July 2009
- WebLogic Server 10.3 - August 2008
- WebLogic Server 10.0 - March 2007
- WebLogic Server 9.2
- WebLogic Server 9.1
- WebLogic Server 9.0 - November 2006
- WebLogic Server 8.1 - July 2003
- WebLogic Server 7.0 - June 2002
- WebLogic Server 6.1
- WebLogic Server 6.0 - file date March 2001 on an old CD
- WebLogic Server 5.1 (code name: Denali) First version supporting hot deployment for applications (via command line)
- WebLogic Server 4.0
- WebLogic Tengah 3.0.1 - March 1998
- WebLogic Tengah 3.1 - June 1998
- WebLogic Tengah 3.0.1 - March 1998
- WebLogic Tengah 3.0 - January 1998
- WebLogic Tengah 3.0.1 - March 1998
- WebLogic Tengah - November 1997
Oracle WebLogic Server forms part of Oracle Fusion Middleware portfolio and supports Oracle, DB2, Microsoft SQL Server, MySQL Enterprise and other JDBC-compliant databases. Oracle WebLogic Platform also includes:
- JRockit, a custom JVM.
- Korthal that includes Commerce Server and Personalization Server
- WebLogic Integration
- WebLogic Workshop, an Eclipse IDE for Java, SOA and Rich Internet Applications
- WebLogic Server includes .NET interoperability and supports the following native integration capabilities:
- CORBA connectivity
- COM+ Connectivity
- IBM WebSphere MQ connectivity
- Java EE Connector Architecture
- Native enterprise-grade JMS messaging
- WebLogic/Tuxedo Connector
Oracle WebLogic Server Process Edition also includes Business Process Management and Data Mapping functionality. WebLogic supports security policies managed by security administrators. The Oracle WebLogic Server Security Model includes:
- application business logic separated from security code
- complete scope of security coverage for all Java EE and non-Java EE components
- Enterprise Grid Messaging
- JMS Messaging Standard
- Oracle Coherence, in-memory caching of frequently used data across multiple servers
- Oracle TopLink
- Oracle WebLogic Server Web Services
- BPEL & BPEL-J
- Java EE 1.3, 1.4, 5, 6
- JPA 1.0 & 2.0
- JMX and SNMP
- Native support for:
- XSLT and XQuery
As of 2010, Oracle Corporation regards the following products as "core components" of Oracle WebLogic Server:
Supported Open Standards
- Oracle Application Server :
Oracle Application Server
In computing, the Oracle Application Server 10g (the "g" stands for grid) (short Oracle AS), consists of an integrated, standards-based software platform. It forms part of Oracle Corporation's Fusion Middleware technology stack. The heart of Oracle Application Server consists of Oracle HTTP Server (based on Apache HTTP Server) and OC4J (OracleAS Containers for Java EE) which deploys Java EE-based applications. The latest version of OC4J offers full compatibility with the Java EE 1.4 specifications.
Oracle Application Server became the first platform designed for grid computing as well as with full life-cycle support for service-oriented architecture (SOA).
The current release of Oracle Application Server, 10g R3, does not feature a metadata repository tier, relying instead on metadata repositories provided in previous releases.
Following Oracle's acquisition of BEA Systems: 'key features will be integrated with WebLogic Server with seamless migration'.
Oracle Corporation marketed its first application server using the name Oracle Web Server (OWS). A subsequent repackaging resulted in the Oracle Application Server (OAS). A later product, superseding OAS, became the iAS (Internet Application Server).
Oracle Corporation subdivides some of its products into varying "editions" - apparently to facilitate marketing and license-tracking.
Available Oracle AS editions include:-
- Enterprise Edition
- Standard Edition
- Standard Edition One
- Java Edition
- Oracle Portal
- Oracle Identity Management
- Oracle Integration
- Oracle Business Rules
- Oracle BPEL Process Manager (option)
- Oracle Business Activity Monitoring (option)
- Oracle Business Intelligence
- Oracle Forms
- Oracle Reports
- Oracle TopLink
- Oracle JDeveloper
- Oracle Application Server Containers for Java EE (OC4J)
- Oracle Enterprise Manager
- Oracle Application Server Web Cache
- Oracle Application Server Wireless
- Oracle Application Development Framework
Oracle Corporation refers to its implementation of the Java EE specification as Oracle Containers for J2EE and abbreviates the concept as OC4J. OC4J, originally based on the IronFlare Orion Application Server, has developed solely under Oracle's control since Oracle Corporation acquired the source code.
- OC4J includes the following servers:
- Web Container
- Enterprise JavaBean Container
- JMS Server
Oracle Application Server can utilize an "Oracle AS Infrastructure Database" an Oracle database instance supporting the Oracle AS Metadata Repository and/or Oracle Identity Management.
OPMN - the Oracle Process Management and Notification server - monitors components of the Oracle Application Server.
- JRockit :
JRockit, a proprietary Java Virtual Machine (JVM) originally developed by Appeal Virtual Machines and acquired by BEA Systems in 2002, became part of Oracle Fusion Middleware in 2008.
The JRockit code base and the HotSpot virtual machine from Sun Microsystems (now Oracle) are currently being integrated, with the target of releasing a JVM with a combined code base around the release date of JDK 8.
JRockit was made free and publicly available in May 2011.
Many JRE class files distributed with JRockit exactly replicate those distributed with HotSpot. JRockit overrides class files which relate closely to the JVM, therefore retaining API compatibility while enhancing the performance of the JVM.
Following the finalization of the acquisition of Sun Microsystems, Oracle announced in JavaOne 2010 that the best features of JRockit would be implemented in OpenJDK
In May 2011, Oracle announced that JRockit has become free, confirming that they plan to port JRockit features on OpenJDK
Oracle claims that using JRockit can give significant performance gains, but independent benchmarking has not always confirmed this. Server benchmarks on earlier Java Virtual Machines tend to show that server performance of HotSpot was better, but that JRockit had a much better scalability.
Supported CPU types
- Intel x86
- Intel x86-64
- Intel Itanium (support has ended)
JRockit Mission Control
JRockit 5.0 R26 bundled a set of tools called JRockit Mission Control. The tools include:
- an interactive Management Console, which visualizes garbage-collection and other performance statistics
- a runtime performance profiling tool called Runtime Analyzer
- a memory-analysis tool called Memory Leak Detector
- From release R27.3 the tools suite also includes a latency analyzer that graphically visualizes when threads stall due to synchronization, file/network I/O, memory allocation and garbage collection pauses.
- Tuxedo (software) :
Tuxedo (Transactions for Unix, Extended for Distributed Operations) is a middleware platform used to manage distributed transaction processing in distributed computing environments. Tuxedo is a transaction processing system or transaction-oriented middleware, or enterprise application server for a variety of systems and programming languages. Developed by AT&T in the 1980s, it became a software product of Oracle Corporation in 2008.
From the beginning in 1983, AT&T designed Tuxedo for high availability and to provide extremely scalable applications to support applications requiring thousands of transactions per second on commonly-available distributed systems. The original development targeted the creation and administration of operations support systems for the US telephone company that required online transaction processing (OLTP) capabilities.
The Tuxedo concepts derived from the Loop Maintenance Operations System (LMOS). Tuxedo supported moving the LMOS application off mainframe systems that used Information Management System (IMS) from IBM on to much cheaper distributed systems running (AT&T's own) Unix.
The original Tuxedo team comprised members of the LMOS team, including Juan M. Andrade, Mark T. Carges, Terrence Dwyer, and Stephen Felts. In 1993 Novell acquired the Unix System Laboratories (USL) division of AT&T which was responsible for the development of Tuxedo at the time. In September 1993 it was called the "best known" distributed transaction processing monitor, running on 25 different platforms. In February 1996, BEA Systems made an exclusive agreement with Novell to develop and distribute Tuxedo on non-NetWare platforms, with most Novell employees working with Tuxedo joining BEA. In 2008, Oracle Corporation acquired BEA Systems, and TUXEDO was marketed as part of the Oracle Fusion Middleware product line.
Tuxedo has been used as transactional middleware by a number of multi-tier application development tools. The Open Group used some of the Tuxedo interfaces as the basis of their standards such as X/Open XA and XATMI.
The Tuxedo developers published papers about it in the early 1990s. Later it became the basis of some research projects.
- Standards based APIs - SCA, The Open Group XATMI, Object Management Group CORBA
- Communication types - Synchronous, Asynchronous, Conversational, Unsolicited Notifications, Publish/subscribe
- Typed buffers
- FML/FML32 - Self describing fielded buffers similar to Abstract Syntax Notation One or Fast Infoset
- STRING and multibyte strings MBSTRING
- CARRAY binary blobs
- VIEW/VIEW32 externally descripted records
- Transaction Management - Global Transactions - Two-phase commit protocol - X/Open XA
- Clustering - Domains
- /WS - Remote Clients
- Java clients - Jolt
- JEE Integration - Tuxedo JCA Adapter
- Bidirectional Web Services - SALT
- /QUEUE - Transient (in memory) and Persistent Queues (also called Reliable Queues)
- Data Dependent Routing (DDR)
- Event Broker
- Security - Authentication, Authorization, Auditing, and Public key infrastructure based message signing and encryption
- Programmed Administration and SNMP support
- System and application performance monitoring - TSAM
- Load balancing, server spawning and decay
- Mainframe connectivity - TMA
- Supports C, C++, COBOL, Python, Ruby, PHP, and Java applications on most Unix platforms, Linux, Microsoft Windows, and other proprietary platforms such as OpenVMS and AS400 IBM System i
Tuxedo is at its core a message routing and queuing system. Requests are sent to named services and Tuxedo uses memory based inter-process communication facilities to queue the requests to servers. The requester is unaware of where the server that actually processes the request is located or how it is implemented. In essence, Tuxedo provided the elements of service-oriented architecture (SOA) decades before the phrase was coined. Tuxedo can use the content of the message to determines what servers should be utilized to receive the request by means of data dependent routing.
The heart of the Tuxedo system is the Bulletin Board (BB). This is a shared memory segment that contains the configuration and state of a Tuxedo domain. Servers, services, transactions, and clients are all registered in the BB providing a global view of their state across the machines within a domain. To coordinate updates to the BB a process called the Bulletin Board Liaison (BBL) runs on each machine to keep the local copy of the BB up-to-date. A master machine runs a process called the 'Distinguished Bulletin Board Liaison' that coordinates the updates to the BB. This allows each machine to have a view of what servers, services, transactions, and clients are on each machine within the domain.
Another process on each machine called the Bridge is responsible for passing requests from one machine to another. This allows Tuxedo to spread load across the various machines within a domain and allows servers and services to be running on multiple machines. In addition the BBL and Bridge monitor each other and restart the other should one fail. In the advent of a failure of the master machine, another machine designated as a backup master can take over the function of master machine. Also, since machines within a single domain can be of different architectures (x86, IA32, SPARC, P-Series, etc.), the Bridge is also responsible for handling differences in things like endianness.
On Oracle Exalogic Tuxedo leverages the RDMA capabilities of InfiniBand to bypass the bridge. This allows the client of a service on one machine to directly make a request of a server on another machine.
Flexible buffer formats
Tuxedo applications can utilize a variety of message formats depending upon the type of data that is to be passed. One of the most popular formats is the FML buffer format which is much like a binary XML or ASN.1 format. FML buffers can contain an arbitrary number of named fields of arbitrary type. Fields can be repeated and nested. As it is a self describing binary format, the processing of fields incurs very little overhead in comparison to the parsing necessary to support something like XML. VIEW buffers are essentially records, C structures, or COBOL copybooks. A VIEW buffer has an external description which allows Tuxedo to access the fields within it if necessary for things like data dependent routing. Other buffer formats include XML, CARRAY (opaque binary data), STRING, and MBSTRING (a string buffer containing multibyte characters.) Tuxedo can automatically and transparently convert FML buffers to and from XML buffers.
There is also support for user-developed buffer types (for example JamFlex buffers defined by Tuxedo version of Panther RAD toolset).
For remote clients (Java, CORBA, or /WS), Tuxedo provides communication concentrators called listener/handlers that handle the remote network communication. Clients connect to these communication concentrators and act as proxies for the clients. As clients make requests, the listener/handler uses the local Tuxedo infrastructure to make the request on the behalf of the client. Tuxedo then load balances the requests across the servers within the domain that offer the service even if the server is not on the local machine. This is in contrast to most Java EE application servers where load balancing is done by the client making requests to different machines with the cluster.
To facilitate the sharing of services across domains, Tuxedo provides domain gateways. A domain gateway allows importing and exporting services from remote domains. This allows the local domain to see services on remote domains as though they were local services. The domain gateways are responsible for propagating security and transaction context to the remote domain. Besides connecting Tuxedo domains together, domain gateways exist for mainframe systems using TCP/IP, IBM Systems Network Architecture (SNA), or the OSI protocols, and Java Platform, Enterprise Edition application servers. For the mainframe gateways, each system sees the services imported from the remote system as local services and use the local systems infrastructure to interact with those services. This means that Tuxedo sees a CICS transaction as a Tuxedo service, and CICS sees a Tuxedo service as a CICS transaction.
The BBL on each machine monitors the state of all servers and can automatically restart failed servers. It can also detect hung servers and kill/restart them as required. Any transactions that are affected by a server or machine failure are rolled back.
Transaction monitoring and coordination
Tuxedo applications can request that all service invocations and their associated updates to any resources controlled by resource managers (such as databases) be controlled by a transaction. Once the application begins a transaction, all subsequent service invocations and nested invocations are included as part of that transaction, even those services that were executed on remote domains. Tuxedo then coordinates the commit processing with the resource managers to ensure atomic updates to all affected resources. Transactions can be controlled by the application or automatically controlled by the Tuxedo configuration, i.e., container controlled transactions.
Tuxedo provides a queuing subsystem called /Q. This facility provides transient and persistent queues that allows application to explicitly queue requests to named queues. Queues can be ordered by message availability time, expiration time, priority, LIFO, FIFO, or a combination. Queues are managed by an XA compliant resource manager allowing queue operations to participate in transactions. An automated queue forwarding server is provided that will remove entries from a queue and invoke an associated Tuxedo services.
The event subsystem within Tuxedo provides support for unsolicited events as well as brokered events. Unsolicited events allow Tuxedo applications to send out-of-band notifications to clients that aren't necessarily waiting for a response. Brokered events allow application to subscribe to events of interest and when another application posts an event, all applications subscribed to that event receive it. This allows applications to use an event driven model instead of the more typical request/response model.
Oracle offers a number of add-on products to Tuxedo.
In March 2010, Oracle announced two new products. Application Runtime for CICS and Batch along with the associated Oracle Tuxedo Application Rehosting Workbench allows the migration of IBM Customer Information Control System (CICS) and batch applications onto Tuxedo on distributed systems. By providing automated conversion tools, CICS equivalent API pre-processor macro expansion, and a JES-2 like Batch execution environment, the migration of mainframe applications is greatly simplified.
This product provides a bi-directional web services SOAP/HTTP(S) gateway. This gateway allows Tuxedo services to be accessed by external SOAP clients without making any changes to the Tuxedo service. Likewise Tuxedo applications can call an external web service as though it were a local Tuxedo service. The latest version of SALT supports WS-AtomicTransactions and modules for Apache Web Server, Oracle HTTP Server, and Oracle iPlanet Web Server, that allows the creation of dynamic web content by calling Tuxedo services.
This product provides centralized monitoring capabilities for multiple Tuxedo domains. TSAM agents are deployed on the machines in a Tuxedo domain. These agents collect metric data from the running Tuxedo processes based on a configured policy, and send the data back to the TSAM Manager where it is used historically or in real time. TSAM provides configuration information, call path, call pattern, service execution, transaction, and more monitoring metrics. TSAM also monitors Tuxedo ART CICS and Batch applications.
Tuxedo Mainframe Adapters (TMA)
This product provides a set of gateway processes that run on Tuxedo that communicate with a mainframe using its native protocols. This gateway provides bidirectional integration between mainframe and Tuxedo platforms and makes Tuxedo appear as a remote CICS region to the mainframe.
This product is a wrapper to the WebLogic Tuxedo Connector (WTC) found as part of the WebLogic Server (WLS) product. WTC can only be used on WebLogic, but the JCA adapter allows deploying WTC capabilities on other Java Application Servers that support the Java EE JCA specification.
Tuxedo Message Queue
Provides enterprise messaging capabilities that combines the features of Oracle MessageQ with Tuxedo. This extends the existing /Q message queuing facility of Tuxedo by providing things like delivery notification, offline messaging, and store and forward capabilities.
- Oracle WebCenter Imaging :
Oracle WebCenter Imaging
Oracle WebCenter Imaging (formerly known as Oracle Imaging and Process Management or Oracle IPM) is Oracle Corporation's combined document management and business process management suite, marketed as a component of the Oracle Fusion Middleware portfolio of products.
Oracle WebCenter Imaging provides organisations with a software solution focused on process-oriented imaging applications and "image-enabling" business applications, including Oracle E-Business Suite, PeopleSoft Enterprise, and many others. It enables annotation and markup of images, automates routing and approvals, and supports high-volume applications for trillions of items.
Oracle WebCenter Imaging (and its historical variants) have been installed at thousands of customers world-wide since its inception, in a variety of industries from finance and banking, healthcare, through to construction.
Oracle WebCenter Imaging 11g Release 1 (188.8.131.52.0) - released February 2012
Oracle WebCenter Imaging 11g Release 1 (184.108.40.206.0) - released May 2011
Oracle WebCenter Imaging 10g Release 3 (10.1.3.6.0) - released April 2011
Oracle WebCenter Imaging was originally developed by Optika in the late 1990s, as a workflow-enabled next generation of an imaging-only product called FilePower. The initial versions (1.0 to 1.5.1) were marketed under the name of eMedia, and with the release of version 2.0 the name was changed to Acorde. The Acorde name lasted through to version 4.0, which was the last Optika-developed release, due to a merger between Optika and Stellent in 2004, where the Optika brand was dissolved. At this point, the product was rebranded as Stellent Imaging and Business Process Management (or its acronym of IBPM). The version numbers were aligned with Stellent versioning at the time, so the following releases were 7.5 and 7.6.
Soon after the merger, Oracle Corporation acquired Stellent in 2007, and the product was rebranded as Oracle Imaging and Process Management (IPM). The subsequent Oracle-branded version was known as 7.7 (Stellent numbering), and 10gR3 which aligned with Oracle Corporation's product line at the time.
In 2009, Brainware entered into an OEM agreement with Oracle whereby Oracle plans to embed the Brainware Distiller' intelligent data capture software into Oracle WebCenter Imaging. This adds AP processing and intelligent data extraction into the imaging product offering. As it turns out, Oracle took a more modular approach, and integrated this technology into a new Oracle product, called Oracle Forms Recognition (OFR), which is designed to closely integrate with Oracle WebCenter Imaging.
In July 2011, several of Oracle Corporation's ECM products underwent a repositioning under the existing Oracle WebCenter marketing name, so Oracle IPM became known as Oracle WebCenter Imaging.
Oracle WebCenter Imaging supports both Oracle and Microsoft SQL Server databases. In 10g versions (and below) the only core server architecture supported is Win32 or Win64, so support for the main services is restricted to Microsoft Windows Server editions, from Windows 2000 Server through to Windows Server 2008. End-user/client access for image retrieval and workflow actions is via either a Windows-based application (also known as a "production" or "thick" client) which is required for administrative functions, or two versions of a web-based client; a heavier but more featured version, or a cut-down "express" version. The Windows client is installed and kept updated from a central repository service (known as Distributed Software Management Service, or DSMS), enabling easy installation to end-user machines, and automatic updates as the central repository is updated or upgraded. The web client is ASP.NET based, so is restricted to Microsoft IIS only.
The WebCenter Imaging server consists of a number of separate highly task-focused components (known as services), which can be enabled or disabled depending on requirements, distributed over a number of physical machines to spread workload, and in most instances duplicated to provide scalability.
The 11g release has been completely rewritten as a J2EE application, which runs on Oracle WebLogic Server, so supported operating systems and architectures has been extensively improved. With the initial release (Release 1) versions, there is no direct upgrade path from previous versions, so it is for new installs only. Both client and administrative access is now performed via a web interface, and workflow functionality has been removed; the intention is to integrate the product with dedicated workflow suites, such as Oracle BPEL Process Manager. There are also no longer specific services as in previous versions, so scalability and redundancy is now handled via the clustering functionality provided by the WebLogic Server architecture.
- Oracle Adaptive Access Manager :
Oracle Adaptive Access Manager
The Oracle Adaptive Access Manager (OAAM) is part of the Oracle Identity Management product suite that provides access control services to web and other online applications.
Oracle acquired the company "Bharosa" which means 'trust' in the Hindi language to extend its web-based access management solutions. Bharosa was founded by Thomas Varghese a research scientist and a serial entrepreneur by background, in 2003. Don Bosco Durai and Jon Fisher later came on board as co-founders.
The premise was simple in that the existing authentication technologies were unsatisfactory and easy to compromise. No authentication technology can really provide its full and intended security benefits unless the computer and computer network are re-designed from the grounds up.
Oracle Adaptive Access Manager has two components, the strong Authentication-agnostic security component and the application-agnostic Risk component. One simple example of the Strong Authentication component is that a User can choose a personalized keypad and use mouse clicks to enter password to prevent passwords being stolen with key loggers and being phished or pharmed. The Risk Component analyzes the authentication and transaction data for abnormalities and anomalies in real-time to prevent fraud and also in off-line mode to identify and detect internet fraud.
- Oracle Enterprise Service Bus :
Oracle Enterprise Service Bus
Oracle Enterprise Service Bus (Oracle ESB), a fundamental component of Oracle's Services-Oriented Architecture suite of products, provides seamless integration of data and enterprise applications within an organisation and their connected ( "extended" or 'virtual') enterprises.
Oracle ESB is technically an 'enterprise service bus' designed and implemented in an Oracle Fusion Architecture's SOA environment; to simplify the interaction and communication between existing Oracle products, third-party applications, or any combination of these.
As a software architecture model for distributed computing it is a specialty variant of the more general client server software architecture model and promotes strictly asynchronous message oriented design for communication and interaction between applications. Its primary use is in Enterprise Application Integration of heterogeneous and complex landscapes of an organisation, and thus enabling its easy management.
An ESB service is designed and configured with Oracle JDeveloper and Oracle ESB Control user interfaces. It is then registered to an ESB Server. The ESB Server supports multiple protocol bindings for message delivery, including HTTP/SOAP, JMS, JCA, WSIF and Java, using synchronous/asynchronous, request/reply or publish/subscribe models. Currently, the ESB Server does not support Remote Method Invocation.
Oracle Enterprise Service Bus (ESB) should not be confused with Oracle Service Bus (OSB). ESB was developed by Oracle. OSB, formerly known as Aqualogic Service Bus, was acquired when Oracle bought BEA Systems. The two products are related and interchangeable.
Oracle Enterprise Service Bus contains the following components:
- ESB Server
- Oracle ESB Control
- ESB Metadata Server
- Oracle JDeveloper
Oracle Enterprise Service Bus application-integration features fall into the following categories:
- Server Capabilities
- SOAP invocations services
- Adapter services
- File/FTP adapter service
- Database adapter service
- JMS adapter service
- MQ adapter service
- AQ adapter service
- Oracle Applications (OA) adapter services
- Custom adapter service
- Document Transformation : XSLT and MFL
- Content-Based and Header-Based Routing
- Tight integration with Oracle BPEL Process Manager
- Management and Monitoring Capabilities
- ESB Control, the central point for metadata and configuration changes that take effect immediately
- Visual representation of end-to-end service relationships
- Minimal overhead end-to-end message instance tracking and monitoring
- Error Hospital - automated and manual means for individual and bulk message replays
- Oracle Application Development Framework :
Oracle Application Development Framework
In computing, Oracle Application Development Framework, usually called Oracle ADF, provides a commercial Java framework for building enterprise applications. It provides visual and declarative approaches to Java EE development. It supports rapid application development based on ready-to-use design patterns, metadata-driven and visual tools.
Based on the MVC architecture. Oracle ADF can support any combination of the following:
- Web Services - both SOAP and REST
- TopLink - and EclipseLink
- POJO - simple Java classes (Plain Old Java Objects)
- ADF Business components
- CSV and XML files
- JavaServer Faces (JSF)
- ADF Task Flows - extension of the JSF controller layer that adds complete process flow and reusability aspects.
- JavaServer Pages (JSP)
- JavaServer Faces (JSF)
- ADF Faces
- ADF Mobile browser - based on Apache Trinidad
- Excel through ADF desktop integration
The Oracle JDeveloper free Integrated Development Environment provides a graphical interface for creating data-management applications using ADF.
Oracle also offers Eclipse based tooling for ADF in Oracle Enterprise Pack For Eclipse.
Implementers can deploy Oracle ADF applications on Java EE-compliant containers.
Mobile application development
Oracle ADF Mobile - a hybrid framework for mobile development. Enables development of a single source and generation of native applications for both iOS and Android devices. Coding of logic is done with the Java language. UI layer can be developed with a set of components (AMX) that generate an HTML5 based user interface. In addition Oracle ADF Mobile can incorporate local HTML5 pages and remote HTML content generated from other servers.
Oracle ADF Mobile includes a controller layer based on the ADF Taskflow concepts, as well as support for the ADF binding solution for easy binding of UI to services. Oracle ADF Mobile support interaction with device features such as GPS, contacts, SMS and more.
Oracle Corporation has marketed parts of Oracle ADF since 1999 â€” specifically ADF Business Components â€” then known as "JBO" and later as "BC4J" ("Business Components for Java").
The current ADF architecture with the generic model/binding layer was introduced with JDeveloper 9.0.5.
In June 2006 Oracle Corporation donated the ADF Faces component library to Apache Trinidad. (ADF Faces, Oracle's JSF implementation, includes over 100 components.) In September 2012 Oracle introduced a free version of the core Oracle ADF technologies under the name "Oracle ADF Essentials" for more information see: http://www.oracle.com/technetwork/developer-tools/adf/overview/components-1844931.html
Oracle ADF Essentials is a free to develop and deploy packaging of the key core technologies of Oracle ADF. See the license terms for Oracle ADF Essentials: http://www.oracle.com/technetwork/licenses/adf-essentials-license-1837221.html For the "full" Oracle ADF: The Oracle Application Server licence includes a component for a license fee for Oracle ADF. This means that all users who have purchased an Oracle Application Server licence may use Oracle ADF for free. Users who want to deploy ADF to a third-party application-server can purchase an ADF runtime license at their local Oracle sales office. Users can develop and test Oracle ADF applications free of charge declaratively within Oracle JDeveloper.
Oracle Corporation purchased WebLogic in June 2008, and thus no longer regards it as a third-party application-server, so ADF is included in every WebLogic license.
Supported customers can get access to the source code for Oracle ADF through a request to Oracle Support.
- TopLink :
In computing, TopLink is an object-relational mapping (ORM) package for Java developers. It provides a framework for storing Java objects in a relational database or for converting Java objects to XML documents.
TopLink Essentials is a reference implementation of the EJB 3.0 Java Persistence API (JPA) and a product of Oracle.
The Object People (that's the "Top" in the Name) originally developed TopLink in Smalltalk in the 1990s. In 1996-1998 a Java version of the product was created named "TopLink for Java". After the joint acquisition of The Object People in April 2000 by BEA Systems and WebGain, the TopLink product-line became the property of WebGain
In 2002 Oracle Corporation acquired TopLink, which continues to be developed in the Oracle Fusion Middleware product.
In 2006, Oracle donated source code from the TopLink product and development resources to the open-source Sun Microsystems java.net GlassFish project. It became the Java EE EJB 3.0 JPA reference implementation.
In 2007, TopLink source code was donated to the Eclipse Foundation and the EclipseLink project was born.
In March 2008 the Eclipse Foundation announced that Sun Microsystems had selected the EclipseLink project as the reference implementation for the JPA 2.0, JSR 317 standard.
As well as functioning as an object-relational mapping tool, TopLink has other features including:
- query framework that supports an object-oriented expression framework, Query by Example (QBE), EJB QL, SQL, and stored procedures
- an object-level transaction framework
- caching to ensure object identity
- a set of direct and relational mappings
- object-to-XML mappings, in addition to JAXB support
- EIS/JCA support for non-relational datasources
- visual mapping editor (Mapping Workbench)
- limited support for query in memory
Java Pro Readers' Choice Award for Best Java Data Access Tool or Driver (July 2003).
Editor's Choice JavaWorld 2003 Award for Best Java Data Access Tool (2003).
4th-best Java persistence architecture (as voted by Java Developer's Journalreaders in 2004).
- Oracle Forms :
Oracle Forms is a software product for creating screens that interact with an Oracle database. It has an IDE including an object navigator, property sheet and code editor that uses PL/SQL. It was originally developed to run server-side in character mode terminal sessions. It was ported to other platforms, including Windows, to function in a client - server environment. Later versions were ported to Java where it runs in a Java EE container and can integrate with Java and web services.
The primary focus of Forms is to create data entry systems that access an Oracle database.
How it works ?
Oracle Forms accesses the Oracle database and generates a screen that presents the data. The source form (*.fmb) is compiled into an "executable" (*.fmx), that is run (interpreted) by the forms runtime module. The form is used to view and edit data in database-driven applications. Various GUI elements, such as buttons, menus, scrollbars, and graphics can be placed on the form.
The environment supplies built-in record creation, query, and update modes, each with its own default data manipulations. This minimizes the need to program common and tedious operations, such as creating dynamic SQL, sensing changed fields, and locking rows.
As is normal with event driven interfaces, the software implements event-handling functions called triggers which are automatically invoked at critical steps in the processing of records, the receipt of keyboard strokes, and the receipt of mouse movements. Different triggers may be called before, during, and after each critical step.
Each trigger function is initially a stub, containing a default action or nothing. Programming Oracle Forms therefore generally consists of modifying the contents of these triggers in order to alter the default behavior. Some triggers, if provided by the programmer, replace the default action while others augment it.
As a result of this strategy, it is possible to create a number of default form layouts which possess complete database functionality yet contain no programmer-written code at all.
Oracle Forms is sold and released separately from the Oracle Database. However, major releases of an Oracle database usually result in a new major version of Oracle Forms to support new features in the database.
Oracle Forms started as Interactive Application Facility (IAF), which had two main components: the compiler (Interactive Application Generator - IAG) and the runtime interpreter (Interactive Application Processor - IAP). Released with Oracle Database version 2, IAF provided a character mode interface to allow users to enter and query data from an Oracle database. It was renamed to FastForms with Oracle Database version 4 and added an additional tool to help generate a default form to edit with IAG, the standard tool. The product saw one more name change before gaining its current moniker, called SQL*Forms version 2 with the Oracle 5 database.
Oracle Forms 2.3 was character-based, and did not use PL/SQL. The source file was an *.INP ASCII file. This enabled developers to commonly edit the INP file directly, although that editing method was not supported by Oracle. This version used its own primitive and unfriendly according to whom ? built-in language, augmented by user exits compiled language code linked to the binary of the Oracle-provided run-time.
Oracle Forms 3 was character-based, and by using PL/SQL was the first real version of Forms. All subsequent versions are a development of this version. It could run under X but did not support any X interface-specific features such as checkboxes. The source file was an *.INP ASCII file. The IDE was vastly improved[according to whom?] from 2.3 which dramatically decreased the need to edit the INP file directly, though this was still a common practice. Forms 3 automatically generated triggers and code to support some database constraints. Constraints could be defined, but not enforced in the Oracle 6 database at this time, so Oracle used Forms 3 to claim support for enforcing constraints. There was a "GUI" version of Forms 3 which could be run in environments such as X Window, but not Microsoft Windows. This had no new trigger types, which made it difficult to attach PL/SQL to GUI events such as mouse movements.
Oracle Forms version 4.0 was the first "true" GUI based version of the product. A character-based runtime was still available for certain customers on request. The arrival of Microsoft Windows 3 forced Oracle to release this GUI version of Forms for commercial reasons. Forms 4.0 accompanied Oracle version 6 with support for Microsoft Windows and X Window. This version was notoriously buggy and introduced an IDE that was unpopular with developers.according to whom ? The 4.0 source files became binary and were named *.FMB. This version was not used by the Oracle Financials software suite.
Oracle Forms version 4.5 was really a major release rather than a "point release" of 4.0 despite its ".5" version number. It contained significant functional changes and a brand new IDE, replacing the unpopular IDE introduced in 4.0. It is believed[according to whom?] to be named 4.5 in order to meet contractual obligations to support Forms 4 for a period of time for certain clients. It added GUI-based triggers, and provided a modern IDE with an object navigator, property sheets and code editor.
Due to conflicting operational paradigms, Oracle Forms version 5 accompanied Oracle version 7. It featured custom graphical modes tuned especially for each of the major systems, though its internal programmatic interface remained system-independent. It was quickly superseded by Forms 6, which was released with Oracle 8.0 database and was rereleased as Forms 6i with Oracle 8i. This was basically Forms 4.5 with some extra wizards and bug-fixes. But it also included the facility to run inside a web server. A Forms Server was supplied to solve the problem of adapting Oracle Forms to a three-tier, browser-based delivery, without incurring major changes in its programmatic interface. The complex, highly interactive form interface was provided by a Java applet which communicated directly with the Forms server. However the web version did not work very well over HTTP. A fix from Forms 9i was retrofitted to later versions of 6i to address this.
The naming and numbering system applied to Oracle Forms underwent several changes due to marketing factors, without altering the essential nature of the product. The ability to code in Java, as well as PL/SQL, was added in this period. Forms 7 was never release to the public and only existed internally as Project Cherokee. Version 8 did not exist; This number was jumped over in order to allow the Oracle Forms version number to match the database version in v9. Forms 9i included many bug fixes to 6i and was a stable version, but it did not include either client - server or character-based interfaces, and three-tier, browser-based delivery is the only deployment option. The ability to import java classes means that it can act as a web service client.
Forms 10g is actually Forms version 9.0.4, so is merely a rebadged forms 9i. Forms 11 includes some new features, relying on Oracle AQ to allow it to interact with JMS.
Integration with Oracle Designer CASE Tool
Oracle Designer is a CASE tool that is sold by Oracle. It is able to generate various software modules including Oracle Forms and Oracle Report
Whilst Oracle's preferred approach for new development is its Java based Oracle Application Development Framework or Oracle Application Express. Oracle's development tools statement of direction is quite clear in its commitment to continuing to support Oracle Forms and continue to develop and enhance it in the following areas:
Making the upgrade to the web and to new releases as smooth as possible
Allowing Forms and Reports applications to take full advantage of the application server services and inter-operate with Java EE applications. An Alternative to Oracle Application Development Framework is also Oracle Application Express. One of the advantages of Oracle Application Express is that it is more closely related to Forms as it also relies heavily on PL/SQL.
- Oracle Developer Suite :
Oracle Developer Suite
Oracle Developer Suite is a suite of development tools released by the Oracle Corporation. The principal components were initially Oracle Forms and Oracle Reports, although the suite was later expanded to include JDeveloper amongst others.
In the early 1990s, Oracle had two complementary, but quite different tools - SQL*Forms and SQL*ReportWriter. Both were character-based and there was some integration between the two although they were sold as separate products. The developer interface became more similar over time and they were eventually grouped together as Oracle IDE (Integrated Development Environment).
The suite was renamed to Oracle Developer and then to Oracle Developer/2000.
As with most products that had 2000 in their name, this was dropped after 1999 and the suite was renamed Oracle Developer Suite. Tools such as JDeveloper and Oracle Designer were added over subsequent years.
Most of the component parts of Oracle Developer Suite are now part of what Oracle calls Oracle Fusion Middleware.
The name of the suite has been changed a few times. The software components that are included in the suite have also changed over time.
This section requires expansion. (June 2008)
- Suite Name Version Components Date
- Oracle IDE Forms, Reports, Book, Graphics
- Oracle Developer Forms, Reports, Book, Graphics
- Oracle Developer 2000(D2K) Forms, Reports, Book, Graphics
- Oracle Developer Suite Forms, Reports, Designer, JDeveloper
The latest release, Oracle Developer Suite 10g consists of the following components:
- Oracle JDeveloper
- Oracle Forms
- Oracle Reports
- Oracle Designer
- Oracle Discoverer
- Oracle Software Configuration Manager
- Oracle Business Intelligence Bea
- Oracle BI Publisher :
Oracle BI Publisher
Oracle XML Publisher (XMLP) is Oracle Corporation's latest reporting technology. It was originally developed to solve the reporting problems faced by Oracle Applications. Osama Elkady from the Applications Technology Group and Tim Dexter from the Financials Group were the main drivers for the product. It was first released with Oracle E-Business Suite 11.5.10 in 2003. Since then it has been integrated into most of Oracle Products including JD Edwards EnterpriseOne application 8.12 and Peoplesoft Enterprise 9, and as a standalone version, XML Publisher Enterprise with no dependency on Oracle Applications. When XML Publisher became part of the Oracle BI Enterprise Edition Suite it was re-branded as Oracle BI Publisher.
BI Publisher separates the creation of data from the process of formatting it for different uses. The engine can format any well-formed XML data, allowing integration with any system that can generate XML, including Web Services or any data source available through JDBC. BI Publisher can merge multiple data sources into a single output document.
BI Publisher report templates can be designed using the Microsoft Word, Adobe Acrobat, Microsoft Excel (standalone only) and Adobe Flash (standalone only). Templates created using these tools contain embedded fields with properties that determine how the XML data will be merged into the template, using Extensible Stylesheet Language syntax to precisely match the server's engine.
Template Builder for Word
Template Builder is an extension to Microsoft Word that simplifies the development of Rich Text Format templates. Templates created using Template Builder are transformed into XSL Stylesheets that can be used to generate PDF, RTF, Microsoft Excel and HTML outputs.
Starting with the 11g release, BI Publisher also offers a pure web based layout editor that allows users to create management reports and simple production reports in a WYSIWYG layout editor. The layout editor is written in pure DHTML. As with Rich Text Format templates Reports created in the web based layout editor are transformed into XSL stylesheets and can be viewed in the same output formats. In addition, the layout editor templates (.xpt) can also be viewed in an interactive viewer which allows re-sorting and interactive filtering of existing reports.
XML Publisher templates can be designed in Adobe Acrobat 5.00 and above, using the native form field capabilities.
The 10.1.3.3 release of Oracle BI Publisher offers support for Adobe Corporation's new document format for building interactive forms and reports, called Flex. You can build Flex templates, test them on your desktop, and deploy them to the BI Publisher server to generate Flash output. Users are then able to run the reports from the BI Publisher user interface or schedule them for delivery to report consumers.
In addition, to using the tools mentioned above users can also upload existing XSL stylesheets to run with BI Publisher.
Data Template/Model design
BI Publisher supports the generation of XML data from SQL queries, web services, XML files and XML HTTP servers, LDAP queries, MDX queries (starting 10.1.3.4.1), Oracle ADF view objects (11g) and Microsoft EXCEL files (11g). While previous version allowed the simple addition through a UI, linking of queries required the creation of an XML configuration file. In 11g the data model can be created using a web based visual data model builder.
The server is a Java EE application that can be deployed to any Java EE container. The XML data is fed through the templates to produce XSL Formatting Objects, which can be transformed into most popular output formats:
- Portable Document Format
- Rich Text Format
- Plain Text (e.g. EFT/EDI)
The Delivery Manager is responsible to deliver the output to different destinations, such as fax and email, with the flexibility of delivering the same output to different destinations; e.g. HTML format can be sent to email while a PDF format sent to the printer. The following protocols are supported:
- Internet Printing Protocol (IPP)
The Delivery Manager provides an open architecture that allows custom delivery channels to be implemented.
- Oracle Reports :
Oracle Reports is a tool for developing reports against data stored in an Oracle database. Oracle Reports consists of Oracle Reports Developer (a component of the Oracle Developer Suite) and Oracle Application Server Reports Services (a component of the Oracle Application Server).
The report output can be delivered directly to a printer or saved in the following formats:
- Microsoft Excel
- Oracle RPT was an early, primitive predecessor to SQL*ReportWriter.
- Character based report writing tool.
- The software was purchased by Oracle from a third party
- New GUI mode IDE
- Major rewrite
- Release April 1995. New Object Navigator. New Toolbars. New Menus.
- Still no undos.
- New features added in 6i:
- WebDB integration
- XML Output
- HTML Parameter Form Extensions
- SQL Access to the Reports Server Queue
- EXEC_SQL Integration
- New features added in 9i:
- XML report definition
- Query types: XML, JDBC, Oracle9i OLAP, text files
- Pluggable Data Sources
- Java Importer
- Oracle9i JDeveloper Integration
- Oracle9i SCM Integration
- Integration with BI Beans
- Oracle9iAS Portal Report Import
- Edit Oracle9iAS Discoverer Worksheet Export.
- New features added in 10g:
- New output format SPREADSHEET, output to Microsoft Excel.
- Extended HTML formatting customisation
- Compliant to HTML 4.01 and XML 1.1 standards
Oracle Reports 1
Oracle Reports 2.5
Oracle Reports 6i
Oracle Reports 9i
Oracle Reports 10g
- Oracle Discoverer :
Oracle Discoverer is a tool-set for ad-hoc querying, reporting, data analysis, and Web-publishing for the Oracle Database environment. Oracle Corporation markets it as a business intelligence product. It was originally a stand-alone product, however it has become a component of the Oracle Fusion Middleware suite, and renamed Oracle Business Intelligence Discoverer.
The Discoverer product comprises:
- Discoverer Administrator
- Discoverer Catalog
- Discoverer Desktop
- Discoverer End-User layer
- Discoverer Plus
- Discoverer Portlet Provider
- Discoverer Portlets
- Discoverer Viewer
- Oracle E-Business Suite :
Oracle E-Business Suite
Within the overall rubric of Oracle Applications - Apps, Oracle Corporation's E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle. The software utilizes Oracle's core Oracle relational database management system technology. The E-Business Suite (current version: 12.1) contains several product lines, including :
- Oracle CRM
- Oracle Financials
- Oracle HRMS
- Oracle Mobile Supply Chain Applications
- Oracle Order Management
- Oracle Procurement
- Oracle Project Portfolio Management
- Oracle Quotes
- Oracle Transportation Management
- Oracle Warehouse Management Systems
- Oracle Inventory.
- Oracle Enterprise Asset Management
- Each product comprises several modules, each separately licensed.
Significant technologies incorporated into the applications include the Oracle database technologies, (engines for RDBMS, PL/SQL, Java, .NET, HTML and XML), the "technology stack" (Oracle Forms Server, Oracle Reports Server, Apache Web Server, Oracle Discoverer, Jinitiator and Sun's Java).
Oracle Corporation brands the on-line technical documentation of E-Business Suite as eTRM - "E-Business Suite Technical Reference Manuals".
- Oracle CRM :
Oracle CRM is a customer relationship management application developed by Oracle Corporation. Oracle CRM includes Oracle and Peoplesoft products but leads with Siebel CRM and CRM on Demand.
Oracle CRM is divided into a number of different product lines. Oracle entered the CRM market following its acquisition of Siebel Systems in September 2005 and later acquired UpShot CRM which offered a more robust user interface than the legacy Siebel On Demand product.
Siebel 8.1.1 is the latest release of their on-premise solution. Oracles CRM On Demand Release 20 is the latest release of their SaaS solution
On Premise solutions
Oracle CRM On Premise is a traditional on-premise deployment where the customer is required to buy or lease infrastructure, including hardware, operating systems and databases, and install a packaged system in its data centre. Forrester Research estimates that on-premise solutions still make up about 90 percent of CRM sales.
On-premise solutions are most suitable for organisations that need complete ownership and control over the deployment and maintenance of their CRM application and infrastructure. They are also most suitable for integration with operational and legacy applications. Some CRM providers and specialized third parties offer highly customized vertical industry solutions that extend on-premise deployments with a level of sophistication.
On Demand and SaaS
Oracle CRM On Demand was released in 2006. CRM On Demand is a CRM solution accessible over the internet and paid for by a monthly subscription charge. This method of using software is often called software-as-a-service (SaaS) and is available to authorized users with a web browser. The benefits of a SaaS solution are that there is no hardware requirement and minimal set-up costs. The disadvantage of a SaaS solution is the inability to customize the application to meet unique business needs. Although the depth of functionality available is not yet comparable to on premise solutions, the lower cost and faster implementation times appeal to many customers.
Oracle Social CRM was released in 2008 and combines traditional enterprise CRM capabilities with social networking and Web 2.0 technologies. The applications are designed to reflect the way sales people work by helping them identify qualified leads, develop sales campaigns and collaborate with colleagues to close more deals.
Other Social CRM Applications include Oracle Sales Prospector, Sales Campaigns and Sales Library. These applications are designed to work with any CRM applications, not just those from Oracle. These applications are provided using SaaS and paid for by a monthly subscription.
PeopleSoft Enterprise CRMPeopleSoft Enterprise Customer Relationship Management is a family of applications in Oracle's PeopleSoft Enterprise product suite. PeopleSoft solutions are tailored to fit industry business processes, customer strategies, and success criteria for organisations.
PeopleSoft merged with Oracle in 2005 and integrated product lines under the Oracle PeopleSoft name.
Features of Oracle's Siebel CRM include:
- Social CRM
- Customer data integration
- Quote and order capture
- Partner relationship management
- Business Intelligence (BI) applications
- Price Management
- CRM gadgets
- Self-service and eBilling
- Integration to Siebel CRM
- Oracle Financial Services Software :
Oracle Financial Services Software
Oracle Financial Services Software Limited (formerly called i-flex Solutions Limited BSE: 532466) is a subsidiary of Oracle Corporation. It is an IT solution provider to the banking industry. It claims to have more than 900 customers in over 145 countries. Oracle Financial Services Software Limited is ranked No. 9 in IT companies of India and overall ranked No. 253 in Fortune India 500 list in 2011.
Part of Citicorp
Oracle Financial Software Limited was a part of Citicorp's (now Citigroup) wholly owned subsidiary called Citicorp Overseas Software Ltd (COSL). In 1991, Mr. Ravi Apte carved out a separate company called Citicorp Information Technologies Industries Ltd. (CITIL) out of COSL and named Mr. Rajesh Hukku to head CITIL. While COSL's mandate was to serve Citicorpâ€™s internal needs globally and be a cost center, CITIL's mandate was to be profitable by serving not only Citicorp but the whole global financial software market. COSL was the brain child of Mr. Ravi Apte, who convinced Citicorp, while working for Citibank, to start COSL as the offshore captive.
Many of the executive management of Oracle Financial Services, including Rajesh Hukku, R.Ravisankar and NRK Raman were at COSL and moved to CITIL when it was formed.
CITIL started off with the universal banking product MicroBanker (which became successful in some English speaking parts of Africa and other developing regions over the next 3 - 4 years) and the retail banking product Finware. In the mid-90s, CITIL developed FLEXCUBE at its Bangalore development center after a significant development effort spanning more than 18 months. After the launch of FLEXCUBE, all of CITIL's transactional banking products were brought under a common brand umbrella.
CITIL changed its name to i-flex solutions to reflect its growing independence from Citicorp and to strengthen its FLEXCUBE brand. The name CITIL also made the prospective client banks hesitant about trusting the company with their data, since the name alluded to a close link with Citibank which could be one of their competitors.
The first version of MicroBanker was created at COSL by Ravi Sankaran who migrated to Australia before CITIL was formed. COSL started selling MicroBanker to non-Citi banks in Africa. Ravi Apte the founder CEO of COSL decided to carve out CITIL to focus on non-Citi business. Because non-Citi was the primary target for MicroBanker, MicroBanker was moved to CITIL. Rajesh Hukku was in the United States managing COSL's business development in North America during the time CITIL was formed. It was Mr. Apte who decided to get Hukku back to India to head the newly formed CITIL. This is previously
Enter Oracle Corporation
In 2006, i-flex became a majority-owned subsidiary of Oracle Corporation. Oracle built its stake through a series of purchases, first buying Citigroup's 41% stake in i-flex solutions for US$593 million in August 2005, a further 7.52% in March and April 2006, and 3.2 per cent in an open-market purchase in mid-April 2006.
On 14 August 2006, i-flex solutions announced it would acquire Mantas, a US-based anti-money laundering and compliance software company for US$122.6 million. The company part-funded the transaction through a preferential share allotment to majority shareholder Oracle Corporation.
Following its acquisition by Oracle, i-flex has begun an expansion plan reportedly to capitalize on its owner's brand and financial strength. It has invested to expand capacity at its existing locations in India which is reportedly sufficient to accommodate 17,000 employees compared with over 10000 staff already employed by the company in August 2007.
On 12 January 2007, after an open offer price to minority shareholders, Oracle increased its stake in i-flex to around 83%.
On 4 April 2008, the board of directors of i-flex solutions approved a proposal to change the name of the company to Oracle Financial Services Limited, subject to regulatory and shareholder approvals. A press release issued by the company said that "The proposed new name reflects the company's close strategic and operational alignment with its parent, Oracle Corporation, which owns 81 percent of the company." It added that the current management team under N.R.K. Raman, CEO and Managing Director, will continue to run the operations of the company.
On 24 October 2010, Oracle announced the appointment of Chaitanya M Kamat (Chet Kamat) as Managing Director and Chief Executive Officer of Oracle Financial Services Software Limited. Mr. Kamat has also joined the Board of Directors. The outgoing CEO and MD, N.R.K.Raman retired from these posts after 25 distinguished years of service.
Now Oracle Financial Services Software Limited is a major part of Oracle Financial Services Global Business Unit (FSGBU) under Mr.Frank Brienzi who is the Vice President & Group Head of Oracle FSGBU World Wide
Products and services
Oracle Financial Services Software Limited has two main streams of business. The products division (formerly called BPD - Banking products Division) and PrimeSourcing. The company's offerings cover retail, corporate and investment banking, funds, cash management, trade, treasury, payments, lending, private wealth management, asset management and business analytics. The company undertook a rebranding exercise in the latter half of 2008. As part of this, the corporate website was integrated with Oracle's website and various divisions, services and products renamed to reflect the new identity post alignment with Oracle.
Recently,Oracle Financial Services launched products for Internal Capital Adequacy Assessment Process, exposure management, enterprise performance management and energy and commodity trading compliance.
- Oracle FLEXCUBE Universal Banking Suites
- Oracle Banking Product
- Oracle FLEXCUBE Core Banking
- Oracle FLEXCUBE Universal Banking
- Oracle FLEXCUBE Investor Servicing
- Oracle FLEXCUBE Private Banking
- Oracle FLEXCUBE Lending and Leasing
- Oracle FLEXCUBE Islamic Banking
- Oracle FLEXCUBE Direct Banking- Internet, Mobile, SMS and WAP
- Oracle FLEXCUBE Messaging Hub
- Oracle FLEXCUBE Remit
- Oracle FLEXCUBE Enterprise Limits and Collateral Management
- Oracle Financial Services Analytical CRM Advanced
- Oracle Financial Services Channel Analytics
- Oracle Financial Services CRM Analytics
- Oracle Reveleus Internal Capital Adequacy Assessment Process
- Oracle Financial Services Basel II
- Oracle Financial Services Operational Risk
- Oracle Financial Services Market Risk
- Oracle Financial Services Credit Risk
- Oracle Financial Services Liquidity Risk
- Oracle Financial Services Corporate Credit Risk
- Oracle Financial Services Model Risk Management
- Oracle Financial Services Fraud
- Oracle Financial Services Energy and Commodity Trading Compliance
- Oracle Financial Services Anti Money Laundering
- Oracle Financial Services Broker Compliance
- Oracle Financial Services Trading Compliance
- Oracle Financial Services Know Your Customer
- Oracle Financial Services Regulatory Reporting System
- Oracle Financial Services Analytical Applications for Enterprise Performance Management Oracle Financial Services Data Warehouse
- Oracle Financial Services
- Oracle Financial Services Support
- Oracle Financial Services BPO
- Oracle (OFSS) ASP Private Limited
- Oracle Financial Services University
- Oracle Financial Services AIM
- Oracle Partner Network
Oracle Financial Services Analytical Applications for Customer Insight
Oracle Financial Services Advanced Analytical Applications Infrastructure Oracle Financial Services Analytical Applications for Enterprise Risk Management
Oracle Financial Services Analytical Applications for Financial Crime and Compliance Management
- Oracle General Ledger :
Oracle General Ledger
The Oracle General Ledger module within Oracle Financials is an integrated part of the ERP package of Oracle applications. It is a financial management solution within E-business suite for entering and reporting on the financial data of large companies. Oracle claims its GL module can import and post 42 million journal lines per hour, which would make it a suitable GL application for very large enterprises with high GL transaction volume.
Before setting up oracle GL, The following need to be set up:
(M) = Mandatory step, others are optional
- Chart of Accounts (M)
- Account Combinations
- Period Types (M)
- Calendar (M)
- Transaction Calendar
- Currencies (M)
- Set of Books or SOB (M)
- Assign SOB to a responsibility (M)
- Daily conversion Rate types (M)
- Journal Sources (M)
- Journal categories (M)
- Suspense Accounts
- Inter-company and Summary Accounts
- Statistical UOM (Unit of Measure)
- Historical Rates and Document Sequences
- Automatic Posting and Incumberance types
- System Controls (M)
- Budgetory Control Groups
- Profile options (M)
- Open / Close GL accounting periods.
Once the above steps are done, to implement Oracle GL the following need to be set up
Other features of Oracle GL include
A single legal entity is possible to assign with multiple ledgers to meet statutory, corporate and regulatory reporting.
Chart of Accounts is created segment-wise for reporting hierarchies. Up to 30 segments can be created in a chart of accounts with 25 characters per segment.
Financial Statement Generator (FSG) which comes with Oracle GL generates financial reports, such as the income statements and balance sheets from the GL data applying the access security rules. Ad-hoc reports can be prepared with the FSG.
Technically, oracle General Ledger - Release 11i contains approximately 130 tables, excluding the temporary processing tables, 70 forms and 140 concurrent programs or reports. The tables and forms which are part of and accessible to GL, but are not owned by the GL user are not included in the above counts. e.g. FND objects owned by APPLSYS are not included.
- SAP AG
- SAP HANA
- SAP Business Suite
- SAP ERP
- SAP SCM
- SAP CRM
- SAP SRM
- SAP PLM
- SAP Business One
- SAP Netweaver
- Oracle Fusion Application
- Oracle Fusion Middleware
- Oracle SOA Suite
- Oracle Weblogic Server
- Oracle Developer Suite
- Oracle BI Publisher
- Oracle CRM
- Oracle E-Business Suite
- Oracle Discoverer
- Oracle Application Server
- Microsoft Dynamics ERP
- Microsoft Dynamics AX
- Microsoft Dynamics GP
- Microsoft Dynamics NAV
- Microsoft Dynamics SL
- Microsoft Dynamics C5
- Siebel CRM
- JD Edwards
- Sugar CRM
- Vtiger CRM
- Apache OFBiz
- Open Bravo
- Civic CRM
A solid working knowledge of productivity software and other IT tools has become a basic foundation for success in virtually any career. Beyond that, however, I don't think you can overemphasise the importance of having a good background in maths and science.....
"Every software system needs to have a simple yet powerful organizational philosophy (think of it as the software equivalent of a sound bite that describes the system's architecture)... A step in thr development process is to articulate this architectural framework, so that we might have a stable foundation upon which to evolve the system's function points. "
"All architecture is design but not all design is architecture. Architecture represents the significant design decisions that shape a system, where significant is measured by cost of change"
"The ultimate measurement is effectiveness, not efficiency "
"It is argued that software architecture is an effective tool to cut development cost and time and to increase the quality of a system. "Architecture-centric methods and agile approaches." Agile Processes in Software Engineering and Extreme Programming.
"Java is C++ without the guns, knives, and clubs "
"When done well, software is invisible"
"Our words are built on the objects of our experience. They have acquired their effectiveness by adapting themselves to the occurrences of our everyday world."
"I always knew that one day Smalltalk would replace Java. I just didn't know it would be called Ruby. "
"The best way to predict the future is to invent it."
"In 30 years Lisp will likely be ahead of C++/Java (but behind something else)"
"Possibly the only real object-oriented system in working order. (About Internet)"
"Simple things should be simple, complex things should be possible. "
"Software engineering is the establishment and use of sound engineering principles in order to obtain economically software that is reliable and works efficiently on real machines."
"Model Driven Architecture is a style of enterprise application development and integration, based on using automated tools to build system independent models and transform them into efficient implementations. "
"The Internet was done so well that most people think of it as a natural resource like the Pacific Ocean, rather than something that was man-made. When was the last time a technology with a scale like that was so error-free? The Web, in comparison, is a joke. The Web was done by amateurs. "
"Software Engineering Economics is an invaluable guide to determining software costs, applying the fundamental concepts of microeconomics to software engineering, and utilizing economic analysis in software engineering decision making. "
"Ultimately, discovery and invention are both problems of classification, and classification is fundamentally a problem of finding sameness. When we classify, we seek to group things that have a common structure or exhibit a common behavior. "
"Perhaps the greatest strength of an object-oriented approach to development is that it offers a mechanism that captures a model of the real world. "
"The entire history of software engineering is that of the rise in levels of abstraction. "
"The amateur software engineer is always in search of magic, some sensational method or tool whose application promises to render software development trivial. It is the mark of the professional software engineer to know that no such panacea exist "
Core Values ?Agile And Scrum Based Architecture
Agile software development is a group of software development methods based on iterative and incremental development, where requirements and solutions evolve through collaboration.....more
Core Values ?Total quality management
Total Quality Management / TQM is an integrative philosophy of management for continuously improving the quality of products and processes. TQM is based on the premise that the quality of products and .....more
Core Values ?Design that Matters
We are more than code junkies. We're a company that cares how a product works and what it says to its users. There is no reason why your custom software should be difficult to understand.....more
Core Values ?Expertise that is Second to None
With extensive software development experience, our development team is up for any challenge within the Great Plains development environment. our Research works on IEEE international papers are consider....more
Core Values ?Solutions that Deliver Results
We have a proven track record of developing and delivering solutions that have resulted in reduced costs, time savings, and increased efficiency. Our clients are very much ....more
Core Values ?Relentless Software Testing
We simply dont release anything that isnt tested well. Tell us something cant be tested under automation, and we will go prove it can be. We create tests before we write the complementary production software......more
Core Values ?Unparalled Technical Support
If a customer needs technical support for one of our products, no-one can do it better than us. Our offices are open from 9am until 9pm Monday to Friday, and soon to be 24hours. Unlike many companies, you are able to....more
Core Values ?Impressive Results
We have a reputation for process genius, fanatical testing, high quality, and software joy. Whatever your business, our methods will work well in your field. We have done work in Erp Solutions ,e-commerce, Portal Solutions,IEEE Research....more
Why Choose Us ?
The intellectual commitment of our development team is central to the leonsoft ability to achieve its mission: to develop principled, innovative thought leaders in global communities.Read More
Today's most successful enterprise applications were once nothing more than an idea in someone's head. While many of these applications are planned and budgeted from the beginning.Read More
We constantly strive to redefine the standard of excellence in everything we do. We encourage both individuals and teams to constantly strive for developing innovative technologies....Read More
If our customers are the foundation of our business, then integrity is the cornerstone. Everything we do is guided by what is right. We live by the highest ethical standards.....Read More