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! 


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 »