Monday, October 28, 2013

Oracle forms converter to Apex

Oracle Application Express Oracle Forms Conversion Project 

Oracle Application Express, release 3.2 and above, enables you to load your Oracle Forms source into an Oracle Application Express project and generate an initial APEX application. The conversion automatically converts most user interface components but does not convert business logic implemented within triggers, program units, or PL/SQL libraries. Loading Oracle Forms definitions into the Oracle Application Express project provides analysis and tracking of the conversion project. Once the initial design has been generated, the rapid application development capabilities inherent within Oracle Application Express can be utilized to enhance and expand the generated application. Post-generation the business logic within Oracle Forms can be re-implemented and new screens which take advantage of Web 2.0 capabilities such as interactive reports and flash charts can be added using the wizards built into the Oracle Application Express builder. 

Oracle Application Express for Oracle Forms Developers

Feature
Oracle Forms
Application Express
Description
4GL Declarative
Yes
Yes
Oracle Forms renders applications using metadata stored in an .fmx file. Application Express renders applications using metadata stored in an Oracle database.
4GL Languages
SQL and PL/SQL
SQL and PL/SQL
Oracle Forms runs client-side PL/SQL. Application Express uses server-side PL/SQL.
User Interface
Java
HTML
Oracle Forms is accessed using a web browser and its user interface is rendered using a JVM. Application Express is also invoked from a Web browser but its user interface is HTML and JavaScript.
Page Layout
Windows / Canvases
Page / Regions
Oracle Forms uses exact positioning and Application Express uses HTML-relative positioning.
Client-side Field Control
Form triggers
Javascript and AJAX
Oracle Forms provides robust field-level validation and event processing. Application Express supports declarative page-level validation and event processing. Programmatic field-level validation and event processing requires Javascript and AJAX.
Web Service Support
Yes
Yes
Both Oracle Forms and Application Express support the calling of Web Services, for example BPEL.
Charting
BI Beans
Flash Charts
Oracle Forms uses BI Beans as its integrated charting engine. Application Express uses Flash Charts as its integrated charting engine.
Locking
Pessimistic, Optimistic, Custom
Optimistic, Custom
Oracle Forms supports a range of locking models with pessimistic as the default. Due to its asynchronous architecture, Application Express uses an optimistic locking model.
Database Connections
Synchronous
Asynchronous
Oracle Forms uses synchronous connections to allow transactions to span multiple screen interactions. Application Express does not transparently allow transactions to span page views. Application Express programmatically supports transactions spanning page views using collections.
Concurrent User Support
Database connectivity maintained by user session
Database connectivity only maintained for the processing of requests
Each connected user in Oracle Forms maintains a synchronous connection to the Oracle database. Application Express users are asynchronously connected to the Oracle database.
Architecture
3 Tier
2 Tier
With Oracle Forms, Application logic is processed in the Oracle database, a mid-tier Forms Server, or in the rich client. With Application Express, PL/SQL application logic is processed within the Oracle database. Client-side logic is implemented using JavaScript. HTTP communications are facilitated using Apache and Mod/PLSQL.


Oracle Application Express Application Migration Workshop (Application Migrations) enables you to
 migrate a Microsoft Access application or convert an Oracle Forms application to an 
Oracle Application Express application.

Integrating Oracle Application Express with Oracle Access Manager 11g

Prerequisites 
The prerequisites for the solution given in this paper are:
• Oracle Database 10.2.0.3 or above
• Oracle Application Express 4.1.1 or above.
• Oracle Access Manager 11g

Oracle Forms Services applications can be executed in a Single Sign-on environment using Oracle Access Manager 11g (OAM) and Oracle Internet Directory (OID) to eliminate the need for additional or different logins to access many applications during the same user session.
Oracle Forms Services applications in Oracle FMW 11g Release 2 can be protected by one of the following authentication servers:
  • Oracle Access Manager (OAM) 11g
  • Oracle Single Sign-On Server (OSSO) 10g
Feature
  • Benefit
Comprehensive Web Access Management, Web Single Sign-On, Identity Propagation, and Federation
  • Provides centralized, policy-based authentication and single sign-on for Web applications, Web services, and data and cloud services
  • Delivers seamless single sign-on to enterprise resources from any device including desktops, laptops, and mobile devices
  • Enables on-boarding of partners and service providers faster using industry security standards
  • Provides standards-based secure propagation of identity across applications and Web services
Mobile and Social Sign-On
  • Delivers seamless single sign-on across native and Web applications on mobile devices
  • Enables low-value enterprise and consumer-facing applications to consume identities from social networks and other third-party identity providers using popular user-centric identity standards
Real-time External Authorization
  • Provides real-time external authorization for applications, middleware, and databases with enterprise-class scalability and granular security
  • Provides interoperability with a wide spectrum of modern industry authorization standards (XACML, RBAC, ABAC) for enhanced security, greater choice and flexibility
  • Delivers out-of-the-box integration with a variety of native, custom, and third-party applications, application servers, data persistence frameworks, directory servers, portals and content management systems, and XML gateways
