Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Oracle E-Business Suite Release 12.2.5 Highlights

Posted on July 15th, 2016 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle E-Business Suite R12.2.5 has been around for a while now. If you are still using an older version, you can think to upgrade. Having the the most up to date version of EBS guarantees that you are utilizing the latest and greatest features that Oracle has to offer.

There are some significant advances in Release 12.2 and specifically Release 12.2.5. Release 12.2.5 has many functional enhancements.

MODERN USER EXPERIENCE AND MOBILITY

Oracle E-Business Suite 12.2.5 embraces the modern look and feel of other Oracle products so that users navigating between Oracle E-Business Suite and Oracle Cloud applications can have a consistent user experience.

Key business benefits include:

  • Latest Oracle Look and Feel: Business users can leverage touch-friendly, icon-based or tab navigation as well as other new interactions and widgets
  • Tablet Optimized HTML User Interfaces: Receiving, Discrete MES Supervisor
  • Information Discovery: New Areas: Fixed Assets, Customers, Quoting, iStore, OIC, and CMRO; Mobile Templates, DFF Support, Global Search, Quick Links. Rename from Endeca Extensions

FUNCTIONAL ADVANCEMENTS ACROSS THE SUITE

Oracle E-Business Suite 12.2.5 delivers customer-driven functional advances across the integrated suite to help organizations further optimize their business processes. Key advances include:

  • Financials: Oracle General Ledger integrates with the Approvals Management framework (AME) to increase automation of journal approvals and improve governance, control and compliance. Oracle Receivables provides new methods for automated receipt application.
  • Procurement: Oracle Procurement Command Center, a new product, allows increased visibility and access to purchasing activities for more value creation. Oracle iProcurement Information Discovery helps improve buying decisions with ratings and reviews for catalog items and services. iProcurement uploads catalogs via the Oracle Supplier Network (OSN) to automate catalog management.
  • Projects: Oracle Advanced Project Planning and Control, a new product, allows increased visibility to project status for more proactive management. Oracle Projects can improve project control with a contractual schedule of values
  • Order Management and Logistics: Oracle Order Management extends support for flexible ordering of products, services, subscriptions, and warranties. Oracle Contract Renewal Command Center, a new product, helps improve visibility to service and lease renewals for higher loyalty. Flexible serial tagging in inventory and warehouse management organizations reduces overhead by capturing serial numbers only at point of use. Zone picking in Oracle Warehouse Management provides reduced idle time and improves picking efficiency.
  • Manufacturing: Outsourced Mfg, Component Availability Mgt
  • Asset Management: Map Visualization, Linear Asset Enhancements
  • Service: Oracle Service enables shared service center operation using multi-org access control (MOAC), with service execution users accessing just the service requests in their operating unit. Configurable HTML UIs in Oracle Field Service and Oracle TeleService helps increase the productivity of field service dispatchers and call center agents
  • Human Capital Management: A flexible, HTML payroll dashboard allows quick validation of payroll readiness and provides improved monitoring of payroll runs. Organizations can configure talent matrices of different dimensions to organize their talent

OPERATIONAL EFFICIENCY

  • Online Patching: Support for Simplified Dev Environments, Patching Progress Monitoring Tool
  • Technology Stack: Middle Tier Technology Checker
  • Automated System Management: Streamlined Patch Wizard Reports, Patch Wizard Export

TECHNICAL INSIGHTS

  • E-Business Suite R12.2.5, Patch 19676458 with 9 Zip files with 4.3GB in total size
  • Preliminary Pre-Requirements for R12.2.5 Upgrade
    • Oracle E-Business Suite 12.2.5 Release Update Pack requires Fusion Middleware Technology Stack (FMW) 11.1.1.7 (11gR1 PS6) or higher.
    • Apply the Latest AD and TXK Delta Release Update Packs
    • Minimum RDBMS Version is 11.2.0.4 or Higher

Posted in EBS Suite, Oracle Application | No Comments »

