Thursday Feb 27, 2014

Need Assistance With A Create Mass Additions Issue?

We have created a new Troubleshooting Assistant for Oracle Fixed Assets for the Create Mass Additions process.  This process (also known by its short name in Assets as FAMACR and in Payables as APMACR) is used to bring addition and adjustment lines from Accounts Payable into Fixed Assets via the mass additions interface.  There have been a number of changes to the process and enhancements made in recent releases.

TroubResolveleshooting Assistants are resources created to help you find a resolution to an issue by guiding you from the problem, through the possible scenarios, and to the proposed solution.  These troubleshooting assistant types of resources were formerly called Search Helpers.  Called by either name, they are designed to provide a path through various topics related to a process and, based on the selections you make, provide suggested solutions. 

The troubleshooting assistant for create mass additions includes solutions for these issues, and more: 

  • Addition lines that were not transferred from Payables to Assets
  • Addition lines that were transferred into Assets but should not have been 
  • Merging of addition lines 
  • Transferring freight, tax or miscellaneous lines
  • ORA-30926 errors
  • Performance issues

You can access this troubleshooting assistant in Troubleshooting Assistant: Create Mass Additions From Payables (AP) to Fixed Assets (FA) (Doc ID 1609542.2)

Oracle eBusiness Suite OTM Analyzer Version 1.04 is now available

Oracle eBusiness Suite OTM Analyzer Version 1.04 is now available!

This version of Oracle Transportation Management's analyzer includes new features such as collapsible sections, file name includes time, subsections with Show More are limited to 200 rows and improved formatting.

There are four new sections: Agent Health Checks, System Health Checks, System Transaction Checks and Process Control Request/History Check. Each contain several subsections of information with warnings.

Download the latest version from OTM Analyzer script for Analysis and Performance Monitoring, Doc ID 1579683.1.

Thursday Feb 20, 2014

Demantra Performance and Setup Analyzer Script and Monitoring Tool

The Demantra Setup and 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.  

  • Immediate Analysis and Output of your Demantra Environment
    • Reveals Current Environment
    • Delivers Known Recommendations and Solutions
    • Perform Sanity Checks for Known Issues
  • Easy to add Tool for regular Maintenance
  • Execute Analysis anytime to compare current environment 
  • DBA's / System Administrator's should run the script and review the output
  • Output usually will be reviewed by technical application DBA or super user
  • This script was designed for 7.3.1 and later.

Where to Run the Script & How to fix Items Identified:

You may run the script on a Production environment as it's non-invasive.  We recommend fixing items identified from the output first in a clone of production to test/verify the expected outcome.  Visit Doc ID 1618885.1 to download the script and view a complete output example. 

Troubleshooting Assistant Now Available for Invoice Validation!

Proactive Support has created another great tool for you to use when facing Invoice Validation issues!

There are  many Troubleshooting Assistants available to help customers find solutions to their issues faster but we have just added another assistant for Invoice Validation because customers continue to have problems in this area and we wanted a quick way to help them find their answers.

Check out the new Troubleshooting Assistant: Oracle Payables (AP) Invoice Validation (Doc ID 1616563.2).

You will also see this tool when raising an SR for validation issues and you should defintely give it a try as it's been created from common issues and takes you directly to the known solutions.

You can interact with the tool to locate specific common error messages, review by symptoms or dig right into the issues we are aware of with the online validation or batch processing sections.  There is even some EBTax common problems included.

We also address corruption in the assistant, because often corruption can be the cause of your problem.  Why waste time trying to figure out what's wrong when you can run a simple request and find out?  

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

The MGD (Master Generic Data Fix) concurrent request can be ran for a date range or for a single transaction and the output will tell you exactly what is wrong with that transaction and tell you what you need to do to fix it. This is the reason why under the data corruption topic we refer to the MGD as your solution!  

