Wednesday Jun 03, 2015

Oracle Receivables Proactive Best Practices: Tool Summaries & Troubleshooting Assistants

Webcast_icon.jpgOracle Receivables Proactive Best Practices: Tool Summaries & Troubleshooting Assistants

Date: June 10, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India Time (Mumbai)

This one-hour Advisor Webcast is recommended for functional and technical Oracle Receivables (AR) users who want to utilize all of the Proactive resources/tools at their disposal to quickly find solutions to commonly encountered issues. We will review the use and benefits of a number of AR Proactive tools, including: Guided Resolutions, Automation, AutoInvoice & AutoAccounting Analyzers, What's New Advisors, Information Centers and more. Where appropriate, we will also look at sample use cases.

Topics will include:

  • Guided Resolutions
  • Automated Troubleshooting Flow
  • Analyzers
  • Additional Instrumental Assistants

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 10-Jun-15: Oracle Receivables Proactive Best Practices: Tool Summaries & Troubleshooting Assistants

Wednesday Mar 11, 2015

Webcast: Inventory Sales Order Flow and Troubleshooting – R12

Webcast_icon.jpgWebcast: Inventory Sales Order Flow and Troubleshooting – R12

Date: March 18th, 2015 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 5:00 pm CET, 9:30pm IST

This one-hour adviser webcast is recommended for Order Management and Inventory technical and functional Users. We will review the sales order data flow from Order Management into Inventory with focus on R12, for a Discrete Inventory Org (non WMS enabled). Will provide basic troubleshooting techniques for stuck sales order type transactions in the MTL_TRANSACTIONS_INTERFACE (MTI) and review some of the diagnostics used by Oracle Inventory Support to troubleshoot stuck sales order records during regular daily and monthly end business cycles.

Topics will include:

  • Overview
  • Process Flow
  • Troubleshooting
  • Demonstration
  • Diagnostics: Tools Available
  • References

Details & Registration: Doc ID 1290983.1

Tuesday Jan 13, 2015

Easy Assistance for Troubleshooting Issues

As we have discussed in previous blog entries, sometimes it seems like you have to be 'Carnac the Magnificent' when searching for a solution in MyOracle Support (MOS). Besides our previous suggestions on techniques for knowing how to search, sometimes for broad issues, the hardest part of searching is a starting point. Maybe you are having an issue like a problem logging a service request (SR). Maybe you are looking at an issue in your Oracle Database or EBS Product specific area where there are many MOS notes offering solutions. In scenario's like these, the Inventory Blog Team suggests using a Troubleshooting Assistant.  

Troubleshooting Assistants help narrow a search based on a series of questions that guide you to a solution. They are very much like the new 'Guided Resolution' feature that is now available for some SR problem types when logging SR's. They are also available in many different Oracle Product areas, and for many different issues. Wait...what's that? We are divining that you are asking, "How do I find one of these helpful Troubleshooting Assistants?" Well it's very simple oh honorable one. In MyOracle Support (MOS) make sure your Powerview is off, then search using the term ‘Troubleshooting Assistant’. This will return Troubleshooting Assistants across different Product areas. Or use Powerview to search for Troubleshooting Assistants for a specific Product. Or simply select one when you see it during a search in MOS. It's that easy.

Doc ID 1391970.2 above for EBS Inventory/Receiving RVTII-060 errors, is a prime example of a broad issue where there are many possible solutions. The Inventory Blog Team would certainly recommend using this assistant if the RVTII-060 error occurs.

Troubleshooting Assistants are living documents that are regularly updated with recent updated information, so it's helpful to bookmark the docs for future reference. Troubleshooting Assistants are another tool offered by Oracle Support to help with fast and easy solutions, and again, here's to successful searching in MOS!

Monday Sep 08, 2014

How to Fix FRM- and ORA- Errors in Oracle Teleservice

We get hundreds of support service requests reporting various FRM-xxxx or ORA-xxxx errors in the Oracle Teleservice Service Request, Contact Center or Tasks forms.  Did you know that there are just a few simple steps to resolving these errors?  The vast majority of these support requests are easily fixed by following one or more of the steps below:
  • Regenerate all JTF, CS and CSC packages, objects, forms and libraries.
  • Make sure that all the required products are set as 'Installed'.
  • Apply the latest Service RUP patch so that you are on the latest codeline.
  • Ensure that you have correctly set the MO: Operating Unit profile.
Want to know more?  Take a look at our Troubleshooting guide: Service: Troubleshooting FRM-40735 Errors (FRM-40105, ORA-06508, ORA-1403, ORA-4062) in Service Requests, Contact Center, Tasks (Doc ID 1326683.1).

Friday Aug 01, 2014

