Thursday Nov 29, 2012

Mexico Minimum Wage Changes - Payroll Patches Available

Mexico has published new Minimum Wage values effective November 27th 2012.  

The following Payroll patches have been released to update the Minimum Wages:

 Release  Patch Number
 11i Patch 15919087
 12.0.x Patch 15920839:R12.PAY.A
 12.1.x Patch 15920839:R12.PAY.B

Please note the following:

  • the Minimum Wage values have been updated and they are effective from November 27th 2012
  • these patches are different from all other statutory updates (there are additional post installation steps), so please be sure to carefully read the entire patch readme before beginning to install these patches to ensure successful processing.

Monday Nov 26, 2012

Hot Off the Presses! Get Your Early Release of the December Procurement Newsletter!

Get all the recent news and featured topics for the Procurement modules including Purchasing, iProcurement, Sourcing and iSupplier. Find out what Procurement experts are recommending to prevent and resolve issues.  Webcast information and important links are also included.  The December newsletter features articles on:

  • Maximizing your search results to include the Procurement Community
  • Concurrent Processing Analyzer
  • Preventing FRM-40654 errors

And there is much, much more!

Access the newsletter now:  Doc ID 111111.1

ALERT: Error Processing US Wage Attachment Elements In Payroll Run After RUP Patches

Customers who have run the Upgrade Wage Attachments process after applying the 2012 RUP are reporting errors similar to those listed below when either running a quickpay or processing a payroll for employee(s) with involuntary deductions.

APP-PAY-51118: Error was encountered when processing assignment 1115
ETNAME: Garnishment 3
APP-PAY-51119: Error was encountered when processing Element Type Garnishment 3
SQLERRMC ORA-01403: No data found
SQL_NO 520
TABLE_NAME pay_input_values_f
APP-PAY-06881:Error ORA-01403: no data found has occured in table pay_input_values_f at location 520

This issue was logged in Bug 14679161 - QUICK PAY ERROR AFTER RUP (2012) AND WAGE ATTACHMENT UPGRADE APP-PAY-06881.

The following one off patches have been released to My Oracle Support to resolve this issue*:

11i -  Patch 14679161
12.0 - Patch 14849394:R12.PAY.A
12.1 - Patch 14849394:R12.PAY.B

* IMPORTANT:  Depending on when/if customers have run the Wage Attachment upgrade process will determine the appropriate action to take. Any customer who is encountering the above error and/or has run the Wage Attachment upgrade process AFTER applying the 2012 RUP (applicable to their release level) should log a Service Request with Oracle Support to receive assistance on the necessary steps to take to resolve the problem BEFORE applying the above patch.

Any customer who has not yet run the Wage Attachment Upgrade process (either before or after applying the 2012 RUP), should follow the action plan documented in the patch readme.

For those customers who have already run the Wage Attachment Upgrade process BEFORE applying the 2012 RUP, should apply the patch (applicable to your release) listed above. Be sure to run any post install processes, such as the data install utility and HR global driver.  See the patch readme for full details.

Please consult Note 404478.1: Americas (US, CA, MX) HCM High Priority Alert for the latest Alert status.

Wednesday Nov 21, 2012

Payables Master Generic Datafix (MGD) Now Includes Even More Data Integrity Checks For EBTax!!

The Payables MGD is a vital diagnostic that all R12/12.1 customers need to run regularly to check the data integrity of their Payables system. This script does not make any changes to your system, so it’s risk free and it produces a HTML formatted output showing which data corruption issues have been detected and provides the Doc ID’s that will be needed to fix them.

This MGD diagnostic (version 120.92 and above) is even better than it used to be as it now checks for 11 new EBTax corruption signatures that Support was seeing on a consistent basis. These lengthy Service Requests could have been avoided with one run of the MGD which tells you right away if you have data corruption. It’s the first thing our Payables support engineers will have you run when you log an SR so why not be one step ahead?

The new EBTax signatures that were included in this latest update to the MGD are pulled from the following common solutions documents:

R12 E-Business Tax/Payables Data-Fixes: Cause and action to handle ZX_LINES_SUMMARY_U1 issue Doc ID 1152123.1
EB-Tax Data Corruption Issues & Recommended Solutions Doc ID 1316316.1

The specific issues that are now screened are detailed below:

3. TRX_NUMBER mismatch
4. TAX_RATE mismatch
5. Currency Conversion related columns mismatch in Migrated Invoices
8. Missing Reversal Tax Distributions For Tax Distributions
9. Tax Lines for discarded or cancelled Transaction Lines are not marked as cancelled
11. AP_UNFROZEN_DIST_EXIST/Unfrozen Tax Distributions exist for this invoice

Get Proactive – Check your system for these common EBTax issues and fix the data before it causes a problem.

