Tuesday Dec 31, 2013

Attention Oracle Mexico Payroll Customers: Year Begin 2014 Patches have been released!

The Oracle Mexico Payroll Year Begin 2014 patches have been released and are now available on My Oracle Support!

Patch numbers:

Please note 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.

We would like to make you aware of the following important points contained in the Readme, and ask that you read through the patch readme very carefully: 

  1. Year Begin 2014 for Oracle Mexico Payroll
  2. ISR Tax rates one-off patch
  3. CFDI Payroll Payslip
  4. Important End of Year Patch Information
  5. Mandatory Patch Information

Concurrent Processing Tips & Tricks & CP Analyzer Update

Concurrent Processing Tips & Tricks & CP Analyzer Update

Did you know?

Tuning concurrent processing largely depends on customers' specific business needs. While Support is unable to provide specific recommendations that address all circumstances, we can certainly provide the guidance which helps you make decisions.

Be sure to check out the following documents to understand the considerations for healthy Concurrent Processing:

  • Doc ID 1057802.1 Best Practices for Performance for Concurrent Managers in E-Business Suite
  • Doc ID 986272.1 How To Performance Tune The Concurrent Processing Server


We suggest you run the FNDCPPUR "Purge Concurrent Request and/or Manager Data" request on ALL instances during hours of low workloads. Doing this regularly and after hours will decrease the contention on the tables running against daily processing. For more information on basic usage for running the Purge program and code fixes, please reference: Doc ID 822368.1 Concurrent Processing - How To Run the Purge Concurrent Request FNDCPPUR, Which Tables Are Purged, And Known Issues Like Files Are Not Deleted From File System or Slow Performance.

Tip: Discuss with the functional teams for determining the best retention policy.

Ensure that the log/out files are removed from the below directory as you run "Purge Concurrent Request and/or Manager Data program":


See Doc ID 844976.1 for more details.

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

Concurrent Processor Analyzer sample output

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

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.

For top Concurrent Processing content, visit:

  • 11i / R12: Concurrent Processing - Product Information Center (PIC) Doc ID 1304305.1

Monday Dec 30, 2013

CRM Product Family Webcasts - January 2014


The EBS CRM Product group are happy to announce three webcast for January 2014.

Webcast: Oracle EBS Channel Revenue Management / Trade Management: Product Overview

Date: January 8, 2014 at 1:00 pm EST, 10:00 am PST, 6:00 pm GMT, 11:30 pm, IST

This one hour session is an overview of the Channel Revenue Management Suite (formerly known as Trade Management ) which Includes Channel Rebates and Point of Sale Management, Accounts Receivable Deductions Settlement, Supplier Ship and Debit and Distributor Price Protection Modules. This session will highlight the integrations with Oracle EBS Products like Order Management, Pricing, General Ledger, AR and AP and will be followed with additional sessions detailing each of the product module capabilities.


Details & Registration : Doc ID 1607801.1.

Webcast: Overview of Lease Management

Date: January 9, 2014 at 10:00 am EST, 7:00 am PST, 3:00 pm GMT, 8:30 pm IST

This Webcasts presents an introduction to the Concepts of the leasing business with a functionality overview of Oracle Lease and Finance Management and how the module  supports leasing business requirements.


Details & Registration : Doc ID 1606686.1.

Webcast: Configure a Compensation Plan and Calculating Commission

Date: January 24, 2014 at 6:30 am EST, 3:30 am PST, 11:30 am, GMT , 5:00 pm IST

This one-hour session is recommended for technical and functional users who are using / implementing Oracle Incentive Compensation. The session will cover the components/sub components of a compensation plan, how to create a plan and understand how the calculation engine evaluates the commission for the plan.


Details & Registration : Doc ID 1606683.1.

Remember that you can access a full listing of all future webcasts as well as replays from Doc ID 740966.1.

Friday Dec 27, 2013

Wondering Why There Hasn't Been a New 12.1.3 Procurement Rollup Patch (RUP) Recently?

So are you keeping an eye on Doc ID 1468883.1 and wondering why there has not been a new 12.1.3 RUP released since March 2013 Patch 15843459:R12.PRC_PF.B?

