Friday Jan 17, 2014

Introducing OTL Analyzer

Oracle Time & Labor Product Support is announcing the new Proactive Diagnostics Script: "OTL Analyzer" that will considerably save the time taken for supporting your issues, and will proactively help you enhance your OTL setup! 

This script will include many helpful sections including what current OTL_Diag.sql script has been providing in addition to new sections that fully scans your OTL Setup, and proactively provide colorful reminders/comments/warnings/errors about areas that might cause potential problems in your output. This script will be helpful for both customers and support.

The analyzer will replace the current diagnostics OTL_Diag script that is being used by both the OTL Customers and Support. The following notes can be used to refer to the new OTL Analyzer for setup and running steps information:

  • OTL (Oracle Time and Labor) Analyzer Script (Doc ID 1580490.1)
  • How to run OTL Analyzer as a Concurrent Request (Doc ID 1589250.1)
  • OTL Analyzer Tool FAQ (Doc ID 1596937.1)

 This Analyzer / Health Check / Data Collection tool is a PL*Sql script which will check the E-Business Suite environment, and can be executed on all currently released / supported application versions  (i.e., 12.0, 12.1, and 12.2).   As the process executes, it will output diagnostics advice and proactive recommendations within an .html output file.

When reviewing the analyzer output, you can immediately see where issues are identified as they are displayed in red (errors), orange (warnings) or blue (best practices), so that they can be easily seen.  In addition to identifying areas of concerns, the analyzer will also identify My Oracle Support (MOS) articles which can be utilized to resolve the issue.

The following parameters are entered when executing the script and determine the tabs displayed in the output. When the Analyzer is executed, an environment review is performed and feedback provided on:

  • OTL technical information (version, patching, performance, database objects)
  • OTL setup analyzer
  • Employee Preferences
  • Specific timecard data:
  • HXC (Self Service, Timekeeper, API) Timecard Data
  • HXT (OTLR/PUI) Timecard Data
  • Batch information

For Release 12 it is recommended that this script be setup as a concurrent request so that it may be executed by either Functional or Technical representatives from your business.

We have made it easy for customers and provided some ready and safely loaded on Production LDT files to implement all the necessary setup steps.

Download the OTL Analyzer Script (Doc ID 1580490.1) today and provide us your feedback!

Order Batch Pricing

Have you ever wondered if there was an easier way to reprice existing orders?

One way to price or re-price existing Orders is by querying for those Orders and manually choosing the “Price Line” or “Price Order” action from the form. Alternatively a call can be made to Process Order API with “PRICE_ORDER” or “PRICE_LINE” action for the specified Orders / Lines.

The first approach requires users to query for the Orders and/or Lines in the user interface either using Sales Order or Order Organizer. Manually selecting all the Orders/Lines and then choosing the Price Order/Price Line action.

In the second approach, user will have to make a call to Process Order API. This requires PL/SQL knowledge to write a wrapper API that would fetch all the required Orders/Lines matching a criteria and then pass the Orders/Lines to Process Order API with the Pricing Action.

As of R12.1.1, there is a concurrent program that can easily be submitted from the user interface and can Price the Orders/Lines matching the input criteria. The Batch Price concurrent program attempts to price items as specified by input parameters for any open orders or lines. Batch Pricing honors the Calculate Price Flag on the individual order lines.  This concurrent program will execute in the background using parallel processing, so that users can continue with their activities.

For more information please refer to the Order Management Users Guide Batch Price Concurrent Program section or Doc ID 580068.1 12.1.1 Oracle Order Management Release Notes.

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



« January 2014 »