Windows 10 and E-Business Suite 11.5.10.2, 12.1, and 12.2

Posted on August 10th, 2015 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

From July 29, 2015, pc's are getting option to upgrade Window 10 via Microsoft's "Windows Update" delivery mechanism.

Good news for EBS Customer is "Microsoft Windows 10 ( both 32-bit and 64-bit) " is certified as a desktop client operating system for end-users accessing Oracle E-Business Suite 11.5.10.2, 12.1, and 12.2 with the following components.

  • Microsoft Internet Explorer 11 [ Certified to EBS 12.1 ,12.2 and 11.5.10.2 ]
  • Mozilla Firefox ESR 38 [ Certified to EBS 12.1 ,12.2 and 11.5.10.2 ]
  • Java Client Plugin [JRE 1.8.0_51 and higher/JRE 1.7.0_85 and higher]

All E-Business Suite customers encourged to apply all JRE updates to end-user desktops.

You can check details are Steven Chan Blog .

Microsoft Edge Browser

The Edge browser is the new browser included with Windows 10 integrated with the OS and is not a separate install under Program Files. Seems to be more of an APP.

The new default browser "Microsoft Edge" may not work and it will need some time before it gets certified.

The certification of Microsoft Edge on Windows 10 with Oracle E-Business Suite 12.1 and 12.2 is currently in progress. Most likly , there is no plans to certify anything for 11i.[ Source Steven Chan Blog]

Further Reading

  • Recommended Browsers for Oracle E-Business Suite Release 12 (Doc ID 389422.1)

Posted in EBS Suite | No Comments »

Go Mobile with E-Business Suite [Smartphone Apps]

Posted on October 17th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle has recently released 14 mobile applications for Oracle E-Business Suite. In order to support real-time business decisions and collaboration , today's increasingly mobile workforce requires instant access to targeted enterprise data and functions-wherever and whenever they want.

These mobile applications, including horizontal apps targeted for all employees as well as role-based line of business applications .

These new applications provide simple on-the-go access to horizontal functions such as:

S.N App Name Key HighLights Available as part of Licensed Product Remark
HORIZONTAL APPS FOR ALL EMPLOYEES
1 Mobile Approvals
  • Quickly filter approval requests by sender or subject
  • Review at a glance header and line details, action history, and comments
  • Approve or reject with or without comments, or request more information
  • Supports most used approval types in initial release, including expenses, requisitions, purchase orders, recruitment. More approval types to be added

Any Oracle E-Business Suite product

that uses workflow approvals

  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
2 Fusion Mobile Expenses for E-Business Suite
  • Enter expenses via quick entry, direct entry, receipt images, and calendar entries
  • Charge to projects and cost centers
  • Flag policy violations and receipt requirements
  • Download corporate card transactions and edit details
  • Enter mileage expenses
  • Submit expense reports
  • Enter expenses in connected and offline mode
Oracle Internet Expenses
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
3 Mobile Timecards
  • Enter time day-wise for easy time booking
  • Enter time in quick time or regular time modes
  • Support payroll and project based time entry
  • Aggregate day-wise entries into timecard periods
  • Submit timecards
  • View timecard history
Oracle Time and Labor
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
4 Mobile iProcurement
  • Track my requisitions for approval and delivery status
  • View requisition, approvers, lines, and shipments
  • Monitor alerts for rejections, delays, and returns
  • Collaborate in context using device features
Oracle iProcurement
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.

ROLE-BASED LINE OF BUSINESS APPS These role-based line of business applications drive faster business execution and decision making through improved visibility and access to enterprise data and functions

5 Mobile Sales Orders
  • View orders for my customer list
  • Search orders by key attributes
  • View order and line details and status (customer, product, pricing, holds, shipping)
  • Monitor shipment alerts (on hold, backorder)
  • Collaborate in context with device features