Instead of releasing all-encompassing RUPs, Procurement Development has been focusing on specific areas.  Visit Doc ID 1468883.1 the ‘Additional Recommended Patching’ section to see the patching available for the following areas:
  • iSupplier Portal, Sourcing and Supplier Lifecycle Management
  • Purchasing Approvals (including AME)
  • Procurement Accounting Processes

These patches are designed to be applied on top of Patch 15843459.

Visit Doc ID 1468883.1 ‘Additional Recommended Patching’ section today for details!

Tuesday Dec 24, 2013

Happy Holidays!

Wishing all our readers our good wishes for this holiday season and looking forward to 2014!  

From all the team at EBS Support.

Monday Dec 23, 2013

New Feature: UK Bank Account Modulus Validation

 In the United Kingdom (UK), Vocalink (BACS Technology partner) provides up to date details of the modulus checking methods in use for a number of UK banks and financials institutions to validate UK  Bank Account and to sort code numbers, along with the required weighting tables and sort code substitution data.  An algorithm can be used along with these tables to validate the bank account.

There are three types of modulus checks that are performed on the UK bank accounts.  

  •  Mod 10 - Standard 10 modulus check
  • Mod 11 - Standard 11 modulus check
  • DB1A1 - Double alternate modulus check


This feature enhances the existing UK bank account validation model by introducting modulus check validation.  A modulus check will be performed during the creation and modification of the bank accounts and will aslo be applied on the importing of bank accounts through public API's. 

When the bank accounts are entered, the system will now invoke a new modulus check, in addition to the existing length check (8 digits) for validating the UK bank accounts.  The modulus algorithm applied on the bank accounts depend on the bank sort codes and is part of the sort codes published by Vocalink.

 The solution introduces two new concurrent programs for the load and maintenance of the modulus weights table and Sorting and Substitution data file used in the validation process.  

 The feature can be disabled by using a Cash Management system profile (CE: Disable Bank Validations), and is available as a downloaded patch for Release 12.1 onwards.

To find out more about this feature, and obtain the patch, see DocId: 1563308.1

Service Contracts Online Renewals Explained

Service Contracts has a number of different options for contract renewal.  The Online Renewal type can be used for automatic renewal of a contract when customer agreement is required.  When this approval type is chosen, the application sends an email notification to the customer requesting them to review the contract renewal details via a URL link to the Customer Acceptance Portal. 

From the portal customers can review the renewal and have three options to select to continue:

  • accept
  • request assistance
  • decline.
The setup steps to for Online Renewal are:
  1. Global Defaults setup
  2. Setting up Quote to customer template and profiles
  3. Contract setup
  4. Running the flow.

The required setups are explained in detail in a new document: Doc ID 1602944.1: Service Contracts Online Renewal Setup Flow.

Friday Dec 20, 2013

North American Payroll - Tax Interface

If you have been thinking about switching to the 'Enhanced + Wage Accumulation' tax interface, this is the perfect time - before running the first payroll of the new year!  Switching at the beginning of the year helps ensure that the wage and tax balances are accumulated consistently for the entire tax year, instead of switching mid-year and then having to make balance adjustments to clean up the balances.  

The Wage Accumulation functionality provides an override capability to how Oracle Payroll accumulates wages. With the 'Enhanced + Wage Accumulation' tax interface, you can choose to: 1) accumulate wages only if tax withheld or 2) always accumulate wages.  This impacts how the State wages are reported on the Employee W-2.

The switch is made by running the 'Select Tax Interface' US Payroll concurrent process and the recommendation is to do this at the beginning of the tax year, before you've run your first payroll of the new year.

Details about the Wage Accumulation functionality can be found in Doc ID 460678.1 Wage Accumulation Readme.