Guided Resolution Now Available for Cancel or Discard Issues!

Guided Resolution Flows for Invoice Cancel and Discard Issues are here!

With the latest upgrade of My Oracle Support we have enabled Guided Resolution Flows for some products so that when you create an SR for a specific problem type you will see a specific set of questions that guide you through to a targeted solution.

Oracle Payables is one of the lucky products that was first to go live with this new functionality and you will see the new SR create process under Invoice Processing Issues and Reporting (Cancel/Discard) problem type:

When you click Next instead of seeing possible solution documents displayed you will be asked a series of targeted questions that will lead you to a solution.

When you have answered the questions on your specific path you will be shown the solution we believe will resolve your issue. 

At this point you can save your SR as Draft whilst you investigate the solution or, if it was a quick fix that you have already verified, you can click the Solved Issue button to let us know the Guided Resolution helped you resolve your issue!

If for some reason you aren't able to locate the right solution there is still the Next button to log an SR as usual but the good news is that your answers will automatically be recorded in the SR and this information will be used to help us understand your issue further and to help us improve our tool.

Over the coming days and weeks, more Guided Resolution Flows will be made available to you - so keep your eyes open!

We hope you enjoy using these new tools and that you find your solutions faster than ever!  As usual we would love your feedback so get in touch on the Payables community thread!

Sunday Jul 20, 2014

Prepayments Headaches Gone!

Have you been struggling with prepayment application issues?

Well it's no wonder, as there are many areas of the application where prepayments can cause problems and it's not always easy to find the correct solution for your issue.  To help you we have created a consolidated list of Prepayment issues that will help you locate the right solution faster:

R12: Common Error Messages Displayed While Applying / Unapplying Prepayments (Doc ID 1572373.1)

R12: Consolidated List of Prepayment Application Issues Related to the Data Displayed on the GENERAL tab on the Invoice Workbench (Doc ID 1677492.1)

Interactive Troubleshooting Assistant: R12 Payables Prepayments (Doc ID 1559751.2)

Take a look at these consolidated troubleshooting documents next time you have a Prepayment issue for stress free solutions!

Wednesday Jul 09, 2014

Learn About Troubleshooting Reports & Printing Issues

E-Business Suite Applications Technology Group (ATG)
Advisor Webcast Program – July 2014


Webcast: Reports & Printing Troubleshooting

Thursday July 17, 2014 at 18:00 UK / 10:00 PST / 11:00 MST / 13:00 EST

Topics Covered Include:

  • Analyzer: E-Business Reports & Printing
  • E-Business Reports Analysis
  • Recommended Reports Patching
  • Reports Profile Options
  • E-Business Printing Analysis
  • Recommended Printing Patching
  • Printer Profile Options
  • Best Practices 

Details & Registration: Doc ID 1681612.1


If you have any question about the schedules or if you have a suggestion for an Advisor Webcast to be planned in future, please send an E-Mail to Ruediger Ziegler.

Tuesday Jul 01, 2014

New Troubleshooting Help for Holds Applied at Invoice Validation

Understanding why holds are applied at Invoice Validation time has always posed challenges for customers.  Now there is new help available in the form of a Troubleshooting Causes and Solutions document:

R12: Main Invoice Holds placed during Invoice Validation process: troubleshooting and solution (Doc ID 1682809.1)

Use this document to find causes and solutions for the following common Invoice Holds:

Please provide feedback on this document and let us know if it helped you resolve your issue by posting in the community post on this topic.

Thursday Jun 26, 2014

Announcing RapidSR for Oracle Payables: Automated Troubleshooting (AT)

What's New?

Customers are now able to create an accounting SR, upload the Master GDF diagnostic, and have the system automatically analyze the MGD output and update the SR with a solution summary.  In most situations we anticipate this to be much faster than waiting for an engineer to pick up and process the SR.  We call it RapidSR because it is FAST!

This first automation phase involves AP Accounting issues and covers the following impact areas:

  • GL Transfer
  • Accounting Failure
  • Accounting Incorrect
  • Period Close
  • Sweep
  • Trial Balance

A valid MGD output is required for automation to work and the requirements are:

  • Minimum version required = 120.213 or above
  • The diagnostic must be run in a single transaction mode. 

Doc ID 1608498.1 - SRDC R12: Collect Validation Information for Data Related to Invoices, Payments, Accounting, Suppliers and EBTax provides the link to the latest version of the MGD.

How Do You Log An Automation SR?

Step 1) Simple, when logging your next SR for an Accounting problem, simply select the following problem type:

Accounting Issues and Reporting > Create Accounting Fails for Specific Invoice, Check or Vendor

Note: Sev1’s and OnDemand/Cloud SRs will not be automated even when choosing this option.

