Friday Nov 29, 2013

HCM: Mexico Year End Information

Attention Mexico Payroll Customers!   We would like to make you aware of several important points.

A. Important End of Year Patch Information
B. Mandatory Patch Information for Oracle Mexico Payroll
C. Regulatory/Statutory Support for Release 11i EBS Payroll

A. Important End of Year Patch Information

Please note the following:

The Oracle Mexico (MX) Payroll Year End/Year Begin patches are released separately from the US and Canada Year End patches.
The Americas Year End patches do not contain the Mexico Year End updates.
Global customers need to apply both the Mexico Year End/Year Begin patches and the US and Canada Year End patches.

Important Year End Prerequisite Information for Mexico Payroll customers:

* HRMS Release Update Pack 11 for 12.0 (patch 16077077) is a mandatory prerequisite for Year End 2013/Year Begin 2014 for R12.0 customers.
* HRMS Release Update Pack 6 for 12.1 (patch 16000686) is a mandatory prerequisite for Year End 2013/Year Begin 2014 for R12.1 customers.

End of Year 2013 Mexico Payroll Patch Release Schedule:

The patch release schedule for 2013 Year End/2014 Year Begin patches for Oracle Mexico Payroll is as follows:

  • December 15, 2013: End of Year 2013 Phase 1
    - this patch will include Mexico payroll bug fixes and is mandatory for year end processing.
  • December 31, 2013: Year Begin 2014 Patch
    - this patch will include minimum wage and ISR Tax rate updates and is mandatory for existing customers.
  • January 31, 2014: End of Year 2013 Phase 2
    - this patch will include phase 1 and Year Begin patch content plus any other statutory update posted after Year Begin.

- This is a tentative schedule and may vary depending on the legislative postings in order to provide timely patch releases to Mexico Payroll customers.
- For complete details on the Oracle Mexico Payroll Year End Patching Schedule, see Doc ID 975677.1.

B. Mandatory Patch Information for Oracle Mexico Payroll:

For the complete R11i Payroll Mandatory Patch List, see Doc ID 941673.1.
For the complete R12.0 Payroll Mandatory Patch List, see Doc ID 941742.1.
For the complete R12.1 Payroll Mandatory Patch List, see Doc ID 941743.1

C. Regulatory/Statutory Support for Release 11i EBS Payroll

Please note that Mexico statutory legislative support for Release 11i customers ends November 30th, 2013. For further details, please see: When Is Statutory Legislative Support for Payroll Going To End For Release 11i  Doc ID 1384995.1.

Payroll World is an email distribution list for North American Oracle Payroll customers used to quickly disseminate information regarding product updates, patches, and statutory changes. To subscribe to this email distribution list, send e-mail with your contact name, CSI number, and company name to

Wednesday Nov 27, 2013

1099 Patches For 2013 US Tax Reporting Just Released!!

The 1099 US Tax Reporting patches for the 2013 tax year have now been released and are available for download from My Oracle Support.

Patch Details: 

R12.0.x: Patch 17896105:R12.AP.A:1099 CHANGES FOR YEAR 2013: R12 (12.0)

R12.1.x: Patch 17896105:R12.AP.B:1099 CHANGES FOR YEAR 2013: R12 (12.1)

R12.2.x: Patch 17896105:R12.AP.C:1099 CHANGES FOR YEAR 2013: R12 (12.2)