It should ALWAYS be the first thing you check any time you have a payables issue so if you aren't aware of it, please read up on Payables #1 problem solving document or watch the video and get your data corruption issues fixed and prevent those headaches at month end.


EBS: Assistant (Search Helper) Index (Doc ID 1501724.1

So next time you have an Invoice Validation problem give the Troubleshooting Assistant a try and you might be surprised how easy it was to resolve! 

Tuesday Feb 18, 2014

Oracle Transportation Management (OTM) 6.3.3 is now available!

Oracle Transportation Management, Global Trade Management, and In-Memory Logistics Command Center 6.3.3 are available for download as of February 7, 2014.

You can download Oracle Transportation Management, Global Trade Management, and In-Memory Logistics Command Center 6.3.3 from Oracle Software Delivery Cloud.

For complete details on this release (Release Notes, Documentation, Installer Notes, etc.), refer to Doc ID 1596782.1.

Monday Feb 17, 2014

EBS Business Process Advisor: CRM Channel Revenue Management

The EBS CRM team are happy to announce that we've added a new document to our series of EBS Business Process Advisors: Trade Planning and Execution to Claim Settlement - EBS Business Process Advisor: CRM Channel Revenue Management [Video] (Doc ID 1602524.2).  The Advisor will be of particular interest to users of the EBS Channel Revenue Management product (formerly known as Trade Management).  It covers the full channel revenue management lifecycle, from creation and allocation of budgets and quota, through trade planning exercises and offer creation, through to the investigation and settlement of claims.

This new note has a similar layout to our earlier note (Doc ID 1589750.2: Service Request Creation to Resolution' E-Business Suite Business Process Advisor).  The note contains:

  1. Business Flow Details: details of the modules used within the flow together with a demonstration script and example setup with an explanatory video.
  2. Hotspots:  highlights areas of the business flow where data and control passes between different products, or where the underlying logic requires further explanation or clarification.
  3. Related Flows: over time the aim is to extend the library of EBS Business Process Advisor documents to cover multiple business flows.  This tab will act as a link between these by indicating directly and indirectly related business flows documents.

What are Business Process Advisor Documents?

Oracle E-Business Suite (EBS) is released as a collection of separate modules with supporting material, such as Implementation and User Guides.  These tend to focus on the setup and use of an individual module without detailing how that module interacts with other related modules.  A typical implementation will include multiple modules which together provide a business flow, so there is a need to know how these modules function together.  The EBS Business Process Advisor documents assist in the modeling of specific business flows by describing the flow from a product and process perspective.

Who are they aimed at?

These notes are aimed at users and implementers to help with the understanding of the end-to-end business flow.

How you can help

Are there particular business flows that you are interested in seeing covered in an EBS Business Process Advisor document?  What do you find useful about the Business Process Advisor content and format?  Let us know by leaving a comment here, or you can mail us.

Friday Feb 14, 2014

ASCP Integration with Oracle Transportation Management

Are you looking for integration of transportation of goods into your Advanced Supply Chain Planning (ASCP)?  Most planning systems have no visibility of delays in transportation and their impact to manufacturing utilization or customer service. With version 12.1.1+ ASCP can now integrate with Oracle Transportation Management (OTM). 

The integration will provide:

  • Leverage Oracle Transportation Management Supply Chain Event Management to obtain real time, projected material arrival dates.
  • Provide a Business Process Execution Language (BPEL) process and associated web services to consume events and generate planning exceptions to provide planners real time visibility to transportation delays.
  • Use the updated dates in ASCP interactive planning calculations to calculate the impact of transportation delays on downstream orders and take corrective action.

For details, you can refer to Integrating Oracle E-Business Suite with Oracle Transportation Management (Doc ID 1546042.1).

Thursday Feb 13, 2014

RUP-IT! For Inventory, Warehouse Management and Receiving

What is the rollup (RUP) schedule history for Inventory, Warehouse Management, and Receiving (INV/WMS/RCV)? 


RUP-IT is an Inventory Support Initiative meant to improve customer support experience, reduce outages, improve user productivity, and decrease total cost of ownership of the Oracle Application Inventory modules.  As you  might already know, keeping on the latest Rollup is the fastest way to avoid SRs and to get fixes for common issues.

Avoid SRs and stay on the latest RUP now through Doc ID 726226.1 INV/WMS/RCV Family Patch Release History / Patchsets / RUPs.

Latest Rollup (RUP) Patches

Latest Rollup (RUP) Patches

* For R12, also, see  Doc ID 423541.1 for EBS-wide R12 Rollups.

Service Items Can Now be Promotional Get Items

As of R12.2.2, you can now add a service item (for example, warranty for a specific period) as a ‘promotional get item’ for the parent item.  After you define a line level promotional modifier for an item (for example, a PC) in the Define Modifier window, you can add a service item (for example, warranty for a specific period) as a ‘promotional get item’ for the parent item.

Use the Get region in the Define Modifier Details window of the parent item to specify the following for the promotional get item:

  • The service item quantity.
  • The UOM, which the application uses as the primary UOM for conversion.
  • The duration of the service program such as 1, 2, or more.
  • The period of the service program such as day, month, or year.
  • The percent price for the service item.

Please refer to Oracle Advanced Pricing Release Notes for Release 12.2.2, Doc ID 1582797.1, for additional details on this new feature.

Wednesday Feb 12, 2014

Learn More About EBS R12.2

Last fall, we released Oracle E-Business Suite 12.2, (Press Release).  EBS 12.2 includes new product functionality, new Fusion Middleware and database components, and introduces new tools for installing, configuring, and maintaining E-Business Suite environments.

In fact, there are hundreds of new features, as EBS 12.2 includes significant enhancements across the integrated suite of business applications spanning enterprise resource planning, human capital management, and supply chain management.

Recently we sat down with Jeanne Lowell, VP of Strategy for Oracle’s EBS, to hear more about E-Business Suite 12.2.  Watch this video to hear Jeanne summarize the key strengths of Oracle EBS 12.2 and how it can help you cut downtime to minutes, increase your flexibility and your scalability! 

ASCP Enhanced Exception Management in R12.2.2

Advanced Supply Chain Planning (ASCP) R12.2.2 introduces enhanced functionality for Exception Management.  Prior to this enhancement, ASCP generated all exceptions for all items and resources with attached exception sets. You can now control which exceptions ASCP generates, thus saving the computational burden of generating unneeded exceptions.

A new window called Exception Group allows you to select specific exceptions from a list of available exceptions. You can save the Exception Group and attach it to plans using a new plan option field. When the plan is run, ASCP generates only the exceptions listed in the Exception Group.

For more information regarding Enhanced Exception Management in Release 12.2, please refer to the Oracle Advanced Supply Chain Planning Release Notes for Release 12.2.2, Doc ID 1504893.1.

ORAchk Health Checks for the Oracle Stack

ORAchk includes EXAchk’s functionality and replaces the popular RACcheck tool, extending the coverage based on prioritization of top issues reported by users, to proactively scan for known problems within:

  • E-Business Suite Financials Accounts Payables
  • Oracle Database
  • Sun Systems

ORAchk features:

  • Proactively scans for the most impactful known problems across your entire Engineered System as well as various layers of your stack
  • Simplifies and streamlines how to investigate and analyze which known issues present a risk to you
  • Lightweight tool runs within your environment; no data will be sent to Oracle
  • High level reports show your system health risks with the ability to drill down into specific problems and understand their resolutions
  • Can be configured to send email notifications when it detects problems
  • Collection Manager, a companion Application Express web app, provides a single dashboard view of collections across your entire enterprise

ORAchk will expand in the future with more high impact checks in existing and additional product areas. If you have particular checks or product areas you would like to see covered, please post suggestions in the ORAchk community thread accessed from the support tab on the below document.

For more details about ORAchk see Document 1268927.1

Tuesday Feb 11, 2014

Attention Oracle Mexico Payroll Customers: 2013 Year End Phase 1 Patches have been Released!

The Oracle Mexico Payroll 2013 Year End Phase 1 patches have been released and are now available on My Oracle Support.

R12.0 Patch 17941884:R12.PAY.A
R12.1 Patch 17941884:R12.PAY.B

Please note:
- These patches include both the 2014 Year Begin (Patch 17924551:R12.PAY.x) and 2014 ISR Tax Rates (Patch 18050606:R12.PAY.x) patches. Therefore, it is not necessary to also apply these separately if you have not already done so.
- 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.

Here are a few highlights of this patch release:

- CFDI Payroll Payslip XML Interface: The 2014 ISR tax legislation mandates that employers generate employee payroll payslips in XML format in order to get the CFDI (Certificado Fiscal Digital por Internet - Internet Digital Fiscal Certificate) from the government agency SAT. These patches deliver the components to allow customers to generate XML payslips.
Important Notes regarding the CFDI Payroll Payslip XML Interface:
- There are mandatory setup steps after applying this patch. Please read the entire Functional readme for details.
- The CFDI Payroll Payslip XML Interface delivered in this patch includes only mandatory fields. Those fields are described in the XML layouts posted by the government.
- The optional XML fields and several enhancements to this functionality will be delivered in the 2013 Year End Phase 2 patch.
- To comply with the statutory requirements, this functionality generates one XML file per payslip. However, it also generates a single XML file with all the employee payslips.
- State tax updates: The state tax rate has been increased to 3.0% for Distrito Federal, Mexico and Puebla states, effective January 1st, 2014.

Please see the patch readmes on My Oracle Support for functional details and full patch install instructions.
Doc ID 1597562.1 - 2013 MX Payroll Year End Phase 1 Rel 12.0
Doc ID 1597597.1 - 2013 MX Payroll Year End Phase 1 Rel 12.1

For complete details on the Oracle Mexico Payroll Year End Patching Schedule, see My Oracle Support Doc ID 975677.1: Mexico HRMS 2013 Year End Patch Release Schedule.

Service Contracts Renewals and Public APIs

Your chance to interact with the Service Contracts Development team!  Service Contracts Development are looking for customers to share their experience and requirements around two specific Service Contracts product areas:
  • Service Contracts Public APIs
  • Service Contracts Renewal Processing.
If you have experience, requirements or interest in either of these areas then we'd love to hear from you!  Please post a response in the two My Oracle Support Contract and Lease Management Community threads that we've started to gather customer feedback:
We look forward to hearing from you!

Monday Feb 10, 2014

Urgent! Change in the HTTP Proxy Service Used for OSN - Oracle Supplier Network Starting February 16th

Oracle Supplier Network currently uses the HTTP Proxy service - - for document delivery.  The proxy service is due to be decommissioned on 16th Feb 2014 at 10:00 AM GMT and a new proxy service hosted by Oracle Managed Cloud Services - - will be used instead.

What does this mean for Oracle Supplier Network customers?

Outbound requests from Oracle HTTP Server mid-tiers should go through the OnDemand HTTP proxy services, and, which are the BIG-IP virtual servers that load balance the actual physical devices.

To ensure continued connectivity, the subnets for the new proxy service must be allowed access in customer's firewall.  Please see 'What are the IP Addresses for OSN' (Doc ID 435409.1) for a listing of the required subnets.  You may open the firewall to receive requests from the subnets mentioned in the note.

These configuration changes need to be done by 16th Feb 2014, 10:00 AM GMT.  If you do not complete these changes before the mentioned time, the documents delivered by Oracle Supplier Network might fail to reach your ERP system."

For more information see the Procurement Community thread: 'Urgent!!! FAQ - Change in the HTTP Proxy Service Used for Oracle Supplier Network (Doc ID 1620906.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



« February 2014 »