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

User Management Reporting

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

As part of their ongoing Sarbanes-Oxley compliance efforts, Companies have determined they needed to fully assess their process for managing user access to company resources, and have a process that could be quickly implemented to manage the entire life-cycle of enterprise identities within the organization.

dgreybarrowPrior to R12 , this was requirement

Customer wants the query to find out the relationship between User – Responsibility – Menu – Sub-menu – Function in one query.

This data is needed for the audit purpose. Their auditors wants to check for user which all functions are attached. Depending on this data they will decide what functions to remove from that user.

Considering SOX and such Auditor Requirement, in Release 12.1, there is enhancements in the user management area to provide more information on the security infrastructure, and this enhancement is a 360 degree view of the security entities and extensive reporting on these objects to ensure SOX compliance.

Fundamental questions like which users are assigned the security administrator role, who assigned the role, and what data security grants are made available.

Administrators with the UMX Security Administrator Role can now query the security infrastructure to know which users have access to what items.

The reports that are generated can be in multiple formats, and can be used for SOX compliance and run periodically.

dgreybarrow SOX Compliance RBAC Reports

  • Its report is based out of security infrastructure which includs function and data security
  • The whole concept is W3H system that means “Who, What, Why, How” which is a foundation for an auditing and querying tool for 360-degree view.

W3H system is broadly aimed at:

  • Auditors of Oracle Applications.
  • Oracle Support, who can use this tool for diagnosis
  • Developers of the Oracle E-Business suite products who would like to query the Security system.

Posted in Misc | No Comments »

Integrate with Oracle’s iPhone App

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

According to a Frost & Sullivan survey of C-level executives and IT managers, 70% of respondents rely heavily on mobile devices for business purposes. Therefore gaining popularity with iphone and ipad , companies/IT are looking different options to extending user with usage of smart application. These mobile application that allows employees to access:

  • Up to the minute reports
  • Alerts with key performance indicators
  • Workflow approvals
  • Tasks and activities

Here is a consolidated list of apps that are available till date

  • Oracle Business Indicators for iPhone provides access to Oracle Business Intelligence solutions and data in the form of requests, iBots, and alerts. Oracle Business Indicators works with Oracle Business Intelligence Enterprise Edition (OBIEE).

You must have an OBIEE setup before you can use Oracle Business Indicators. Certain features in Oracle Business Indicators can be accessed only if you have licensed the equivalent feature in OBIEE.

You can get this here.

  • Oracle Business Approvals for Managers enables managers and executives to review key targeted tasks, access relevant business intelligence reports, make informed decisions and take immediate actions easily and securely while on-the-go.

This application allows managers to handle pending E Business Suite actions related to expense reports, purchase order requisitions, human resources vacancies, and HR job offers. Managers can also use this mobile app to evaluate pending EBS approvals, request more information, and approve or reject pending requests.

You can get this here.

  • Oracle iReceipts is an enterprise application that is part of Oracle PeopleSoft Expenses, which allows users to create and submit expense lines for cash transactions in real-time.
    • This allow employees to capture cash transactions on the iPhone and iPod touch as they occur, then easily submit these transactions to Oracle’s PeopleSoft Enterprise Expenses.
    • This allows users to capture receipt images with the iPhone Camera rather than having to deal with several paper receipts. The images are then processed as normal within the PeopleSoft Expenses solution. The app can also automatically tag transactions with a user’s location using location based features

You can get this here.

For Sales guys who looking to convert their mobile phones into a productivity tool, where they can proactively work on their sales leads, sales forecasts, and opportunities these two application are most beneficial for them.

  • Oracle Mobile Sales Assistant is a CRM application provides real-time, secure access to the information a sales organization needs on the mobile device.

Key features of the application are:

  • Access to Leads, Opportunities, Contacts, and Accounts from CRM
  • Update Appointments, Tasks, Notes, and Message Center in CRM
  • Leverage native iPhone Services such as Contacts, Phone, Email
  • Mapping & Directions Integration
  • Contextual access to Social Networking Sites such as LinkedIn, Facebook, and Spoke