R11i: Patch 17925376:1099 CHANGES FOR YEAR 2013 FOR 11i(11.5.10.CU2/

Note: These patch numbers were updated on 16th Dec 2013 due to prior patches (R12 - 17842317 and 11i - 17763198) being superseded. 

For full details please review the 1099 Document that is updated every year at this time in preparation for the upcoming 1099 tax season:

Oracle Payables Plans for 2013 1099 Reporting (Doc ID 209913.1)

CRM Product Family Latest Patch Information

See the table below for latest patching information for CRM family products. 

Product Details
Lease and Finance Management Patch 17624521:R12.OKL.B - OLFM : 1213 RUP3 DELTA 16 Doc ID 1597291.1
R12.1: Payments Recommended Patch Collection (IBY RPC), Sep 2013
Doc ID 1481221.1
Sales & Marketing, Channel Revenue Management,Quoting, Order Capture and iStore
Recommended and Latest Patch Listings for Sales & Marketing, Channel Revenue Management,Quoting, Order Capture and iStore
Doc ID 1596130.2

You'll notice that the link for the Sales and Marketing product family points at a new information center note where you can find listings of all the latest patches that are released for these products.  These are dynamic listings of the patches and are updated every night, so you can be sure you can see the latest available information.

Tuesday Nov 26, 2013

Easily Understand Oracle Loans Tables – Oracle Loans Diagnostic Just Released!

Oracle Loans Diagnostic Patch 17835988 has been released to My Oracle Support for download and use with Release 12.  Using Loan ID and Responsibility ID as input parameters, the Loans Diagnostic provides details for the related loans.

My Oracle Support Communities - Helpful and Correct Answers

Do you use the My Oracle Support Communities?  Sometimes it is hard to tell if you got the information you needed! As the person asking the question, you can let the community know which replies you found correct and which ones were helpful.

By marking replies correct or helpful, you make it easier for community members to find replies that might help them in a similar situation, since your designation will change the background color of the reply to make them stand out. In addition, you are rewarding the member who posted the reply with points.

How Do I Mark an Answer Correct or Helpful?

In each reply to a question, extra options are visible to the person who posted the question. At the bottom of the reply, you can select either “Helpful Answer” or “Correct Answer.”

Build the Community’s Knowledge and Acknowledge Members that Help You

The time you take to mark your question as answered provides value to the community and expresses appreciation to the person who provided the answer that solved your problem or gave you new insight on an approach.

You may find other members follow your example, making it easier for you to find the answers you need in discussion threads too!

Read more and watch the short video in Doc ID 1180503.1 which will tell you all you need to know about helpful and correct answers.

Certain Payables GDF Patches Are Available For R12.2 Customers

The purpose of this blog is to raise awareness of GDF patch availability for R12.2.x customers and customers preparing to upgrade to R12.2.x.

Development have been actively working on generating the Generic Data Fix (GDF) patches for R12.2 customers and when they are made available they will be delivered with a .C suffix:


R12.0.x Customers would apply Patch 17714320:R12.AP.A

R12.1.x Customers would apply Patch 17714320:R12.AP.B

R12.2.x Customers would apply Patch 17714320:R12.AP.C 

At present, around 60 GDF patches are available for R12.2.x, so if the Master GDF script (Doc ID 1360390.1) detects corruption and recommends a GDF patch that is not yet released for R12.2.x, then please understand that work is currently in progress to get the remaining Payables GDF patches released for R12.2.x as soon as possible.  Until that time, customers on R12.2 can use the following workaround:


  1. Run the Master GDF script from Doc ID 1360390.1 - Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax [VIDEO])

  2. Review the output of the report to determine ig a GDF patch is required.  

  3. Determine in My Oracle Support if the GDF patch is already released for R12.2 (Check for .C version). If so, then that is the recommended patch to be applied and no further research is needed. Proceed to apply the .C version of the GDF patch.

  4. However, if the required 'GDF'.C patch is NOT available then do both of the following steps:

    a) Review My Oracle Support Doc ID 1597490.1 - R12.2.x Payables Generic Data Fixes - which advises customers to install GDF infrastructure patch 17637775:R12.AP.C.  This only needs to be done once per installation even if multiple GDF patches are required.

    b) Download the R12.1 version of the recommended GDF patch (i.e. Patch 17445464:R12.AP.B) and run the scripts from the patch as indicated in the README manually. Do not try to apply the patch as the system will prevent this due to incompatible release.

Example 1:
Customer running R12.2 - Master GDF advises they need to apply patch 17445464 to correct their data.
Patch 17445464:R12.AP.C is not available.
Customer uses workaround:

Solution: Apply Infrastructure Patch 17637775:R12.AP.C + Patch 17445464:R12.AP.B manually.

Example 2:
Customer  running R12.2 - Master GDF advises they need to apply patch 1771432 to correct their data.
Patch 17714320:R12.AP.C is available.

Solution: Customer should apply Patch 17714320:R12.AP.C.

Monday Nov 25, 2013

Mobile Field Service: Store and Forward Training

Back in July we told you about the new multi-platform functionality available for Mobile Field Service Store and Forward Multiple Platforms.  This solution allows field service technicians to remotely access customer, product, service request and task related information on mobile devices.  Technicians can continue to update their tasks, capture materials, time, expense details, access inventory levels, return, transfer and request parts, regardless of the internet connectivity and synchronize when they are online.

The details of implementing and using the MFS Multiple Platforms application are explained in Doc ID 1564644.1 but now there is also available a recorded presentation available : R12.1.3+ TOI: Implement and Use Mobile Field Service - Multi Platform Applications