Step 2) The Automated Troubleshooting Instructions: Payables Data Corruption Screening (Doc ID 1672163.1) document will appear explaining in more detail what will happen.

Click Next

Step 3) You have one question to answer - just tell us which impact area is causing you problems...

IMPORTANT: Click on the Note icon and carefully read the description for each impact area to properly select the closest match.  The Impact Area is the primary driver that AT uses to help provide a solution. 

Step 4) Choose severity and submit the SR.

That's it!

What Happens Next? 

Shortly afterwards you will receive a request to upload the MGD (if already uploaded then just ignore this step).  You will be reminded several times to provide files but the system will wait for you to provide this. 

Once the MGD is available our automated system will review it and paste your solution in the SR for you similar to the screenshot below:

How cool is that?

Be aware that if at any time you update the SR (except to upload the MGD file) before automation has completed, you will cause the SR to fall out of automation and be routed to an Accounting engineer.   Please give the process time to work, around 30-60 minutes depending on how long the MGD output is, and we think you will be amazed at how quickly and efficiently you will have a solution available and documented in your SR.

What If Automation Cannot Provide A Solution? 

If the automation engine cannot determine a solution for your issue because the MGD doesn't have any corruption signatures found or an invalid MGD file was uploaded, or if you have problems running the MGD and need assistance then the SR will drop out of automation and be routed to an engineer so you really have nothing to lose giving automation a try! 

We are excited about this new feature, so if you have an Accounting SR to log, please start selecting the Create Accounting Fails for Specific Invoice, Check or Vendor option from under the Accounting Issues and Reporting menu and give it a try!

Please provide any feedback on this process direct on our community post on this topic. 

Wednesday Jun 18, 2014

What R12 Diagnostics are Available for Inventory?

Imagine a scenario...Inventory period close is fast approaching and you conduct your regular run of the Inventory Analyzer Doc ID 1499475.1 to check the health of your Inventory transactions. The Inventory Analyzer does it's job and identifies records existing with data issues. You're at the point where the Inventory Analyzer has given you a lot of valuable information, including solutions to resolve issues, however you decide you want more detailed information about the transaction records before moving forward. You would like to look specifically at the transactions open interface and pending transactions areas and get more detailed information, including what inventory items are associated with the transactions. You wonder what additional tools are available to collect the information you're looking for? One fantastic resource is the Diagnostics Test Catalog for 12.1.3 and Above Doc ID 1083807.1. The R12 diagnostics catalog allows you to collect detailed information for many areas of your Inventory  environment (as well as many other areas of most EBS Products and R12.2). Access Doc ID 1083807.1, click on the 'Oracle Inventory Management' link, and view the Oracle Inventory Management (INV) diagnostics available in the diagnostics catalog.

Once you've scrolled down, like in the example above, you can take advantage of the Inventory Transactions diagnostics, as well as any of the other diagnostics available for Inventory (and there are many). Keep in mind that the diagnostic catalog should already be part of your EBS environment, but if it is not, the catalog can be added via Doc ID 167000.1 E-Business Suite Diagnostics Installation Guide.

So, be sure to use Oracle E-Business Suite Diagnostics as an additional tool to help troubleshoot problems or issues to proactively help resolve situations in your environment, especially before period close.

Friday May 23, 2014

Troubleshooting Enterprise Asset Management Transactions

New whitepaper!!  The objectives of this white paper are to provide an overview of how to resolve pending or errored transaction issues in Enterprise Asset Management. This paper will cover the following topics:
  • Consider the type of transactions affected
  • Specify the tables involved
  • Look at resource transaction errors and consider the  cause, validate if there is a root cause solution and explain how to fix these errors (including datafixes).
  • Look at material transaction errors and consider the  cause, validate if there is a root cause solution and explain how to fix these errors (including datafixes).

You can download the whitepaper from Doc ID 1672312.1 Troubleshooting Stuck/Errored Transactions in Enterprise Asset Management.

Monday May 12, 2014

Demantra Engine on Linux Install, Upgrade Troubleshooting Whitepaper