You can get this here.

  • Oracle Mobile Sales Forecast is an easy-to-use application that provides real-time visibility into an individual or organization’s opportunity (with details like deal size, close date, or close probability) pipeline.

Key features of the application are:

  • Filtered view of opportunities
  • Real time Forecast
  • Quick access to key data
  • Compare expected revenue to quota
  • Easy-to-use native widget application

You can get this here

  • Oracle Enterprise Asset Maintenance Workbench is an application available to help maintenance department to increase their productivity and effectiveness. The application will help field workers/maintenance engineers to take advantage of iPhone GPS capabilities to be location aware and respond to maintenance requirements in a more effective manner.

Key features of the application are:

  1. Integration with existing Oracle eAM e-Business suite application.
  2. Use GPS capability of iPhone to see current location and search assets in the Google Maps.
  3. List all assets within the search radius.
  4. View the list of released work orders for an asset and complete it remotely.
  5. View the list of work orders assigned to the user and complete it remotely.

You can get free itune here.

Looks at Licensing requirement for these usage with Oracle Products.

dgreybarrow Sofware & Licensing

Majority of Oracle Iphone apps are free and available from the Apple iTunes store, Oracle Business Approvals for Managers requires licensing of a server product called Oracle Business Approvals Connector for Managers. Also there is seperate licensing of Oracle e-Business Application Suite – Enterprise Asset Management 12.1.1 (Oracle eAM) and GIS Setup for Oracle eAM.

In Order to download the software , here are the steps.

  1. Go to
  2. Click Continue on the welcome screen
  3. Fill out the form and check the boxes for the export restrictions.
  4. Select Product Pack “E-Business Suite” and either platform of “Linux x86” or “Microsoft Windows (32-bit)”. Click Go.
  5. Click on the link towards the bottom of the page for “Oracle Business Approvals Connector for Managers 1.0 Media Pack for Linux x86” or “Oracle Business Approvals Connector for Managers 1.0 Media Pack for Microsoft Windows (32-bit)“

There will be downloads for:

6. Oracle Business Approvals Connector for Managers 1.0
7. Oracle Business Approvals Connector for Managers 1.0 : Required Oracle EBS 12.0 patch
8. Oracle SOA Suite 10g ( (32-bit) (CD)
9. Oracle Application Server 10g ( Patch set (32-bit) (CD)

dgreybarrow Similar Post

Posted in Centrestage | No Comments »

FA Tax Book Implementation

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

Tax book in FA is set up to track assets and depreciation as per you Tax laws.Basically there are two depreciation – depreciation for you accounting and financial reporting – This is based on the Corporate Book you set up and depreciation as per you tax laws – which is based on your tax book.

dgreybarrow Setup Configuration

The following setup processes are required for a Tax Book

tax book

  1. Define a Tax Book which is attached to a corporate book
  2. Define asset categories for those will be maintained in Tax Book
  3. Copy asset from Corporate Book to Tax Book for the first time. CIP Assets are not copied
  4. Copy asset from Corporate Book to Tax Book periodically

Read the rest of this entry »

Posted in Oracle Asset | No Comments »

Its all about GL Drilldown

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

dgreybarrow What is GL Drilldown

GL Drilldown feature allows users to view sub ledger transaction information for the GL journal line created by importing information from the sub ledger products. Users are able to view sub ledger transaction information for different Products using the GL Drilldown feature by navigating to the Product UI that is the source of such transaction.

The Drill Down feature is invoked by Drill Down button on Journal Review screen. The Drill Down button opens XLA Drill Down UI. The UI shows product transaction and accounting information related to journal line.

This post is another extension of my previous post.

If you are starting Drilldown from General Ledger that will takes you SLA Journal details. Typically the flow is as:

  1. Drilldown is performed from Journal lines in General Ledger, that means data is stored in the table GL_JE_LINES. The link between SLA data and data in GL is through the table GL_IMPORT_REFERENCES.
  2. This data is populated in GL_IMPORT_REFERENCES only if “Import References”¨ option is selected in the Journal source definition.
  3. Once Populated, the data can be mapped from GL_JE_LINES to GL_IMPORT_REFERENCES table using the columns je_header_id and je_lines_num.
  4. From subledger side , SLA Journal line data is stored in the table XLA_AE_LINES, which is connected with its header which stored in XLA_AE_HEADERS.
  5. Then data in GL_IMPORT_REFERENCES can be mapped to XLA_AE_LINES using the columns gl_sl_link_id and gl_sl_link_table.
  6. When Transfer happen, typically it can be done either Summary or Detail mode, which typically configure when you define the Event Class, which is attached to the Journal Line Type.
    • Take a note, if the transfer is done in Summary mode, then the Reference columns will not be populated in any of these table GL_IMPORT_REFERENCES or GL_JE_LINES
  7. Then Journal Line Type is then attached to the Journal Line Definition, which internally hookup with Subledger Accounting Method.
  8. Data from SLA, which comes to GL_INTERFACE, can then be imported in either Summary or Detail Mode.
  9. The option for summary or details is configure in the Accounting Setup Manager
  10. If you are importing data in Summary mode, then the Reference columns are populated in GL_IMPORT_REFERENCES (provided data has come in Detail mode from SLA), while GL_JE_LINES will not have the Reference columns populated.
  11. On the other hand if data is imported in Detail mode, both GL_IMPORT_REFERENCES and GL_JE_LINES tables will have the Reference columns populated (again provided the data has come in Detail mode from SLA).
  12. Table XLA_AE_LINES Column gl_transfer_mode_code gives the information for the transfer mode from SLA to GL.
  13. For the Journal Import mode, the values for specific applications is stored in the table XLA_LEDGER_OPTIONS which stores the setup for various applications for the Ledgers defined. The column indicating the Journal Import mode is transfer_to_gl_mode_code, which have three values as P (Summarized by Period), A(Summarized by Accounting Date) or D(No Summarization i.e. Detail mode)
  14. The XLA_TRIAL_BALANCES table is populated after successful journal import.
  15. You can use the different SLA reports for pulling SLA data.
  16. Last but not the least, drilldown will work from GL to all the Subledgers that are using the SLA Engine

Posted in Oracle General Ledger, Subledger Accounting | No Comments »

PMP vs AIM vs. OUM

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

If you compare PMP process group in refrence to Oracle AIM and Oracle Unified Method (OUM) here is quick compare :


Initiating Operation Analysis Inception
Planning Solution Design Elaboration
Executing Build Construction
Monitoring and Controlling Transition Transition
Closing Production Production

Posted in Methodology/Process | No Comments »

Identity Management for Oracle R12 E-Business Suite

Posted on May 20th, 2011 by Sanjit Anand ||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 ||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 »

Quick comparison: AIM Vs OUM

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

A reader asked a very good question, how OUM differ from AIM in term of deliverable ? Considering the fact of Implementation project phases how and what is percentage you can consider as per OUM curves?

If you already practiced AIM’s methodology you will not find a very big difference, majority of task and deliverable remain same, but they reclassified under different Process. Lets take a quick look, if you take first on Phases then AIM was based out of 6 phases where as OUM only 5.

Read the rest of this entry »

Posted in Methodology/Process | No Comments »

Oracle Unified Method (OUM) :Envision – Part -III

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

The OUM focus area provides a framework for development and maintenance of enterprise level IT strategy, architecture, and governance.

The Envision focus area consists of two phases:

  • Initiate

During Initiate, you perform a set of foundational tasks that have a broad range of objectives and applicability. At one end, delivering a service based on the Envision Roadmap process can establish the vision for one or more projects intended to achieve a focused set of business objectives. On the other end, Initiate phase processes can be used to establish a broad set of enterprise level IT processes that are continued in the Maintain and Evolve phase.

  • Maintain and Evolve

The processes and tasks of the Maintain and Evolve phase bring the work begun during Initiate into the day to day life of the enterprise. This phase forms the foundation for governing and managing enterprise level business processes and strategies.

Envision is organized into six processes:

  • Envision Roadmap
  • Enterprise Business Analysis
  • Organizational Change Management
  • Enterprise Architecture
  • IT Portfolio Management
  • Governance

Envision OUM

dgreybarrow Similar Post

Posted in Methodology/Process | No Comments »

Oracle Unified Method (OUM) : Manage – Part -II

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

As mention in previous post, OUM Second focus area is Manage, which provides a framework for all types of projects which can be planned, estimated, controlled, and completed in a consistent manner.

Similar to Implement , The Manage focus area (or PJM) has three phases:

  • Project Start Up Phase

The purpose of the Project Startup phase is to provide strong and clear directions for producing a product or service which delivers identified benefits or purpose for the client. During the Project Startup phase, resources are allocated to achieve specific objectives, satisfy needs, and set expectations through a planned and organized approach.

  • Project Execution and Control Phase

The purpose of the Project Execution and Control Phase is to provide adequate visibility into actual progress so that management can take effective actions when the project’s performance deviates significantly from the project plans

  • Project Closure Phase

Project Closure Phase is the last phase of the Project Life Cycle. The commencement of the Project Closure Phase is determined by the completion of all Project Objectives and acceptance of the end product by the customer. Closure of any financial issues,Collection and Completion of All Project Records & Archiving of All Project Records are typical elements of this phase.

Manage OUM

The Manage focus area is organized into 13 processes as:

  1. Bid Transition The Bid Transition process, Typically represented in Project Start Up, is in reality more of a project initiation task. The first major activity that a project manager is expected to perform is to participate in the handoff from the “sales cycle” to the “delivery cycle”.
  2. Scope Management – The goal of the Scope Management process is to identify clear boundaries of what is to be implemented and what key work products are to be produced.
  3. Financial Management – In order to control costs and provide a basis for financial monitoring and reporting, the project manager needs to plan the project costs in detail.
  4. Work Management – The objective of the Work Management process is to develop the work plan and to define and document the processes and policies to be used to execute, maintain, control and close-out the Project Workplan.
  5. Risk Management – Risk Management is a structured process for identifying, documenting, gaining agreement on, and communicating risks throughout the lifecycle of a project.
  6. Issue and Problem Management -Issue and Problem Management is a structured process for identifying, documenting, tracking, and resolving issues and problems as they occur throughout the lifecycle of a project.
  7. Staff Management – The objective of the Staff Management process is to plan resource requirements, assign roles and responsibilities, staff the project, and manage the project team.
  8. Communication Management – The objective of the Communication Management process is to regularly inform project stakeholders of the project status and continually set expectations.
  9. Quality Management – Very similar to PMI , The Quality Management process “implements the quality management system through the policy, procedures, and processes of quality planning, quality assurance, and quality control, with continuous process improvement activities, conducted throughout….”
  10. Configuration Management – The objective of the Configuration Management process is to reduce project risk by defining appropriate management and control processes for important work products including both documentation and software.
  11. Infrastructure Management – The objective of the Infrastructure Management process involves setting up the team work environment and technical infrastructure for the project.
  12. Procurement Management – The objective of the Procurement Management process is to document the procurement requirements, procure required contracted goods and/or services, and manage the procurement of the goods and/or services.
  13. Organizational Change Management – The objective of the Organizational Change Management process is to be aware of the Client’s Organizational Change Management Strategy and to effectively create a Change and Communication Plan that addresses this strategy. The goal is to create the change momentum needed to increase buy-in and reduce resistance – thus reducing productivity losses.

Next post will more focus on Envision Focus Area. Keep watching.

dgreybarrow Similar Post


Posted in Methodology/Process | No Comments »

« Previous Entries