The presentation covers:

  • General overview
  • Technology overview
  • Feature overview
  • Implementation tips
  • Troubleshooting tips
  • Upgrade path.

Tune in and hear the details of what's new and changed, direct from Development. 

Webcast: R12: Business Flow Accounting In Financials Accounting Hub (FAH)


ADVISOR WEBCAST: R12: Business Flow Accounting In Financials Accounting Hub (FAH)

Date:  December 12, 2013 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT

Oracle Financials Accounting Hub (FAH) is used to account for third party transactions. The Business Flow Accounting feature of FAH allows the accounting of downstream transactions (i.e., payments) to be derived based on the accounting of upstream transactions (i.e., invoices). Our discussion will focus on how to utilize Business Flow Accounting in FAH. This session is recommended for technical and functional users who have a basic understanding of the components FAH and want to learn about the Business Flow Accounting feature of FAH. We recommend reviewing Doc ID 1465987.1, Accounting for Transactions from a Custom Application Using R12 FAH, prior to the webcast.

Topics will include:

  •     Relevant Fundamentals of FAH
  •     How to use Business Flow Accounting feature of FAH to account for logically related third party transactions
  •     Demonstration of Business Flow Accounting
  •     Drill down to Subledger Accounting from General Ledger


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

Friday Nov 22, 2013

Fundamentals of Asset Move Functionality

Enterprise Asset Management, Asset Move functionality was introduced in Release 12.1.1. 

You may need to move assets from one organization (often a different location) to another organization for different reasons; for example, to replace a failed asset , or to borrow an asset for a particular job or project. The Asset Move Workbench enables you to transfer an asset and its child assets from one maintenance organization to another as a single unit, and the parent child asset relationships are preserved.

For a detailed white paper of this functionality, please refer to document: Fundamentals of Asset Move Functionality, Doc ID 1580799.1.

Thursday Nov 21, 2013

Optimizing Calculation Performance in Oracle Incentive Compensation

If you use Oracle Incentive Compensation (OIC), then new Doc ID 1600221.1- Guidelines to Optimize Calculation Performance via Oracle Incentive Compensation Settings is recommended reading.

In an effort to parallelize calculation, a single calculation concurrent request can spawn thousands of calculation subprocesses. By understanding how OIC spawns calculation, implementers can better understand how to optimize the 3 core OIC settings that drive performance in the calculation process. There are non-OIC factors, like DB tuning that drive OIC Calculation performance, but these are not the focus of the document which is focused on an understanding of the 3 core OIC settings:
  • Transaction Batch Size
  • Salesrep Batch Size
  • Number of Concurrent Managers Workers
Read more in Doc ID 1600221.1 which contains explanations of these settings and guidelines on how to set them.

Wednesday Nov 20, 2013

Transportation Management Analysis and Performance Monitoring

The OTM Analyzer is a Self-Service Health-Check script which reviews the overall footprint, analyzes the current configurations and settings for the environment providing feedback and recommendations on Best Practices. 

Benefits include the following:
  • Immediate Analysis of OTM Environment
    • Identifies Entity Data Volume
    • Identifies Database Parameter and recommendations
    • Identifies OTM processes volumes.
  • Easy to add Tool for regular Maintenance.
  • Execute Analysis anytime to compare trending from past outputs.
Please refer to the following document for additional information: ASCP Performance Analyzer script for Performance Monitoring (11.5.X and R12) (Doc ID 1579683.1).

Tuesday Nov 19, 2013

Just Released! The New iProcurement 'iP Item Analyzer'

The IP Item Analyzer (available in Doc ID 1586248.1)  is a script that you can use proactively to prevent known issues in iProcurement as well as to collect data to troubleshoot items not found in iProcurement search, with a single document or group of documents.

There are over 19 possible checks and some of the highlights include:

  • Proactive checks with recommendations to prevent known issues and severity one situations. The proactive checks include:
    • Critical patches that have not been applied
    • Invalid objects along with error message and solutions for common errors
    • Validations of setup conditions - for example, profile options that may cause search issues
  • Multiple document checks that detect problems and find solutions for a range of issues. These validations include:
    • Data corruption issues
    • Purchasing categories not mapped
    • All items that do not have a shopping category mapped to a purchasing category
  • Single document check prints all the information needed to troubleshoot the problem with the search process, including:
    • Mutliple checks to verify if item should be searchable in Procurement
    • Analyzes item on purchase orders to validate if the item will appear in the search
    • Data integrity issues

