Wednesday Mar 26, 2014

Interested in E-Business Tax Integration with General Ledger?

Did you ever consider using Tax Journals feature in General Ledger but felt discouraged by the complex setup required, or simply did not know where to start?  We now have a simple solution for you!

A new Whitepaper was published recently on this topic: 

E-Business Tax Integration with General Ledger in Release 12 (Doc ID 1613279.1)!

This document aims to provide all required setup steps in E-Business Tax and General Ledger with the final purpose of creating Tax Journals in Oracle Applications.

Find step by step details with screenshots and examples regarding setup for:

  • Tax and Tax Regime
  • Tax Jurisdictions
  • Tax Rates and Rules
  • Transactions Processing in General Ledger
  • Useful Standard Reports
  • Table Level Details 

Sample of Tax Setup from the Whitepaper

E-Business Tax permits configuration of taxes according to local tax laws and international requirements. Integration of E-Business Tax with General Ledger allows uniformly using tax configurations for manual journals too.

Don't just READ about this setup, SEE it! 

Tuesday Mar 25, 2014

End of Tax Year Resources for Oracle UK Payroll Customers

For our Oracle UK Payroll customers, the end of the tax year (5 April) is right around the corner!

Here are a few points of reference that we hope you'll find useful.    


  • UK legislative Changes for end of tax year 2013/14, the start of tax year 2014/15 and the Real Time Information changes effective from April 2014 (Doc ID 1610646.1).
    This document contains the patch information and functional Readme for end of year, start of year, and RTI changes.

  • Oracle 11i Human Resources (HRMS) Mandatory Patches for UK Payroll (Doc ID 472794.1).
  • UK payroll mandatory patches in Oracle EBS R12 (Doc ID 551753.1).
  • UK Payroll Mandatory Patches in Oracle EBS R12.1 (Doc ID 862407.1).

    Refer to these documents for information on the UK mandatory patching requirements.

Other Information

  • EBS HCM : UK TYE SEMINAR 2014 (Doc ID 1620341.1).
    This document provides Transfer of Information presented during customer seminars in February 2014, and contains information relating to processing of End of Year and Start of Year for 2013/14 for UK payroll customers.
  • EBS UK Payroll : Real Time Information (RTI) White Paper and Patch Information (Doc ID 1324671.1).
    This document provides a central location for information related to Real Time Information (RTI). This resource page includes reference to external resources regarding HMRC requirements as well as Oracle resources to aid you in using our products and tools to accomplish the required legislative processing.  This Document is dynamic and it is expected that it is continually updated, as such please monitor this note appropriately.

If you encounter any issues with end of year processing, please raise a Service Request via My Oracle Support with Oracle Payroll Support.

Understanding Encumbrance Accounting in R12

Encumbrance Accounting has always been one of those tricky areas to understand and it is often quite complex and time consuming to resolve issues that arise.  Having a detailed understanding of how Encumbrance Accounting works in General Ledger, Payables and Purchasing will get you on the right track faster.

Recently a new document was created that attempts to pull together all the information that relates to Encumbrance Accounting so that you can understand everything from what it is, to how the applications are setup to use it, to using diagnostic tools and checking patch levels when something doesn't work just how you expect it to.

Please review R12: MASTER TROUBLESHOOTING GUIDE (MTG) for Encumbrance Accounting Issues in Oracle PO and AP (Doc ID 1578275.1) available on MyOracleSupport which discusses the following topics:  

  • What is Encumbrance Accounting
  • How does Encumbrance Accounting work in Oracle?
  • Funds Reservation Statuses on PO Documents
  • Required Setups (GL, AP, PO)
  • Seeded Oracle Reports for Encumbrance Accounting
  • Recommended Patches
  • Diagnostic Tools 
  • Hot Topics
  • More Resources 

One of the additional resources referenced within the above document is R12 Encumbrances Accounting Bulletin (Doc ID 1583781.1).  This interactive document allows you to filter the knowledge based on a topic of choice and includes Encumbrance Transactions for both Accrue on Receipt and at Period End and shows you the transactions you would see and the values of DR and CR that would be inserted into the XLA tables at the various stages.  

