EBS 122 Cum RCD ATG
EBS 122 Cum RCD ATG
EBS 122 Cum RCD ATG
Applications Technology
Releases 12.1 and 12.2 (inclusive of 12.0.2 – 12.2.13)
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document ii
Simplified Configuration for Managed Server Information 11
EBS Installation Central Inventory 11
Simplified Mechanism for Changing Oracle WebLogic Server Administration User Password 11
Middle Tier Oracle E-Business Suite Technology Codelevel Checker 11
External Integration with Oracle Unified Directory 12
3.3.10. Release 12.2.7 12
Job Role Separation 12
Java Web Start 12
Support for Logical Host Names 12
Support for Oracle Grid Listener 12
Support for Oracle GoldenGate Replication 12
3.3.11. Release 12.2.7+ 12
s_srvctl_thread_count Context Variable 12
3.3.12. Release 12.2.9 13
Java Web Start on macOS with Firefox 13
Multiple Forms Sessions with Java Web Start 13
3.4. Internationalization 13
3.4.1. Release 12.1.1 13
Hijrah and Thai Buddhist Calendar Support 13
Multilingual Support/National Language Support (MLS/NLS) Enhancements in Concurrent Processing 13
3.4.2. Release 12.1.2 13
Lithuanian, Indonesian, and Ukrainian language support 14
Space and single quote number group separator support 14
First day of the week support 14
Gantt chart and inline (embedded) date pickers support Thai and Hijrah calendars 14
3.4.3. Release 12.1.3 14
Oracle iSetup MLS 14
Lightweight MLS 14
Improved MLS Export Functionality in Oracle Application Framework 15
Oracle Application Framework Rich UI Bi-Directional Support 15
Serbian Language Support 15
3.4.4. Release 12.2 15
Lightweight MLS Enhanced Support 15
Linguistic Sorting Support 15
Character Date International Calendar Support Enhancements 16
Expanded Number Spelling Support 16
Support for All Territories in Oracle Database 16
Serbian Language Support 16
Forms UI Export Functionality Enhancements 16
Oracle Workflow E-mail Character Encoding Configuration 16
Oracle Diagnostics Internationalization Enhancements 16
Oracle Diagnostics Internationalization Tests 16
Internationalization Library Version Display Support 16
3.4.5. Release 12.2.5 17
Lightweight-Only Language Support 17
Concurrent Programs Support for Linguistic Sorting 17
Oracle iSetup Internationalization Enhancements 17
Oracle Report Manager Internationalization Enhancements 18
3.4.6. Release 12.2.6 18
Improved Language Determination 18
Translation Synchronization Patches Manifest File for Full Mode Languages Only 19
Oracle Applications Manager Licensing for Lightweight MLS 19
Oracle iSetup Streamlined Migration of Language Data 19
Oracle Web Applications Desktop Integrator Internationalization Enhancements 19
3.4.7. Release 12.2.7 19
Calendar Configuration File Editor 19
Oracle Web Applications Desktop Integrator Internationalization Enhancements 20
Oracle Workflow Internationalization Enhancements 20
3.4.8. Release 12.2.9 20
Certification of Edge and Firefox Browsers for Bidirectional Languages 20
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document iii
Oracle Workflow Internationalization Enhancements 20
3.5. Oracle E-Business Suite on Oracle Cloud Infrastructure 21
3.5.1. What’s New 21
4. Applications Technology 22
4.1. Oracle Application Framework 22
4.1.1. Release 12.0.3 (RUP3) 22
Expose HGrid's Record Set Size for Administrator Personalization 22
4.1.2. Release 12.0.6 (RUP6) 22
Record History 22
Flexfield Reference Fields 22
4.1.3. Release 12.1.1 23
Record History 23
Bulk Uploads for Attachments 23
Home Page Favorites Links Can Open in New Windows 23
Support for Java BigDecimal Data Type 23
Enhanced Search Region Personalization 23
Application Tier Data Sorting 23
Virus Scan Support for Attachments 23
Flexfield Reference Fields 24
Hijrah and Thai Buddhist Calendar Support 24
4.1.4. Release 12.1.2 24
User Interface Enhancements 24
Oracle E-Business Suite Business Intelligence (OBIEE) Integration 25
Portlet Generator 25
REST Interface 25
4.1.5. Release 12.1.3 25
User Interface Improvements 25
Opening Portlet Links in a New Window 26
ADF Integration 26
4.1.6. Release 12.2 26
Usability Improvements 26
AutoVue Integration 27
Personalization Improvements 27
Enhanced Oracle JDeveloper OA Extension 28
iPad Certification 28
Enhanced Key Flexfield End Date Validation 29
Support for Copying Attachments 29
Support for File Upload Anti-Virus Scanning 29
Preferences Page Integration with Delivery Manager 29
Enhanced “About” Page 29
Improved External Applications Integration 29
Portlet Generator Changes 29
Disable Access Keys 29
New Rating Bar 29
Modal Pop-Up 30
Long Text Attachment 30
Improved Record History 30
Message Rich Text Editor AntiSamy Support 30
Improved Sorting Support for Composite Table Columns 30
Obsolescence of Validation Profiles 30
Improved Classic and Advanced Table Accessibility Support 30
4.1.7. Release 12.2.3 30
New Skyros Skin 30
Rich Table Interactions 30
Dynamic Views 31
4.1.8. Release 12.2.4 31
Dialog Pages as Modal Pop-Ups 31
Rich Table Interactions 31
Rich HGrid Interactions 31
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document iv
Time Support in Date Picker 31
New Menu Component 31
New Spin Box Component 31
Gesture Support for Mobile Devices 31
Universal Global Header 32
Simplified Home Page 32
Chrome Browser Certification 32
HTML5 Certification 32
Support for Hiding Columns in an Attachment Table 32
New Advanced Search Criteria 32
4.1.9. Release 12.2.5 32
Look-and-Feel Upgrade to Oracle Alta UI 32
Rich Table Interactions 33
Simplified Page UI 33
Descriptive Flexfield Support as a Pop-Up 33
Inline Attachment Enhancements 33
Pop-Up Enhancements 33
Icon Support for Buttons 34
‘WHERE’ Clause Support for Key Flexfields 34
4.1.10. Release 12.2.6 34
Developer Controls on Types of Attachments 34
Attachments Integration with Oracle AutoVue Release 20.2.3 34
Oracle AutoVue Library Update for New Print APIs 34
Validation Support for URL Attachments 34
Home Page and Global Header Improvements 34
Search Region Usability Improvements 34
Flexfield Special Value Set 35
Splitter Component 35
Layered Layout 35
Table Integration with Oracle Web Applications Desktop Integrator 35
Record History Support of Non-EO-Based View Objects 35
Tri-State Checkbox Support for Multi-Select Tables 35
Header Text Selection Support to Hide/Show Content in iOS 35
Relocation of Date Field Tip Text 35
Support for Hint in Text Field, LOV Input Field, and Spin Box 36
4.1.11. Release 12.2.7 36
Personalization Workbench 36
Repositioning of Navigator Icon in Home Page and Global Header 36
Support for Adding Bookmarkable Pages to Favorites Using Icon 36
Simplified Attachment Pop-up Window 36
Themes 36
Multi-Column Search in Look-Ahead List of Values 37
Column Freezing in HGrids 37
Expression Language (EL) Support for Profiles and Messages 37
4.1.12. Release 12.2.9 37
List Search 37
Masonry Layout 38
Accordion Component 38
Query By Example 38
Simplified Table Toolbar 38
Enhancements for Rich Table Interaction 38
Tip Bean Enhancements 39
Color Picker Enhancement 39
Key Flexfield LOV Pop-up 39
Shorthand Alias Search in Key Flexfield Window 39
Look-ahead Support for Key Flexfield Search 39
Descriptive Flexfields Usability Improvements 39
Home Page Enhancements 39
Default Favorites 39
Global Header Enhancements 40
Date Picker Modal Window Enhancements 40
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document v
List of Values Modal Window Enhancements 40
Enhanced Graphs 40
Internet Explorer 11 Standard Document Mode 40
Personalization Workbench Enhancements 40
Advanced Sort Pop-up 40
4.1.13. Release 12.2.10 41
Check Box Enhancement 41
List Search Enhancements 41
Saved Search Notifications 41
Enhanced My Worklist Pop-Up 41
Enhanced Manage Saved Search Pop-up 41
Exporting Tables to PDF 41
Sequence Numbers for Attachments 41
Searching with Key Flexfield Criteria in List Search 41
Enhanced Advanced Sort Pop-up 42
Query By Example for Tables 42
OA Image Bean Support for Database Storage of Images 42
4.1.14. Release 12.2.11 42
Color Coding for Infotiles 42
Collapse and Expand Infotiles 42
Enhanced Export of Table Data to PDF and Excel 42
Enhanced Charts 42
Support for Enterprise Command Center Pop-up 43
Direct Display for Descriptive Flexfields in Simple Search Panel 43
Semicolon as Separator for Exported CSV File 43
New API for List Search 43
Saved Search Notifications in Classic Query Bean Views Panel 43
New Key Flexfield Web Bean Attribute 43
New Profile Option to Disable Diagnostic Console Button 43
Redwood Theme 43
4.1.15. Release 12.2.13 44
Enhanced Navigator Performance 44
Interactive Gantt Chart 44
Extended Use of Redwood Theme 44
Last Successful Login Display 44
Antivirus Scanner for Attachments 44
4.2. Oracle Application Object Library 44
4.2.1. Release 12.0.3 (RUP3) 44
Custom Directory Information Tree (DIT) 44
4.2.2. Release 12.1.1 45
Data Type Support Enhancements in the Generic Data Loader (FNDLOAD) 45
Data Type Support Enhancements in the XML Definition File (XDF) 45
Integrated Business Events in Concurrent Processing 45
Manager and Request Instance Affinity in Concurrent Processing 45
Startup Threshold for Managers in Concurrent Processing 45
4.2.3. Release 12.1.2 45
Oracle Access Manager Integration 45
Oracle Application Object Library Java APIs 46
DataSource for Oracle E-Business Suite (AppsDataSource) 46
JAAS for Oracle E-Business Suite 46
Scheduling Charts User Interface Enhancements 46
4.2.4. Release 12.1.3 47
Key Flexfield Cross-Validation Rules Report Enhancements 47
Flexfield Segment Name Validation 47
Concurrent Processing Integration with Oracle Business Intelligence Publisher Delivery Manager47
Oracle E-Business Suite Support for 11g Case Sensitive Database Passwords 47
FNDMENU Diagnostics Menu Security Enhancement 48
Database Connection Tagging 48
4.2.5. Release 12.1.3+ 48
Recalculation of Dynamic Default Parameters in Standard Request Submission 48
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document vi
Setting Environment Values and Parameters on a Per-Service Basis 48
Concurrent Processing Command-Line Utility 48
New Schemes for Storing Concurrent Processing Log and Output Files 48
Output File Naming Changes 48
Timed Shutdown for Concurrent Processing 48
Allowed Resources 49
Allowed Redirects 49
4.2.6. Release 12.2 49
Native Oracle Database 11g Release 2 Caching for Profiles 49
Uptake of AUTO Sampling Statistics Gathering Feature in Oracle Database 11g Release 1 49
Support for Copying Attachments in the Oracle Application Framework UI 49
Flexfield Value Set Security 49
Browser Cookie Scope 50
Allowed JSP Lists 50
Oracle Application Object Library REST Services 50
4.2.7. Release 12.2.3 50
Advanced Password Hashing 50
4.2.8. Release 12.2.4 51
Recalculation of Dynamic Default Parameters in Standard Request Submission 51
Profile Option to Control Opening of Key Flexfield Window by Default 51
Setting Environment Values and Parameters on a Per-Service Basis 51
Allowed Redirects 52
4.2.9. Release 12.2.5 52
Login Page Enhancements 52
Null Values Allowed in Find Window Queries for Descriptive Flexfields 52
Flexfields Cross-Validation Rule Violation Report Enhancement 52
Flexfields Test Page 52
Concurrent Processing Command-Line Utility 52
JSP and Java API for File Streaming 52
4.2.10. Release 12.2.6 53
Setup Wizard for Flexfields Value Set Security 53
Flexfields Registration HTML UI 53
Oracle E-Business Suite Forms in Read-Only Mode on the Responsibility or User Level 53
New Schemes for Storing Concurrent Processing Log and Output Files 53
Audit Trail Search HTML UI 53
Allowed JSP List Enabled by Default 53
Allowed Redirects Enabled by Default 53
Secure Configuration Console 53
4.2.11. Release 12.2.6+ 54
Allowed Resources 54
4.2.12. Release 12.2.7 54
Allowed Resources Enhancements 54
Secure Configuration Console Enhancements 54
4.2.13. Release 12.2.9 54
Read-Only Flexfields Segments Capability 54
New Concurrent Processing Output File Naming Conventions 54
Concurrent Processing Timed Shutdown 55
Allowed Resources Enhancements 55
Secure Configuration Console Enhancements 55
4.2.14. Release 12.2.10 55
Restricting Visibility of Shared Attachments in the Document Catalog 55
Flexfields Forms Diagnostics Logging 56
Sign-on Auditing Enhancements 56
Allowed Resources User Interface Enhancements 56
Secure Configuration Console User Interface Enhancements 56
Password Hashing Default 56
4.2.15. Release 12.2.11 56
Default Retention Period for Inactive Sessions and Sign-On Audit Data Increased to 400 Days 56
Control Proxy User Selection by Organization for Internal and External Users 57
Secure Configuration Console Check for CPU Level 57
Secure Configuration Console Check for FND Global File Manager Authorization 57
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document vii
Secure Configuration Console Check for Unused Resources 57
Increased Severity for Allowed Resources Configuration Check in Secure Configuration Console57
4.2.16. Release 12.2.12 57
Propagation of Delivery Options and Notifications Options to Child Requests in Concurrent Request
Submission 57
Association of File Extensions to File Formats/MIME Types for Concurrent Request Output Files57
Forced Authentication 58
4.2.17. Release 12.2.13 58
Disable and Enable Inactive FND Users Based on Security User Type 58
Last Login Date and Time 58
Online Help SSL-Only Support 58
4.3. Oracle Applications Manager (OAM) 59
4.3.1. Release 12.1.3 59
Support for Timing Report per Application Module 59
4.3.2. Release 12.1.3+ 59
Export Function for Patch Impact File Details Page in Patch Impact Analysis 59
4.3.3. Release 12.2 59
Integration of Oracle Applications Manager and Oracle Enterprise Manager 11g Fusion Middleware Control
59
4.3.4. Release 12.2.2 59
View All Button on Patch Wizard Detail Pages 59
4.3.5. Release 12.2.4 59
Sync with Licensed Products Button on Codelevels Summary Page 59
4.3.6. Release 12.2.5 60
Streamlined Recommended Patches List in Patch Wizard 60
Export Function for Recommended Patches Page in Patch Wizard 60
4.3.7. Release 12.2.6 60
License Manager Language Mode Selection 60
Export Function for Patch Impact File Details Page in Patch Impact Analysis 60
4.4. Oracle Diagnostics Framework 60
4.4.1. Overview 60
4.4.2. Release 12.0.3 (RUP3) 61
Diagnostics Execution Engine and User Interface Enhancements 61
4.4.3. Release 12.0.4 (RUP4) 61
New and Revised Diagnostic Tests 61
4.4.4. Release 12.0.6 (RUP6) 62
Diagnostics Enhancements 62
4.4.5. Release 12.1.1 62
Performance Enhancements 63
Role Based Access Control Uptake 63
Test Level Sensitivity 63
Oracle XML Publisher Integration 63
UI Enhancements 63
Customization Support 64
Role Based Access Control and Valid Applications 64
Test Set Scheduling 64
Preference Profile Options 64
Performance Profile Options 64
4.4.6. Release 12.1.2 64
Recognition of XML file types 64
4.4.7. Release 12.1.3 65
In-Context Diagnostics 65
4.5. Oracle E-Business Suite Applications DBA 65
4.5.1. Release 12.0.2 (RUP2) 65
Change Base Language Script 65
4.5.2. Release 12.2 65
Online Patching 65
4.5.3. Release 12.2.4 65
Online Patching Log Analyzer 65
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document viii
New Online Patching Cleanup Mode 65
4.5.4. Release 12.2.5 66
Patching Support for Single File System Development Environments 66
Integration of EBS Technology Codelevel Checker (ETCC) with adop 66
Enhanced adop Console Messages 66
New adop Monitoring Tool 66
Performance Enhancements in adop Operation 66
Improved Oracle WebLogic Server Error Reporting by Online Patching Log Analyzer Utility 66
Ability to De-register a Custom Application 66
4.5.5. Release 12.2.6 67
Log File Structure 67
Handling Seed Data Changes 67
Delta Synchronization Method 67
Warning for Missing Application Tier Patches 67
4.5.6. Release 12.2.7+ 67
Script to Terminate Sessions Connected to Old Editions 67
4.5.7. Release 12.2.10 67
adop Enhancements with Oracle Database 19c 67
Performance Enhancement for Online Patching 68
File System Synchronization Enhancement 68
4.5.8. Release 12.2.11 68
Oracle E-Business Suite System Schema Migration 68
Certification with Oracle Database Unified Auditing 68
4.5.9. Release 12.2.12 68
Consolidated adgrants.sql File 68
4.5.10. Release 12.2.13 69
Database Native Cleanup 69
4.6. Oracle E-Business Suite Information Discovery 69
4.6.1. Overview 69
4.6.2. Support Update 69
4.6.3. Release 12.2 V7 70
Upgrade to Oracle Endeca Information Discovery 3.2 70
New Layout Template 70
Summarization Bar Metric Refinement 70
Enhanced Oracle E-Business Suite Results Grid Features 70
Expanded Language Support 70
Changes to the EndecaServer.properties File 71
Hostname Resolution Improvements 71
Profile File Created for New Data Domains 72
Automatic Log Cleanup by the Cluster Coordinator 72
Optimized Application Tier Deployments 72
Diagnostics Enhancement 73
Improved Handling of Invalid Records by the Bulk Load Interface 73
New EQL Function 73
Sorting Records Based on Geocode 73
Concurrent ETL Enhancement 73
4.7. Oracle E-Business Suite Integrated SOA Gateway 74
4.7.1. Business Case 74
4.7.2. Overview 74
4.7.3. Release 12.1.1 74
Integration Repository 74
SOA Provider 75
Service Invocation Framework 75
SOA Monitor 75
4.7.4. Release 12.1.2 76
Enhanced SOA Diagnostics 76
Introducing Java APIs for Forms as an integration interface type 76
Oracle E-Business Suite Integrated SOA Gateway Customization (Integration Repository Parser)76
4.7.5. Release 12.1.3 76
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document ix
Uniform / Static XSD Schema File Nomenclature and Schema Structures 76
Enhanced Logging / Auditing and Monitoring 77
SAML Token Support 77
4.7.6. Release 12.1.3+ 77
Support for REST Services 77
Security Services 77
Annotation for Java Bean Services 78
4.7.7. Release 12.2 78
Oracle WebLogic Server 11g with Oracle SOA Suite 11g Integration 78
Asynchronous Web Service Support 79
Oracle E-Business Suite Integrated SOA Gateway Diagnostics and Designer Script 79
Error and Exception Handling 79
4.7.8. Release 12.2.3 79
Support for PL/SQL APIs as REST Services 79
Security Services 80
4.7.9. Release 12.2.4 80
Support for Java APIs as REST Services 80
Annotation for Java Bean Services 80
4.7.10. Release 12.2.5 81
Support for Application Module Services 81
Enhanced Language Tag Support 81
4.7.11. Release 12.2.7 81
Support for Concurrent Programs as REST Services 81
4.7.12. Release 12.2.7+ 81
Support for Open Interface Tables and Open Interface Views as REST Services 81
4.7.13. Release 12.2.10 82
Support for Business Service Objects (BSOs) as REST Services 82
REST Service Monitoring, Logging, and Related UI Enhancements 82
4.7.14. Release 12.2.11 82
Support for REST Service Invocation Framework 82
4.7.15. Release 12.2.12 83
Enabling GET HTTP Method for PL/SQL REST Services 83
4.7.16. Release 12.2.13 83
Service Invocation Monitor for Outbound Invocations through Service Invocation Framework 83
4.8. Oracle E-Business Suite Mobile Foundation 83
4.8.1. Overview 83
4.8.2. Mobile Release 1.0 83
Mobile App Services 83
Mobile Applications Manager User Interface 84
User Login and Configuration Flow 84
4.8.3. Mobile Release 2.0 84
Improved Login Flow 84
Diagnostics Improvements 84
4.8.4. Mobile Release 2.1 84
Improvements in Login and Configuration Flow 84
Ability to Change Server URL Without Reinstalling App 84
Diagnostics Improvements 84
Improvements in App Configuration and Management 85
4.8.5. Mobile Release 3.0 85
Changes to Support Both iOS and Android with the Same Client Code 85
Ability to Update Server URL from Connection Details Page 85
Updates to Configuration UI 85
4.8.6. Mobile Release 4.0 85
Support for Enterprise Distribution 85
Customization Support for Corporate Branding 86
Support for Web SSO Authentication 86
Enhanced Mobile App Setup Pages 86
4.8.7. Mobile Release 4.1 86
Support for Custom App Development 86
4.8.8. Mobile Release 5.0 86
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document x
User Installation and Usage Metrics for Administrators 86
Updated Look and Feel for Selected App Interactions 87
Uptake of Oracle Mobile Application Framework (MAF) 2.2.2 87
Opening Links to External Websites Within an App 87
4.8.9. Mobile Release 6.0 87
Opening Links to External Websites Within an App on Android Devices 87
Updated Look and Feel for Selected App Interactions 87
Clearing User Credential Fields 87
Uptake of Oracle Mobile Application Framework (MAF) 2.3.1 87
Separate Privileges for Developers and Administrators in UI 87
4.8.10. Mobile Release 6.1 87
APIs for Custom App Development 87
4.8.11. Mobile Release 7.0 88
Ability to Import Custom CA or Self-signed Server Certificates 88
Automatic Download of Mobile App Configuration 88
Uptake of Oracle Mobile Application Framework (MAF) 2.4.0 88
Support for Push Notifications in Selected Apps 88
Enhanced Mobile App Setup Pages 89
4.8.12. Mobile Release 7.1 89
Additional Self-Service Human Resources APIs for Custom App Development 89
4.8.13. Mobile Release 8.0 89
Ability for Administrators to Preconfigure EBS Server URL when Deploying through Enterprise Mobility
Management 89
Preventing Attachments from Being Shared 89
Uptake of Oracle Mobile Application Framework (MAF) 2.5.0 89
4.8.14. Mobile Release 9.0 89
Uptake of Oracle Mobile Application Framework (MAF) 2.6.2 89
4.8.15. Mobile Release 9.1 89
Uptake of Oracle Mobile Application Framework (MAF) 2.6.3 89
4.9. Oracle E-Business Suite Secure Enterprise Search 90
4.9.1. Overview 90
4.9.2. Release 12.0.6 (RUP6) 91
Search Modeler 91
4.9.3. Release 12.1.1 91
Search Modeler 91
Out of Box Searchable Business Objects 91
4.9.4. Release 12.1.2 92
UI Improvements 92
Design Time Search Security Plug-ins 92
4.9.5. Release 12.1.3 92
Export Search Results to Excel 92
4.10. Oracle Enterprise Command Center Framework 93
4.10.1. Overview 93
4.10.2. Release 12.2 V1 94
User Interface Components for Information Discovery 94
Security 94
Responsive Design 94
4.10.3. Release 12.2 V2 94
Advanced Search 94
New User Interface Components for Information Discovery 94
User Interface Enhancements 95
Multiple Language Support 95
4.10.4. Release 12.2 V3 95
Page Layout 95
Search Box Enhancements 96
‘Like’ Search in Available Refinements 96
Tab Component Enhancements 96
Grid Enhancements 97
Compare Column Headers 97
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document xi
Conditional Formatting in Summarization Bar 97
Relevance Ranking 97
Push Model 97
Upgrade 97
Cloning 97
4.10.5. Release 12.2 V4 98
Saved Search 98
Refinement Breadcrumbs 98
Multiple Data Set Support in Search 98
Multiple Data Set Support in Available Refinements 98
Chart Enhancements 98
Compare Enhancements 99
Record Details 99
Results Table Pagination Enhancement 99
Exporting Data from a Results Table or Grid 99
Exporting a Data Set 99
Importing Data into a Data Set 99
Available Refinements Scrolling 99
About ECC 99
Oracle E-Business Suite Postback 99
Oracle Application Framework Pop-ups 100
Online Data Load 100
Descriptive Flexfield Support 100
Upgrade 100
4.10.6. Release 12.2 V5 100
Activity Audit 100
User Preferences 101
Cascading Breadcrumb 101
Chart Maximization 101
Chart Export 101
Export 101
Aggregate Table Pagination Enhancement 101
Number Abbreviation in Summarization Bar 101
Negative Refinements 101
Aggregate Grid 101
“Other” Group in Pie and Donut Charts 101
Top and Bottom N in Chart 102
Line Chart Enhancements 102
Sequential Full Load 102
About ECC - Monitoring 102
4.10.7. Release 12.2 V6 102
Diagrams 102
Descriptive Flexfield Value Set Description 103
Enterprise Command Center Pop-ups 103
Color Pinning in Charts 103
Time Stamp and Time Zone Support 103
Waterfall Charts 103
Multi-Data Set Support in Charts 103
Condition Enhancements 104
Value Defaulting 104
Improved Readability for Refinements 104
Search Suggestion Enhancement 104
4.10.8. Release 12.2 V7 104
Enhanced Network Diagrams 104
Enterprise Command Center Pop-up 105
Look-Ahead Visualizations for Chart Cascading 105
Dynamic Date Filter 105
Faster Discovery through Applied Filters 105
Export Dashboard to PDF 105
Default Saved Search 105
4.10.9. Release 12.2 V8 105
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document xii
Enhanced Network Diagrams 105
Enterprise Command Center Drawer 106
Pivot View 106
Timeline View 106
Date Transformation 106
Public Default Saved Search 106
Descriptive Flexfield Validation 106
SQL Plan Diagnosability 107
4.10.10. Release 12.2 V9 107
Network Diagram and Timeline 107
Enhanced Network Diagrams 107
Inline View 107
Dynamic Pivot Attribute Display and Reordering for Pivot View 107
Analyze Events in Selected Periods in Timeline View 107
Improved Efficiency for Date Calculations in Time Series 107
Relative Date Filters 107
Key Flexfields Exposed in Dashboards 108
Attribute Label Mapping 108
New Association Implementation 108
4.10.11. Release 12.2 V10 108
Redwood Theme 108
New Look and Feel for UI Components 108
Power User Personalization 108
Enhanced End User Personalization for Summarization Bar and Results Table 108
Quick Selection and Multiple Filters for Refinement Breadcrumb 109
Trellis Chart 109
Percentage Chart 109
Dynamic Bucketing for Time Series 109
Group Actions for Results Tables 109
Freezing Columns for Results Tables 109
Footer Summary for Results Tables 109
Record Selection for Results Tables 110
Pivot Sub-summary 110
Grid Styling for Buttons 110
Search Within for Diagrams 110
Row Expander Freeze for Diagrams 110
Expand and Collapse Nodes in Hierarchical View 110
Enhanced Flag Pop-up and Sorting for Summarization Bars 110
Badges 110
Date Format for Data Export 110
4.10.12. Release 12.2 V11 111
Personalization Reset by Administrators 111
Personalization Template 111
Copying Components in Power User Personalization 111
Setting Search Scope 111
Trellis Chart Display for Pie and Donut Charts 111
Cascading Breadcrumbs in Trellis Charts 111
Weekly and Daily Buckets for Times Series Charts 111
Results Table Local Filters 111
Inline Visibility for Selected Rows in Results Tables and Grids 111
Default Image for Hierarchical Views 111
Hierarchical Aggregation 112
Pivot Subsummary Options 112
Export Options 112
Alphanumeric Sorting 112
Uniform Presentation of Number Formatting 112
Absolute Values in Charts 112
Inline Labels 112
Default Drawer Size 112
4.11. Oracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite 112
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document xiii
4.11.1. Overview 112
4.11.2. V1.0 113
Oracle E-Business Suite Pre-built Test Content for Oracle Flow Builder 113
4.12. Oracle iSetup 113
4.12.1. Overview 113
4.12.2. Release 12.1.1 114
Oracle iSetup Migration Package Taxonomy 114
Registering Service Bean APIs with Oracle iSetup 114
Reporting Preferences 114
4.12.3. Release 12.1.3 114
Oracle iSetup MLS 114
4.12.4. Release 12.2.5 114
Oracle iSetup Internationalization Enhancements 114
4.12.5. Release 12.2.6 115
Streamlined Migration of Language Data 115
4.12.6. Product Coverage for Oracle iSetup 115
4.13. Oracle Report Manager 116
4.13.1. Overview 116
4.13.2. Release 12.0.6 (RUP6) 116
Multiple Worksheet Support 116
4.13.3. Release 12.1.1 116
Complex Content Set 117
Multiple Worksheet Support 117
4.13.4. Release 12.1.2 117
Advanced Scheduling Options 117
4.13.5. Release 12.1.3 117
Repository Management Security 117
4.13.6. Release 12.2 118
Microsoft Office Certification 118
Report Manager Home Page 118
Submitting Report Sets 118
Report Delivery 118
Microsoft Excel Report Generation from Firefox 118
Digital Signature Support 118
Row and Column Headings in Microsoft Excel 119
4.13.7. Release 12.2.4 119
Oracle Menu Displayed as Ribbon in Microsoft Excel 119
4.13.8. Release 12.2.5 119
Office Open XML Support 119
Simplified Report Submission 119
Parallel Content Set Support 119
Simplified Report Manager Home and Menu 120
4.13.9. Release 12.2.7 120
Security Enhancements 120
4.13.10. Release 12.2.7+ 120
Microsoft Office Certification 120
4.13.11. Release 12.2.9 120
Transferring Custom Financial Statement Generator Report Templates 120
Enhancements for Maintain Repository Program 120
4.13.12. Release 12.2.10 121
Custom Generic Templates 121
4.13.13. Release 12.2.13 121
Microsoft Office 2021 Certification 121
4.14. Oracle User Management (UMX) 121
4.14.1. Overview – SOX Compliance RBAC Reports 121
4.14.2. Release 12.1.1 121
Categorized Searching 121
360 Degree View 121
Reports 122
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document xiv
Quick Find 122
Snapshot 122
Print Role Hierarchy 122
4.14.3. Release 12.2.4 122
Proxy User Access Control 122
4.14.4. Release 12.2.6 123
Proxy Auditing 123
User Registration HTML UI 123
Responsibility HTML UI 123
4.14.5. Release 12.2.12 123
Proxy User Access to Responsibilities and Workflow Notifications 123
4.15. Oracle Web Applications Desktop Integrator 123
4.15.1. Overview 123
4.15.2. Release 12.1.2 124
Oracle E-Business Suite Desktop Integration Framework 124
4.15.3. Release 12.1.3 124
Digital Signature Support 124
Oracle E-Business Suite Desktop Integration Framework Enhancements 124
4.15.4. Release 12.2 125
Microsoft Office Certifications 125
Usability Enhancements 125
Switch Responsibility Option 125
Commit Rows Parameter 125
Compressing Data for Upload 125
Oracle Web Applications Desktop Integrator Diagnostics 126
4.15.5. Release 12.2.4 126
Oracle Menu Displayed as Ribbon in Microsoft Excel 126
4.15.6. Release 12.2.5 126
Office Open XML Support 126
Flexfield Enhancements 126
Dependent List of Values for an Interface Attribute 126
4.15.7. Release 12.2.6 126
Simplified Create Document Page 126
Simplified Define Layout Page 127
Refreshing Interface Attributes 127
Exporting Oracle Application Framework Table Data with Oracle Web Applications Desktop Integrator 127
4.15.8. Release 12.2.7 127
Copying an Integrator Definition 127
Simplified Define Mapping Page 127
Security Enhancements 128
4.15.9. Release 12.2.7+ 128
Microsoft Office Certification 128
4.15.10. Release 12.2.9 128
Sequence Source Type for Interface Attributes 128
4.15.11. Release 12.2.10 128
Enhancements for SQL Query Contents 128
4.15.12. Release 12.2.13 128
Microsoft Office 2021 Certification 128
Reset Dependent Field’s Value after Change in Parent Field 128
4.16. Oracle Workflow 129
4.16.1. Release 12.1.1 129
Worklist - Bulk Notification Response and Bulk Notification Close 129
Hijrah/Thai Calendar Support 129
4.16.2. Release 12.1.3 129
Notification Mailer - SMTP Authentication 129
4.16.3. Release 12.2 129
E-mail Character Encoding Configuration 129
Deferring Worklist Response Processing 130
Oracle RAC Affinity for Workflows 130
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document xv
Worklist Usability Enhancements 130
Bulk Reset for DISABLED Notification Preference 131
Enhancement for Reassigning Notifications 131
Enhancement for Service Component Processing by Correlation ID 131
4.16.4. Release 12.2.3 132
Worklist Header Icon 132
4.16.5. Release 12.2.4 132
Proxy User Access Control 132
4.16.6. Release 12.2.5 132
Support for Oracle E-Business Suite Attachments in E-mail Notifications 132
Support for Multiple E-mail Addresses for a User or Role 132
4.16.7. Release 12.2.6 132
External Links to Oracle E-Business Suite in E-mail Notifications 132
Ability to Specify Security Protocols for Mailer 133
4.16.8. Release 12.2.7 133
Oracle Workflow Internationalization Enhancements 133
4.16.9. Release 12.2.7+ 133
Ability to Distinguish Approvals Sources 133
4.16.10. Release 12.2.9 133
Oracle Workflow Internationalization Enhancements 133
Action History Enhancement 133
Configuring E-mail Eligibility for Item Types and Messages 133
Configuring Attachments in E-mail Notifications 133
Enhancement for Resending Failed Notifications 134
4.16.11. Release 12.2.10 134
Enhanced My Worklist Pop-Up 134
Action History for Standalone Notifications 134
“Auto-generated” Header for E-mail Notifications 134
4.16.12. Release 12.2.11 135
Respond with Yes/No or True/False in My Worklist Pop-Up 135
Invoke REST Services from Event Subscriptions 135
4.16.13. Release 12.2.12 135
Respond to Notifications as Group with Digital Signature 135
Configure OAuth-2.0–based Authentication 135
4.16.14. Release 12.2.13 135
Configure OAuth–based Authentication for Google Workspace Gmail 135
Script to Delete Vacation Rules 135
Configure Workflow Email Size Limit 136
4.17. Oracle Mobile Approvals for Oracle E-Business Suite 136
4.17.1. Overview 136
4.17.2. Mobile Release 1.0 – Client Version 1.0.0 136
Approval Request Handling 136
4.17.3. Mobile Release 2.1 – Client Version 1.1.0 137
Mobile Foundation Release 2.1 Updates 137
4.17.4. Mobile Release 3.0 – Client Version 1.2.0 137
Android Support 137
Mobile Foundation Release 3.0 Updates 137
4.17.5. Mobile Release 4.0 – Client Version 1.3.0 137
New Approval Types 137
Enhanced Data Layout 137
Improved Approvals Filtering 137
Translation Support 137
Mobile Foundation Release 4.0 Updates 137
4.17.6. Mobile Release 5.0 – Client Version 1.4.0 138
New Approval Types 138
Attachments 138
Adding Custom Workflows 138
Enhanced Pending Approvals by Type Page 138
Enhanced Details Page 138
Enhanced Refresh Interaction 138
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document xvi
Mobile Foundation Release 5.0 Updates 138
4.17.7. Mobile Release 5.0 – Client Version 1.4.2 138
Mobile Foundation Release 5.0 Updates 138
4.17.8. Mobile Release 6.0 – Client Version 1.5.0 139
New Approvals 139
Ability to Customize Seeded Metadata 139
Enhancement for Quoting Approval to Support Customization 139
Technical Updates 139
Mobile Foundation Release 6.0 Updates 139
4.17.9. Mobile Release 7.0 – Client Version 1.6.0 139
Ability to Reassign an Approval Notification 139
Support for Push Notifications 139
Mobile Foundation Release 7.0 Updates 139
4.17.10. Mobile Release 8.0 – Client Version 1.7.0 140
Ability to Distinguish Approvals Submitted through Mobile Apps 140
Mobile Foundation Release 8.0 Updates 140
4.17.11. Mobile Release 9.0 – Client Version 1.8.0 140
New Approvals 140
Mobile Foundation Release 9.0 Updates 140
4.17.12. Mobile Release 9.1 – Client Version 1.8.1 140
Mobile Foundation Release 9.1 Updates 140
4.17.13. Mobile Release 10 140
New App Built with Oracle JET Available Through Web Browser 140
4.18. Oracle XML Gateway 141
4.18.1. Release 12.0.3 (RUP3) 141
Improved Error Notification from Oracle XML Gateway 141
4.18.2. Release 12.2 141
Oracle XML Gateway Inbound Processing in Java 141
Enhanced Oracle XML Gateway Diagnostics 141
4.18.3. Release 12.2.6 142
API to Manage Trading Partners 142
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document xvii
1. Disclaimer
This Release Content Document (RCD) describes product features that are proposed for
the specified releases of the Oracle E-Business Suite. This document describes new or
changed functionality only. Existing functionality from prior releases is not described. It
is intended solely to help you assess the business benefits of upgrading to the specified
release of the Oracle E-Business Suite.
This document in any form, software or printed matter, contains proprietary information
that is the exclusive property of Oracle. Your access to and use of this confidential
material is subject to the terms and conditions of your Oracle Software License and
Service Agreement, which has been executed and with which you agree to comply. This
document and information contained herein may not be disclosed, copied, reproduced or
distributed to anyone outside Oracle without prior written consent of Oracle. This
document is not part of your license agreement nor can it be incorporated into any
contractual agreement with Oracle or its subsidiaries or affiliates.
This document is for informational purposes only and is intended solely to assist you in
planning for the implementation and upgrade of the product features described. It is not
a commitment to deliver any material, code, or functionality, and should not be relied
upon in making purchasing decisions. The development, release, and timing of any
features or functionality described in this document remains at the sole discretion of
Oracle.
Due to the nature of the product architecture, it may not be possible to safely include all
features described in this document without risking significant destabilization of the
code.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Purpose of Document 1
2. Introduction
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Purpose of Document 2
3. Technology Stack
XDK for the Database Tier Same as database Same as database Same as database
version version version
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Release 12.2 Overview 3
Oracle Application Server (for 10.1.2.3 10.1.2.3 10.1.2.3
Application Tier Forms and Reports)
JSP Engine OJSP 10.1.3.5 (based WebLogic JSP Engine WebLogic JSP Engine
on JSP 2.0 11.1.1.6 11.1.1.9
specification) (weblogic.appc) (weblogic.appc)
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Release 12.2 Technology Components 4
Oracle Thin JDBC Drivers (for 11.2 11.2 12.1.0.2
Application Tier Java Code)
Note: The 11.2 JDBC
drivers remain the
default as of Oracle E-
Business Suite Release
12.2.13.
* The actual certification date for some technologies may not coincide completely with
the release of Oracle E-Business Suite, especially on certain platforms. Before planning
to upgrade your Oracle E-Business Suite instance to a new version of a technology,
please ensure that the technology is certified and available for your platform by
reviewing the information available in the “Certify” system on “My Oracle Support”.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Technology Configuration 5
3.3.2. Release 12.0.2 (RUP2)
AutoConfig Profiler
Release 12.1.1 AutoConfig contains an option to run in a profile mode. Running
AutoConfig in this mode generates a performance report with timing details about each
script instantiated and run by AutoConfig.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Technology Configuration 6
AutoConfig Check Config Utility
The Technology Stack Check Config Utility (adchkcfg) in Release 12.1.1 has been
enhanced to report on relevant file system and database changes prior to running
AutoConfig. Enhancements to the adchkcfg utility also include providing a Release 12
look and feel to the resulting report document, and improving the Applications database
profile differences report.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Technology Configuration 7
Enhanced Support for DMZ Deployments
Release 12.1.1 enhances support for use of Oracle E-Business Suite in DMZs (De-
Militarized Zones). See Oracle E-Business Suite R12 Configuration in a DMZ, My
Oracle Support Document 380490.1.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Technology Configuration 8
Automated Deployment of Forms ear File
Previously whenever the forms ear file was patched in the 10.1.2 Oracle Home,
customers had to redeploy it manually to the 10.1.3 Oracle Home. In Release 12.1.3, this
process has been automated assuring that customers will not experience Forms execution
problems due to an obsolete Forms executable.
3.3.6. Release 12.1.3+
Installation
The Release 12.2 installation process has been significantly enhanced compared to prior
releases. These enhancements include the provision of application tier node services, the
use of native Oracle Database and Oracle Fusion Middleware installation tools to install
and configure these technology stack components, and support for integrating Oracle E-
Business Suite with existing Oracle Database 11g Release 2 and Oracle Fusion
Middleware 11g Release 1 homes. Additionally, Rapid Install now supports installing
Oracle E-Business Suite into a Grid Infrastructure (Oracle RAC/ASM) environment.
Online Patching
One of the key features of Release 12.2 is the switch to online patching. This uses the
Oracle Database 11g Release 11.2.0.2 feature of edition-based redefinition to reduce
significantly the downtime traditionally needed for patching and related maintenance
activities.
An edition is a private environment in which you can redefine database objects. With
online patching, patches are applied to a separate edition while users are working with
the original edition. Subsequently, the system is cut over to make the patch edition the
new production edition. After the upgrade to Release 12.2, all future patches and
maintenance packs will be applied online, requiring only a short cutover period to make
the new functionality active.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Technology Configuration 9
Cloning
Release 12.2 simplifies and enhances the cloning process, for example when scaling
systems up by increasing the number of nodes. Also, support is now provided for
cloning the Fusion Middleware components of Oracle E-Business Suite.
Application Tier
A key change to the Oracle E-Business Suite technology stack is the adoption of the
Oracle WebLogic Server component of Oracle Fusion Middleware, in association with
the Oracle HTTP Server component. Corresponding changes have been made to the
various application tier services.
Additionally, Oracle E-Business Suite Release 12.2 has a second file system for the
application tier. The second file system facilitates the online patching functionality for
Oracle E-Business Suite patches and follows the best practices recommendations of
Oracle technologies for minimal patching disruption.
External Integrations
Release 12.2 includes enhancements to support integration with Oracle WebCenter
Portal and Oracle BPEL Process Manager using the new technology stack components
in the application tier.
Additionally, Oracle Application Framework now integrates with AutoVue Document
Print Services. For more information, see section 4.1.6.2.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Technology Configuration 10
Java Web Start on macOS with Firefox
This feature was back-ported from Release 12.2.9. Refer to the full feature description
under the Release 12.2.9 section for this product.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Technology Configuration 11
External Integration with Oracle Unified Directory
Release 12.2 includes enhancements to support integration with Oracle Unified
Directory as an alternative to Oracle Internet Directory. Oracle Unified Directory is a
comprehensive, next generation directory service that is designed to address large
deployments, to provide high performance, to be highly extensive, and to be easy to
deploy, manage, and monitor. It includes an LDAP directory server used for storing
data, a proxy server where the server acts as an interface between the client and the
directory server that contains the data, and a replication gateway between Oracle Unified
Directory and Oracle Directory Server Enterprise Edition.
3.3.10. Release 12.2.7
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Technology Configuration 12
s_srvctl_thread_count has been added to the application tier context file. The
setting for this variable should be based on the number of processors on the system.
3.3.12. Release 12.2.9
3.4. Internationalization
3.4.1. Release 12.1.1
Oracle E-Business Suite Release 12.1.2 adds Lithuanian, Indonesian, and Ukrainian to
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Internationalization 13
the list of supported languages. Space and single quote number group separators are
also supported in Oracle E-Business Suite Release 12.1.2. Users can also select their
start day of the week through a profile option. The Gantt chart and inline date picker
features support Thai and Hijrah calendars in Oracle E-Business Suite Release 12.1.2.
Gantt chart and inline (embedded) date pickers support Thai and Hijrah
calendars
Thai and Hijrah calendar support has been enhanced. All known Thai and Hijrah
calendar issues in Oracle Workflow notifications have been addressed, and Gantt charts
in the user interface and in Oracle XML Publisher reports now support Hijrah and Thai
calendars. In addition, inline (embedded) date pickers in the user interface now support
Hijrah and Thai calendars.
3.4.3. Release 12.1.3
This release improves Oracle E-Business Suite Multi-Lingual Support (MLS). With the
new Lightweight MLS feature, global customers can now enable new languages without
applying the corresponding NLS patches. Oracle iSetup MLS is improved to allow
moving language data across source and target systems with different installed sets of
languages. Oracle Application Framework export functionality has better Unicode
support. Also, the new rich UI capabilities in Oracle Application Framework have Bi-
Directional language (Arabic and Hebrew) support.
Lightweight MLS
The Lightweight MLS feature, new in Release 12.1.3, allows additional languages to be
enabled without the need to apply the corresponding NLS patches. In previous releases,
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Internationalization 14
it was necessary to apply the relevant NLS patches before additional languages could be
used.
Lightweight MLS enables Oracle E-Business Suite to run multiple languages in the same
system, with the various languages being employed by different users as desired. Such a
system can simultaneously support a mixture of languages with full translation (NLS
patches applied) and languages without translation (Lightweight MLS, with no NLS
patches applied).
The Lightweight MLS feature provides the capability to enter and maintain language
data through an English user interface; for example, setup data or customer data such as
item or item description. In addition, users can set up custom reports or templates and
then generate language reports with the language data. You can also move to a full
translation at any time by applying the NLS patch for the relevant language.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Internationalization 15
Character Date International Calendar Support Enhancements
International calendar support in dates of type character is improved in Release 12.2.
International calendar support in the character date routines FND_DATE and
APP_DATE packages is enabled.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Internationalization 16
3.4.5. Release 12.2.5
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Internationalization 17
Oracle Report Manager Internationalization Enhancements
In this release, Oracle Report Manager includes the following enhancements for locale
handling for Financial Statement Generator (FSG) reports.
• In the Financial Report Template Editor, the Language list of values now
displays only the installed and base languages for your Oracle E-Business Suite
instance.
• If you select an installed language that is associated with more than one
territory, the Financial Report Template Editor now registers the template for the
additional language and territory combinations in addition to the combination of
that language with the default territory.
• When you submit a FSG report, the Template list of values displays the
templates registered for the combination of your session language and session
territory.
• If you attempt to create a template for a language using the same name as an
existing template for another language, the Financial Report Template Editor
displays an error message indicating that the same name cannot be reused for a
template associated with a different language.
• Oracle Report Manager can now display a FSG report even if the session
language of the user viewing the report is different than the session language
with which the report was submitted.
3.4.6. Release 12.2.6
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Internationalization 18
'DISPLAY,USER_SESSION,LANG_PARAMETER,BROWSER,PROFILE,SESSION
,BASE'.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Internationalization 19
Oracle Web Applications Desktop Integrator Internationalization
Enhancements
In this release, Oracle Web Applications Desktop Integrator includes the following
enhancements:
• Support for Hijrah and Thai Buddhist calendars
• Support for date values that include a time
• Support for displaying date and time values in Oracle Web Applications
Desktop Integrator spreadsheets in the user’s preferred time zone
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Internationalization 20
3.5. Oracle E-Business Suite on Oracle Cloud Infrastructure
Oracle E-Business Suite Release 12.2 (12.2.3 and later) is certified to run on Oracle
Cloud Infrastructure. Automation is provided for a selection of deployment and
management scenarios. New capabilities are delivered with cloud releases, separate from
Oracle E-Business Suite releases.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite on Oracle Cloud Infrastructure 21
4. Applications Technology
The key focus areas for Applications Technology in Release 12.2 of the Oracle E-
Business Suite are:
• Greater Business Insight: Focus on end user productivity improvements and
business insight.
• Adaptive Business Processes: A complete set of Web services housed in the
Integration repository and out-of-the-box embedding of the relevant Fusion
Middleware SOA components with the Oracle E-Business Suite will make
Release 12.2 truly an agile application business platform and enable Application
Integration Architecture (AIA).
• Superior Ownership Experience: Several major enhancements contribute to
enhancing the ownership experience for the Oracle E-Business Suite customers.
Record History
This feature, introduced in Release 12.1.1, was made available on the Release 12.0 line
in Release 12.0.6. Record history is now available for Oracle Application Framework
based pages. Record history allows a user to see data about a particular record, such as
who created the record and when, and who most recently updated the record and when.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 22
4.1.3. Release 12.1.1
Record History
Record History is now available for Oracle Application Framework based pages. Record
history allows a user to see data about a particular record, such as who created the record
and when, and who most recently updated the record and when.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 23
Flexfield Reference Fields
Reference fields are now available for Oracle Application Framework based
applications. Reference fields are fields whose value is used to derive properties of
segments in a flexfield. A reference field in an Oracle Application Framework page is a
web bean which is used for evaluating one or more properties of a flexfield, such as
default segment value, value set, and context reference field for descriptive flexfields.
Whenever the value in the reference web bean changes, the page is refreshed with
changes to the corresponding flexfield properties.
This feature can be enabled at the customer site using Admin Personalization on existing
flexfields.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 24
add, edit, delete, and view attachments to a business entity on the same page as the base
entity. This capability eliminates the need to navigate to the Add and View attachments
pages.
The pop-up component in Oracle Application Framework allows applications to display
content as a pop-up window on top of an Oracle Application Framework page. Detail
drilldown interactions can be minimized by using this pop-up capability.
Portlet Generator
Portlet Generator is a utility that statically converts a standalone Oracle Application
Framework region into a portlet. These portlets can be embedded in Oracle or third party
portal pages and Oracle WebCenter Portal pages. Portlet Generator complies with
WSRP 1.0 standards.
Portlet Generator offers a search UI that is part of the Functional Administrator
responsibility and lets you search for and register standalone regions as portlets.
Administrators can turn on a profile option that enables portletize links on standalone
regions embedded in pages. An administrator can browse through application pages and
use the portletize links to register the regions as portlets.
REST Interface
REST (REpresentational State Transfer) is an architectural style for distributed
hypermedia systems. REST is similar to SOAP-based (Simple Object Access Protocol)
web services, but with much less payload per message. REST is architecturally tailored
for frequent and lightweight handshakes between the browser and the application tier
server.
The Oracle Application Framework RESTful service interface allows products to expose
Application Module functionality (model) as services. These model services can then be
consumed by any rich internet application. This capability allows you to build custom
user interfaces in a technology of choice but still reusing existing code in your Oracle
Application Framework application.
4.1.5. Release 12.1.3
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 25
The look-ahead LOV has been enhanced to show a UI indicator if look-ahead search has
been enabled on that particular field. The indicator takes the form of an angular
downward-facing arrow at the end of the LOV input field. Support for standard
accessibility mode and rendering in BiDi languages has also been added.
The Inline Attachment capability has now been extended to also support viewing,
updating, and deleting attachments inline within the Attachment Table item and adding
attachments inline within the Message Inline Attachment item. Support for rendering in
BiDi languages has also been added.
The pop-up component now allows form submits done on the pop-up component to
refresh the base page as well. With this capability, you can now build pop-ups that
modify data on the base page. Flexfields can now be rendered within a pop-up. Support
for standard and screen reader accessibility has also been added.
The Rich Content Container component has been enhanced to allow context-dependent,
runtime parameters to be passed to the rich component. Support for embedding external
URLs by specifying the content type as "Others" has also been added.
ADF Integration
It is now possible to link to Oracle Application Development Framework (ADF) Release
11g applications deployed on an Oracle Fusion Middleware Release 11g container from
the Oracle E-Business Suite home page. Each ADF application will have an FND
Function of type ‘ADFX’ defined for it. If such a function is granted to a user, then
when the user logs in, the home page automatically builds a link to the external ADF
application. Note that ADF applications do not support some Oracle E-Business Suite
features such as flexfields.
For more information, see the FAQ for Integration of Oracle E-Business Suite and
Oracle Application Development Framework (ADF) Applications, My Oracle Support
Document 1296491.1.
4.1.6. Release 12.2
Usability Improvements
The following usability improvements add on to the capabilities introduced in Release
12.1.3:
• The Home page now includes a tip at the top of the page displaying the number
of open notifications for the user.
• The Navigator slide-out or pull-down menu that displays the responsibility list
now includes a search input field that enhances the user’s ability to locate a
function quickly. After entering a minimum number of characters (currently set
at 3), the list of functions that matches the input string displays in place of the
responsibility list.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 26
• A new processing indicator informs the user of ongoing processing for rich user
interactions. The indicator appears when you hover over inline attachment
Add/View and while pop-up content is being loaded. The indicator disappears
once the content is fully loaded.
• Pop-up enabled items are now enhanced to display a more distinctive pop-up
indicator as described in the table below:
AutoVue Integration
The OA Framework Attachments user interface now integrates with AutoVue Document
Print Services to allow printing of File type attachments. AutoVue Document Print
Services supports the printing of different file types used in an enterprise, from a single
server where the Auto Document Print Services is configured. This support eliminates
the overhead of having to install and configure additional software on various client and
server machines to view and print all the possible file types used in the enterprise.
Personalization Improvements
New improvements have been introduced into OA Personalization Framework:
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 27
• An administrator can create a SQL-based read only view object through
Personalizations and bind it to new items on a page. This feature lets
administrators declaratively add new content from Oracle E-Business Suite
tables to an existing page.
• More item types and layout region types are available to be created and added to
a page through Personalizations. Additional layout types supported in this
release include header, classic tables, advanced tables, and message component
layout. Additional item types supported include submit button, reset button, and
rich text editor. These additions give administrators greater control over laying
out content.
• You can undo personalizations. The undo feature allows administrators to revert
the personalizations done in the current browser session if errors are
encountered while personalizing the page.
• You can copy a personalization. This capability allows administrators to rapidly
copy a personalization done at a specific level value, such as a responsibility,
function, or organization, to other levels such as different responsibilities or
different functions.
Note: While the application server for Oracle E-Business Suite Release 12.2 has been
upgraded to Oracle WebLogic Server in Oracle Fusion Middleware 11g, the Oracle
JDeveloper OA Extension continues to leverage an embedded Oracle Containers for
J2EE (OC4J) 10.1.3.5 server. Consequently, during development of customizations or
extensions, developers will run pages on the OC4J server. However, the deployed pages
will run on Oracle WebLogic Server.
iPad Certification
Oracle Application Framework applications are now certified to run on the iPad. Known
caveats are documented.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 28
Enhanced Key Flexfield End Date Validation
The end date validation for a key flexfield segment value or code combination now
supports a custom end date defined on the flexfield, as well as with a system date.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 29
Modal Pop-Up
Developers can now define a pop-up component as a modal pop-up. When a modal pop-
up renders, a user cannot interact with the base page until he or she closes the pop-up.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 30
Dynamic Views
Previously OA Framework supported views only for tables under query regions. Now
rich table interactions such as column resizing and reordering persist across sessions by
means of user-level views that OA Framework supports for both classic and advanced
tables in all pages.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 31
hold/press/press and hold, pan/drag, swipe/flick, spread, pinch, check mark/tick, and x-
mark/cross.
HTML5 Certification
You can now set a profile option to enable the uptake of the HTML5 standards doctype
into generated HTML source. If you uptake the HTML5 standard doctype, all OA
Framework-based pages can run in a browser’s preferred standards mode rather than in
quirks mode or compatibility mode.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 32
Rich Table Interactions
Classic and advanced tables now support rich interactions that allow an end user to:
• Vertically scroll a table.
• Freeze a set of columns to remain in view while horizontally scrolling a table.
Classic and advanced tables now also provide touch support for row selection and
actions.
Simplified Page UI
Oracle E-Business Suite applications now boast a simplified layout that includes a new
icon-based menu and new UI components. Developers can now add the following new
UI components to help simplify their page layout:
• Infotile – a component that contains a tile-based header and a detailed region for
content. The implementation of multiple infotile components appear as an
enumeration of tiles, where each tile provides a brief description of its detailed
region. When a user selects a given tile, the detailed content pertaining to that
tile displays in the infotile content region
• Vertical subtab layout – a vertical display of tabs for a subtab layout.
• Hide/Show subtab layout – a Hide/Show region that contains a subtab layout.
In the collapsed mode, only the tabs’ icons display. The content region slides
out and displays related content when a user selects a tab.
Pop-Up Enhancements
Pop-ups are enhanced to now:
• Allow users to move the pop-up by dragging the pop-up header area.
• Allow administrators to set a new property on the pop-up component so that
the pop-up resizes automatically to fit its contents, eliminating the need for
scroll bars.
• Allow developers to use the same AM between a base page and a
parameterized pop-up.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 33
Icon Support for Buttons
Developers can now add an icon to a button along with a prompt and specify the
position of the icon, such as left, right, top, or bottom.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 34
• The ability to declaratively or programmatically specify more than four search
criteria in the Advanced Search panel
Splitter Component
The new panel splitter layout component allows developers to create a page that a user
can split into multiple resizable and collapsible regions.
Layered Layout
The new layered layout component allows developers to create a page containing
multiple layers rather than multiple subtabs. Each layer displays a title bar area that a
user can select to switch between layers. A user can select only one layer at a time, and
the content of a layer renders only when that layer is selected.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 35
Support for Hint in Text Field, LOV Input Field, and Spin Box
You can now specify short hint text to appear in a text input field, a LOV input field, or
a spin box by declaratively setting the Placeholder Text property of the
messageTextInput, messageLovInput or messageSpinBox items.
Personalization Workbench
The new Personalization Workbench provides an alternative WYSIWYG
personalization page that allows administrators to reorder components or change
prompts in-place. The Personalization Workbench includes three panels:
• The Component palette allows you to declaratively add a new item or region to
an existing region of the page.
• The Personalize/Preview area displays the page in layers, where each layer
either represents the personalizations or provides a preview of the
personalizations made to the page at a specific personalization level.
• The Property palette displays and allows you to edit the admin-personalizable
properties of the component selected in the Personalize area.
You can drag and drop components from the Component palette to the Personalize area
to create components on the page. You can also drag and drop existing components to
reorder them on the page.
Themes
A theme determines the appearance of Oracle Application Framework pages, including
the background color, border color, and prompt properties. Administrators can create
themes using the Theme Editor, a lightweight UI-driven tool that enables easy
customization of the look and feel. In addition, Oracle E-Business Suite ships with
ready-to-use themes, similar to those provided by Oracle Cloud Applications.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 36
Multi-Column Search in Look-Ahead List of Values
This enhancement allows developers to enable searching on all search-allowed columns
for the look-ahead LOV instead of just the first column. To enable this feature, a
developer sets the property "Look Ahead Multi Column Search Enabled" to True.
List Search
List Search enables users to quickly and easily retrieve the information they are looking
for. When List Search is enabled on a specific page or application, the Query Bean
panels (Simple, Advance, and Views) are merged into a two-panel layout, with the left
panel holding the search criteria and the right panel displaying the table with the
returned records.
To implement list search on a page, a developer must turn on the property 'Enable List
Search' for a specific query bean. Administrators can enable list search for the pages
where it has been implemented by setting the FND_ENABLE_LIST_SEARCH profile
option to 'True'.
List Search has been selectively implemented across Oracle E-Business Suite products
and product families, with an emphasis to improve user productivity on pages with high
user interaction on key business transactions. List Search is available for the following
products.
Products Pages
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 37
Products Pages
• Invoices
Manufacturing Execution System for • MES Supervisor: Work Orders and
Discrete Manufacturing Exceptions
Order Management • Orders
Project Costing • Expenditure Inquiry
Project Foundation • Project List
• Add Projects
• Project Requests
Project Management • Change Orders
• Change Requests
• Project Issues
• Deliverables
• Tasks
• Financial Tasks
Purchasing • Buyer Work Center
Shipping Execution • Shipping Operations
Sourcing • Demand Workbench
Masonry Layout
The Masonry Layout component enhances usability and helps achieve responsive design
for Oracle Application Framework pages. Using a Masonry Layout aids in rendering
page content in a viewport-friendly manner across different devices, providing a better
user experience.
Accordion Component
The new Accordion component enhances the usability of Oracle Application Framework
regions by providing a header that lets you toggle the Accordion body contents between
being shown or hidden. Users can show or hide product page regions with a mouse click
on the Accordion header, providing a better user experience.
Query By Example
You can now use Query by Example (QBE) on Advanced and Classic tables. Developers
can enable this feature on a table through design-time customization.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 38
Tip Bean Enhancements
Enhancements to the Tip webBean include using a pop-up bean instead of a browser
window so that tips now show in pop-ups instead of a second browser window; support
for multiple messages; and the ability to control the Tip webBean position in List
Search.
You can optionally change back to displaying the key flexfield list of values in a modal
browser window as in previous releases by setting the
FND_ENABLE_OPEN_LOV_IN_POPUP profile to “False”.
Default Favorites
Administrators can now set default favorites in an Oracle E-Business Suite instance, and
end users can access those default favorites as recommended favorites. A new pop-up UI
shows a list of recommended and popular favorites to users, so that they can optionally
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 39
select some of those to add to their own Favorites list and then access those functions
directly from the home page.
Enhanced Graphs
Oracle Application Framework Graph components have been redesigned to render
graphs using a new technology by default instead of BI Beans. You can optionally
change back to BI Beans rendering as in previous releases by setting the FND: Enable
JET Graphs and Charts (FND_ENABLE_JET_GRAPH_CHART) profile option to
“None”.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 40
4.1.13. Release 12.2.10
Products Pages
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 41
Enhanced Advanced Sort Pop-up
The Advanced Sort pop-up is enhanced to allow saving an initial sort to a user-saved
search, when the table is under a List Search region.
Enhanced Charts
Oracle Application Framework Chart components have been redesigned to render charts
using a new technology by default instead of BI Beans. You can optionally change back
to BI Beans rendering as in previous releases by setting the FND: Enable JET Graphs
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 42
and Charts (FND_ENABLE_JET_GRAPH_CHART) profile option to “None” or "JET
Graph Only".
Charts rendered with the new technology include zoom and scroll features, which are
useful particularly for data spanning a larger timeline.
Redwood Theme
A new Redwood theme meets the latest Oracle standards for application look and feel.
In addition, global header icons have been modernized.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Framework 43
4.1.15. Release 12.2.13
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 44
4.2.2. Release 12.1.1
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 45
Oracle Access Manager may be used in place of Oracle Single Sign-On (OSSO) for
those products that support it, or it may be used with OSSO to provide centralized
authentication across all the products in the Oracle E-Business Suite technology
stack. Customers can choose when to migrate to the next generation of Oracle Security
products.
Oracle E-Business Suite now provides support for Java Authentication and
Authorization Service (JAAS). This feature provides security compliance with JAAS
standard specifications.
JAAS for Oracle E-Business Suite is a lightweight login module that is designed to
deploy and run in any Java EE-compliant container. The login module is intended to be
either a starting point for customization, or an integration point, used to connect the
Oracle E-Business Suite with an external authentication service (for example, an
enterprise Single Sign-on system).
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 46
also be able to find a task bar based on a given search criteria. Simplifying the ability to
create, assign, search and display new task assignments in a single form saves time and
increases efficiency.
4.2.4. Release 12.1.3
With this release, the Oracle Application Object Library (AOL) is enhanced to support
the Oracle Database 11g case-sensitive database passwords feature for database user
authentication. In previous releases, Oracle E-Business Suite database passwords were
not case-sensitive. Support for case-sensitive database passwords provides for more
secure Oracle E-Business Suite schema passwords.
This feature is not enabled by default and its use is optional. To enable case-sensitive
database passwords, the database administrator (DBA) must perform the appropriate
setup steps.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 47
FNDMENU Diagnostics Menu Security Enhancement
This enhancement removes the challenge for the APPS password when trying to access
submenus under the Diagnostics menu. Access to the Diagnostics submenus is
controlled by the ‘Utilities: Diagnostics’ profile option and standard E-Business Suite
function security. When the user selects a menu item, Oracle Application Object
Library checks whether the submenu items are granted to the current responsibility. If
the ‘Utilities: Diagnostics’ profile option is set to No and the end user has not been
granted the securing function for the menu item, an error message is displayed.
Additionally, this enhancement provides a read-only mode for the Examine menu, the
Item Properties window, and the Forms Personalization form.
New Schemes for Storing Concurrent Processing Log and Output Files
This feature was back-ported from Release 12.2.6. Refer to the full feature description
under the Release 12.2.6 section for this product.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 48
processes, they will not keep concurrent processing from shutting down; that is, the
shutdown will occur in the specified interval.
Allowed Resources
This feature was back-ported from Release 12.2.9. This feature reduces the attack
surface of Oracle E-Business Suite by enabling the creation of an allowlist of resources -
JavaServer Pages (JSPs) and servlets - that are allowed access to your environment.
Allowed Redirects
This feature was back-ported from Release 12.2.9. This feature restricts redirects by
utilizing an allowlist mechanism, defining hosts with allowed access to a resource and
denying access to those that are not in the allowed listing.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 49
Browser Cookie Scope
A browser session cookie contains sensitive data. For a more secure configuration, the
cookie should be restricted to being sent only to those hosts required to meet operational
and business needs. Oracle E-Business Suite Release 12.2 allows the system
administrator to control which hosts the cookie is sent to.
There are three possible settings. With the 'host' setting, the cookie is scoped to the
originating host (server). This offers the greatest level of security. The 'domain' setting is
the default, and only allows the cookie to be sent to machines within the same domain as
the Oracle E-Business Suite server. This offers a good level of security, without
hampering functionality. Finally, the 'custom' setting is configurable by the system
administrator, and allows the security level to be customized for specific site
requirements.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 50
• You can now specify any of the following additional advanced hash algorithms
as the hash mode: SHA256, SHA384, or SHA512.
• You can also now specify the type of advanced hash migration to perform.
o A full migration migrates all the records in the FND_USER table to
hash mode.
o A background migration migrates all the records in the FND_USER
table to the selected advanced hash mode in the background as a
concurrent program.
o A partial migration allows users with an earlier encryption mode to co-
exist with users creating new passwords with the selected advanced hash
mode. Users on the earlier encryption mode can still log in, but
subsequent password changes will switch these users to the selected
advanced hash mode.
Note: Partial migration is used to change between advanced hash modes
and should be done only after a full or background migration. If a partial
migration is performed first, then a full migration cannot be run in the
future.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 51
Allowed Redirects
The Allowed Redirects feature (formerly also known as Approved Redirects) provides
support for an allowlist of trusted authorities, such as hosts and domains, to which
Oracle E-Business Suite is allowed to redirect web traffic. In addition, it prohibits
redirects from Oracle E-Business Suite to authorities that are not explicitly approved.
This configuration offers defense in depth against phishing attacks directed at Oracle E-
Business Suite users.
The Allowed Redirects is not enabled by default in Oracle E-Business Suite Release
12.2.4, but can be activated through a profile option.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 52
4.2.10. Release 12.2.6
New Schemes for Storing Concurrent Processing Log and Output Files
This enhancement introduces additional choices of storage schemes for management of
large numbers of concurrent processing log and output files. For example, these files
can be organized by user name or by date. Customers can specify the scheme that best
suits their particular needs.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 53
4.2.11. Release 12.2.6+
Allowed Resources
The Allowed Resources feature reduces the attack surface of Oracle E-Business Suite
by enabling the creation of an allowlist of resources, including JavaServer Pages, or
JSPs, and servlets, that are allowed access to Oracle E-Business Suite.
The previous Allowed JSP list feature is now deprecated and has been replaced with the
functionality now available in the Allowed Resources feature.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 54
• REQID.OUT – Results in o<requestid>.out
Any other values, including leaving the variable unset, will result in the default file name
of o<requestid>.extension, where the extension is derived from the request
output type. The following output types are supported:
• Text - .txt
• PDF - .pdf
• HTML - .html
• XML - .xml
• Postscript - .ps
• PCL - .pcl
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 55
Flexfields Forms Diagnostics Logging
Before Release 12.2.10, while diagnosing flexfields issues in Forms-based applications,
a user could set the GLOBAL.FND_FLEX_FNDSQF_DEBUG variable to DEBUG.
This process displayed the user_exit calls along with their parameter values in a dialog
window, requiring additional user input. With this enhancement in Release 12.2.10, the
user can have the debug information logged in a file. Choosing the ‘SPOOL’ option
will log the information in a file in the database directory defined for PL/SQL file I/O.
(See My Oracle Support Document 2525754.1, Using UTL_FILE_DIR or Database
Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and
12.2.) Choosing the ‘DEBUG_SPOOL’ option will log the information to a file and
also display the dialog window.
Default Retention Period for Inactive Sessions and Sign-On Audit Data
Increased to 400 Days
The default value for purging inactive sessions in the concurrent program Purge
Inactive Sessions (FNDDLTMP) has been changed to 400 days. Also, the concurrent
program Purge Sign-On Audit Data (FNDSCPRG) now uses a retention period (400
days by default) as a parameter instead of a date to determine which records to purge.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 56
Control Proxy User Selection by Organization for Internal and External
Users
Oracle E-Business Suite allows users to grant delegates the ability to act on their behalf
(act as proxy users for them) when performing specific Oracle E-Business Suite
functions. In this release, internal users select their proxies from a list of internal users
by default. In addition, a new security policy can be used to limit the list of potential
proxies for a user to the user's organization. Likewise, a new policy for external users
can be used to limit these users to selecting a proxy from a list including only those users
in their own organization.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 57
file_format_code/mime_type combination. When a user views an output file
with that file_format_code/mime_type combination, the file is streamed with
the specified file extension to the browser. The browser's association of an application
to the file extension will enable the correct program for viewing.
Forced Authentication
Similar to the session timeout behaviors, the Forced Authentication feature forces users
to reauthenticate with Oracle Access Manager (OAM) when ICX session timeout is
reached, regardless of whether OAM timeout has been reached. This feature requires
integration of Oracle E-Business Suite Release 12.2.3 or later with Oracle Access
Manager using Oracle E-Business Suite AccessGate 1.4 or later.
Disable and Enable Inactive FND Users Based on Security User Type
The Disable Inactive FND Users concurrent program and the Enable Inactive FND
Users concurrent program are enhanced to consider the security user type in
determining the users they run against.
The Disable Inactive FND Users concurrent program checks the value of a new profile
option called FND: Security User Type (FND_SEC_USER_TYPE) to determine which
user accounts should be inactivated if they have not logged in within a specified amount
of time and inactivates them. Conversely, the Enable Inactive FND Users concurrent
program allows for the re-activation of those user accounts that were initially
inactivated by the Disable Inactive FND Users concurrent program.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Application Object Library 58
4.3. Oracle Applications Manager (OAM)
4.3.1. Release 12.1.3
Export Function for Patch Impact File Details Page in Patch Impact
Analysis
You can use the Export All button to export the table of files identified by running Patch
Impact Analysis for a given patch. This Export feature creates a comma separated file
(.csv) containing all of the data in the table that can then be opened up in Microsoft
Excel. Within Excel you can filter by impact type (new or changed) or other criteria.
This feature is forward-ported to 12.2.6.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Applications Manager (OAM) 59
4.3.6. Release 12.2.5
Export Function for Patch Impact File Details Page in Patch Impact
Analysis
You can use the Export All button to export the table of files identified by running Patch
Impact Analysis for a given patch. This Export feature creates a comma separated file
(.csv) containing all of the data in the table that can then be opened up in Microsoft
Excel. Within Excel you can filter by impact type (new or changed) or other criteria.
This feature is forward-ported from 12.1.3+.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Diagnostics Framework 60
4.4.2. Release 12.0.3 (RUP3)
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Diagnostics Framework 61
Item Master (ITM)
Marketing (AMS)
Order Management (ONT)
Partner Management (PV)
Payables (AP)
Payroll (PAY)
Projects (PA)
Public Sector Financials International (IGI)
Purchasing (PO)
Quoting (QOT)
Receivables (AR)
Release Management (RLM)
Sales (ASN)
Service (CS)
Shipping (WSH)
Spares Management (CSP)
TeleSales (AST)
Time and Labor (HXT)
Trade Management (OZ)
Trading Community Architecture (HZ)
Work in Process (WIP)
For a complete list of diagnostic tests available for Oracle E-Business Suite R12, please
refer to the E-Business Suite Diagnostics Test Catalog for R12, My Oracle Support
Document 421245.1.
4.4.4. Release 12.0.6 (RUP6)
Diagnostics Enhancements
Oracle E-Business Suite Diagnostics has been enhanced to offer a new user interface for
managing and running your diagnostic tests. This new UI incorporates the User
Management security model based on RBAC. In addition, the reporting engine is now
integrated with Oracle XML Publisher.
4.4.5. Release 12.1.1
In Release 12.1.1, the Oracle Diagnostics Framework has been re-engineered to offer a
highly performing diagnostics engine, user-friendly access and reporting, and an
integrated application security model. To access the new Oracle Diagnostics Framework
one needs Application Diagnostics responsibility and a diagnostic role. To access Oracle
E-Business Suite diagnostic scripts use the new Oracle E-Business Suite Diagnostics
roles to execute and configure the diagnostic tests.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Diagnostics Framework 62
Performance Enhancements
The Oracle Diagnostics Framework engine now supports execution of long running tests
and large volume reports. Each request can be tracked through a unique request name.
UI Enhancements
The user interface is enhanced to support Oracle XML Publisher integration, browser
look-and-feel compliance, RBAC uptake, and tracking of long running tests and large
volume reports.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Diagnostics Framework 63
Customization Support
Oracle Diagnostic Framework now makes it possible for users with custom
responsibilities to run diagnostic tests. Customers running applications that have been
cloned from a seeded Oracle application or customers running localizations can create a
custom role and grant that maps to an Oracle seeded application. Once this is done, the
system will recognize mapping between custom/ localized applications and seeded
applications. The responsibility LOV provided by the framework will start showing the
responsibilities of the user associated with custom applications.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Diagnostics Framework 64
eliminate the need for you to schedule patching downtime, since XML type diagnostics
patches can be applied in Hot Mode.
4.4.7. Release 12.1.3
In-Context Diagnostics
In-context Diagnostics uses the inline pop-up feature in Oracle Application Framework
to enable a user to enter input for a diagnostic test, execute it, and view the result or
report, all from the current product page, without navigating to the Diagnostics screens
to run the test.
Online Patching
One of the key features of Release 12.2 is the switch to online patching. For more
information, see section 3.3.6.2.
4.5.3. Release 12.2.4
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Applications DBA 65
cleanup_mode=full
The behavior in standard mode is the same as for quick mode, with the additional action
of dropping covered_objects. The purpose of standard mode, which is now the default, is
to prevent the SYSTEM tablespace growing too large.
4.5.4. Release 12.2.5
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Applications DBA 66
required for a patching cycle. Deregistration is performed by running the
$AD_TOP/bin/adDeregisterCustomProd.pl script.
4.5.5. Release 12.2.6
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Applications DBA 67
Performance Enhancement for Online Patching
Internal synchronization within online patching has been tuned to handle extremely large
seed tables more effectively.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Applications DBA 68
in four different modes to provide the necessary grants from the relevant Oracle E-
Business Suite account to the EBS_SYSTEM and APPS accounts. Some of the modes
are run automatically during application of patches that include the adgrants.sql file; you
can run other modes manually for certain operations.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Information Discovery 69
4.6.3. Release 12.2 V7
o Java 7 and 8
o Internet Explorer 11
• The search box has been repositioned to the top right of the Oracle E-Business
Suite Information Discovery dashboard.
• A left side bar is introduced on separate Available Refinements filters and the
Bookmarks component.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Information Discovery 70
• Full UI support for 22 additional languages
The properties file also includes two new Cluster Coordinator parameters. Endeca
Server uses these parameters to control how many snapshots of logs ZooKeeper should
keep in the data directory, and how often ZooKeeper should run an automatic log
cleanup:
Description Default
Cluster Coordinator
parameter
endeca-cluster- Specifies the number of log snapshots to retain Y
coordinator-auto- in the Cluster Coordinator data directory. This
purge-snap-retain- parameter is set to 3 by default.
count
endeca-cluster- Specifies the interval for automatic deletion of Y
coordinator-auto- log snapshots. This parameter is set to 1 hour
purge-interval by default. To disable the automatic deletion
of ZooKeeper's log snapshots, set the task
interval to 0 (zero) hours.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Information Discovery 71
Endeca Server and its clients are running on the same domain network; otherwise, use
the complete FQDN.
The automatic creation of this file simplifies the maintenance of data domains during
their backup and restoration (exporting and importing). You can make use of this
feature when importing a previously exported data domain because you no longer need
to keep track of a custom data domain profile.
• The endeca-cluster-coordinator-auto-purge-snap-retain-
count sets the number of snapshot logs to retain in the ZooKeeper data
directory, and is set to 3 by default.
• The Endeca Server and Integrator Server are consolidated into one domain.
• This release uses one admin server with three managed servers for Endeca
Server, Studio, and Integrator.
• The installer size has been reduced due to consolidation and the removal of the
dependency on ADF runtime.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Information Discovery 72
Diagnostics Enhancement
The get-logs command obtains WebLogic, Dgraph, and Cluster Coordinator
(ZooKeeper) log files and compresses them to a single zip file. A configuration file
specifies the settings needed by the command, such as the destination path for the zip
file and whether the installation is a single-node or clustered environment.
The Conversation Web Service enables sorting records that have geocode attribute
values by the distance from a specified reference point.
The following validations and diagnostics have been added to provide users useful
messages to take corrective action:
• Clover credentials are not stored in EBS FND_VAULT - Request ends in error.
User advised to run post-setup step 3.
• Clover URL is not up - Request ends in error. User advised to verify if the
Clover URL mentioned in the profile is correct and to check if Clover is up.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Information Discovery 73
4.7. Oracle E-Business Suite Integrated SOA Gateway
4.7.1. Business Case
In an increasingly integrated, inter-dependent and heterogeneous applications world,
service-oriented architecture (SOA) and Web services offer a number of business
benefits. It offers consistent, robust, and maintainable points of integration that reduce
both cost and risk in business operations and IT. Specifically, by consolidating business
logic and consolidating points of integration, it lends itself favorably to comprehensive
reliability and flexibility. However for the SOA promise to be delivered, it is a must that
the underlying business services are well formed, consumed by applications in a
consistent manner, and are governed suitably. Additionally from an Oracle point of
view, there is a compelling need that the services delivered fit in with the Applications
Integration Architecture (AIA). In order to accomplish these goals, in Release 12.1.1
Oracle E-Business Suite has developed a comprehensive SOA-based integration
infrastructure in the form of a new product called Oracle E-Business Suite Integrated
SOA Gateway that helps organizations to provide, consume and monitor web services
for integrations in a heterogeneous ecosystem. Oracle E-Business Suite also delivers
several well-formed business services that cater to AIA and more generic business
needs.
4.7.2. Overview
The Oracle E-Business Suite Integrated SOA Gateway is a new product in Release
12.1.1 with several new components and enhancements to existing components like
Integration Repository. Integrated SOA Gateway is a robust out-of-the-box service-
oriented architecture (SOA) based integration infrastructure to provide and consume
services.
• Integration Repository
• SOA Provider
• Service Invocation Framework
• SOA Monitor
4.7.3. Release 12.1.1
Integration Repository
Integration Repository is the central UI component for the SOA enablement of Oracle E-
Business Suite in Release 12.1.1. Integration Repository is enhanced to provide the
following features.
• Service Enablement UI
Integration Repository provides the UI for administrator’s action to generate and
deploy a Web service for a particular integration interface.
• Business Events in Integration Repository
Integration Repository in Release 12.1.1 includes the Business Events as the
annotated and registered integration interfaces. Now the Business Events can be
browsed in the Integration Repository and they can also be enabled for subscription
for integration purposes from the Integration Repository UI itself.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Integrated SOA Gateway 74
• Composite Services
Integration Repository also supports Composite Services in Release 12.1.1. A
composite service, also called business service, is atomic in nature, but orchestrates
the invocation of Oracle E-Business Suite’s out-of-the-box Web services in a
discrete business process. Integration Developers may design composite services,
which can be implemented by suitably combining multiple Oracle E-Business Suite
out-of-the-box Web services.
• Business Service Objects
A business service object implements standard Service Interfaces that provides
methods for accessing and operating on the business service object. Service
Interfaces provide a set of standard guidelines and implementation instructions for
developing services. The classes that implement these interfaces can be deployed as
Web services in the Integration Repository.
SOA Provider
There are two primary activities that happen either at the design time or run-time that
enable the SOA enablement of the Oracle E-Business Suite.
• In the deployment time the Service Generator exposes the integration interface from
the Integration Repository as Web services while the Service Deployer deploys the
Web service.
• At the run-time, the SOA Provider intercepts the SOAP Requests to Oracle E-
Business Suite services while honoring the authentication and authorization security
model and sends back an appropriate SOAP Response or Error Message.
SOA Monitor
As the SOA Provider executes the incoming SOAP Requests for the Oracle E-Business
Suite services at the run-time, the SOA Monitor provides the capability to audit Web
service’s SOAP Request and the corresponding SOAP Response or Error Message. The
SOA Monitor provides the information about Web service requested for, the SOAP
Request and Response details, status of the Web service response, sender’s details etc.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Integrated SOA Gateway 75
4.7.4. Release 12.1.2
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Integrated SOA Gateway 76
Enhanced Logging / Auditing and Monitoring
The logging mechanism in Oracle E-Business Suite Integrated SOA Gateway is
enhanced to provide inside-out visibility to administrators, developers, and business
analysts about any runtime errors in integration flows and focus on targeted problem
identification and resolution. The log granularity is increased, and a permanent
monitoring feature is now available for better visibility into integration transactions at
any time. Additionally, the optional audit feature provides a greater level of information
about the integration transactions.
Security Services
This feature was back-ported from 12.2.3. Refer to the full feature description under the
12.2.3 section for this product.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Integrated SOA Gateway 77
Annotation for Java Bean Services
This feature was back-ported from 12.2.4. Refer to the full feature description under the
12.2.4 section for this product.
Additionally, as part of the support for Application Module Services, annotation is
enhanced to support these services as well. This feature was back-ported from 12.2.5.
Refer to the full feature description under the 12.2.5 section for this product.
Oracle WebLogic Server 11g with Oracle SOA Suite 11g Integration
Oracle E-Business Suite Integrated SOA Gateway now uses Oracle SOA Suite 11g
running on Oracle WebLogic Server 11g to provide greater capabilities and best-in-class
SOA infrastructure for Oracle E-Business Suite. In this integration, Oracle SOA Suite
provides the most current SOA technology such as Web services standards support,
protocols, and binding, while Oracle E-Business Suite Integrated SOA Gateway
provides the integration content, such as the integration interfaces, security model, and
guidelines for best practices.
• Service Provider - In this release, Oracle E-Business Suite Integrated SOA
Gateway continues to generate and deploy Oracle E-Business Suite Web
services into Oracle SOA Suite. However, at run time the SOAP requests and
responses from Web service clients and consumers will be executed by Oracle
SOA Suite.
• Service Invocation Framework - Previously, the Service Invocation
Framework (SIF) was based on the Web Services Invocation Framework
(WSIF) provided in Oracle Application Server 10g. In Release 12.2, SIF
leverages the JAX-WS (Java API for XML-based Web Services) Dispatch from
Oracle WebLogic Server 11g.
• Service Administration
o Service Lifecycle Management - In this release, integration repository
administrators can perform the following additional service lifecycle
tasks in the interface details page of the Oracle Integration Repository:
Retire an active deployed service to ensure that current running
requests are completed while the service no longer accepts new
requests.
Activate a retired service.
Reset a service by clearing up the associated service artifact and
resetting the Web service status to its initial value (‘Not
Generated’).
o Service Monitor - The component known as SOA Monitor in earlier
releases is now called the Service Monitor. The Service Monitor fetches
data and statistics for each instance of a Web service request and
response from the underlying Oracle SOA Suite infrastructure to let you
monitor Oracle E-Business Suite Web services. You can use the Service
Monitor user interface in Oracle E-Business Suite to view the runtime
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Integrated SOA Gateway 78
SOAP request and response data received and sent from Oracle SOA
Suite.
o Log Configuration - The Log Configuration user interface is simplified
to configure design-time and run-time logs and service auditing at
interface level.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Integrated SOA Gateway 79
A REST service has a simplified development life cycle - Deploy and Undeploy. The
administrator can deploy desired operations contained in the selected API with REST
service operations, and undeploy the service if needed. REST services are deployed to
an Oracle E-Business Suite managed server without any dependency on Oracle SOA
Suite and can be used for user-driven applications, such as for mobile, tablet, or
handheld devices.
In this release, REST services are supported with the synchronous interaction pattern
only.
This feature is back-ported to Release 12.1.3+.
Security Services
Security services are a subtype of Java interfaces that can now be displayed through the
Integration Repository. They are predefined, predeployed REST services from Oracle
Application Object Library. Unlike other interface types, security services are pregranted
to all users. There is no user action needed at design time.
At run time, security services help authenticate user credentials, initialize application
sessions with context information, and authorize access privileges for authenticated
users. They are mainly used for mobile applications.
This feature is back-ported to Release 12.1.3+.
4.7.9. Release 12.2.4
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Integrated SOA Gateway 80
This feature is back-ported to Release 12.1.3+.
4.7.10. Release 12.2.5
POST is the only supported HTTP method for concurrent program REST services.
Support for Open Interface Tables and Open Interface Views as REST
Services
Oracle E-Business Suite Integrated SOA Gateway now supports open interface tables
and open interface views as REST Services through the Integration Repository. This
feature lets you directly interact with data stored in the open interface tables or open
Interface views through the associated REST services.
The supported HTTP methods are determined by the direction of the selected interface.
For open interface tables with the Inbound direction, all four HTTP methods (GET,
POST, PUT, and DELETE) are supported. This means that you can read, insert, update,
and delete data contained in the selected open interface table. For open interface tables
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Integrated SOA Gateway 81
with the Outbound direction and for open interface views, you can read or select records
from the selected interface through the GET method only.
Note that an open interface is a combination of a concurrent program and associated
open interface tables. The corresponding concurrent program can be deployed as a
REST service operation with the POST method only.
This feature is back-ported to Release 12.1.3+.
4.7.13. Release 12.2.10
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Integrated SOA Gateway 82
4.7.15. Release 12.2.12
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Mobile Foundation 83
Mobile Applications Manager User Interface
The Mobile Applications Manager user interface pages let administrators enable the
mobile apps their enterprise will use and specify configuration parameters to determine
how the apps connect to the Oracle E-Business Suite server.
Diagnostics Improvements
Users can now upload log files directly to the Oracle E-Business Suite server from the
apps, instead of sending the log files through e-mail.
4.8.4. Mobile Release 2.1
Diagnostics Improvements
The diagnostics capabilities for mobile apps include the following improvements:
Enhanced login error messages for easier diagnostics
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Mobile Foundation 84
Display of server URL and server configuration, including service version to
identify the server patch level for the mobile app
Ability to check for latest server-side configuration
Ability to upload client log file with application bundle ID as the debug log module
name for easy search and retrieval from the Oracle E-Business Suite logs page
Changes to Support Both iOS and Android with the Same Client Code
Oracle E-Business Suite apps are now available for Android devices as well as iOS
devices. Enhancements in Oracle E-Business Suite Mobile Foundation allow the same
client-side code to be used to make the apps available on either operating system.
Updates to Configuration UI
The following features provide enhanced app configuration for administrators on the
Oracle E-Business Suite server:
Ability to test configuration file from application search results page
Configuration parameters are grouped as Connection Settings
Additionally, references to the connections.xml configuration file that was formerly used
in earlier releases have been removed from the user interface.
4.8.6. Mobile Release 4.0
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Mobile Foundation 85
Customization Support for Corporate Branding
You can customize corporate branding in the apps, including changing logos to use your
company logos. To enable this customization, you must use enterprise distribution.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Mobile Foundation 86
Updated Look and Feel for Selected App Interactions
Look and feel changes include the following:
• New action icon and action list view: Apps that use an action sheet have an
updated Actions icon in the upper right corner, as well as an action sheet layout
in a list view rather than a grid layout.
• Updated styles on Android for buttons and the page title display for the
Springboard icon and Back button
• Updated launch page that displays Oracle after the login page
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Mobile Foundation 87
published in the Oracle Integration Repository, a component in Oracle E-Business Suite
Integrated SOA Gateway, where you can deploy them as REST services. You can also
deploy custom REST APIs through the Oracle Integration Repository and REST
framework for use in a custom app.
4.8.11. Mobile Release 7.0
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Mobile Foundation 88
profile and certificate from the Apple Developer Program. You can then use these to
build and deploy the iOS app through enterprise distribution.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Mobile Foundation 89
4.9. Oracle E-Business Suite Secure Enterprise Search
Note: The Oracle E-Business Suite Secure Enterprise Search feature is not offered with
Oracle E-Business Suite Release 12.2.4 and later. Oracle's strategic direction is to use
Enterprise Command Centers to deliver search and information discovery capabilities
with Oracle E-Business Suite.
For more information, see Product Obsolescence Desupport Notice for Oracle E-
Business Suite Secure Enterprise Search, My Oracle Support Document 2723756.1.
4.9.1. Overview
With the proliferation of enterprise information and the focus on security and
governance, the enterprise search market has become a key area of focus for companies
like Oracle.
Surveys have shown notable increases in overall information-related task time for
workers in academic, corporate, government, and health-care enterprises. The overall
portion of task time spent on information gathering increased on average by almost 1
hour per week. Hence the need for a complete and pervasive fast and accurate search
experience across Oracle E-Business Suite is high. The key differentiators between
enterprise search and consumer search are twofold:
• Focus on security: Users should only see search results that they have access to
or in other words confidential information is restricted to those with
permissions. Appropriate governance and audit mechanisms need to be inbuilt.
• Focus on search across multiple application modules.
Oracle E-Business Suite provides a seamless integration between Oracle E-Business
Suite data and Oracle Secure Enterprise Search (SES) engine so that users can search
across multiple Oracle E-Business Suite modules seamlessly and in a secured fashion.
A Web-based tool, Search Modeler is provided to customers as an easy-to-use
framework for application developers and enterprise data modelers to define searchable
objects and to provide full text search capability to the application users.
Key capabilities:
• Full-text search capability on Oracle E-Business Suite data to search structured
and unstructured data. Attachments are examples of unstructured data.
• Common infrastructure for Oracle E-Business Suite to crawl and index data into
the Oracle SES database.
• Search Modeler – a Web-based tool to create, modify and deploy searchable
business objects including Oracle E-Business Suite and custom applications.
• Security – object level access and data level access control
• Search refinement – refine the search criteria through narrow or expand options
and filtering options.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Secure Enterprise Search 90
• Saved Search – Users can book mark and save the search for easy access and to
eliminate any navigation.
4.9.2. Release 12.0.6 (RUP6)
Search Modeler
This feature, introduced in Release 12.1.1, was made available on the Release 12.0 line
in Release 12.0.6. The Search Modeler is a lightweight browser-based design tool used
to create, modify and deploy searchable business objects without the need for extensive
programming skills or development tools. This tool is meant to help data modelers to
rapidly create searchable business objects within Oracle E-Business Suite and custom
modules.
Search Modeler
The Search Modeler is a lightweight browser-based design tool used to create, modify
and deploy searchable business objects without the need for extensive programming
skills or development tools. This tool is meant to help data modelers to rapidly create
searchable business objects within Oracle E-Business Suite and custom modules.
Search Modeler uses the Oracle Application Object Library (AOL) metadata extensively
to reduce the time spent in designing searchable objects. It is capable of defaulting
relationships between entities, and provides validation through diagnostics. The tool
resides in a separate OC4J 10.1.3.3 home. It authenticates users against the connected
Oracle E-Business Suite instance.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Secure Enterprise Search 91
4.9.4. Release 12.1.2
UI Improvements
Information workers need to access relevant information quickly in order to make
decisions or complete transactions. Search results now include a relevance ranking to
inform users how relevant the search result is to their search criteria. This feature lets
users quickly access the most relevant information or transaction.
Oracle E-Business Suite Secure Enterprise Search allows users to display search results
in two different styles for enhanced readability, instead of the previous concatenated
display. The Classical style renders the search results in an Internet-style display. The
Tabular style renders the search results in a table or spreadsheet-like format.
Additionally, search results are now displayed with appropriate user-friendly captions to
enhance the user experience.
Users also now have the capability to sort the search results displayed in the current page
according to their needs.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle E-Business Suite Secure Enterprise Search 92
the search results, they can export the details to excel spreadsheet for further
processing.
• Inventory Items: Customers can search inventory items by part number,
specification, lot number, location and so on. They can also search based on
stock levels or any other indicator as needed. After they search the results, they
can export to excel and use the data for reconciliation with physical inventory.
Invoking Oracle Secure Enterprise Search User Interface from Oracle E-
Business Suite
Oracle Secure Enterprise Search provides advanced user interface functionality beyond
that which is available Oracle E-Business Suite within Oracle E-Business Suite. The
Oracle Secure Enterprise Search user interface offers greater flexibility for
customization and advanced features such as faceted search and clustering.
New functionality invokes the Oracle Secure Enterprise Search user interface from
within Oracle E-Business Suite and allows seamless integration between the Oracle
Secure Enterprise Search user interface and Oracle E-Business Suite.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 93
4.10.2. Release 12.2 V1
Security
Oracle Enterprise Command Center Framework enforces Oracle E-Business Suite
security for function and data access, thus providing the same support for segregation of
duties and data access controls as in other Oracle E-Business Suite components.
Responsive Design
Mobility and responsive design are built into Oracle Enterprise Command Center
Framework, so all dashboards will automatically adjust their layout to better fit a
desktop or mobile device form factor.
Advanced Search
• Wildcard Search: You can use the search operators (*) or (%) to perform a
wildcard search, in which the search results matches any text that contains the
characters between the search operators. You can also use the question mark (?)
as a wildcard to perform a single (one and only one) character search.
• Phrase Search: You can search for an exact sequence of terms by enclosing
your search terms in quotation marks (“ ”).
• Boolean and Expression Search: You can use various operators such as
AND, NOT, and OR to build complex expressions to narrow the search results.
Oracle Enterprise Command Center Framework provides the following new user
interface visualization components:
• Bubble/Scatter Chart: Scatter charts display data points, with each point
representing a dimension value. Points can also be aggregated into bins in a
binned scatterplot, or measured against a third metric and displayed as scaled
bubbles in a bubble chart. These charts are useful for showing correlations
between metrics.
• Line Chart: Line charts show one or more metric values aggregated across a
series dimension. They are useful for showing changes or trends.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 94
• Multi-metric Chart: Multi-metric charts show one or more metric values
aggregated across a series dimension. They are useful for precise comparisons of
one or more values.
• Reference Line in Chart: You can now display a reference line on a chart
based on a predefined metric.
• Attribute groups are now available to enhance data categorization and grouping
in the Available Refinements and Results Table.
Note that in this release, Oracle Enterprise Command Center Framework does not use
the Oracle E-Business Suite number format and currency format to format numbers and
currency amounts. Instead, it displays numbers and currency amounts unformatted.
Page Layout
Oracle Enterprise Command Center Framework provides the following page layouts:
• Side Navigation (default): In this default page layout, the side navigation panel
that contains the search, selected refinement, and available refinements
components is always displayed on the page.
• Collapsed Side Navigation: In this page layout, the side navigation panel is
collapsed by default and can be expanded by clicking the “Toggle Navigation
Panel” icon. When the side navigation panel is collapsed, the Selected
Refinements component is displayed as a floating icon on the page. When the
side navigation panel is expanded, this icon no longer appears.
• No Side Navigation: This page layout lets you display a page without the side
navigation panel. This layout is best suited for a landing page or home page that
will not have any navigation components. However, the Selected Refinements
component is displayed as a floating icon after any filter is applied.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 95
Search Box Enhancements
Oracle Enterprise Command Center Framework provides the following enhancements in
the search box to increase search usability:
• Look and Feel: The search box can now appear at the page level instead of in
the side navigation panel. A new look and feel gives users a better interface with
easy-to-read search term highlighting and keyboard navigation for the auto-
suggestion list.
• Search Attribute: Business users can select a context under which they want to
perform their search. The context can be configured to refer to any attribute in
the system. Inline search within the context attribute is also supported.
For example, if a user is using Oracle iProcurement and would like to shop for a
laptop, the user can select the Computer category in the Search drop-down
menu. After the user enters a search for a laptop, a specific list appears that
applies to the selected category.
• Search Behavior: If a user selects a search attribute, additional controls let the
user choose how to display the remaining values of context attributes based on
the current filter state on the page.
Users can also remove applied filters from the search box by changing their
selection from the attribute list.
• Hyperlink: A user can now search and navigate to another page and apply the
search term as a filter on the destination page.
• Condition: The search box supports applying a data set condition on the
suggestion list results.
• Delete a Tab: Administrators can delete a tab if the component contains more
than two tabs.
• Drag and Drop Components: Administrators can drag and drop page
components inside or outside the tab.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 96
Grid Enhancements
Grid enhancements include the following:
• Runtime Sorting: Business users can sort by any attribute displayed at runtime.
• Pagination Control and Selection: Pagination control and record selection can
be removed from a grid to support additional business use cases for the grid.
• Text Formatting: You can change the text style, alignment, size, and color.
Relevance Ranking
For record search only, you can control the order of the search results based on the
record score in the data set. This ranking is supported only in results tables and grids.
Data is sorted by “Score” by default. You can override this default order or add more
sort options when you configure a dashboard.
Push Model
With the push model, the client can push data or metadata to Oracle Enterprise
Command Center Framework in a compact JSON format. Using this feature, the client
extracts the data from different sources and pushes it to Oracle Enterprise Command
Center Framework.
Upgrade
You can upgrade from Release 12.2 V2 to Release 12.2 V3 without needing to reinstall
Oracle Enterprise Command Center Framework through the quick install package. The
upgrade will preserve configurations and data sets already created as well as any page
and metadata extensions you have implemented.
Cloning
You can now use cloning to back up and restore a snapshot of a working Oracle
Enterprise Command Center Framework instance. Cloning can be used to save backups,
as part of an upgrade procedure, or to add new nodes to increase high availability.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 97
4.10.5. Release 12.2 V4
Saved Search
This feature enables users to save the filters applied on a page and reapply those filters
later. For example, you can choose to save your frequently applied filters or preferred
filters. Saved searches appear in the list of search suggestions. There are three types of
saved searches:
• Public Saved Searches: Administrators can create public saved searches, which
can be accessed by all users.
• Private Saved Searches: Both administrators and business users can create
private saved searches, which can be accessed only by the user who created
them.
Refinement Breadcrumbs
The breadcrumbs feature provides an optimized display of the selected refinements as a
flat list that is always displayed. The breadcrumbs list allows easier access to and
manipulation of the selected refinements.
Chart Enhancements
In this release, Oracle Enterprise Command Center Framework provides the following
enhancements for charts:
• Line Charts:
• Bar/Line Charts:
o Multi-metric charts
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 98
Compare Enhancements
Users can compare records in a results table or grid, with attributes organized into
attribute groups if configured. Additionally, in a grid, user can take direct action from
the Compare pop-up.
Record Details
This feature displays details for a selected record or cell within a results table or grid.
The attributes displayed in a record details pop-up can be organized into attribute
groups if configured.
About ECC
The About feature provides administrators information about the current Oracle
Enterprise Command Center version, JET version, Solr version, application versions,
configuration properties, and documentation and training links.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 99
Oracle Application Framework Pop-ups
An Oracle Enterprise Command Center dashboard can include an Oracle Application
Framework pop-up that allows users to perform all required actions from the pop-up
without needing navigate away from the dashboard.
Upgrade
You can upgrade from Release 12.2 V2 and Release 12.2 V3 to Release 12.2 V4 without
needing to reinstall Oracle Enterprise Command Center Framework through the quick
install package. The upgrade will preserve configurations and data sets already created
as well as any page and metadata extensions you have implemented.
Activity Audit
A new dashboard in Oracle Enterprise Command Center Framework gives full insight
into the use of the Enterprise Command Center dashboards. It allows business analysts
and administrators to know whether dashboards are being used or not, who uses them,
which dashboards are used most, and at what times. The new dashboard also helps
generate valuable new insights into user searches.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 100
User Preferences
User preferences improve business user usability as each user can change many run-time
options in the dashboard. These changes are also preserved for future access to the same
dashboard by that user.
Cascading Breadcrumb
The Cascading Breadcrumb feature displays the current cascaded level and associated
value in a chart or tag cloud. This feature automatically matches the navigation hierarchy
through the displayed data to give the user full context.
Chart Maximization
Chart maximization lets users control the chart height at runtime. This feature provides
better readability and supports visibility for more dimensions and scaled representation
of values.
Chart Export
Users can now export a chart as an image. Additionally, users can export a CSV file
capturing data represented in a chart in a tabular format.
Export
Export is now available from charts, tag clouds, and aggregate tables, in addition to the
previously introduced export capabilities in results tables and grids.
Negative Refinements
Users can now apply negative refinement or exclude attribute values directly from the
available refinements components.
Aggregate Grid
An aggregate grid displays aggregated values in a flexible layout template. Aggregate
grids allow grouping data based on different attributes to provide more accurate views of
the data, thus acting as a one-stop shop for deriving deep insights from your data.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 101
Top and Bottom N in Chart
This feature displays a sliding window of data, allowing users to focus on what's
important and reduce information overload.
Diagrams
Business users need to trace activities in the enterprise pertaining to any business
transaction, partner, or entity. Often, in a complex operating environment, multiple
actors are involved in the business outcome. Someone reacting to a product recall,
customer complaint, missing payment, quality issues, or similar issues may need to find
the root cause of a problem that started in an upstream process far removed from where
the problem was reported. Network diagrams in Oracle Enterprise Command Center
Framework are an innovative solution for this challenging problem.
• Allow exploration of a business process from any stage of the relationship, with
the ability to explore from the beginning, end, or any other level in between.
• Let users explore multiple distinct business processes (diagrams) at once, with
the option to paginate the display per process.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 102
• Highlight the exploration starting point in a different color regardless of position
in the hierarchy, and allow retrieval of the starting point at different levels of the
diagram in one action.
• Allow change of focus dynamically from the starting business entity to any other
entity displayed in the diagram by making that entity the starting point of a new
diagram.
• Drill back from any node into related business transactions in the ERP and CRM
applications and take immediate action.
Waterfall Charts
Oracle Enterprise Command Center Framework has introduced a new chart type that
visualizes the cumulative effect of sequential or categorical positive and negative values
applied to the starting value.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 103
Condition Enhancements
Oracle Enterprise Command Center Framework now supports compound conditions
with several levels of nesting. You can specify your conditions with ease and clarity in a
redesigned configuration UI.
Value Defaulting
If a NULL value is to be shown to users in a dashboard, you can now specify a context-
sensitive default value such as “Unassigned” to serve as a user-friendly label to be
displayed in the UI. Users can use this label for refinements as well as visualizations.
In this release, network diagrams now provide the following key capabilities for users:
• Explore multiple distinct business processes (diagrams) in one flow and choose
to paginate the information displayed by process, with a preview for each page.
• Maintain the history of previous filters and interaction with the network.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 104
Enterprise Command Center Pop-up
Enterprise Command Center dashboards can now include a pop-up that allows users to
perform all necessary actions from the pop-up without the need to navigate away from
the dashboard. For more information, see section 4.1.14.4.
• Display a network diagram in a tabular format with a hierarchy which you can
expand and collapse.
• Gray out nodes that are not part of the highlight path that contributes to the
selected node.
• Use a traversal filter as a group of filters that use associations to get other nodes
related to that filter, without affecting the primary filter that has been applied to
shape the diagram flow.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 105
• Focus on the current node and display only paths that contribute to that node
while hiding other paths not related to this node.
Pivot View
Oracle Enterprise Command Center Framework has introduced the Pivot view as an
alternative view of the aggregated table to calculate, summarize, and analyze data at
different group levels. The Pivot view allows users to see comparisons, patterns, and
trends in the data.
Timeline View
Oracle Enterprise Command Center Framework has introduced the Timeline view as an
alternative view of the results table. The view of time-related events over time allows
users to analyze any patterns appearing over any selected periods and see how events are
distributed across a period.
Date Transformation
Oracle Enterprise Command Center Framework has introduced new date transformation
capabilities to make working with dates more efficient. Oracle Enterprise Command
Center Framework now transforms date and date/time data and creates a new subset of
date/time values (Year, Quarter-Year, Month-Year, Quarter, and Month). You can use
these values further or build more accurate visualizations with them.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 106
SQL Plan Diagnosability
In this release, Oracle Enterprise Command Center Framework provides diagnosability
infrastructure for data load tracking, allowing you to download and share SQL plan files
for better analysis and diagnosability.
Inline View
Enterprise Command Center dashboards can now include an inline view of a page-less
component inside a component, allowing users to get more detailed insight without
navigating away from the dashboard.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 107
progress over time. A relative date filter allows you to filter the dashboard based on a
sliding window of time and take advantage of the default saved search with the relative
date.
Redwood Theme
Oracle Enterprise Command Center Framework has adopted the new Redwood theme.
This theme includes a new color palette, font, and modernized UI.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 108
show, or reorder the items in the summary bar. The changes made to the
summary bar at runtime are stored as a user preference.
• Results Table: The enhanced runtime option empowers users to manage the
attributes used in the configuration according to their business needs. Users can
hide, show, or reorder the attributes of the results table. Any changes made
while managing the attributes are stored in the user preferences.
Trellis Chart
The new trellis chart type visualizes a series of subcharts using the same scale and axes.
A trellis chart uses three or four dimensions, which are used to visualize complex
relationships and comparisons.
Percentage Chart
The percent chart now offers an alternative visualization of a stacked bar chart in which
the relative percentage of multiple data series is stacked in bars. The total of each bar
always equals 100%. The percent chart is a hybrid between a comparison and a
composition chart.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 109
Record Selection for Results Tables
Designers can restrict the number of records that a user can select at runtime in a results
table.
Pivot Sub-summary
The Pivot feature now supports adding a sub-summary at the pivot row level. Business
users can show or hide the sub-summary using runtime options.
Badges
The color pinning feature originally introduced for charts in V6 is extended and
modernized in other detailed dashboard components. Color pinning applies badge-style
conditional formatting on categorical attributes. Numerical attributes may also support
conditional formatting by highlighting the attribute value using specific colors. The
badges highlight certain values of an attribute to draw business users' attention to them.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 110
4.10.12. Release 12.2 V11
Personalization Template
This release introduces the Oracle Enterprise Command Center Framework
personalization template, which is a pre-created Oracle Application Framework page
with a tab structure. This page has a rich content container for the Enterprise Command
Center dashboard and can be personalized at the site, application, and responsibility
levels.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Enterprise Command Center Framework 111
Hierarchical Aggregation
Hierarchical connect-by-like queries now support hierarchical aggregation.
Export Options
Exporting to a PDF file now includes diagrams, row expander components, and
hierarchical query components at the dashboard level. Additionally, exporting to a CSV
file now offers an option to exclude attribute keys, streamlining data sharing for
improved communication and collaboration.
Alphanumeric Sorting
Lookup mapping now allows for sorting based on alphanumeric values using the link
between code and meaning attributes across dashboards.
Inline Labels
Oracle Enterprise Command Center Framework components now display inline labels to
enhance form usability and user experience.
4.11. Oracle Functional Testing Suite Advanced Pack for Oracle E-Business
Suite
4.11.1. Overview
Oracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite takes
advantage of the Oracle Flow Builder module of the Oracle Functional Testing Suite for
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content DocumentOracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite 112
Oracle Applications that can help customers reduce the time and expertise needed to
create and maintain automated test scripts for Oracle E-Business Suite Release 12.1.3.
Using Oracle Flow Builder, even non-technical testers can create working test scripts
using pre-built components. Each component represents an atomic test operation such as
“create an invoice batch” or “apply an invoice hold.” Testers can assemble pre-built
components into test flows, and combine test flows with spreadsheet data to drive the
testing of multiple data conditions without a need for recording scripts.
Oracle Flow Builder includes over 3,600 pre-built components and 230 pre-built flows
designed by the Oracle E-Business Suite Quality Assurance team for their Oracle E-
Business Suite testing across all product families. Customers can leverage the pre-built
components and flows to jump-start their own test automation. The Oracle Flow Builder
framework allows customers to add, modify and extend the pre-built components to
address new functionality and customizations to Oracle E-Business Suite.
4.11.2. V1.0
Oracle E-Business Suite Pre-built Test Content for Oracle Flow Builder
Oracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite provides
the components (based on the user interface) for testing features of different products
delivered as part of Oracle E-Business Suite to be used with Oracle Flow Builder. The
components delivered in the Advanced Pack cover in-depth functionality of the products
and flows, depicting end-to-end business processes. The following products are covered
in Oracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite:
• Oracle Asset Lifecycle Management
• Oracle Channel Revenue Management
• Oracle Discrete Manufacturing
• Oracle Lease and Finance Management
• Oracle Incentive Compensation
• Oracle Process Manufacturing
• Oracle Procurement
• Oracle Project Management
• Oracle Property Manager
• Oracle Service
Oracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite also
provides components for PL/SQL APIs, open interfaces and web services.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle iSetup 113
4.12.2. Release 12.1.1
Reporting Preferences
Oracle iSetup generates reports on the functional configuration that might include
additional detail not significant to a customer for their analysis or comparison. In
Release 12.1.1, customer can define reporting preferences:
• To define additional criteria for comparison of Oracle iSetup reports. These
additions will be appended to the pre-seeded criteria.
• To limit the standard reports to relevant information.
These customer preferences for reporting or comparison can be preserved for later reuse.
The Oracle iSetup Reporter User Interface now allows user to change Report Layout
dynamically. Currently it supports Tabular & Hierarchical layouts.
The Oracle iSetup Downloadable Standard Reports feature now supports BR100 Styled
format.
The Oracle iSetup Loader auto generates deployment detail reports based on “Load
Preferences”. Deployment details capture record level details such as Inserted, Updated,
Error and Warning.
4.12.3. Release 12.1.3
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle iSetup 114
• Generic Loader API - Oracle iSetup can now upload translation data in addition
to English data. Language data can be uploaded by automatic language detection
(implicitly) as well as by upload parameter input from the UI (explicitly).
• XML Publisher API - Oracle iSetup can now move MLS (Translatable) template
files as well as localized template files.
4.12.5. Release 12.2.6
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle iSetup 115
o Costing
o Engineering
o Enterprise Asset Management
o Inventory
o Order Management
o Purchase Orders
o Quality
o Pricing
o Shipping
o Work in Progress
o Warehouse Management
• Projects Setup
• OA Personalizations
• XML Publisher
• Workflow Business Event System Objects
• Workflow Definitions
• Oracle Lease Management
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Report Manager 116
Complex Content Set
You can now use any display type in a content set, including Row/Total (RT),
Row/Expand (RE), Row/Both (RB), Column/Total (CT), and Page/Total (PT), as well as
Page/Expand (PE). Oracle Report Manager now supports complex combinations of these
display types for an account assignment in a content set definition.
With this feature, Oracle Report Manager now matches the support for publishing
reports based on all display types formerly provided in the client version of Oracle
Application Desktop Integrator (ADI).
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Report Manager 117
4.13.6. Release 12.2
Report Delivery
In addition to storing your reports in the repository, you can now also deliver the reports
to report consumers outside Oracle E-Business Suite. Oracle Report Manager supports
the following types of report delivery:
• Upload reports to an FTP server.
• Save reports to the local file system of the Oracle E-Business Suite application
tier.
• Send reports to Oracle E-Business Suite users through e-mail.
You can deliver reports as either HTML or PDF files.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Report Manager 118
Row and Column Headings in Microsoft Excel
A new profile option lets you choose to display row and column headings in the
Microsoft Excel spreadsheet when users output a report to Microsoft Excel. Row and
column headings let users easily select an entire row or column at once to perform
actions such as editing, formatting, or copying the row or column.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Report Manager 119
Simplified Report Manager Home and Menu
The Report Manager Home page has been streamlined through the use of Oracle
Application Framework simplified UI features introduced in this release, including tiles
to display the lists of requests in different statuses and a Hide/Show subtab layout for the
Report Submission and Administration links. Release 12.2.5 also introduces a new menu
hierarchy for Oracle Report Manager, with “Report Home” as the single top-level
function underneath which all other Oracle Report Manager pages are organized.
4.13.9. Release 12.2.7
Security Enhancements
Oracle Report Manager has enhanced the checks it performs to secure access to report
functionality.
4.13.10. Release 12.2.7+
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Report Manager 120
4.13.12. Release 12.2.10
Categorized Searching
Because multiple queries can be posted to the system, there is a need to simplify
querying. W3H will provide a simple user interface where the queries will be
categorized. Some possible categories are “User based queries” and “Role based
queries.” Frequently asked queries can be prominently displayed.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle User Management (UMX) 121
user have?” the system will also provide information about WHY that role was assigned
to that user and HOW the role was assigned to that user.
Reports
W3H will allow information to be saved in various formats. The supported formats will
be Microsoft Word document (DOC) and Adobe Acrobat PDF. Reports will be
generated using XML Publisher.
Since the information required can be huge, running the query and preparing the report
can take time and cause browser timeout. Therefore, W3H reports will be generated
using Concurrent Programs.
Quick Find
Developers, and sometimes system administrators, can execute queries that might not
require extensive output. For example, “Does this user have access to the System
Administration role?” W3H will provide a quick find feature in each query output so
that the user can filter the output further. Please refer to the UI section for more
information.
Snapshot
Auditors would like to know what happened in a specified period. For example, “Did
this user have access to the SALARY object during appraisal time?” The system will
allow the user to enter the date range for each type of query.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle User Management (UMX) 122
4.14.4. Release 12.2.6
Proxy Auditing
The Proxy Auditing feature provides a consolidated report for auditors to evaluate the
transactions of proxy users or any other user on a specific data object. Administrators
and delegators can run this report to see the transactions that were executed by the proxy
user on their behalf.
Responsibility HTML UI
The capability to create responsibilities is now available in an Oracle Application
Framework page. This page is equivalent to the Responsibility Define form.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Web Applications Desktop Integrator 123
4.15.2. Release 12.1.2
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Web Applications Desktop Integrator 124
• Define importer rules to specify how to move data from the interface tables to
application base tables, including any validation rules to apply before importing
data into application base tables.
• Test an integrator definition by creating a test document.
• View an integrator definition in read-only mode.
• Define a content that uses a Java program to obtain the data that the integrator
downloads into the desktop document.
4.15.4. Release 12.2
Usability Enhancements
In Release 12.2, the Oracle Web Applications Desktop Integrator user interface is
enhanced to let you perform the following tasks:
• Display a corporate brand logo in a spreadsheet created using Oracle Web
Applications Desktop Integrator.
• Use expand and collapse buttons to show and hide the Context, Headers, and
Lines regions in a spreadsheet.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Web Applications Desktop Integrator 125
Oracle Web Applications Desktop Integrator Diagnostics
You can run diagnostics tests to review the module versions and profile values currently
in use for Oracle Web Applications Desktop Integrator, and to review the metadata
defined for a particular integrator.
Flexfield Enhancements
Oracle Web Applications Desktop Integrator is enhanced to support the following
flexfield features.
• When you define a flexfield component for a key flexfield, you can specify the
column in which the flexfield’s data set is stored so that the data set is
referenced dynamically during validation.
• Additionally, when you define a flexfield component for a key flexfield, you can
specify a WHERE clause to restrict the list of values for the flexfield.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Web Applications Desktop Integrator 126
based page. You can use a profile option to specify whether you want to use the
simplified Create Document page or the previous interface, the Create Document page
flow, which guides users through multiple pages to enter the document parameters.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Web Applications Desktop Integrator 127
Security Enhancements
Oracle Web Applications Desktop Integrator has enhanced the checks it performs to
secure access to integrator functionality.
4.15.9. Release 12.2.7+
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Web Applications Desktop Integrator 128
4.16. Oracle Workflow
For information about related internationalization features, see section 3.4.
4.16.1. Release 12.1.1
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Workflow 129
Deferring Worklist Response Processing
To increase performance, a workflow administrator can optionally configure Oracle
Workflow to defer the processing of notification responses submitted through the
worklist. In this case, control is returned to a user immediately after the user submits a
response, while the subsequent activities in the workflow are executed at a later time.
You can choose to defer notification response processing for all item types or only for
specified item types. Use the Administration tab in the Oracle Workflow administrator
Web pages to configure the item types for which you want to defer response processing.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Workflow 130
within the Administrator Monitor and the Self-Service Monitor. The sizes you
can select are Small, Medium, or Large.
• You can now use the special message attribute #RELATED_HISTORY to
include the action history of another notification within response-required
notifications as well as within FYI notifications. Additionally, you can now
include the action history of a related notification in a different work item.
• A user who receives a request for more information can now transfer that
request to another user and include a comment to that user. Additionally, a
workflow administrator managing notifications through the Notifications
administrator page can now transfer a request for more information from the
user who received the request to another user, or answer the request on behalf of
the user who received the request.
• If a notification is reassigned, the sent date displayed in the notification for the
new recipient now shows the date of the reassignment – that is, the date when
this recipient first received the notification – rather than the date the notification
was sent to the original recipient. Similarly, the sent date displayed in a request
for more information now shows the date when the request was made, rather
than the sent date of the original notification.
• The Notification Details page now displays a brief status at the top of the page
indicating if another user has delegated or transferred the notification to the
current recipient, if another user has requested or provided more information, or
if another user transferred a request for more information to the current
recipient. Any comment provided by the other user is displayed as well.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Workflow 131
process messages that are being handled by a dedicated listener, but leave these
messages to be processed by the dedicated listener.
Note: For all agents other than WF_DEFERRED and WF_JAVA_DEFERRED, a
general agent listener or Java agent listener can process all messages on
the agent. For these agents there is no change from previous releases.
4.16.4. Release 12.2.3
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Workflow 132
notifications. You use a new profile option named
FND_FRAMEWORK_EXTERNAL_AGENT to specify the external web entry point
that the workflow mailer should use to generate the links. You can designate users as
external users by assigning them the new role WF_EXTERNAL_ROLE.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Workflow 133
• The behavior of the MAILTEXT, MAILATTH, MAILHTM2, and MAILHTML
notification preferences is changed to provide a choice between preferences that
include attachments and preferences that do not include any attachments. Now,
only the MAILATTH and MAILHTML preferences support attachments. The
MAILTEXT and MAILHTM2 preferences no longer support any attachments,
including the Notification Detail Link attachment, workflow attachments
defined as 'Content-Attached' message attributes, and Oracle E-Business Suite
attachments specified in the #ATTACHMENTS attribute. This change lets users
choose whether to receive the attachments in e-mail for easy access, or to save
space in their e-mail accounts by excluding the attachments from e-mail
notifications and accessing the attachment content only by logging in to Oracle
E-Business Suite.
• A new role named WF_EXTERNAL_ROLE_NOEBS_ACCESS lets you
identify external users who do not have access to your Oracle E-Business Suite
instance and should not receive the link to the notification in the Notification
Details page as an attachment. If you assign this role to a user, the Notification
Details link is not attached to e-mail notifications, even if the user selects a
notification preference that includes attachments. For example, if you send e-
mail notifications to suppliers or customers outside your own enterprise, you can
assign them the WF_EXTERNAL_ROLE_NOEBS_ACCESS role so that they
do not receive the Notification Details link.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Workflow 134
indicating that they are auto-generated. The header appears as follows:
Auto-Submitted: auto-generated
Including this header can help enable message filtering and avoid automatic responses
being returned to the notification mailer.
4.16.12. Release 12.2.11
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Workflow 135
through the UI. You can optionally choose to delete only vacation rules for that user of a
particular item type or only vacation rules for that user whose effective period ended
before a particular date.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Mobile Approvals for Oracle E-Business Suite 136
4.17.3. Mobile Release 2.1 – Client Version 1.1.0
Android Support
In previous versions, Oracle Mobile Approvals for Oracle E-Business Suite was
available only for iOS devices. Starting with version 1.2.0, the app is now available for
Android devices as well.
Translation Support
This app is available in the following languages: Brazilian Portuguese, Canadian French,
Dutch, English, French, German, Italian, Japanese, Latin American Spanish, Simplified
Chinese, and Spanish.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Mobile Approvals for Oracle E-Business Suite 137
4.17.6. Mobile Release 5.0 – Client Version 1.4.0
Attachments
You can view attachments for approval requests.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Mobile Approvals for Oracle E-Business Suite 138
4.17.8. Mobile Release 6.0 – Client Version 1.5.0
New Approvals
New approvals are supported for these functional areas: Human Resources (person status
change), Projects (project, budget), and Service Contracts.
Technical Updates
Technical updates include the following:
• The display of line details is limited to the first 50 records to enhance
performance. Users can view the full line details in the Oracle Workflow
Worklist web pages.
• Developers can configure multiple parameters for Level 2 to Level 3 drilldown
when defining approval metadata.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Mobile Approvals for Oracle E-Business Suite 139
• Technical updates with uptake of Oracle Mobile Application Framework (MAF)
2.4.0
New Approvals
New approvals are supported for Inventory Management (cycle count) and Lease and
Finance Management (contract booking, funding, and termination quotes).
New App Built with Oracle JET Available Through Web Browser
Oracle Approvals for EBS has been rebuilt using Oracle JavaScript Extension Toolkit
(Oracle JET) technology. The new app, which supports Oracle E-Business Suite Release
12.2.3 and later, is available through a URL in a web browser on a mobile device rather
than through the app stores. This version replaces the previous version of the app that
was built with Oracle Mobile Application Framework (MAF).
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle Mobile Approvals for Oracle E-Business Suite 140
The MAF-based version of the app will move to sustaining support. For details, see
Oracle E-Business Suite Mobile Apps, Release 12.1 and 12.2 Documentation Index, My
Oracle Support Document 1641772.1.
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle XML Gateway 141
4.18.3. Release 12.2.6
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Document Oracle XML Gateway 142