Development and Proactive Support have released the 9th edition of the Demantra Engine on Linux Install Upgrade Troubleshooting Configuration whitepaper.   If you are using, installing or upgrading Demantra on Linux or Unix you may find this document very valuable!  This new white paper contains special Linux/Unix instructions when deploying the Demantra Analytical Engine. Covering important topics listed below and MORE!

  • Deploying Demantra on Linux or UNIX 
  • 64bit Analytical Engine Requirement
  • Hardware requirements for Analytical Engine on Linux
  • About the Installer
  • Configure the Web Application on UNIX
  • Configure the Engine on Linux
  • Post-install Configuration
  • Engine Manager Configuration
  • Configure Environment Variables
  • Deploying on Oracle Application Server (OAS) 
  • Deploying on WebLogic
  • Deploying on Tomcat
  • Engine Configuration
  • Configure Environment Variables
  • Configure the Engine
  • Engine Starter Server
  • Running the Engine
  • Sample Commands
  • Samba Configuration
  • Distributed Engine
  • Configure Promotion Optimization (PMO) on Linux (Optional)
  • Configure the Standalone Integration Tool (APS Standalone) on UNIX (Optional)
  • Run the Engine Administrator on Linux
  • Calling Oracle Demantra Analytical Engine from UNIX Environment
  • Engine on Solaris

Plus a comprehensive Engine Troubleshooting/Common Issues section. To review the new, 9th edition, see My Oracle Support (MOS) Doc ID 1389868.1.

Thursday Apr 03, 2014

New Log Analyzer for Depreciation Error Logs

We have a new depreciation error log analyzer for Fixed Assets.  This new tool can be found in the document:  Log Inspector: Assets Depreciation (FADEPR) Terminated in Error (Doc ID 1626908.1).  When your depreciation process has terminated in error, you can use this tool to explore possible causes and find solutions. The Log Inspector will step you through the process. 

When you first view the Log Inspector document, you can select the link to view a short presentation about the use of the tool.  When you are ready to access the tool, you first select your release 12.0.x, 12.1.x, or 12.2.x.  Then select "Next."

The Log Inspector presents the second screen to you.  You will paste the contents of your depreciation error log file into the blank entry field.  When you select "Next," the Inspector will process the information provided to obtain a possible solution.

Error log

In this example, the depreciation error log was pasted into the Log Inspector's window, "Next" was selected, and the Inspector returned a solution:


The next time you encounter an error when running the depreciation process, consider utilizing the Log Inspector for analysis of the issue.  

Thursday Feb 20, 2014

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! 

Thursday Jan 16, 2014

Mass Additions Create Giving You Headaches? New Troubleshooting Assistant Available!

Don't Struggle Interfacing Invoice Distribution Lines from Payables To Fixed Assets - Help Is Available!

Mass Additions Create (APMACR) is the process by which Oracle Payables Invoice Distribution Lines are checked for eligibility and they if meet the critiera, they are inserted into the FA Mass Additions table as Mass Addition Lines.  

Oracle Assets users then prepare those Mass Addition Lines, by populating additional information, and run Post Mass Additions (FAMAPT) to convert that Mass Addition into an Asset.

Capital Project Related Invoice Distribution Lines are treated a little differently as they have to firstly interface from Oracle Payables into Oracle Projects before Oracle Projects interfaces them into Fixed Assets.  However, Create Mass Additions still examines project related invoice distribution lines and flags them as Capital Project related so that the relevant Projects concurrent programs can process them.  

For more information on Interfacing Project Related Invoice  Distributions to Oracle Assets Via Oracle Projects please review Doc ID 866310.1 - PAXCPGAL & PAXCPCAL - What Are The Steps to Generate Asset Lines and Interface Them to Oracle Fixed Assets?

What Help Is Available? 

It's very common for Payables users to fail to understand why their Invoice Distribution Lines didn't get selected by APMACR but the following documents should help you understand and resolve your issues.

1) We have the Mass Additions Diagnostics that have been around for a while:

These diagnostics allow you to enter a responsibility, operating unit, GL Date, Invoice ID and Asset Book and the report will examine the conditions required for successful interface to Mass Additions and it will explain why the line didn't meet the conditions. 

The screenshot below is taken from a sample output and it shows the invoice distribution didn't interface because the account used on the invoice distribution is not defined as an Asset or CIP Clearing account in any category for the asset book.  


2) We have White Papers, Troubleshooting Guides and Functional Overviews to help explain this process in detail:

  • R12: Master Note: APMACR - Mass Additions Create Program - Functional Overview (Doc ID 1321002.1)
  • Understanding Mass Additions Create (APMACR) and Troubleshooting from FA Perspective (Doc ID 1070597.1)
  • White Paper on Mass Additions Create Process in R12 (Doc ID 567690.1)

3) If you are unsure what you should read to help you resolve your Mass Additions Create issues, then look no further than a Troubleshooting Assistant

  • Troubleshooting Assistant: Create Mass Additions From Payables (AP) to Fixed Assets (FA) (Doc ID 1609542.2)

 This document was created to help you quickly locate the relevant document that will explain your issue and help you interface your invoice distribution lines to Oracle Assets.



4) If you are still unsure, why not use the Payables Community which is there for you to use to post your questions and enter into discussions with Oracle and other customers using Oracle Payables.


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



« July 2016