Wednesday Jul 10, 2013

How to Define Table-Validated Lists of Values in Web ADI

I am pleased to announce a new video tutorial on defining table-validated Lists of Values using the Oracle Web Application Desktop Integrator (Web ADI).  One of the common requirements for List of Values in a Web Application Desktop Integrator spreadsheet is to display user-friendly values in a desktop-based spreadsheet but upload a corresponding identifier or code to the E-Business Suite. You can learn how to do this in this new tutorial.

Using the List of Values component with Web ADI

Oracle Web Application Desktop Integrator supports Oracle E-Business Suite’s user interface components such as List of Values (LOV) in spreadsheets. In a Web Application Desktop Integrator spreadsheet, a List of Values can be displayed as a pop-list or as a standard Search and Select view. A table-validated List of Values is a type of List of Values that not only displays set of values from a table, but also ensures that the value uploaded to Web Application Desktop Integrator Interface is valid. 

The Desktop Integration Framework allows you to create custom desktop integrators for Web Application Desktop Integrator in E-Business Suite Release 12. You can define table-validated List of Values components for data uploaded from spreadsheets to the Oracle E-Business Suite.

What is in this tutorial?

This step-by-step video tutorial walks you through the following:

  1. Prepare Database Objects
  2. Create Custom Integrator
  3. Define Table List of Values Component
  4. Associate Table List of Values Component to Interface Attribute
  5. Define Layout for Integrator
  6. Preview Integrator
  7. Verify uploaded data

Your feedback is welcome

This is our first video tutorial and we're very interested in feedback.  Please post a comment here or drop us an email directly with your thoughts.


Related Articles

Wednesday Feb 06, 2013

Using Oracle Label Security with Oracle E-Business Suite

Most security administrators know how to use E-Business Suite responsibilities to manage access to data and functionality.  The majority of EBS customers will never need anything beyond those standard capabilities. Some organisations may need specialised security to complement the EBS responsibility model. Oracle Label Security may appropriate for certain specialised requirements.

Oracle Label Security example diagram

Oracle Label Security allows administrators to classify every row in a table, ensuring that access to sensitive data is restricted to users with the appropriate clearance level. OLS can be used to enforce regulatory compliance with a policy-based administration model to support custom data classification schemes for implementing “need to know” access. Labels can be used as factors within Oracle Database Vault command rules for multi-factor authorization polices.

Supported but not certified

It is possible to use Oracle Label Security with the E-Business Suite.  Custom OLS policies will -- by design -- change the end-user behavior of EBS.  It is possible for an OLS policy to break EBS, so we can't offer the standard technology certification in this case.   What is certified is "the approach" of using OLS to implement custom security policies over EBS relational data.  We do not certify specific versions of OLS, nor do we certify specific OLS policies.

From a support perspective, we treat OLS policies like any other EBS customization, namely:

  • We can only issue EBS patches for issues that can be reproduced in environments without custom OLS policies.
  • If you report an issue that can't be reproduced in vanilla, uncustomized environments, our default guidance will be to disable the custom OLS policies.
  • We cannot review your OLS policies or make recommendations on how to create custom OLS policies.

How do I define OLS policies in EBS environments?

This rather-elderly Note explains techniques for adding OLS policy initialization logic to EBS session initialization.  Although this Note is written specifically for Oracle9i Label Security and EBS 11i, the techniques documented here remain valid today to later database and EBS releases:

Related Articles

Tuesday Oct 02, 2012

New Whitepaper: Primer on Integrating with EBS 12 with Other Applications

Oracle E-Business Suite offers several integration points and a variety of integration technologies. While a given integration point may be available through various technologies and products, it is important to select the best approach for your specific integration requirements. I am pleased to announce the publication of a new white paper that can help with this:

Overview of EBS integration technologies

This whitepaper reviews integration strategies for Oracle E-Business Suite applications that are available today. The intended audience is solution architects, integration consultants, and anyone else interested in learning about integration options with Oracle E-Business Suite.

The white paper outlines the following enterprise application integration styles:

  • Data-centric integration
  • Integration through native interfaces
  • Process-centric integration
  • Event-driven integration
  • B2B integration
  • Integration through web services 

The white paper also discusses Oracle E-Business Suite application layer products and technologies that address the specific needs of each of these integration styles. It concludes with criteria for selecting the appropriate integration-related tools and technologies for your requirements.

Attending OpenWorld 2012?

We have two sessions covering Oracle E-Business Suite integration. Please join us to hear more on this subject:

  • CON9005 - Oracle E-Business Suite Integration Best Practices ( Tuesday, Oct 2, 1:15 PM - 2:15 PM - Moscone West 2018)
  • CON8716 - Web Services and SOA Integration Options for Oracle E-Business Suite ( Thursday, Oct 4, 11:15 AM - 12:15 PM - Moscone West 2016)

 Related Articles

Monday Aug 06, 2012

Oracle E-Business Suite Personalizations Course Now Available

Oracle University logoI am pleased to announce a new training course titled "Oracle E-Business Suite Personalizations".

This Oracle University course is now offered as a 5-day class in either the Classroom Training (ILT) or Live Virtual Class (LVC) format. The course can be found under the E-Business Suite Tools and Technology Training category.

The course is a hands-on lab-intensive offering, and is intended for Application Developers, Functional Implementers, Support Engineers, and Technical Administrators. The course's objective is to give you insights into the rich and upgradable personalizations that Oracle E-Business Suite offers. You will also learn how to setup flexfields to capture information relevant to a business and personalize the user interface (UI) to suite a business need or a user preference for both OA Framework-based and Oracle Forms-based products.

You'll get the following hands-on experience in this course:

  • Work with Key and Descriptive Flexfields
  • Use Value Sets and Validation Options
  • Perform OA Framework Personalizations
  • Perform Form Personalizations
  • Work with Custom Programs and Help Systems
  • Work with Data Loader Applications

For more information regarding the course, please see the full course description, schedule, and other relevant information at the Oracle University website.

Finding other ATG courses and training materials

The catalog of all ATG training materials is available in this blog's Webcasts and Training section. If you have any questions or comments, feel free to email Bill Sawyer (Senior Manager, Applications Technology Curriculum) at BilldotSawyer-AT-Oracle-DOT-com



« April 2014