Together these two fantastic documents should enlighten the reader and provide a detailed understanding of Encumbrance Accounting in Oracle Applications. 

Monday Mar 24, 2014

E-Business CRM Install Base Analyzer is Now Available!

Oracle Install Base is an item instance life cycle tracking application that facilitates enterprise-wide life cycle item management and tracking capability.  In a typical process flow a sales order is created and shipped, which updates Inventory and creates a new item instance in Install Base (IB). The Inventory update results in a record being placed in the Service Fulfillment Manager (SFM) Event Queue.  If the record is successfully processed the IB tables are updated - if there is an error the record needs to be resolved so that the IB instance can be created and maintained. 

Due to various causes, everything from user setups, code bugs, or wrong data being entered, transactions can be delayed or hindered from updating the Install Base.  This can cause errors and processing delays in other modules such as Asset Tracking, Service, Contracts, Field Service and many other modules that depend on the timely and accurate update of the IB tables. 

Now you can proactively find issues before they impact your business users and customers by utilizing our newest tool -  the IB Analyzer.  See Doc ID 1597450.1 for details and to download the script.

The Install Base Analyzer is designed to make recommendations on best practices and reveal areas of concern based on your current setup and transaction statuses. It can be run manually or as a concurrent request. There are currently 24 checks (more will be added over time) for various areas such as profile and parameter setups, patching level, invalid objects, Event queue message statuses, inconsistent lot and revision control item setups, top transaction error summaries and a number of known errors and their solutions.

IB Analyzer output example

This script is a non-invasive, safe, read-only script that can be run in your Production environment.  The output is in HTML form, is user friendly and easy to navigate.  And best of all, for those problems that are identified, we provide direct links to their known solutions.  

We will continue to improve and update the IB Analyzer as we identify problem trends and common errors.  Please try out the tool and let us know what you think.  We are open to questions, comments, concerns and any ideas for improvement you may have. 

Come and see all that the IB Analyzer (Doc ID 1597450.1) can do for you today and provide us your feedback!

Get Help to Verify Your General Ledger Balances Anytime!

General ledger is the core of accounting information summarizing all financial transactions into accounts and gathering all data into balances that will be used to prepare financial statements or for various other reporting purposes. 

  • Maintaining correct balances is crucial for reporting purposes
  • Financial users may want to verify balances periodically to make sure they are accurate 

In order to gather information needed for analyzing problems related to General Ledger balances, in addition to the usual period closure activities such as running specific diagnostics from Doc ID 1416402.1 that would spot balances issues, you should also consider our Glbalfix - Gl Balances Corruption Script.

We have gathered all the useful information related to Glbalfix script, from installation to detailing all checks performed, preparation and execution along with potential errors and suggestions to spot and eliminate the root cause prior to performing any fix, in this new document:

Glbalfix: GL Balances Corruption Script - Master Note (Doc ID 1563019.2).

Once installed, the script can be safely submitted to run anytime in report mode, to verify the balances only - here's a sample output:

Glbalfix output sample

Remember, running the script does not mean it would change any data, you can use it just to verify the balances are correct! If a problem is detected, you decide further if and when to fix it!

Why don't you give Glbalfix a try?

Friday Mar 21, 2014

Purging Order Management Workflow

For maintaining a healthy workflow environment, the "Purge Order Management Workflow" concurrent request should be scheduled regularly. 

Purge Order Management Workflow Concurrent Program purges workflow items associated with Oracle Order Management, such as OM Order Line and OM Order Header. Unlike the Purge Obsolete Workflow Runtime Data program provided by Oracle Workflow, the Purge Order Management Workflow program purges workflows of closed sales order lines even if the sales order header is still open. It tries to close open workflows in a few very specific cases to make more workflow items eligible for purge. Use this purge program to reduce the size of workflow tables and improve high volume order processing performance.