Access the MGD note and watch the video that explains how it works here - R12: Master GDF Diagnostic to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax [VIDEO] Doc ID 1360390.1

Monday Nov 19, 2012

Webcast: Oracle Service Charges - Introduction/Overview


December 5, 2012 at 12 pm ET, 11 am CT, 10 am MT, 9 am PT

Have you wondered how Service Charges flow through into Order Management?  Do you want to understand more about the functional flows for Service Charges?  If you use Service Charges as part of your service implementation then you won't want to miss this webcast which explains Oracle Service Charges functionality and integration points with other products.  

Topics will include:

  • Functional flows involving Service Charges
  • Integration points
  • Data flow
  • Available UI's
  • Available API's.

REGISTER.jpgGo to Doc ID 1455786.1 to register.

Current Schedule and Archived Downloads can be found on Doc ID 740966.1.

Thursday Nov 15, 2012

Sales and Procurement Contracts 12.1.3++ Release Information

New functionality has been released for Sales and Procurement Contracts in a new patch: Contracts 12.1.3++: Patch 13877401: 12.1.3 Rollup for Oracle Contracts Core.

The new functionality includes:

  • APIs for Import of Contract Templates, Contract Expert rules, Questions and Constants:
    The three APIs are as follows: API for Templates, API for Rules, and API for Questions and Constants. These can be used to both create entities and update existing templates and rules. The APIs will display error and warning messages which can be processed and analyzed by the customer.

  • Ability to Apply Multiple Templates to a Sourcing, Procurement or Sales Document:
    The buyer can select and add multiple templates to a quote,sales agreement document, sourcing or purchasing odcument.  All the clauses and deliverables from the new templates are synchronized with the document. The Contract Expert rules are from the original template. The buyer can also view the list of templates that are added to any sales or procurement document.

  • Ability to Define Multi-Row Variables:
    You can create user defined manual variables that are tables containing one row per line or multiple rows. Contract Preview will print the variable values according to the layout defined for the variable. These variables are not available for Contract Expert Rules and Supplier.

  • Enhancement to Suggested Sections for Clauses by Contract Expert:
    You can associate multiple default sections with a clause. A clause is associated with multiple values of any system variable and for each such value a section name is associated in Contracts Terms Library. When Contract Expert is run in the contract authoring flow, the clause is automatically placed in the associated section name.

Plus many more new features. Read the following notes for details on all the new and changed functionality:

Oracle Procurement Contracts Release Notes, Release 12.1.3++ (Doc ID 1467140.1)
Oracle Sales Contracts Release Notes, Release 12.1.3++ (Doc ID 1467149.1)
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)

Wednesday Nov 14, 2012

Don’t miss the Procurement AME New Features and Setup for Purchase Orders Webcast on December 6th and Follow up Live Chat


This one-hour session on December 6th is recommended for technical and functional users who are interested to know more about the new 12.1.3 features for Procurement with Approval Management Engine (AME).


  • Scope and limitations of AME functionality for purchase orders
  • Setup and use of AME for purchase orders
  • PO Review and PO E-Sign new features
  • Demonstrations will be included

See DocID 1456150.1 to sign up now!

Live Chat

There will be a live chat in the Procurement Community on December 13th for follow up questions and answers.  Join us to share and gain knowledge!

Monday Nov 12, 2012

Take Control of Workflow with Workflow Analyzer!

Take Control of Workflow with Workflow Analyzer!
Immediate Analysis and Output of your EBS Workflow Environment

The EBS Workflow Analyzer is a script that reviews the current Workflow Footprint, analyzes the configurations, environment, providing feedback, and recommendations on Best Practices and areas of concern.

Go to Doc ID 1369938.1  for more details and script download with a short overview video on it.

Proactive Benefits:

  • Immediate Analysis and Output of Workflow Environment
    • Identifies Aged Records
    • Identifies Workflow Errors & Volumes
    • Identifies looping Workflow items and stuck activities
    • Identifies Workflow System Setup and configurations
    • Identifies and Recommends Workflow Best Practices
  • Easy To Add Tool for regular Workflow Maintenance
  • Execute Analysis anytime to compare trending from past outputs

The Workflow Analyzer presents key details in an easy to review graphical manner.   See the examples below.

Workflow Runtime Data Table Gauge
The Workflow Runtime Data Table Gauge will show critical (red), bad (yellow) and good (green) depending on the number of workflow items (WF_ITEMS).

Workflow Error Notifications Pie Chart
A pie chart shows the workflow error notification types.

Workflow Runtime Table Footprint Bar Chart
A pie chart shows the workflow error notification types and a bar chart shows the workflow runtime table footprint.

The analyzer also gives detailed listings of setups and configurations. As an example the workflow services are listed along with their status for review:

The analyzer draws attention to key details with yellow and red boxes highlighting areas of review:

You can extend on any query by reviewing the SQL Script and then running it on your own or making modifications for your own needs:

Find more details in these notes:

  • Doc ID 1369938.1 Workflow Analyzer script for E-Business Suite Worklfow Monitoring and Maintenance
  • Doc ID 1425053.1 How to run EBS Workflow Analyzer Tool as a Concurrent Request

Or visit the My Oracle Support EBS - Core Workflow Community

Friday Nov 09, 2012

EBS Customer Relationship Manager (CRM) Product Family Webcasts

Oracle's Advisor Webcasts are live presentations given by subject matter experts who deliver knowledge and information about services, products, technologies, best practices and more. Delivered through WebEx the Oracle Advisor Webcast Program brings interactive expertise straight to your desktop, at no cost. Each session is usually followed by a live Q&A where you can have your questions answered.

If you miss any of the live webcasts then you can replay the recording or download the PDF of the presentation. Doc Id 740966.1 gives you access to all the scheduled webcasts as well as the archived recordings and presentations. Just select the product family you are interested in to access the latest webcasts in that area.

Below is a listing of the currently scheduled archived webcasts for the EBS CRM and Industries product family.

Webcast Topic and Description

Webcast Link

Date and Time

Upcoming: Oracle E-Business Suite - Service Oracle Service Charges - Introduction/Overview


Dec 6, 2012

EBS CRM - Service R12: How to debug Email Center Auto Service Request Creation Failures

Recording | .pdf


XCALC: Failed Calculations when Using OIC

Recording | .pdf


XPOP: Failed Population When Using Oracle Incentive August 30, 2012

Recording | .pdf


XROLL: Failed Roll Up When Using Oracle Incentive Compensation August 16, 2012

Recording | .pdf


Common Problems Associated with Product Catalog in Sales

Recording | .pdf


Oracle Incentive Compensation - Troubleshooting Payment Issues

Recording | .pdf


R12 Renewing Service Contracts - Overview

Recording | .pdf


11i and R12 Oracle CRM Service Basics and Troubleshooting - an Overview

Recording | .pdf


11i and R12 Transaction Error Troubleshooting Overview

Recording | .pdf


Thursday Nov 08, 2012

New and Improved Patch for FRM-40654 Errors in Purchase Orders and Requisitions

Development has modified the code in purchase orders and requisition forms to prevent error FRM-40654 when there are trailing spaces in the tables for most of the fields.  After applying the patch, the form will still display the error but a requery will allow you to save the transaction.

For the scenarios not covered in the fix, the FND log will now display the specific field that causes the error.  This an example of the FND log for one document where the note_to_vendor has trailing spaces:

Form note_to_vendor oldvalue Database  note_to_vendor newvalue
Failed first if statement when comparing fields
FRM-40654: Record has been updated. Requery block to see change.

This new patch includes the fix in Patch 14204845:"In Oracle Purchasing, leading or trailing spaces in po lines data was resulting in errors".  For more information on FRM-40654 errors see the patching section of Note 1203796.1.

Be proactive and apply Patch 14479586:R12.PO.B for 12.1.3 or Patch 14569747 for 11.5.10 now!

Wednesday Nov 07, 2012

R12.0 Cash Management Consolidated Patch Collection (CPC) And R12.1 Cash Management Recommended Patch Collection (RPC)

If you have Oracle E-Business Suite's Cash Management (CE) application installed, you'll want to be sure to install the latest CPC (Consolidated Patch Collection) if you are using a R12.0 version of the apps, or the latest RPC (Recommended Patch Collection) for the R12.1 version of the apps. These collections give you all the fixes currently available for known issues in the specified versions of the application, including all of the latest Root Cause Analysis Fixes (RCAs)!

What is an "RPC" (for R12.1 users)?

Since the release of 12.1, a number of recommended patches for Oracle Cash Management have been made available as standalone patches to help address important business process issues.

Adoption of these patches was highly recommended at the time, but not always implemented, so to further facilitate adoption of these patches, Oracle consolidated them into product-specific Recommended Patch Collections (RPCs) - a collection of recommended patches.

They were created by Oracle Development with the following goals in mind:

  • Stability: To address data integrity issues that have been identified by Oracle Development and Oracle Software Support as having the potential to interfere with the normal completion of important business processes (such as, period close, etc.).

  • Root Cause Fixes (RCAs): To make available root cause fixes for known data integrity issues.

  • Compact: To keep the file footprint as small as possible to help facilitate the install process and minimize testing.

  • Granular: To compile the collection of patches based on functional areas, allowing a customer to apply multiple RPCs at once, or in phases (based on individual needs and goals).

Where to start

ALL R12 Cash Management users (R12.0 and R12.1 users) should start with the following Note on My Oracle Support (MOS):