Oracle Order Management
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
6 Mobile Inventory
  • Search and barcode scan items and LPNs
  • View on-hand materials and LPNs across facilities
  • Identify loose vs. packed material
  • View existing material reservations
  • Identify material moves in a facility
  • View in-transit and received material
Oracle Inventory Management
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
7 Mobile Product Information
  • Search or scan items
  • Easily access favorite and recently viewed items
  • View product operational and user-defined attributes
  • View product images
  • View suppliers and on-hand quantities in list or map
  • View key transaction metrics, related to SOs, POs, WOs
  • Personalize what information is displayed
  • Collaborate in context using device features

Any Oracle E-Business Suite product that defines or uses Items.

Items are defined in an item master organization to represent products and services you buy, sell, or otherwise transact.

  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
8 Mobile Procurement
  • Track purchase orders requiring attention
  • Search purchase orders based on key attributes
  • View purchase order, approvers, lines, and shipments
  • Monitor alerts for shipment delays
  • Collaborate in context using device features
Oracle Purchasing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
9 Mobile Project Manager
  • Monitor overall project status in dashboard
  • Contact team members and customer contacts
  • View open payables summary and invoices
  • View open receivables summary and invoices
  • View open issues and change orders
  • Collaborate in context using device features
Oracle Project Costing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
10 Mobile Discrete Production Supervisor
  • Search or barcode scan work orders to view progress
  • View work order and operations detail
  • Perform quick actions like expedite and add notes
  • View component issue and resources charges
  • Manage exceptions like component shortage
  • Collaborate in context using device features
Oracle Discrete Manufacturing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
11 Mobile Process Production Supervisor
  • Search batches and steps or barcode scan to view WIP
  • View batch, steps, material, and resource detail
  • Perform quick actions like release and reschedule
  • Manage exceptions like unallocated ingredients
Oracle Process Manufacturing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
12 Mobile Project Manufacturing
  • Search project inventory by item, project, and task
  • View project on-hand quantities by locator
  • View outstanding project borrow and payback transactions
  • Identify project materials for transfer and borrow/payback
  • Collaborate in context with device features
Oracle Discrete Manufacturing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
13 Mobile Maintenance
  • View and complete assigned operations
  • Issue materials and charge time to operations
  • View and search work orders and assets
  • View asset summary, work history, and meter readings
  • Record asset meter readings
  • View work request details
  • Create simple work orders and work requests
Oracle Enterprise Asset Management
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
14 Mobile Field Service
  • View customer, product, service request, and task info
  • View and update tasks
  • Capture materials, time, and expense details
  • Check inventory levels
  • Return, transfer, and request parts
  • Work online or disconnected
  • Synchronize when online
Oracle Mobile Field Service
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.

For app availability search ‘Oracle EBS America’ on app store

Oracle E-Business Suite mobile applications are extremely easy to use, resulting from a user-centered design process and user experience (UX) design principles based on simplicity, action ability, consistency, and device integration.

Oracle E-Business Suite mobile applications are built using Oracle Mobile Application Framework .

Oracle MAF framework accelerates and simplifies mobile development with the ability to build once and deploy to multiple platforms, providing tight integration with camera and other device services, device-native user experience, and enables end-to-end encryption and security

This framework accelerates and simplifies mobile development with the ability to build once and deploy to multiple platforms, providing tight integration with camera and other device services, device-native user experience, and enables end-to-end encryption and security

  • EBS Mobile Apps Documentation: Note 1641772.1
  • EBS Mobile Apps Administrator's Guide: Note 1642431.1

Posted in Oracle Application, Oracle Order Management, Oracle Payable, Oracle Pricing, Oracle Product, Oracle Purchasing, Technical | No Comments »

Oracle E-Business Suite 12.2.4 is Now Available!

Posted on August 18th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle E-Business Suite 12.2.4 Helps Organizations Further Optimize Business Processes, Reduce Costs, and Respond to Changing Market Conditions.
This Release includes and focus on customer-driven enhancements across virtually all functional areas and new cloud integrations