Adaptive Access and Fraud Detection
  • Provides a unique combination of knowledge-based authentication with registration, answer, and fuzzy logic for the Oracle Identity and Access Management Suite
  • Enables you to add sophisticated security to basic authentication flows in a few easy steps
  • Delivers real-time fraud detection and proactively prevents fraud

Thursday, October 24, 2013

Oracle BI Publisher 11g for E-Bisiness Suite r12 in kuwait



The Reporting Platform for Oracle Applications: BI Publisher

Who is here today?
How Many……
• Siebel
• JD Edwards (World or EnterpriseOne)
• Peoplesoft
• E-Business Suite

Oracle E-Business Suite r12
• In 11i BI publisher
-- 500 templates In R12.1 
--ALL reports are BI Publisher: 2724 templates and 
--2092 data sources or data templates across 95 products

Oracle Reports to Publisher Conversion Assistant || BI Publisher in Many Oracle Products

Oracle Fusion Middleware MapViewer
Oracle Enterprise Taxation Management 
Oracle Identity Management
Oracle Life Sciences AERS
Oracle Life Sciences Data Hub
Oracle FLEXCUBE Universal Banking
i-Flex FLEXCUBE Retail
Oracle FLEXCUBE Direct Banking
Oracle Reveleus
Oracle Mantas
Agile Product Lifecycle Management for Process
Agile Product Lifecycle Management
Oracle Hyperion Planning
Oracle Hyperion Financial Management
Oracle Business Process Management
Oracle Business Event Analysis and Monitoring
LGBU
Oracle Primavera P6 Enterprise Project Portfolio 
Management
Oracle Pedigree and Serialization Manager
Network Management System Utilities
Oracle Application Testing Suite 
Oracle SOA Governance 
Oracle Retail
Oracle Governance, Risk & Compliance
iFlex FLEXCUBE – IFLEX Reinsurance
Oracle FLEXCUBE Lending and Leasing
Oracle Communications Applications
Oracle Transportation Management 
Oracle Insurance Insbridge Rating and Underwriting
Oracle Application Express (APEX)
Enterprise Manager - Configuration Change Console
Oracle Business Transaction Monitoring
Siebel Branch Teller
Oracle Policy Automation

Richer Functionality
– End users can create their own layouts 
– End user chooses output format (PDF, RTF, Excel, HTML, MHTML)
– Report against multiple data sources






Tuesday, October 8, 2013

Dynamic website and Apex application

Fantastic website running in Apex,please visit the link & application .

http://apex.oracle.com/pls/otn/f?p=13116:4

Oracle Application Express 4.2 New Features

New Features

  • Application Builder for Mobile

    Release 4.2 provides declarative support for building mobile Web applications. Mobile pages use jQuery Mobile to render content on the vast majority of mobile devices. Each application can include both desktop and mobile user interfaces.
  • Mobile and Responsive Themes

    To support the development of mobile pages, a new theme has been introduced which is based on jQuery Mobile. This theme supports mobile page transitions and gestures such as swipe, tap, and pinch. You can also declaratively specify JavaScript and CSS files for use within the mobile templates and pages.
    Another new theme introduced, Theme 25, incorporates reponsive design principles. Reponsive design automatically adjusts to the screen dimensions. Such themes work well on desktop, tablet and mobile devices.
  • HTML5 Charts

    Release 4.2 now includes HTML5 charts. Charts can now be rendered as either HTML5 or Flash, where Flash charts have automatic fallback to HTML5 when Flash is not detected.
  • HTML5 Item Types

    New item types have been introduced including Slider, HTML5 Date Picker, and Yes/No Flip Toggle Switch. Incorporating such HTML5 attributes as sub-types for Email, Phone, and URL together with Placeholders will allow you to improve your end user experience.
  • Mobile Calendars

    A new "mobile-friendly" calendar template has been introduced along with a new List View calendar option.
  • Packaged Applications

    Release 4.2 includes a suite of business productivity applications, easily installed with only a few clicks. These solutions can be readily used as production applications to improve business processes and are fully supported by Oracle. Packaged Applications also include a collection of sample applications which demonstrate some of the major features of Oracle Application Express.
  • RESTful Web Services*

    RESTful Services in Release 4.2 provides stateless access to data and logic, through the use of SQL and PL/SQL. RESTful Services are accessed through the use of Uniform Resource Identifiers (URIs), defined within Oracle Application Express. Data can be easily served in JSON or CSV format, or additional formats by choosing PL/SQL as the source.
    * This feature requires APEX Listener 2.0 or later.

Oracle Application Express 4.2 bundle pack at kuwait

we offered all kind of small business application with affordable price and free* technical support.

please visit the demosntation application and call us anytime.


http://apex.oracle.com/pls/apex/f?p=20256