Doc ID 1367845.1: R12: Cash Management Recommended Patch Collections

It's a great place for important implementation information about both sets of critical patch collections!

For R12.1x users

R12.1 users should also take a look at the documents below for even more information about the RPC for the R12.1.x versions of the Cash Management application, and other related available RPCs:

Note Number



Master Troubleshooting Guide for CE: Reconciliation & Clearing [VIDEO]


EBS: R12.1 Oracle Financials Recommended Patch Collections (RPCs)


R12: Oracle CE: Upgrading from R11i to R12.1: Latest Recommended Patches

Patch Wizard Utility

While a patch may contain several hundred files, the impact on your system may actually be minimal. Patches contain hard prerequisites that are intended to make a patch work on a very low code baseline. The Patch Wizard Utility will give you a detailed analysis of the patch’s impact on your instance BEFORE it’s applied, so you’ll know exactly what to expect from the application. Please refer to Doc ID 976188.1 for more information on this important utility

Tuesday Nov 06, 2012

Don’t miss the Receiving Webcast on November 20th

This one-hour session is recommended for technical and functional users who are interested to know about the Receiving transactions and its debugging techniques.


  • Using generic diagnostic scripts.
  • How to read debug logs in receiving.
  • Data flow for various document types (PO, RMA, ISO, IOT) to help debug issues
  • Receiving Transaction processor
  • Generic datafixes.

 See DocID 1456150.1 to sign up now!

Monday Nov 05, 2012

Oracle E-Business Products New Search Helpers for Guided Resolution of Customer Issues

Oracle E-Business Proactive Support has created many new guided resolution documents that you may find helpful in resolving issues in your EBS applications.  These new documents are called “Search Helpers” and they guide you through your issue to a solution.  They are meant to be an easy and fast method to finding a relevant, complete solution.

Hundreds of notes and service requests were reviewed and the best solutions to these known issues were selected.  For some issues, notes were updated to better clarify the solution.  In other cases, if a note with a solution did not already exist, one was created.

You start the process by selecting the scenario you have encountered.  You may have received an error message, or there may be a particular area of the application in which you have encountered an issue.  Based on your selection of the issue, the Search Helper will present one or more additional possible symptoms.  When you have selected from both of these two sections, you are then presented with one or more articles known to have fully solved this issue in the past. 

Several EBS products have produced Search Helpers documents.  Take a look at Doc ID 1501724.1 for an index of the current EBS Search Helpers. 

Here is an example of a Search Helper from the Receivables Transactions area:

Receivables Transactions Search Helper

After selecting the Functional Area of "Entering / Updating Transactions" a list of Known Symptoms is presented:

Receivables Transactions Search Helper - Symptoms

And, when "Transaction numbers are not in sequence" is selected, a solution link is provided for Document ID 197212.1: How To Setup Gapless Document Sequencing in Receivables.

Receivables Transactions Search Helper - Solution

The EBS applications that currently have published Search Helpers are:
Advanced Pricing
Applications Technology
General Ledger
Human Capital Management
Inventory Management
Order Management
Process Manufacturing
Value Chain Planning

Friday Nov 02, 2012

ADVISOR WEBCAST: R12: How to debug Email Center Auto Service Request Creation Failures

November 6, 2012 at 11 am ET, 9 am MT, 8 am PT, 4 pm London

The primary function of this WebCast is to explain how to debug problems when auto-creating a Service Request from an Inbound Email into Email Center. We see a significant number of issues raised with Support in this area, as the only indication the auto-creation has failed, is the Email routing to the Supervisor Queue for manual processing.

Topics will include:

  • Understand Email Center and Auto SR creation process.
  •  Run the debug procedures.
  • Understand the output and check the reasons for SR Creation failure.
  • See the fixes for the most common issues faced.
  • See the results for successful SR creation.

REGISTER.jpgGo to Doc ID 1493122.1 to register.

Current Schedule and Archived Downloads can be found on Doc ID 740966.1.

Thursday Nov 01, 2012

Need a Holistic view of your Concurrent Processing? Choose CP Analyzer

Concurrent Processing Analyzer Features

The Concurrent Processing Analyzer is a Self-Service Health-Check script which reviews the overall Concurrent Processing 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:

  • E-Business Applications Concurrent Processing Analyzer Overview
  • E-Business Applications Concurrent Request Analysis
  • E-Business Applications Concurrent Manager Analysis
  • Identifies Concurrent System Setup and configurations
  • Identifies and recommends Concurrent Best Practices
  • Easy to add Tool for regular Concurrent Maintenance
  • Execute Analysis anytime to compare trending from past outputs

Go to Doc ID 1411723.1 for more details and script download.

Feedback welcome!


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 2012 »