Also, this Release Update Pack (RUP) for the EBS 12.2 release codeline includes new features as well as statutory and regulatory updates, and error corrections for stability, performance, and security.

Some of the introducing enhancements listed as below:

  • Oracle Financials: Faster approval cycles from parallel approval of invoices. A single mass allocation formula is used to generate allocation journals for all ledgers in a ledger set. Integration with Oracle Revenue Management Cloud allows users to leverage the revenue compliance and recognition benefits of that product.
  • Oracle Lease :The following features of Oracle Lease and Finance Management have been added or changed
    • Enter Interim Payments for Assets, Fees and Services
    • Author Contracts with New and Re-Leased Assets
    • Author Variable Rate Contracts with Additional Interest Rate Conventions
    • Update Default Asset Salvage Values
    • Revise Variable Rate Contracts
    • Enhanced Security Deposit and Contract Termination Processing
    • Enhanced Pass Through Processing for Fees and Services
  • Oracle Projects: Enhancements includes Oracle Project Contracts and Oracle Project Billing allow US federal contractors to improve cash flow, increase transparency and audit, and automate billing.
  • Oracle Purchasing: Web ADI–enabled spreadsheet creation and modification of purchase order lines, schedules, and distributions improves buyer productivity when dealing with large orders.
  • Oracle iProcurement: A streamlined single-step checkout flow allows employees to quickly complete shopping activities and start the requisition approval process.
  • Oracle Procurement Contracts: Improved buyer efficiency from auditing of contract documents by reviewing details of policy deviations and net clause additions.
  • Oracle Services Procurement: Enhanced capabilities provide buyers with greater flexibility to support a broad range of complex order scenarios.
  • Oracle Channel Revenue Management: Improved volume offer capabilities and a streamlined user interface enable users to quickly adapt to changing business conditions.
  • Oracle Order Management: A new HTML user interface provides improved usability, greater flexibility, and a more modern user experience.
  • Oracle Yard Management: A new solution enables manufacturing, distribution, and asset-intensive organizations to manage and track the flow of trailers and their contents into, within, and out of the yards of distribution centers, production campuses, transportation terminals, and other facilities.
  • Oracle Manufacturing: Significant usability improvements in the Oracle Manufacturing Execution System (MES) help improve operator productivity by simplifying time entry and quality collection. New capabilities to manage the auto-dekit (disassembly) of serialized products supports customer returns and internal reuse of component parts.
  • Oracle Enterprise Asset Management: Enhancements to support linear assets in industries, such as oil and gas, utilities, and public sector, help improve productivity and retire costly integrations and custom code.
  • Oracle Service: Enhanced spare parts planner’s dashboard provides rich user interaction to improve planner productivity.
  • Oracle Value Chain Planning: Numerous enhancements across multiple products include deeper industry functionality, such as minimum remaining shelf-life enhancements for the pharmaceutical and consumer goods industries, multistage production synchronization for process industries, and integration between Oracle Service Parts Planning and Oracle Enterprise Asset Management for asset-intensive industries. New promotions planning analytics in Oracle Advanced Planning Command Center improve business insight.
  • Oracle Payroll: Payroll dashboard provides at-a-glance readiness checks, validation, and analytical views of the entire payroll cycle to help payroll administrators gain valuable insight into payroll processes, avoid costly errors, and improve productivity.
  • Oracle Self-Service Human Resources: Transaction dashboard helps employees and managers monitor the approval progress of self-service transactions, and review transaction details at any point after final approval.
  • Oracle Learning Management : Enhanced user interface simplifies the learner’s ability to search the training catalog, engage in learning activities, and share experiences with fellow learners.

The details for downloading and applying the Oracle E-Business Suite 12.2.4 Release Update Pack can be found in the Oracle E-Business Suite Release 12.2.4 Readme (Doc ID 1617458.1).

Posted in EBS Suite | No Comments »

Introduction to Oracle MAF (Mobile Application Framework)

Posted on July 27th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In June 2014, Oracle unveiled Oracle Mobile Application Framework.

Oracle Mobile Application Framework is a hybrid mobile framework that enables developers to rapidly develop single-source applications and deploy to both Apple's iOS and Google's Android platforms.

Features include support for multiple integrated development environments, including Oracle JDeveloper and Eclipse (through Oracle Enterprise Pack for Eclipse); support for multiple development languages, support for Apache Cordova plug-ins; and support for applications developed under Oracle ADF Mobile.

Oracle recommends that new mobile application development be done with the new Oracle Mobile Application Framework. Some Key Highlights Includes:

  • Build Once, Run on Multiple-Platforms
  • Simpler UI development
  • Java, JavaScript, and HTML5-based application development
  • Choice of development tools
  • Offline-capable: SQLite with Encryption
  • Full Access to Native Device Features
  • Modular, Reusable Components

Oracle MAF – Business Benefits

  • Increase mobile development speed
  • Eliminate mobile skills shortage – use existing skill sets
  • Complete solu)on out of the box
  • Extensible

Here is Oracle Mobile Application Framework Architecture [ Adopted from www.Oracle.com ]

Oracle Mobile ApplicationFrameworkArchitecture

Here is YouTube lesson, for More insights.

Additionl Note

Posted in Centrestage, Emerging Technologies, Technical | No Comments »

Revert R12.1.3 Homepage Layout to Link Style as in R12.1.1 or 11i

Posted on May 7th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

If you are using R12.1.2 , user may report some difficulty with Homepage responsblity , therefore they prefer similar to 11i or R12.1

In release 12.1.2 the E-Business Suite homepage has been re-designed using the configurable pages infrastructure.

This is new Enhancement which allows customers to work with a WYSIWYG model of configuration. This allows highly flexible content and layout including the ability to add and move content around the homepage to suit your needs.

These configurable home page provide a new and improved navigator tree which has expandable menus using richer and faster ajax calls and requests are kept within the sidebar to save valuable homepage space. The new tree also eliminates full page render of server-side requests therefore enhancing performance.

hanging menu

What If , you want to Revert back this options. Here are some notes, from our DBA who helped to achieve this.The above changes will result in the expandable menus changing to the older 'link style' menus.

Set the following profiles:

  • FND: Applications Navigator Menu Consolidation count : 25 – old is Null
  • FND:Slide out menu: Enabled – old is disable
  • Enable Configurable Home Page: No
  • FND: Personalization Region Link Enabled: Yes
  • FND: Disable Configurable Home Page: True — old is false

You can refer to Note :1061482.1: 12.1.2: How to Modify and Enable The Configurable Home Page Delivered Via 12.1.2 for more details.

Posted in EBS Suite | No Comments »

Oracle Environmental Accounting and Reporting [ EAR] -Solution for capturing and reporting environmental and emissions data

Posted on February 19th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In Release 12.1.3 of the eBusiness Suite, Oracle included an Environmental Accounting and Reporting application.

Environmental Accounting and Reporting (EAR) enables to record and account for activities that have an impact on the environment. It provides the ability to store date effective energy consumption and emissions by location that are later used for environmental reporting.

EAR provides several flexible means to record environmental data through the use of standard transactions , such as invoice processing, inventory issues, batch entry, and manual
data entry.

Supported by a built-in emissions calculation engine that takes the emission factors, the emission sources and the transactional data, it computes the CO2 equivalent and the inventory usage, and stores the data where all the reporting is then done, the Environmental Data Ledger.

It allows the classification of green house gas (GHG) emissions data by Scope 1, 2, or 3 [ see more details at the end] , and also by standard industry codes

The application was originally built by an Australian company NDEVR and subsequently acquired by Oracle . [ Source Oracle Website]

Oracle Environmental Accounting and Reporting is an add-on module to Oracle E-Business Suite and provides multiple modes to capture environmental data, a GHG emissions accounting engine, and pre-built dashboards and reports to:

  • Record, account, track, and report activities that impact the environment.
  • Participate in voluntary GHG monitoring and disclosure programs such as Carbon Disclosure Project.
  • Identify opportunities to improve energy efficiencies and reduce GHG emissions.
  • Recognize and undertake early voluntary actions for reducing greenhouse gas emissions.
  • Fulfill mandatory GHG reporting requirements enforced by global and local legislations.
  • Enhance shareholders confidence as an environmentally conscious organization.

Some of the key features of Oracle EAR that allow you to achieve the above are:

  • Store date effective energy and emission factors for location specific GHG accounting.
  • Maintain an emissions audit data trail in the Environmental Ledger for a time based analysis, reporting, and statutory auditing requirements.
  • Classify GHG emissions data as Scope 1, 2, or 3 and by standard industry codes. Refer to the Setting Up chapter for more information on Scopes.
  • Configure organization hierarchy to meet specific analysis and reporting needs of the enterprise.
  • Record environmental data through several flexible means – through ERP transactions, manual batches or import using WebADI templates.
  • Report emissions data using Oracle Business Intelligence dashboards.
  • Define KPIs for tracking an enterprise’s sustainability performance.

Technology Overview

Oracle Environmental Accounting and Reporting uses the following Oracle technologies:

  • Oracle Business Intelligence Enterprise Edition (OBIEE).
  • Oracle E-Business Suite (EBS) Technology Stack.
    • Following applications of Oracle E-Business Suite to be able to run the EAR application:
      • Oracle System Administration
      • Oracle Inventory
      • Oracle General Ledger
      • Oracle Human Resource Management System
      • Oracle Payables
      • Oracle Assets
      • Oracle Projects
  • Oracle Data Integrator (ODI).

Oracle Environmental Accounting and Reporting

The centre of the diagram [ Fig 1] shows the environmental ledger [ CHG Ledger] – the central storage for EAR, which is supported by a number of configuration screens.
The top section of the diagram shows how environment source data may be collected from:

  • Oracle Payables (e.g. from electricity invoices which show usage statistics)
    • EAR integrates with Oracle Payables to capture data while processing Invoices with or without Purchase Order match, related to the supply and use of products and services that have environmental impact.
  • Oracle Inventory (e.g. if you have an onsite petrol bowser)
    • EAR integrates with Oracle Inventory to record data related to the issue of Items to Assets that result in environmental emissions
  • The Environmental Transaction Batches window (manual data entry specifically related to environmental sources)
  • Or upload data from spread-sheets using Oracle WebADI Templates (e.g. from data extracted fromother systems)
  • EAR leverages Oracle Data Integrator (ODI) to transfer the data from the Environmental Ledger to the Environmental Data Warehouse. The Oracle Business Intelligence application uses the data for environmental reporting through the pre-built dashboards and reports.
  • EAR enables you to record environmental transactions involving the issue of items, to assets defined in the Oracle Assets application.
  • EAR allows you to map Environmental Organizations to projects and tasks defined in Oracle Projects. While processing Invoices that have references to projects and tasks, EAR uses this information to identify organizations to calculate and store environmental data based on the projects and tasks mapped to the organization.

Environmental Reporting Overview

Oracle Environmental Accounting and Reporting provides the following pre-built dashboards to report the source usage, emissions data, carbon disclosure, and KPI measures for organizations:

  • Emissions
  • Energy
  • Metrics
  • Reporting
  • Summaries
  • Test
  • Transaction
  • Usage

Categorization of Emission Types

  1. Scope 1 : Direct GHG Emission from sources owned or controlled by the organization (i.e. gasoline that is put into a fleet of vehicles owned by the organization)
  2. Scope 2 : Energy Indirect GHG Emission from the generation of imported electricity, heat or steam consumed by the organization (i.e. electricity or gas bought by the organization)
  3. Scope 3 : GHG emission that arises from GHG sources that are owned or controlled by other org anizations (i.e. business travel)

Additional Reference

  • Oracle Environmental Accounting and Reporting User's Guide 12.1 (# E23439-02)
  • MOS 1327248.1 - Oracle Environmental Accounting and Reporting Release Notes 12.1.3

Posted in Functional, General Interest, Oracle Application | No Comments »

Secure Configuration of Attachments

Posted on March 14th, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

This post is just a notes after a issue popup on attachments . Key profile options details is highlighted here.

1) File Upload Limits for Attachments

  • Set Profile: Upload File Size Limit (UPLOAD_FILE_SIZE_LIMIT)
    • Limits the maximum Attachment file size that can be uploaded
    • Specified in KB (e.g. 2000KB)
  • Allowing unlimited attachment sizes can allow for a Denial of Service attack (DOS)

2) Attachments file type extension validation

  • Set Profile: Attachment File Upload Restriction Default
    • Yes (default): Black list behavior – Disallow types marked as ‘N’
    • No (recommended): White list behavior – Only allow types marked as ‘Y’
  • Validate attachments file type extensions
    • New column - FND_MIME_TYPES. ALLOW_FILE_UPLOAD – values N & Y

This was Delivered as part of January 2012 CPU

3)Tag scanning of HTML Attachments

  • Set Profile: FND: Disable Antisamy Filter
    • False (default / recommended) – sanitize HTML pages
  • OWASP Antisamy – allows a specific (white list) of HTML elements and attributes
    • Error Message if uploaded HTML file was modified:

This was delivered as part of January 2012 CPU

Refernce :

  • MOS Note 604458.1: How to Limit The Attachment File Size?
  • MOS Note 1357849.1: Security Configuration Mechanism in Attachments
  • MOS Note 1357849.1: Security Configuration Mechanism in Attachments

Posted in EBS Suite | No Comments »

Identity Management for Oracle R12 E-Business Suite

Posted on May 20th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle Identity Management (OIM) is an integrated system of business processes, policies and technologies that enable organizations to facilitate and control their users' access to critical online applications and resources -- while protecting confidential personal and business information from unauthorized users. It supports user authentication, authorization and provisioning.OIM suite of products now has been extended to support the Oracle R12 E-Business Suite of ERP applications

In summary, Oracle Identity Management includes the following products and applications:

  • Oracle Internet Directory (OID): Oracle Internet Directory is an LDAP server for authentication between Oracle R12 EBS and third party LDAP servers such as Microsoft Active Directory.
  • Oracle Access Manager (OAM): OAM provides additional security authentication for identity management which basically replacing previous Oracle Single Sign On (OSSO) as future solution for single sign on authentication product.
  • Oracle Adaptive Access Manager (OAAM) :Oracle Adaptive Access Manager (OAAM) is the complementary identity management solution which is part of the Oracle Identity Management (OIM) suite of Oracle Fusion Middleware products.
  • Oracle Virtual Directory (OVD) :Oracle Virtual Directory provides LDAP virtualization directory services with Oracle Identity Management products to authenticate LDAP resources between Oracle database and Oracle EBS applications. As such OVD functions to
    integrate Oracle applications in a secure environment.

Posted in Technical | No Comments »

EBS Maximum Attachment Size

Posted on May 16th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

When you are trying to upload any attachment in EBS via iProc or iexpense or isupplier or istore, Take a note there is no limit to the file size of an attachment; however, the 2-4 GB limitation of a LOB could be considered the limitation of an attachment file.

You can also limit the file size by setting the Profile Option on site level:

'Upload File Size Limit'

Normally, any file upload within OA Framework observes this profile option value.

The 'Upload File Size Limit' profile option is being interpreted as bytes instead of kilobytes by the forms application.This profile option is being interpreted correctly by the framework interface but not interpreted correctly via the forms interface.

It specifies the maximum allowable file size in KB for uploaded attachments.For example, if the limit is 2MB, this value should be set to 2000.

Posted in Technical | No Comments »

Page 1 of 812345678

« Previous Entries