Also new with the 2013 Q3 / YE Phase 1 statutory patch is the ability to turn on the Wage Accumulation functionality at the business group level, by setting the applicable year from which the 'Enhanced + Wage Accumulation' tax interface will be in use (only 2013 or later can be used).  You can learn more about BUSINESS GROUP LEVEL CONTROL FOR ENABLING WAGE ACCUMULATION in the Q3-2013 readme note:
Doc ID 1584799.1 3rd Quarter 2013 Statutory Patch Readme – Release 11i
Doc ID 1584800.1 3rd Quarter 2013 Statutory Patch Readme – Release 12.0.x
Doc ID 1584801.1 3rd Quarter 2013 Statutory Patch Readme – Release 12.1.x

As with any set up change, you should do this first in a non-production environment and thoroughly test.

Thursday Dec 19, 2013

Integration between Enterprise Asset Management and Oracle Time and Labor

A new white paper provides an overview of how Enterprise Asset Management (EAM) integrates with Oracle Time and Labor (OTL) in connection with timecard data provided by OTL. The following topics are discussed:

•     Required Setup Steps
•     Process Flow for Integration between OTL and   EAM
•     Basic Technical Details (tables etc)
•     Product Enhancements
•     Frequently asked questions

EAM is the application used to create and implement maintenance procedures for both assets and rebuildable inventory items. EAM tracks the performance of assets (including rebuildables and inventory items) using meters, quality plans, and condition monitoring systems. By effectively monitoring an asset's operating condition, effective preventive maintenance strategies can be implemented.

Oracle Time & Labor is part of Oracle’s Human Resources Management System (HRMS) – it is an intuitive web-enabled timecard solution that completely automates the process of time record keeping.  It can help to control costs and time worked, consolidate timecard information and adhere to organizational time management rules. For employees, it offers a simplified way to submit, review, track and approve timecards.

Employees, line managers, authorized delegates or administrators can submit timecards, and supervisors, managers and/or administrators can review the approval
status on the web. Timecards can be approved automatically or routed for approval using Oracle Workflow.

Hence, the business scenario is as follows :

•    Firstly, work orders are created in EAM to carry out maintenance work on an asset.  There will be operations linked against the work order to carry out the work and these operations will be linked to departments and resources. The resources can then be linked to specific employees who will be doing the work.
•    These employees can then enter timecard data against the above work orders to specify how much time they have spent working on the specific operation for the work order.
•    These timecards are then migrated to EAM where they will result in resource transactions created against the work order.

White Paper : Integration between Enterprise Asset Management (EAM) and Oracle Time and Labor (OTL) (Doc ID 1606963.1) describes how the above integration works.

Wednesday Dec 18, 2013

Use Approvals Management Engine for Approval Mechanism of Order Lines

In R12.2.2, Order Management integrates with Oracle Approval Management (AME) to leverage the robust capabilities of the approval rules engine to dynamically determine the list of approvers for Quotes, Sales Agreements and Returns (RMA). Order Management has been integrated with Oracle Approval Management for the workflow "Negotiation Flow - Generic with Approval" and "Order Flow - Mixed or Return with Approval" to provide an additional option to use Approvals Management Engine (AME) for the approval mechanism of order lines with the above work flows.

You can enable this option by selecting the Use Approvals Management Engine check box on the Order Management Transaction Types window. For the AME enabled transactions, Order Management utilizes the AME capabilities of a central business rules repository and a common execution engine, to manage approvals for its business processes.

AME repository has been enhanced to include certain OM specific attributes on which rules can be defined. Such seeded attributes are:

  • Header Level - Customer (Sold To Customer), Customer Category (of Sold To Customer), Order Type and Ordered Amount
  • Line level - Line Type, Item, Quantity, Line Amount and Line Discount Percent

Key benefits of this integration are:
  • You can use seeded as well as custom attributes to create AME conditions and rules.
  • AME dynamically determines the list of approvers based on conditions and rules.
  • You can define the approval process with Serial or Parallel Approvals. In the case of Parallel Approvals, additional options such as “First Responder Wins” and ”Consensus” are available to choose from when defining the approval rules.
  • With this new feature, Order Management leverages AME to dynamically generate the list of approvers based on attribute values, conditions, approval types and approval group.
  • In addition, centralizing storage of approval policies in AME improves audit and accountability. Moreover, the new capabilities can be rapidly and easily implemented in AME.

