Thursday Mar 31, 2016

UK Legislation: TYE16: Isle of Man (12.2)

The R12.2 Isle of Man Budget Changes for 2016 has been released via My Oracle Support

This patch delivers Isle of Man Budget changes for April 2016.

Please refer MOS Note ID: 2072952.1 for further details.

This is a cumulative patch, it includes the following patch:

  • 21507339:R12.PAY.C : TYE16: P11D LEGISLATIVE CHANGES FOR 2015-16

Patch Readme has important installation, setup instructions and guidelines.

If you encounter any issues with these patches, please raise a Service Request via My Oracle Support with Oracle Payroll Support in the normal way.

Wednesday Mar 30, 2016

Alternate Accounts - GL Feature That Helps Avoid Journal Import Errors

Subledger Create Accounting Program or GL Journal Import may sometimes fail due to having to transfer data into GL on an invalid account - one that was recently disabled or end-dated. 

To help avoid such errors, GL provides the feature of Alternate Accounts which gives the users an opportunity to setup a replacement code combination for an invalidated one, allowing the mentioned programs to continue until successful completion.

How to define this setup? 

Just navigate to GL > Setup > Accounts > Combinations - define your Alternate Account for the code combinations as needed:

General Ledger Alternate Accounts Sample

Where will the Alternate Account be used?

  • in  Subledger Create Accounting Program
  • in GL Journal Import process

Are there situations where Alternate Accounts can not be used?

  • they will not be considered by Subledger or GL forms where the accounts are entered by the users
  • will  not replace an account combination that has posting/budgeting disabled

I like this feature and want to know more!

Sure! Please review this useful document:

R12: How to Use Alternate Accounts in General Ledger? (Doc ID 2111940.1

Tuesday Mar 29, 2016

Webcast: 10 Tips to Improve Create Accounting Performance in Oracle E-Business Suite

Webcast_icon.jpg10 Tips to Improve Create Accounting Performance in Oracle E-Business Suite

Date: April 12, 2016 at 11 am ET, 8 am PT, 5 pm GMT, 8:30 pm India (Mumbai)

This one-hour Advisor Webcast is recommended for those working with Financial Accounting Hub and/or Create Accounting who would like to know more about the purpose and use of Create Accounting and how to resolve performance issues faced when running Create Accounting.

Topics will include:

  • Purpose & use of Create Accounting
  • Performance problems faced during Create Accounting
  • Top 10 Recommendations for better performance
  • Tips & tricks for crisis situations

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 12-Apr-16: 10 Tips to Improve Create Accounting Performance in Oracle E-Business Suite

Friday Mar 25, 2016

Recent Changes for Report Manager Affecting GL FSGs Publishing to Excel

General Ledger's Financial Statement Generator provides the option to create a large variety of custom reports based on General Ledger balances. 

Integration of Financial Statement Generator (FSG) with Report Manager and WebAdi to help publish such reports in Excel directly makes this tool even more powerful. 

Recent changes in Report Manager security code have caused FSG  to no longer publish as Excel file, generating either a template instead of the report, or simply throwing error of insufficient privileges being granted to the responsibility.

Prevent this issue from happening!

Please review these documents for details and solution:

Blank Excel Trying to Generate FSG Statement In Report Manager After JAN 2016 CPU Patch 22133441 (Doc ID 2115436.1)

Users Are Getting Insufficient Privilege Error While Trying To Open FSG Report in Report Manager. What Is The Required Menu Function To Resolve This Error? (Doc ID 2098187.1

Act now!

Thursday Mar 24, 2016

UK Legislation - Oracle E-Business Suite UK Payroll Position Statement on Introduction of Pensions Tapered Annual Allowance

Oracle E-Business Suite UK Payroll Position Statement on

Introduction of Pensions Tapered Annual Allowance

UK Legislative payroll client's have been inquiring about Oracle EBS UK payroll's position on the introduction of Pensions Tapered Annual Allowance

For clarifications the Oracle EBS has published a position statement regarding these UK pensions tax relief measures via My Oracle Support

Knowledge Management document:

Oracle E-Business Suite UK Payroll Position Statement - Pensions Tapered Annual Allowance (Doc ID 2120267.1)

Please, if you have any questions regarding this statement, direct them to us through the logging of a My Oracle Support Service Request with the product Oracle HRMS (UK). 

Monday Mar 21, 2016

Released ! 2015/2016 Year end AU.23 Australia Cumulative Release Patch

Dear Australian Legislative Payroll customers

The AU.23 AUSTRALIA CUMULATIVE RELEASE has been released.  


Patch 22847922:R12.PER.B for release 12.1.x
Patch 22847922:R12.PER.C for release 12.2.x

This patch is the minimum requirement to complete 2015/2016 End of Year processing for the Australian Legislation.

Please review the Readme MOS Document 2115036.1 as this release includes many changes (some of which have already been released separately) including but not limited to:

  • New TFN 28 day functionality
  • Third Party Payment changes to simplify this process
  • Ability to email the Payment Summary
  • Changes to Payment Summary format (minor wording changes)
  • Defined Benefit support for SuperStream

For any issues experienced with this patch please log a MOS Service Request with Oracle Support under Oracle HRMS (Australia)

Friday Mar 18, 2016

Return Material To Vendors Using R12.2's New Functionality

In R12.2, now you can return material to vendors from any Organization (org). The new enhanced functionality allows users to do the following:
• Create a return order for returned lines.
• Return material to vendors from any Organization.
– For example, If an item is received in org M1 and is moved to org M2, it can be returned to the supplier from M2 itself. In the Returns form, the user can enter the receipt org as M1 and enter the original receipt number of org M1. User will be shown receipt details of org M1 and he can return the material from M2 itself.
• Users will be able to create returns without referencing a PO or receipt i.e. return against no document.
–E.g. user can return a damaged hard drive of a laptop to the vendor even though the original PO was created for the laptop. Users will need to enter the item, quantity, supplier and other details in receipt form.

Note: This functionality is available only from R12.2 above and will not be backported to prior versions.

The simple data flow model:

To learn more about this new functionality, you can review the functional Webcast recording found in the Logistics Community: Advisor Webcast Questions? "Release 12.2 Return to Vendor with Shipping Integration" on February 24th 2016.

You can also view the Webcast information from document:
Document for this webcast: Enhanced Return to Vendor Process in R12.2.2+ (Doc ID 2109517.1)

Happy return's, and don't forget to keep an eye on our Webcast series:

  • Oracle Inventory, Product Information Management and Warehouse Management Teams Informational Webcasts (Doc ID 1290983.1)

Thursday Mar 17, 2016

UK Legislation: TYE16: Isle of Man

The  TYE16:  Isle of Man IOM Budget changes for 2016-2017 has been released via My Oracle Support.

This patch delivers the Isle of Man Legislative changes.  The patch Readme also has important installation, setup instructions and guidelines – please ensure all necessary Post Install Steps are run after the patch installation.

This patch release is for 12.1 only at this time and can be found out on My Oracle Support > Patches. 

This patches is cumulative and includes all the functionality previously released under the following patches:

Please refer to My Oracle Support Document 2072952.1:  UK legislative Changes for end of tax year 2015/16, the start of tax year 2016/17 and the Real Time Information changes effective from April 2016, P11D Changes for tax year 2015-16, Tax Year End bug fixes) for more information

As this is an HRGlobal patch, the post install driver (hrglobal.drv) will need to be executed for PER GB (Human Resource) and PAY GB (Payroll).

Additional information in regards to mandatory patching for Oracle HRMS (UK) can be found in the following MOS document:

If you encounter any issues with these patches, please raise a Service Request via My Oracle Support under Oracle HRMS (UK) - Product 1001

Defining Properties in Oracle Property Manager

In Oracle Property Manager, the term property refers to land or to built-up property. Whether your property consists of vacant land or buildings, you can define it at several levels. The property information which is defined in Property Manager can be used

  • To identify and to maintain the physical features of a property
  • To associate the property with Lease agreements
  • To assign it to employees and customers
  • To reporting purpose

Hierarchy of Properties

For built-up property, the default location hierarchy is building, floor, and office. For land, the location hierarchy is land, parcel, and section

1.  Properties: In properties window, you can define property with property name, location / address etc. Once the property is saved, you can associate existing buildings or land with it.  

Under properties, you can have

  • Building: You define buildings in the Building window, including the name, alias, tenure, and from and to dates of the building you are defining.
  • Floors: Once the building is defined, you define the names of the individual floors. You can define from and to dates for each floor, or use the dates that default from the Building window. You can also define the type of space like work space, etc.
  • Offices: Once the floor structure is defined, the next step would be to define offices. You define the individual office spaces by office number. You can define from and to dates, or use the dates defaulted from the Floor window. You can also break down the rent-able, usable, and assignable space by office number, and define the common areas, and the maximum and optimum number of occupants for a space.
2.  Land, Parcels, and Sections

Defining land is identical to defining buildings. You define land using a three-layered structure that includes defining land in the Land window, defining parcels in the Parcel window, and defining sections in the Section window. These windows contain the same fields as the Building, Floor, and Office windows.

For detailed information on how to define properties refer Property Manager user's guide.

Wednesday Mar 16, 2016

Boost Productivity & Get Answers Faster Using E-Business Suite (EBS) Analyzers!

What exactly are EBS Analyzers?  EBS Analyzers are proactive tools created by Oracle Support that review and analyze a particular EBS environment in order to:
  • Identify and provide solutions for known issues
  • Provide health checks and recommended actions
  • Act as a data collector
  • Where appropriate, highlight process flows

Each EBS Analyzer can be run as a standalone SQL script or as a Concurrent Request.  Analyzers are safe to run at any time as they DO NOT update data.   

Using EBS Analyzers helps boost productivity by allowing you to quickly and easily resolve known issues in your environment. Since our Analyzers are regularly updated to include newly identified issues and solutions, you should always make sure you are using the latest version.

How do I know what the latest version of an Analyzer is?  You can quickly see this in one of two ways:

1. The Main Content or Download the Latest Version sections of the Knowledge Document specific to your Analyzer of interest.

Download Latest Version section of Analyzer KM Doc

2.  The Compiled and Latest Version section of the Analyzer Output header.  The compiled version shows you the version of the Analyzer that you used, while the latest version icon allows you to see/download the latest available version of the Analyzer (as long as you are online).

Analyzer version information in header of output

Where can I find EBS Analyzers?  You will find a listing of the latest EBS Analyzers in Doc ID 1545562.1, Get Proactive with Oracle E-Business Suite - Product Support Analyzer Script Index. 

Do I have to download each EBS Analyzer separately?  No!  The EBS Analyzer Bundle Menu Tool (Doc ID 1939637.1) allows you to provision and maintain all your Analyzers.  The Analyzer Bundle Menu Tool is a Perl menu system that enables you to easily execute, update and install Analyzers as concurrent programs and assign them to request groups.

The tool is updated monthly to include newly released and updated EBS Analyzers.  For a complete list of EBS Analyzers currently included in the EBS Analyzer Bundle Menu Tool, see the Change Log for Bundle Zip section of E-Business Suite Support Analyzer Bundle Menu Tool (Doc ID 1939637.1).

Change Log of EBS Analyzer Bundle Menu Tool

Thursday Mar 10, 2016

Financial Information Discovery Integration with Oracle Assets

In today’s world, organizations own huge numbers of assets, which are in different locations spread across the world and assigned to different employees.  In these kinds of situations, data analysis and controlling investments on fixed assets becomes a real time challenge.  Financial Information Discovery Integration (Endeca) can assist with these challenges.

Information Discovery for Oracle E-Business Suite is an integrated application that allows enterprises to leverage information-driven navigation to discover and act on their most pressing business challenges.  The key benefits of Endeca in Oracle Assets are:

  • Increase asset utilization
    • Track assets' remaining life and depreciated values
    • Maintain, replace or sell assets based on financial metrics
  • Reduce asset cost
    • Monitor asset values and relevant additions
    • Gain visibility into asset lifecycle, value increase/decrease, movement, and resale value
  • Improve asset accounting, tracking and assignment
    • Detect and resolve GL reconciliation issues
    • Optimize asset categorization and assignment details

Enabling Endeca integration in Fixed Assets provides search capability and answers basic queries related to asset cost, remaining life, locations, and mass transactions.  Using this, users will be able to query data across multiple asset books within a single ledger.  It also provides direct integration to Purchasing, Enterprise Asset Management, Payables, and General Ledger.

The graphical interpretation of this information helps management analyze the data quickly and helps in quick decision-making.


  • E-Business Suite Financials Release 12.1.3 or 12.2.5
  • Financials Information Discovery V6

Business Flow:
Here is a glimpse of the business process followed by Endeca:


Endeca offers powerful and robust capabilities across the entire Oracle Assets process flow through:

  • Available refinements and Selected Refinements
  • Drillable graphs
  • Metrics, alerts, tag clouds
  • Actionable information pushed to users
  • Ability to review details of relevant transactions prior to taking action

Currently, it provides solutions for four main business requirements:

Asset Cost and Accumulated Depreciation – This feature provides an overview and visibility into all financial transactions affecting asset value.  Graphs in the asset cost page will enable drill-down to data to review discrepancies, analyze a root cause and take corrective action.  You can also see account balances for Oracle Assets and Oracle General Ledger side by side, which smooths the reconciliation process.

Asset Aging – Provides insight into the remaining life of assets with an easy overview of asset cost, accumulated depreciation, and net book value.  This page also provides the top 10 categories by remaining life along with metrics, pie charts and graphs on asset remaining life.

Asset Location – Provides an overview of assets across all locations and gives the opportunity to explore assignment to employees.  It also provides an actionable link to the Asset Workbench to correct employee or cost center assignment discrepancies.

Mass Transactions – Tag clouds, graphs and charts give an overview of pending transactions to be processed.  An actionable link to the mass transactions page helps to process pending transactions quickly.

For more information on what is being provided in each of the above solutions, and how to extract or refine data, refer to the Information Discovery Integration Guide.

With credit to Vaishali Karanth, Oracle Assets Support

Wednesday Mar 09, 2016

Are you new to E-Business Suite Release 12.2 ADOP?

Are you new to E-Business Suite Release 12.2 ADOP?  Would you like to learn the basics?

This note contains videos on the full ADOP patching cycle and the ADOP fs_clone phase. Check out ADOP Basic Usage Training Videos (Doc ID 2103131.1)

Tuesday Mar 08, 2016

Webcast: The ASCP Data Collections Analyzer, March 10, 2016 9:00 AM MT

Webcast_icon.jpgThe ASCP Data Collections Analyzer

Date: March 10, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India Time (Mumbai)

During this webcast we will review the latest ASCP Collections Analyzer data points. We will discuss the scope of the analyzer input/output and recommended solutions.

We will cover the analyzer execution logic and options when executing. Functional Super Users and technical staff can gain insight into the environment where ASCP Data Collections is submitted. Understanding the technical nature of the output will give one a better understanding of what to expect from a performance perspective.

Topics will include:

  • Profile Options
  • Partitions
  • RDBMS Review
  • Functional Setup
  • Source and Destination
  • Complete Review of Collection Environment

    Details & Registration

    Monday Mar 07, 2016

    Webcast: The Demantra Analyzer and Log Parser, March 9, 2016 9:00 AM MT

    Webcast_icon.jpgThe Demantra Analyzer and Log Parser

    Date: March 9, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India Time (Mumbai)

    During this webcast we will review the latest Demantra Analyzer data points. We will discuss the scope of the analyzer input/output and recommended solutions. We will cover the analyzer execution logic and options when executing.

    Functional Super Users and technical staff can gain insight into the environment where the Demantra Analyzer is submitted.

    Understanding the technical nature of the output will give you a better understanding of what to expect from a performance perspective.

    Topics will include:

    • Profile Options
    • Data Health
    • Worksheet Setup
    • RDBMS Health
    • System Dates
    • Processes

      Details & Registration

      Webcast: Iterative Periodic Average Costing (IPAC) in Oracle Cost Management, March 8,2016 9:00 AM MT

      Webcast_icon.jpgIterative Periodic Average Costing (IPAC) in Oracle Cost Management

      Date: March 8, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India Time (Mumbai)

      This one-hour advisor webcast is recommended for Oracle Cost Management functional users and consultants who are interested in the features of Iterative Periodic Average Costing.

      Topics will include:

      • Concept of Periodic Costing
      • Recursive Inter-Org Transfers
      • Iterative Period Average Costing (IPAC) - Features
      • IPAC Setup
      • Running IPAC

        Details & Registration


        Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

        Stay Connected



        « May 2016