Information on the use of "Purge Order Management Workflow" concurrent program, to purge closed workflows, specific to Order Management can be found in document: How To Purge Order Management Workflow, Doc ID 878032.1.

Important Message for Australia Oracle Payroll Customers


 As in previous years Oracle will endeavor to have the minimal number of patches over the months leading up to 30 June. However this year as there are a couple of large legislative changes there will be more than in past years.

Changes from 1 July 2014  (Only available on 12.0 & 12.1+ )

 As in previous years there will be a patch released around the end of May early June with changes from 1 July 2014. As these changes are dependent on the May budget exact timing cannot be provided till after the budget.

Current known changes (pending changes in budget) change to Medicare Levy rate and SGC rate (this may delayed for 2 years)

Gender Equality Reporting (Only available on 12.1+ )

An off cycle patch for Gender Equality reporting is scheduled to be available at the end of March. A white paper will be available on My Oracle Support at the same time.

SuperStream (Only available on 12.1+ )

 Oracle has decided to release two patches for SuperStream to allow customers as much time as possible to complete data capture and update their current solution.

Patch 1 – scheduled end of April. This will include data capture and superannuation processing in payroll. A high level solution overview for data capture and processing will be available in the next week or so to provide customers with as much information as possible before patch release.

Patch 2 – scheduled late June. This will include generation of XBRL file. (One XBRL file per super fund will be required)

A white paper will be available on My Oracle Support on the complete SuperStream solution around the end of April

Software developers and super clearing houses/super funds are currently working on a standard CSV file format. If this is finalized in time Oracle will also be providing a CSV file format which will be accepted by a large number of clearing houses and funds. However, the CSV file format can only be accepted for the transitional period by funds. If customers wanted to continue using this format past the transitional period they would require a third party to convert the information to the new SuperStream format.

Please contact your super funds  and clearing houses to see if they will be accepting this file format. The delivery of this is unable to be determined at this point as the ATO is still defining the file format. This may not be available in Oracle till after 1 July 2014.

Oracle will continue to communicate to customers as we move forward. As previously stated customers should be working with their super funds and super clearing houses as SuperStream delivery relies on them as well.

Thursday Mar 20, 2014

Want to See a Use Case for the iProcurement Item Analyzer – Read on!

A user reported they could not find Item f1000 when searching in iProcurement:

So they ran the iP Item Analyzer and we see that the Item did not have the Purchasable field enabled. The results below show the error and the document with the steps to fix it.

Within minutes issue resolved!

This is just one of the many uses of the iP I tem Analyzer, so don’t delay apply it today! Doc ID 1586248.1

New Whitepaper - Discrete Job Interface (WIP Mass Load)

The objective of this Whitepaper is to discuss the Work Order Interface which is used for importing Discrete Job and Repetitive Schedule information, and Discrete Job Operations, Material,  Resource, and Scheduling information from any source, using a single process.

Summary of contents :
  • Basic WIP Mass Load features
  • Sample scenarios for understanding the behavior
  • Providing clear understanding on what columns need to be fed based on requirement
  • Common interface errors

The Whitepaper can be downloaded from document: Whitepaper - Discrete Job Interface (WIP Mass Load), Doc ID 1618613.1.

Wednesday Mar 19, 2014

References for Creating Personalization in EBS CRM

Are you trying to find information about personalization in a CRM Family product?  Feeling frustrated? When CRM Users are trying to find information regarding personalizations, it is often frustrating since most information about personalizations are located in product areas other than the one you are searching in.  Personalization information from other products can be helpful in understanding how to apply a change in your page/form of interest.  

Doc ID 1616769.1: References for Creating Personalization in EBS CRM has been created to attempt to help you find relevant information.  Take a look at the note and we suggest you bookmark it for future reference as it will be updated as new pesonalization information becomes available.

Tuesday Mar 18, 2014

Check Out the ERs Included in the 12.1.3 January 2014 Rollup Patch (RUP) 18120913!

