Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« How 'impactful' are your Talents for future.... | Main | INTEGRATION ON CLOUD - A STUDY IN KRONOS (Part-3) »

Building customizations (RICEFW) on Oracle SaaS


In the current IT landscape, there is a huge spike in companies adopting software-as-a-solution (SaaS) cloud applications to realize benefits like business agility, quick time to market, and cost optimization. One of the fundamental challenges that organizations face in adopting SaaS applications is exact fitment to their business needs. In most scenarios, organizations need to customize or extend the SaaS applications to meet their specific requirements. So, how do these customizations differ from the traditional on-premises application customization?


During on-premises Oracle applications implementation, these customizations are done through additional configurations and custom extensions built on top of the core functionality. RICEFW (Reports, Interfaces, Conversions, Enhancements, Forms and Workflows) objects represent requirements that are not currently supported within the core functionality of an Oracle Application module, and thus require additional technical development to satisfy the functional requirement of an organization. While this was achieved in on-premises world using Oracle developer tools like reports, procedural language / structured query language (PL/SQL), forms, Oracle Application Framework (OAF), and workflows, the same tool sets are not applicable for building RICEFW for Oracle SaaS applications like CX (Customer Experience) , Enterprise Resource Planning (ERP), Supply Chain Management (SCM), and Human Capital Management (HCM) on cloud. There is neither direct access to database schema nor option to alter the schema in Oracle SaaS.


Technologies used to build RICEFW on Oracle cloud




Following are the tools used to create analytical and transactional reports that are not available as standard reports in Oracle SaaS:


Available within Oracle SaaS


Oracle Transactional Business Intelligence (OTBI): The tool is built on the power of Oracle's industry-leading business intelligence tool - Oracle Business Intelligence Enterprise Edition (OBIEE). This allows users to build powerful data visualization with real-time data that highlights data patterns and encourages data exploration instead of delivering static flat reports.


Smart view: With the smart view desktop tool, users can create or run OTBI analyses within MS Excel, Word, or PowerPoint and save them back into the OTBI catalog in real time.


BI publisher: It is a reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools. It is pre-integrated with Oracle and works seamlessly with OBIEE, e-Business Suite, PeopleSoft Enterprise, JD Edwards Enterprise One, Oracle Hyperion Planning, and Oracle Application Express (APEX).


Available with Oracle PaaS


Business intelligence cloud service (BICS): BICS can combine data from diverse sources and quickly create rich, interactive, analytic applications and reports. Data is stored in the Oracle Database Cloud Service, which is hosted on Oracle Public Cloud.



Following are the tools to build interfaces for external systems in online and batch mode:

Available within Oracle SaaS


File-based data import (FBDi): This tool enables you to import data from text or XML files. Application components involved are import object, import mapping, import activity, file repository, application composer, interface tables, and SaaS application.


Application development framework desktop integration (ADFDi): The tool is one of the features of Oracle ADF that enables desktop integration with MS Excel spreadsheets to manage large volumes of data from web applications via Excel.


Available with Oracle PaaS


Integration cloud service (ICS): This tool is iPaaS (Integration PaaS) that includes an intuitive web-based integration designer for point and click integration between applications on cloud or on-premise.


Service-oriented architecture cloud service (SOA CS): SOA cloud service is iPaaS that can be used to build integrations, which require orchestration between on cloud or on-premise. Domain supported in SOA CS are SOA, Oracle Service bus (OSB), application programming interface (API) manager, SOA & B2B, and managed file transfer.



Following tool is used for carrying out data conversions:


Available within Oracle SaaS


File-based data import (FBDi): It enables you to import data from text or XML files. Out-of-the-box FBDi (spreadsheet) templates are available for account payable / account receivable (AR / AP) invoices, purchase orders, customers, suppliers, commission on audit (COA) values, etc.



Following are the tools to build UI enhancements or extensions for Oracle SaaS:


Available with Oracle PaaS


Java cloud service saaS extension (JCS SX): Tailor-made WebLogic server for rapid extension deployment. Automated trust between PaaS and SaaS for user federation and user synchronization. Single sign-on solution (SSO) across SaaS and extensions on JCS SaaS extension


Application builder cloud service (ABCS): This tool is a cloud offering, which enables business users to rapidly create and host web applications without writing code and without having programming experience. While out-of-the-box integration with Oracle SaaS is a key value proposition, ABCS can be used independently from Oracle SaaS to create standalone applications.



Following tools are used to enable customizations on existing screens:


Available within SaaS


Page composer:  The tool is available to administrators to customize the page based on the select layer. Key activities which can be done are: show / hide a field, change the display name for a field on a page, make a field read-only, reorder tabs on a page, show / hide tabs on a page, and reset all the customizations.


Application composer:  This tool helps to customize and extend the whole application. Customize objects by adding new fields or creating a new object, create a foreign key relationship between objects, modify existing pages using the object created or modified or create new pages , generate custom business logic using triggers, workflows, and validation rules, and secure the created custom objects.



Following tool is used to enable workflows:


Available within SaaS


Business process management (BPM) workflows: This tool can configure seeded workflow tasks, but cannot create a new workflow task.


Nice insight on the tools and technology used with oracle cloud

Good insights on Saas/PaaS tools

What about PLSQL package, how this can be done in cloud

Very helpful !

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles