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

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 »

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 »

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 »

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 »

Generation of GL code combinations by Sql

Posted on April 28th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Here is workaround for automatic/mass CCID generation or insertion of new CCID’s in GL_CODE_COMBINATIONS Table, when new values in Accounting Flexfield Segment are created, EXCEPT “Dynamic Insert” option activated .

you can use the api (function) -> fnd_flex_ext.get_ccid to create the ccid.

If the combination already exists, it returns the existing ccid else creates a new one and returns the id. Explicit commit command needs to be executed after calling this function.

Use below function which returns the CCID if it is exist and create the CCID if it doesn't exist in the application

 

  1.  
  2. <pre>fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
  3. key_flex_code =>'GL#',
  4. structure_number =>l_coa_id,
  5. validation_date =>to_char(SYSDATE,apps.fnd_flex_ext.date_format),
  6. concatenated_segments =>l_account);
  7.  

Read the rest of this entry »

Posted in Technical | No Comments »

Priority for Concurrent Program

Posted on September 29th, 2010 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

If you are working in big user environment, user always complain there request get stuck or takes time to start processing. Majority of time Support team cann't do anything, unless waiting or asking DBA to check the server performance.

There is couple of option you can try , if you know a demanding user and there request name( Concurrent Program) he/she always want in periority.

dgreybarrowOptions 1: If you know what particular program user required in priority.

In oracle EBS you need to set the priority of specific users so that when they run specific reports, those reports should be run on high priority. The steps are very simple:

  1. Go to Sysadmin Responsibility and go to menu Profile > System.
  2. Make sure Site and User boxes are checked.
  3. Select the user name for the user for whom you want to increase the priority
  4. Enter the following within the Profile box and click on Find: Concurrent:Request Priority
  5. Change the priority for the user as you see fit (1 is highest, 99 is lowest, 50 is the default) , Save and exit.

Concurrent Priority1

dgreybarrowOptions 2: You know the Program name, and want to make execution in priority

The steps are very simple:

  1. Login system administrator /Application developer and go to define concurrent screen
    Under Concurrent >> Program >> Define
  2. Find the Program name whose priority you wish to change for ex. "Payable Transfer to GL"
  3. On this screen you can set priority of this request by entering value in "Priority" field( as mark in red) (1 is highest, 99 is lowest, 50 is the default) , Save and exit.

Concurrent Priority

dgreybarrow Oracle definition for Priority

Priority is used to indicate the priority that the concurrent request will be assigned when it is submitted. If you do not assign a priority, the user's profile option Concurrent:Priority sets the request's priority at submission.

dgreybarrow Profile : Concurrent:Request Priority

This displays the default priority number for your concurrent requests. Only a system administrator can change your request priority.

Requests normally run according to start time, on a "first-submitted, first-run" basis. Priority overrides request start time. A higher priority request starts before an earlier request.

Priorities range from 1 (highest) to 99 (lowest). The standard default is 50.

Users can see this profile option, but they cannot update it. This profile option is visible and updatable at all four levels.

Posted in AOL, Technical | 2 Comments »

Contrasting Workflow and BPEL

Posted on May 19th, 2010 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Here is quick compare with two process modeling tool available in oracle.

 

Aspect Workflow BPEL
Repository DB Tables Message/DB
Comm. Method DB Queues XML Messages
Scope EBS All Fusion products
“Widget” Development PL/SQL /Java Web Services wrapper
Architecture Proprietary Standards Based
Versioning No Yes
Scalability Good Excellent

Suggested Read

Posted in Technical | No Comments »

Architecture Assessment

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

Architecture Assessment is a thorough and repeatable process to evaluate changed business requirements and assess their impact/risk to System Architecture:

It involve evaluation of

  • Business Architecture-Business requirement gap analysis
  • Application Architecture-Application Design & Frameworks
  • Information Architecture -System Data Model and Data Migration
  • Technical Architecture-Infrastructure, Configuration Management and Security

Posted in Functional | No Comments »

Supply Chain Management (SCM) :Techno-functional Guide

Posted on July 25th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Read this:

This article is an easy guide for Techno-functional consultant to understand SCM from Implementation as well as Oracle Application product Prospective.Lets start the topic with some of high points of earlier post .

  • As mention in earlier post a Supply Chain is a network of retailers, distributors, transporters, storage facilities and suppliers that participate in the sale, delivery and production of a particular product.
    • Make a note a supply chain is product specific, not company specific
  • Supply chain management (SCM) is a systematic approach to manage the entire flow of information, materials, and services from raw material suppliers through factories and warehouses to the end customer.
  • Moreover , SCM involves the flows of material, information and finance in a network consisting of customers,suppliers, manufacturers, and distributors.
  • You should be clear with Flow that SCM can manage :supply Chain Flow
    • The flow of actual materials, the top middle bars
      • From suppliers : flows of raw materials, intermediate products, finished goods
      • Reverse material flows : returns, repairs, servicing, recycling, disposal
    • and the information flows
      • From suppliers : manufacturing capacity, delivery schedules, promotions they have going
      • Reverse flows : sales, orders, inventory, quality, promotions
    • And finally, there are financial flows:
      • From suppliers: Credits, consignment, payment terms, invoice
      • Reverse Flows : payments, consignment
  • Supply Chain Management is the management of the entire value-added chain, from the supplier to manufacturer right through to the retailer and the final customer.
  • SCM has three primary goals: Reduce inventory, increase the transaction speed by exchanging data in real-time, and increase sales by implementing customer requirements more efficiently
  • The need for SCM is because effective Supply Chain Mgt. is the next logical step towards increased profits and market share.
  • Supply Chain Management (SCM) in line manager prospective is "let's-keep-things-moving-efficiently".

Read the rest of this entry »

Posted in Functional, Oracle Manufacturing | 3 Comments »

Page 1 of 512345

« Previous Entries