For additional R12.2.2 new features, please review Oracle Order Management Release Notes for Release 12.2.2 (Doc ID 1377743.1)

Tuesday Dec 17, 2013

Payables Most Frequently Used Knowledge Content of 2013

So how was 2013 for you?  For the Payables Proactive team it was a busy year as we were working on all sorts of wonderful projects, trying to make life a little easier for you.  

Here’s a rundown of some of the major knowledge that we created or improved this year that has had the biggest impact on you.  You keep FINDING it, READING it and most importantly USING it to resolve your issues without the need to log a Service Request.

So what documents made it onto the 'Most Frequently Used Documents' list of 2013?  

The following list shows you the knowledge content that you, the reader, found in My Oracle Support over the last 12 months, ranked by the total number of hits.  Sorry, but there are no prizes for guessing which amazing script came in the #1 spot because, let's face it, that would just be far too easy...  

#1 - R12: Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax [VIDEO] [Doc ID 1360390.1]

When to use it? Monthly to identify known data integrity issues within your Payables application and learn exactly how to fix those issues – all without the need for a service request.  

#2 - Information Center: Using Oracle Payables [Doc ID 1417577.2]

When to use it?  When you want to quickly see an overview of all our KM content for a particular functional area of the product such as EBTax, Workflow or Prepayments information.

#3 - R12.1: Payables Recommended Patch Collection (AP RPC), Sep 2013 [Doc ID 1397581.1]

When to use it?   This is a one time application which will provide you with all the important fixes since the release of 12.1.3.  Many of these fixes affect Critical Business Processes such as Period Close and are observed as reoccurring very often in the Installed Base. 

#4 - Information Center: Oracle Payables Accounting R12 [Doc ID 1476284.2]

When to use it?  This is a sub-document that can also be accessed from our #2 document, and the use of it would be in the same way, selecting the accounting tab from the Using Payables Information Center brings you directly to this document which highlights the accounting documents that are most useful to you.

#5 - Troubleshooting Assistant: R12 Payables Prepayments (Search Helper) [Doc ID 1559751.2]

When to use it?  Anytime you have a prepayment question or issue and you want to find the solution fast.  This interactive assistant will guide you through to the solutions that resolved issues for others customers experiencing the same symptoms.

#6 - Information Center: Oracle Internet Expenses [Doc ID 1381228.2]

When to use it?  Anytime you want to learn more about OIE, or troubleshoot an issue.  This index of content is invaluable for fnding your way around the OIE content quickly and easily.

#7 - Troubleshooting Assistant: R12 Oracle Payables (AP) Accounting [Doc ID 1573154.2]

When to use it?  Like in #5, troubleshooting assistants are always useful when you have a specific issue, you know the error message or the symptoms that cause the problem and you are trying to quickly find the common solutions for that specific issue.

#8 - R12: Information Center: Troubleshooting Payments to Suppliers and Other Creditors using Oracle Payables (AP) and Oracle Payments (IBY) [Doc ID 1383396.2]

When to use it?  This information center is your central point of resource for all things related to supplier payments.  

#9 - Information Center: Oracle Payables for Suppliers [Doc ID 1363041.2]

When to use it?  This is your central resource for payables supplier issues ranging from issues with employee suppliers to general setup and usage of suppliers. A great resource to use when you have questions or errors related to suppliers.  

#10 - Troubleshooting Assistant: R12 Suppliers (Search Helper) [Doc ID 1410773.2]

When to use it?  Whether you have issues with merging a supplier or you are unable to import or update a supplier, this troubleshooting assistant has your answer.  

Note: Please bear in mind that these might be the top 10 documents that you found when searching on MOS but this is dependent on the volume of incoming searches, so this list is missing some amazing articles in the smaller functional areas.  

For a full listing of all the available Assistants (Search Helpers) please review EBS: Assistant (Search Helper) Index [Doc ID 1501724.1]

For a full listing of all the available Information Centers please review E-Business Suite Product Information Center Index [Doc ID 444.2]

Happy Holidays!

Are you upgrading Oracle Demantra to 12.2.2?