This script may be safely run at any time.  It can be used either reactively, when you are experiencing issues with a particular item, or proactively, to detect issues with all items in an operating unit from a specified date forward.  No data is created, updated, or deleted by this script.

So download the iP Item Analyzer today from  Doc ID 1586248.1 and let us know what you think by replying to the discussion thread 'Enter feedback here for the IP Item Analyzer Note:1586248.1' in the MOS Procurement Community.

Monday Nov 18, 2013

Troubleshooting CRM Integration Points

A topic that consistently comes up in CRM product family Service Requests and in MOS Communities is that of integration points between products, either between products within the CRM product family or between a CRM and an ERP product.  Often there is confusion about how that integration point should work and what to do when it doesn't!

To try and address the types of problems and queries that arise, we have been producing Integration Troubleshooting articles which address a number of different integration hotspots:
  • Integration Troubleshooting: Install Base to Service Contracts (Doc ID 1451488.2)
  • Integration Troubleshooting: Order Management to Service Contracts (Doc ID 1455545.2).
  • Integration Troubleshooting : Charges (Core Service to Order Management) (Doc ID 1589712.2)
  • Integration Troubleshooting : Charges to Installed Base (Doc ID 1443462.2)
  • Integration Troubleshooting : Charges (Core Service) to Order Management (Doc ID 1446616.2)
  • Integration Troubleshooting : Territories to Core Service (Doc ID 1519495.2
  • Integration Troubleshooting : Email Center to Core Service (Automatic SR Creation) (Doc ID 1495860.2).

The notes present information on:

  • details of the integration point, with the applications navigation
  • setup considerations
  • integration flow explanation and troubleshooting.

Integration troubleshooting note example

Let us know if you like these notes and find them useful by rating the documents using the 'Rate this Document' link Rate this document iconon the top right of every KM document, or you can mail us directly on and let us know what you want to see.

Have You Tried The Payables Community? Those That Have Love It And Now It's Easier To Find!

If you haven't tried the Payables community to answer your Oracle Payables questions lately then you need to give it a try!  

The purpose of the Payables Community is to connect people and facilitate the exchange of information, ideas and best uses of the Payables products. We hope, that as a participant, you will become closely involved with helping other users as well as receiving help quickly for issues that you post.  

Starting with My Oracle Support 6.7, that was recently released, we have made it even easier for you to get involved in the community with the introduction of the ‘Ask in Community’ button that was added to immediately to the left of the 'Create SR' Button in the Service Request region.

Ask in community

Now when a customer clicks on the button they will be taken to the 'Create a Community Post' page where they can select which community they want to post in and then enter their question. 

New Post

Some questions may have already been answered so first use the Search feature located on the top right of the page to check for solutions already available. 

You can check out the other sections with the most popular documents. These documents include vital information to help solving errors and provide products information.

The section "Payables Featured Discussions" include details about new products. You are most welcome to join these discussions by adding a question or comment. 

Have you posted a question and read a reply that helped you? If you have, you have the ability to let the person know it was helpful.  Members who posted questions are encouraged to mark replies as helpful or correct, and clicking on the icon for a correct or helpful  answer will take you directly to the question’s first reply of that type.

You can also recommend posts or documents to other Community members. When you view either a discussion reply or a document, you can click on  to tell others that you found the information valuable. The bar to the left of each item, fills with green, as the number of “thumbs up” votes increases.

Some great discussions available for you to review and participate in are:

Give the Payables Community a try next time you have a question and see for yourself how well it works! 

Friday Nov 15, 2013

VCP: ASCP Performance Analyzer Script

The ASCP Performance Analyzer is a Self-Service Health-Check script which reviews the overall Footprint, analyzes the current configurations and settings for the environment providing feedback and recommendations on Best Practices. This is a non-invasive script which provides recommended actions to be performed on the instance it was run on. For production instances, always apply any changes to a recent clone to ensure an expected outcome. 

Benefits Include the following:
  • Immediate Analysis and Output of ASCP Environment
  • Identifies Entity Data Volume
  • Identifies Database Parameter and recommendations
  • Identifies Planning process programs run time trend
  • Easy to add Tool for regular Maintenance
  • Execute Analysis anytime to compare trending from past outputs
Please refer to the following document for additional information: ASCP Performance Analyzer script for Performance Monitoring (11.5.X and R12) (Doc ID 1554183.1)


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



« November 2013 »