Click here to see all the Enhancement Requests (ERs) that have been included in the 12.1.3 January 2014 Rollup Patch (RUP) 18120913:R12.PRC_PF.B.

 Following is just a little snippet from the link:

Monday Mar 17, 2014

Need Assistance With A POST Mass Additions Issue?

In the last entry to the EBS Fixed Assets Support Blog, the Troubleshooting Assistant for the Create Mass Additions process was highlighted.  We also have a Troubleshooting Assistant for the POST Mass Additions process (also known by its short name of FAMAPT).  The Post Mass Additions process is the process used to post mass additions lines, making assets from those addition lines.  Alternatively, you might be making cost adjustments to assets or adding CIP assets using the Post Mass Additions process.  1610669.2

To assist with issues that you might encounter in the Post Mass Additions process, we have a new Troubleshooting Assistant (or Search Helper) to help you identify typical problems and obtain the solutions for those problems. 

  • You might have an error in the process
  • Perhaps you have encountered a performance issue
  • Maybe you are trying to merge addition lines
  • Is the list of values (LOV) for the book empty? 

Select the appropriate issue(s) in the selection window of the Troubleshooting Assistant and possible solutions will appear on the right side once you make your selection(s).

You can access this Troubleshooting Assistant by reviewing Troubleshooting Assistant: FAMAPT - Post Mass Additions (Search Helper) (Doc ID 1610669.2).

Wednesday Mar 12, 2014

Meet the Payables Period Close Analyzer!

See Doc ID 1489381.1 in My Oracle Support to learn all about our latest analyzer script "ap_pclose_detect_pkg.sql".  This script was created just for EBS: Payables, and is designed to find transactions that may be blocking the period close process from closing normally, and offers corrective actions you can take to resolve the problems yourself -- eliminating the need to contact Oracle Support for help! 

Below is an example of the HTML output produced by the Payables Period Close Analyzer (PCA):


To learn more about Global Data Fixes (GDFs) and what GDFs are available for Oracle Payables, along with information about the Period Close process in Oracle Payables, and access to other Payables PCA users, see the following:

R12: What is a Generic Datafix Patch (GDF) and what GDFs are available for Payables? [VIDEO] DocID 874903.1

R12: Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax [VIDEO] DocID 1360390.1

Best Practices for E-Business Suite Payables Period Close (one hour webcast)

The "Period Close Analyzer" thread on the Payables Community

Webcast: Understanding Trading Community Architecture (TCA) Customer Entities & User Interface


ADVISOR WEBCAST: Understanding Trading Community Architecture (TCA) Customer Entities & User Interface

Date:  March 26, 2014 at 9:30 am ET, 6:30 am PT, 1:30 pm GMT

This one-hour session is recommended for technical and functional users who use the Customer Standard User Interface in Release 12. Join us to gain an understanding of the Trading Community Architecture (TCA) Customer Standard function for maintaining customer data including party relationships, customers, organizations, and locations that belong to the commercial community in the TCA Registry.

Topics will include:

  • Main entities in the Customer Data Model
  • Customer Standard User Interface (UI) HTML pages
  • Data Quality Management (DQM) functionality in the Customer UI
  • Multiple Organization Access Control (MOAC) in the Customer Standard UI
  • Trading Community Architecture (TCA) diagnostic scripts


For more details and how to register see Doc ID 1612925.1.

Tuesday Mar 11, 2014

Planned Enhancement Requests for Inclusion in the Procurement Application Suite

The Procurement Development team is pleased to announce the first round of 'PLANNED' Enhancement Requests (ERs) for inclusion in the Procurement Suite of Applications.  Development selected these ERs based on Community Voting, number of Customers attached to the ER as a result of Service Requests (SRs) logged, and feasibility for implementation. The SRs were used in this selection process since this ER Community is only 4 months new.  Future ER selection will be based solely on the 'Voting' contained within this community space. 

To see a list of these ERs and for more information : click here


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



« April 2014