When upgrading your Demantra application from an older version directly to 12.2.2 there are some issues of which you need to be aware. 

ORA errors, Excel missing cut/paste data, performance issues, Notes, Calendar and other known upgrade issues. For example, did you know creation of new Indexes on sales data can take a long time?  Or that Worksheets may not opening after the upgrade?

Please refer to MyOracleSupport (MOS) Doc ID 1602288.1 for details on issues and their known resolutions.

Monday Dec 16, 2013

Guidelines For Applying Install Base and Asset Tracking Patches

If you use Oracle Install Base or Asset Tracking modules in your EBS implementation then Doc ID 1604288.1: Guidelines For Applying A Patch In Install Base (CSI) And Asset Tracking (CSE) Modules is a must-read.

The purpose of the document is to list all mandatory and optional steps required whenever an Install Base (CSI) or Asset Tracking (CSE) patch is applied on an environment.  Following the steps given you will help you to avoid some of the common errors and problems that are typically reported after applying a CSI/CSE patch.
For example:
  1) Database objects (especially Package Bodies) become invalid, resulting in transactions not properly interfaced in Install Base.
  2) Code fixes introduced by a given patch are not used by user browser session, resulting in reporting that issue is not fixed even after applying the given patch.

Take a look at Doc ID 1604288.1 now and bookmark it ready for the next time you have to apply a CSI/CSE patch.

Friday Dec 13, 2013

What’s New for Oracle Configurator in R12.2.2!

Fusion Configurator Engine (FCE)
The FCE uses constraint programming technology to provide configuration capabilities that are easier to use and more powerful than those of the Original Configurator Engine.

Desupport of DHTML User Interfaces and the Limited Edition of Oracle Configurator Developer 
DHTML User Interfaces are not supported, and the limited edition of Oracle Configurator Developer is not available.  Support for More Node and Text IDs.  The CZ schema has been enhanced to greatly increase the number of Model nodes and translatable text records that can be created over the life of a database instance.

Maintenance of State for Dynamic Tree UI   
The Dynamic Tree navigation style now maintains its state of expansion when adding or deleting component instances, and, after navigation to a new node, automatically expands to display the currently selected node and its children.

Performance Improvement by Model JVM Routing
Previously, Oracle Configurator cached all Models in a session on every JVM running on the web server, overloading the JVMs. Now, you can route a specific Model to a specific JVM. This can reduce the memory footprint and improve runtime performance.

Integration of Agile Variant Management with Oracle Configurator    
Agile Product Lifecycle Management (PLM) is now integrated with Oracle Configurator. Implementors can import a BOM to Oracle Configurator Developer to define additional UIs and configuration rules. Users of Agile Variant Management can invoke Oracle Configurator to configure a model as a Variant BOM.

Processing Page for Long-Running FCE Actions
You can now choose to display a message page when the processing of the Auto-Complete and Finish actions exceed a specified time period. You can specify the messages that appear on the page. This feature is only available for Models that use the Fusion Configurator Engine (FCE).

For additional details, please review Oracle Configurator Release Notes for Release 12.2.2 (Doc ID 1504904.1)

Thursday Dec 12, 2013

Announcing EBS Service & Depot Repair CAB Meeting 2014

The  E-Business Suite Service and Depot Repair Product Management Team are pleased to announce the next Service and Depot Repair Customer Advisory Board meeting will be held in March 2014.

Date:        Tuesday, March 25 through Friday, March 28
Time:        8:30am to 5:30pm PDT (8:30am to 1pm Friday)
Location:  Oracle Headquarters, Redwood Shores, California

If you would like to join us for the CAB please let us know by contacting us:

Sanjeev Sahni, Director, Service Product Management,
Lee Sacco, Sr. Director, Depot Repair Product Management

If you are planning to attend, please also let us know what topics are of greatest interest and benefit to you so we can craft an agenda that best suits our attendees.

As with past CAB meetings, we'll cover a number of different Service family products during the course of the week and can also invite representatives from non-Service family products that are of interest.

We're hoping to see you in Redwood Shores in March!


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



« December 2013 »