Friday Jan 31, 2014

Employer Shared Responsibility Provision of the Affordable Care Act Patches Available

Many parts of the Employer Shared Responsibility Provision (ESRP) of the Affordable Care Act (or ACA) went into effect at the beginning of this year (2014). ESRP describes the following requirements:

  • Which employers must comply and how they must comply with the provision
  • How employees are defined as eligible for coverage
  • What periods of time employees are eligible for coverage
  • Cost of the coverage to the employee
  • Minimal Essential Coverage definition
  • Reporting to the employee and to the federal government

While transition relief was provided by the Department of the Treasury and the IRS earlier this year which pushed out the penalty and reporting requirements sections of the provision to begin 1/1/2015 instead of 1/1/2014, all other requirements of the provision are still effective as of January 1st, 2014.

As part of complying with the ESRP, employers need to be able to track hours used to determine full time eligibility that are not paid or tracked in payroll or a time keeping system (e.g. military leave, disability leave, workers compensation leave). Additionally, they also need to be able to track Full Time Employees (according to the ACA definition), along with rehires, as well as their eligibility. To assist with these requirements, one off patches have been released for both US HR Only (and Benefits) customers and US Payroll customers.

The "PER" patches for US HR only (and Benefits) customers contain:

  • New fields added to the People form for tracking full time employees as well as rehires
  • Ability to create user defined eligibility criteria based on these new fields
  • Ability to create life events that can be triggered based on changes to these new fields
  • New data elements (mapped to the new fields) added to the System Extract tool

The "PAY" patches (for US Payroll customers) contain the above changes as well as a new informational payroll balance to help track employee service hours. (Please note the informational balance was previously also delivered as part of the End of Year 2013 Phase 3 patch released on January 15th.)

For Oracle US HR (and Benefits) customers who do not have Payroll fully installed, the following one off "PER" patches are now available:

  • 11i - 18103141
  • 12.0 - 18103153:R12.PER.A
  • 12.1 - 18103153:R12.PER.B

Please see the following readmes on My Oracle Support for full details**:

  • Updates to US HR To Accommodate the Employer Shared Responsibility Provision of the Affordable Care Act - Release 11i (Doc ID 1616434.1)
  • Updates to US HR To Accommodate the Employer Shared Responsibility Provision of the Affordable Care Act - Release 12.0 (Doc ID 1616428.1)
  • Updates to US HR To Accommodate the Employer Shared Responsibility Provision of the Affordable Care Act - Release 12.1 (Doc ID 1616417.1)

For Oracle US Payroll (and Benefits) customers, the following one off "PAY" patches are now available:

  • 11i - 18103148
  • 12.0 - 18103154:R12.PAY.A
  • 12.1 - 18103154:R12.PAY.B

Please see the following readmes on My Oracle Support for full details**:

  • Updates to US HRMS To Accommodate the Employer Shared Responsibility Provision of the Affordable Care Act - Release 11i  (Doc ID 1616416.1)
  • Updates to US HRMS To Accommodate the Employer Shared Responsibility Provision of the Affordable Care Act - Release 12.0 (Doc ID 1616426.1)
  • Updates to US HRMS To Accommodate the Employer Shared Responsibility Provision of the Affordable Care Act - Release 12.1 (Doc ID 1616427.1)

** Note: The functional readmes listed above do not contain detailed patch installation instructions. Please refer to the applicable patch readme available in the patch download area on My Oracle Support for the patch installation instructions.

More information on the Affordable Care Act can be found in the following documents on My Oracle Support:

  • Oracle E-Business Suite US Payroll Position Statement: Patient Protection and Affordable Care Act 2010 & Affordable Care and Education Reconciliation Act 2010 (Doc ID 1091444.1 )
  • Oracle E-Business Suite Advanced Benefits Position Statement: Patient Protection and Affordable Care Act 2010 & Affordable Care and Education Reconciliation Act 2010 (Doc ID 1597102.1 )
  • Oracle E-Business Suite US Payroll Position Statement: Employer Shared Responsibility Provisions Under the Affordable Care Act (Doc ID 1542487.1 )

Thursday Jan 30, 2014

Webcast: Learn To Troubleshoot Common Projects Funds Check Errors With Ease!


ADVISOR WEBCAST: Learn To Troubleshoot Common Projects Funds Check Errors With Ease!

Date:  February 13, 2014 at at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 4:00 pm, GMT Time (London, GMT), 9:30 pm, India Time (Mumbai, GMT+05:30)

This one-hour session is recommended for technical and functional users who are using the Projects Funds Check feature. After reviewing recent enhancements in Projects Funds Check User Interfaces (UIs) , we will walk through ways to troubleshoot commonly encountered Projects Funds Check errors.

Topics will include:

  • Funds Check User Interfaces (UIs)
  • Recent enhancements
  • Commonly encountered issues
  • Troubleshooting techniques


For more details and how to register see Doc ID 1609179.1.

Wednesday Jan 29, 2014

New Release of the PO Approval Analyzer – Now Includes AME!

Version 120.15 has just been released for the Approval Analyzer in Doc ID 1525670.1.  It now includes improvements to formatting, with your document information listed first and proactive information following.  Most importantly, if you are using the Approval Management Engine (AME), the analyzer now includes checks for both Purchase Orders and Requisitions.   Get information you would normally have to obtain from the AME Test Workbench to include:
  •     AME Setup information
  •     Rules (including Conditions and Actions)
  •     Attributes and  Action Types
  •     User friendly error messages will be displayed on the AME Approvers list (when there are setup issues); for example:

AME error message

AME package versions are included and much more.  Obtain the PO Approval Analyzer at Doc ID 1525670.1.

Still have questions on the Analyzer?  Post your comment in the Procurement Community thread here: New Release of the PO Approval Analyzer – Now Includes AME!

Tuesday Jan 28, 2014

Logging an SR for Payables? Choose The Correct Problem Type For Faster Resolution

Did you know that you can affect how your SR is routed based on the Problem Type you choose in My Oracle Support?

The initial routing of your SR to an engineer is all dependent on how you choose to classify your issue.  If you don't understand the problem type options and choose the incorrect one, your SR will still get routed to the correct team but it will go the scenic route - around the houses instead of as the crow flies!

Choosing the best problem type means it's routed to the correct group working those issues first time which means the engineers with the skill set to handle your issue or question will get working on it right away.  If it goes to a different team, they will review the issue and decide which is the appropriate group for that issue and transfer that SR.  So speed up the resolution of your issue by getting it to the right team - first time.


When you are in MOS and you have chosen Oracle Payables as a product, the problem type drop down box (as shown above) contains the following options:

1099 US Tax Reporting
Accounting Issues and Reporting
Payables Payments Issues and Reporting
Invoice Processing and Reporting
Supplier Issues and Reporting
EBTax (Payables) Issues e.g. Tax related processing and calculation
Internet Expense/Procurement Card Issues
Localization Issues
Technical Issues
Patch Application Issues
Other Payables Issues 

You might be unsure what to select if you can't account an invoice or your trial balance is causing you concern.  What about a question about Transfer to GL or Period Close? Well that would always be an accounting issue because the problem is with accounting code.

What about if you have a payment workbench problem, payment reports are wrong, users can't print a check or you have questions about AP/AR Netting? What about PPR problems? Those are all payments issues.  

If you cannot enter an invoice or are struggling to discard an invoice line, have holds you don't understand, cannot match an invoice or mass additions isn't picking up certain invoice distributions and you don't understand why, then those would be an invoices issue. The Invoices team also handles prepayment questions and helps troubleshoot report issues where figures are not as expected. Invoice Approval Workflow is also an invoices area.  Generally, if it's related to processing of an invoice but not accounting or paying an invoice then it would be an Invoices issue.

1099 issues have their own option in the drop down menu as specialist knowledge of 1099 US tax reporting is required.  

Supplier setup, merge or import problems, supplier report concerns and even Supplier Bank Accounts all fall under the suppliers category.

EBTax (Payables) issues is a tricky one, because you might think an error when validating an invoice or a problem trying to match to a PO would be invoices, but if that error relates to the tax distributions or the error message is EBTax related those issues would not be handled by the Invoices team but by the EBTax experts. If the EBTax team decides it's not specifically related to EBTax code they will transfer the issue as appropriate but starting with the EBTax experts is your best bet due to the complexity of tax setup.

The technical team handle anything performance related or issues with invalid objects, locks, flexfield setup, document sequencing and upgrade issues..

If you are using localizations and the piece of functionality you have an issue or question with is a localization specific question or the error indicates the code failing is localization code then that should always go to the localization team for review.

All patch issues are handled by the patching community so that should be easy enough to know when to use that option.

Other Payables Issues is a catch all bucket which should only be used if you cannot find another topic that your issue would fall into.  It will need to be reviewed and categorized and the receiving engineer will then transfer the ownership of the SR to the team they feel would be best equipped to handle that issue.  This may be the correct team but it could take a couple of transfers to find the correct engineer.  Since there is a delay in this review and reassign process, it stands to reason that initial contact with an engineer with the correct skillset will take longer, hence the reason to avoid this option if at all possible.

We hope understanding the Problem Type structure will help you get your SR to the right team quicker but there are additional benefits in taking a minute to choose the correct template:

1) The knowledge documents that you will be shown during the SR logging process are specifically selected depending on the problem type you choose as they are the documents that other customers have found the most useful, when having problems in that area. For example, seeing our Invoice Matching troubleshooting assistant or a technical white paper explaining a new piece of functionality might give you a good chance of finding your answer before the SR reaches an engineer!  

2) If the suggested documents don't help you resolve your problem then at least the questions you are asked in the next step of the SR logging process are specific to that problem type and providing these answers will allow the receiving engineer to get a jump start on understanding your problem.

3) We also request customers to upload diagnostic files that will help resolution so choosing the correct problem type means you are asked for the correct type of diagnostic information.  No-one wants to waste time generating and uploading irrelevant diagnostic files.

If you are unsure which bucket to put your problem, please take a few minutes to review the sub-menus under each option and ensure you understand the types of issues handled by that team before categorizing your issue as 'something else' by using the Other Payables Issues option.

Monday Jan 27, 2014

Upcoming CRM Product Family Webcasts


Don't miss the upcoming CRM product family webcasts coming up in February and March.

Webcast: Funds Capture Through Oracle Payments

Date: February 5, 2014 at 8:30 am EST, 7:30 am CT, 6:30 am MT, 5:30 am PT, 1:30 pm GMT, 7:00 pm IST

This one-hour session is recommended for technical and functional users who integrate with Oracle Payments to process online credit/purchase card transactions for inbound (receivables) payments via Oracle Payments, iStore, Order Capture, OM, Oracle Receivables and bank account transfers from Oracle Cash Management and settlements against credit cards and bank accounts or any users integrating with payment processing systems.


Details & Registration : Doc ID 1614255.1.

Webcast: Service Contracts: Online Renewal

Date: February 19, 2014 at 10:00 am EST, 9:00 am CST, 8:00 am MST, 7:00 am PST, 3:00 pm GMT, 8:30 pm IST

This session will be useful for all customers planning to implement the Service Contracts Online Renewal feature. The session will explain how the feature works, how to set it up and troubleshooting tips.


Details & Registration : Doc ID 1614212.1.

Webcast: A Starter's Guide to Oracle Advanced Scheduler Features

Date: March 5, 2014 at 9:30 am EST, 8:30 am CST, 7:30 am MST, 6:30 am PST, 2:30 pm GMT, 8:00 pm IST

This one-hour session is recommended for technical and functional users who are relatively new to Field Service - Scheduler module. This will help them understand the various aspects that they need to keep in mind when using the Oracle Advanced Scheduler functionality.


Details & Registration : Doc ID 1614211.1.

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

Friday Jan 24, 2014

Functional Impact Documents For Monthly Service Cumulative Patches

The Core Service Development team provide monthly cumulative patches which contain fixes and new functionality.  Although the bugs fixed in each patch are always listed, it can be difficult to fully understand the functional impact of a bug fix and what associated setup is required.  Also, whenever a new cumulative patch is applied there has to be thorough testing and, without a clear understanding of what has changed, it's difficult to decide what business flows need to be re-tested.

In an effort to meet these testing requirements and make it easier to apply the monthly patches, the Development team will be providing an accompanying document which will describe the impacted flows, list testing recommendations and detail additional setup required for testing the bug fixes.  The first of these documents have been created for the December '13 (Patch 17738111:R12:CS:B) and January '14 (Patch 17855988:R12.CS.B) cumulative patches.  Take a look at Doc ID 1608427.1: Functional Impact Document - 12.1.3 Consolidations to access the documents.  We recommend you bookmark the Doc ID as new documents will be added when new cumulative patches are released.

Critical Patch Update for January 2014

Get off to a good start this year and apply the Critical Patch Update for January 2014!

Go to Doc ID1594621.1 for more details for E-Business Suite.

Thursday Jan 23, 2014

North American Payroll - Year End Reminders

By now you probably have a good start on your North America payroll year end processing, and are getting ready to issue 2013 employee tax statements.  Soon after that will come the governmental tax filiings.

This is just a reminder of the year end patches, documentation, and other resources available to you as you complete the North America payroll year end on Oracle EBS Payroll.


US & Canada End of Year Phase 1 2013 released 10/1/2013 -
Patch Numbers:
11i - 17535554
12.0 - 17535555:R12.PAY.A
12.1 - 17535555:R12.PAY.B
US & Canada End of Year 2013 Phase 2 released 12/16/2013 -
(End of Year 2013 Phase 2 includes the End of Year 2013 Phase 1, US Q4 2013 as well as the Year Begin 2014 statutory updates.)
Patch Numbers:
11i - 17955551
12.0 - 17955555:R12.PAY.A
12.1 - 17955555:R12.PAY.B
US & Canada End of Year 2013 Phase 3 released 1/15/2014 -
(End of Year 2013 Phase 3 includes the End of Year 2013 Phase 1 and 2 as well as Year Begin 2014 statutory updates.)
Patch numbers:
11i - 18075555
12.0 - 18075556:R12.PAY.A
12.1 - 18075556:R12.PAY.B
Mexico Payroll Year Begin 2014 released 12/31/2013 -
Patch numbers:
12.0 - 17924551:R12.PAY.A
12.1 - 17924551:R12.PAY.B
Mexico 2014 ISR and Subsidy for Employment Tax Rates released 1/9/2014 -
Patch numbers:
12.0 - 18050606:R12.PAY.A
12.1 - 18050606:R12.PAY.B

IMPORTANT:  For each of the patches that you need, make sure to review the patch Readme for important installation information.


Refer to the My Oracle Support Doc ID 1577601.1 "North American Year End 2013 / 2014 Year Begin Patch Information and Useful Links" for links to the functional patch readmes, End of Year Processing guides, Mandatory Patch lists, and other helpful documentation including information on the year end W2 and 1099R forms.


Year End Advisor Webcasts
Archived 2013, 2 sessions recorded:

  • EBS North American Payroll Year End Process Flow  (November 20, 2013)
  • EBS Oracle Payroll North American Year-End Updates - 2013  (October 9, 2013)

These recorded webcasts can be accessed via the My Oracle Support Doc ID 1455851.1 "E-Business Suite HCM Advisor Webcast Schedule and Archived Recordings".

My Oracle Suport Communities:  Payroll-EBS
This is a great place for you to go for quick answers to functional and technical questions. It's an open forum where you can ask questions and share YOUR expertise with others by answering questions. The communities are monitored and updated not only by Oracle Support, but also by other Oracle EBS users.

North American Payroll World
Payroll World is an email distribution list for North American Oracle Payroll customers used to quickly disseminate information regarding product updates, patches, and statutory changes. To subscribe to this email distribution list, send e-mail with your contact name, CSI number, and company name to

Last year, the Oracle North American Payroll World distribution list completed a transition from a traditional email distribution list to an Oracle Beehive Online Group. Please note that in order to become a member of the new Beehive Online group, you will need to have an active account on OTN (Oracle Technology Network), or if you already have an OTN account, your current email address MUST match the one associated with that account.
To create an account or to confirm your email address, go to MyProfile (
Also, as the Oracle North American Payroll World email announcements are being sent by email ID, it may need to be added to your address book.

Order Information Portal (OIP) Enhancements

In Release 12.2, Order Information Portal (OIP) has been enhanced.  These enhancements are in the following areas:

Several search parameters have been added to allow more search criteria. Customer Number has been added to the Simple Search. Customer Number, Invoice Number, Orders On Hold (Yes/No), Ship To Customer, Bill To Customer, and Deliver To Customer have been added to the Advanced Search.

Previously, only contacts associated with the Sold To Customer on the sales order could view and track sales orders through OIP. Now OIP has been enhanced to allow contacts associated with the Bill To Customer on the sales order to view and track sales orders through OIP.

Several display fields have been added to the summary and detail views of the sales order and delivery.

External users can subscribe to receive notifications based on key business events such as scheduling, schedule date changes, and shipping. In addition, external users can choose to receive notifications individually in their Notifications Worklist for each sales order or consolidated across sales orders by setting up preferences in Workflow mailer.

OIP has been integrated with FND Security to enable rules-based access to the summary and detail views of sales orders and deliveries.

For more information regarding the enhancements made to Order Information Portal in Release 12.2, please refer to the Oracle Order Management Release Notes for Release 12.2.2, Doc ID 1377743.1.

Wednesday Jan 22, 2014

Java Updates Are Here!

JRE 1.7.0_51 is Certified with Oracle EBS
Java Runtime Environment 7u51 (a.k.a. JRE 7u51-b13) and later updates on the JRE 7 codeline are now certified with Oracle E-Business Suite Release 11i and 12.0, 12.1, and 12.2 for Windows-based desktop clients    

JRE 1.6.0_71 is Certified with Oracle EBS
The latest Java Runtime Environment 1.6.0_71 (a.k.a. JRE 6u71-b12) and later updates on the JRE 6 codeline are now certified with Oracle E-Business Suite Release 11i and 12 for Windows-based desktop clients.

R12 Master Generic Data Fix Diagnostic for Purchase Orders and Requisitions

Do you wish you could proactively check your Purchasing documents for known data integrity issues or is there a Purchasing document you are having problems with?

Well, visit Doc ID1474734.1 for the R12 Master Generic Data Fix Diagnostic for Purchase Orders and Requisitions.  Running this one script identifies known data integrity issues within the Purchasing application (for example errors with cancel and close and unit of measure issues) where there are often generic data fixes (GDFs) already available.  The script will produce an HTML output report of all known problems relating to the purchasing transactions created in the specified date range, along with information on notes and/or data-fix patches which are already be available to resolve the data issues.

The following data checks are included:
  • Document type records with null ORG ID.
  • Synchronization issues with archive tables.
  • Quantity billed/amount billed mismatch in purchase order shipments and distributions.
  • Purchase orders with a mismatch of quantity billed or amount billed between the shipment or distribution and the invoice distribution.
  • Purchase order shipments eligible to be closed.
  • Outstanding supply/demand for non-existing or cancelled requisition lines.
  • Fully received internal requisitions continue to show as pending supply.
  • Approved requisitions not available in Autocreate form after associated purchase order is deleted.
  • Purchase orders with unit of measure (UOM) mismatch between Lines and Shipments.
  • Canceled purchase orders in Requires Reapproval status.
  • Tax exception 023 (ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated) when approving.
  • Purchase order with authorization_status = 'REQUIRES_REAPPROVAL' rather than 'REQUIRES REAPPROVAL'.
  • Foreign currency autocreated purchase orders have inverse rate.
  • Purchase order ship-to organization does not match distribution deliver-to organization.
  • Requisition distribution line associated to multiple PO distribution lines.
Don’t delay make Doc ID1474734.1 part of your routine Procurement procedures today!

Tuesday Jan 21, 2014

Oracle Discrete Manufacturing Extensions for Oracle Endeca

First let's discuss Oracle® Endeca Information Discovery.  It is an enterprise data discovery platform for advanced, yet intuitive, exploration and analysis of complex and varied data. The enriched data is made available for search, discovery and analysis via interactive and configurable applications. Oracle Endeca Information Discovery enables an iterative "model-as-you-go" approach that simultaneously frees IT from the burdens of traditional data modeling and supports the broad exploration and analysis needs of business users.

Now let's discuss Oracle Discrete Manufacturing Extensions for Oracle Endeca.  It enables you to search and view dashboard metrics related to job status, job delays, component and resource shortage, quantity of scraps and rejects.  You can use the Oracle Endeca Discrete Work Order Search page to view and analyze the data using Key Performance Indicators (KPIs), performance evaluation metrics, charts, graphs, and tables. Oracle Discrete Manufacturing Extensions for Oracle Endeca Work Order Search provides:

  • Proactive response to work order issues
  • Rapid diagnosis and resolution to current issues affecting schedules from key insights
  • Accurate and fact based decisions for shopfloor
  • Improved yield, cost, and cycle time management.

For additional information on Oracle E-Business Suite Extensions for Oracle Endeca, please refer to the following:

Oracle E-Business Suite Extensions for Oracle Endeca Integration and System Administration Guide
Oracle Discrete Manufacturing Extensions for Oracle Endeca Configuration Notes, Doc ID 1470153.1

Swiss (CHE) Tax Registration Number Change Notice

Replacement VAT number six figure identification number of firms (FDI) with the VAT extension

The federal law on business identification number has changed with effect from 1 Jan 2014.  The old registration number format was 8 characters but the new format supports 19-20 characters. 

Old Behavior

The current VAT number validation format is CH + 6 digits (the six digits after the prefix should be numeric). Example: CH123456. Swiss companies can continue to use the current VAT number format until the end of 2013.

New Behavior

Effective from January 2014, there are changes in the validation of Tax Registration Number. The new VAT number validation is formatted as CHE + nine numeric positions + extension. Example: CHE-123.456.789 MWST.

The following validation is implemented.

  • CHE - is a fixed value. It represents the country code.
  • to separate the country code and the tax number portion.
  • 123.456.789 - nine numeric positions, separated by periods.
  • (Blank) - blank position that separates the numeric portion and the extension portion.
  • XXXX  : Depending on the specific part of Switzerland the company address belongs to. The three possible extensions are: MWST, TVA or IVA.

The total length of the new VAT number, therefore, can be 19 or 20 digits.


a) Apply Patch 15964400 as detailed in Doc ID 1521534.1 - New Swiss (CHE) Tax Registration Number


b) Enter/update existing tax registration number as per new format before January 2014 to avoid any user interface, reporting or data issue. The tax registration number as per old format will not be valid effective from January 2014.

You can enter the registration number using multiple navigations but the most common interface is: Tax Manager > Parties: Party Tax Profiles > Tax Registrations



For full details on this change in legislation, please review the Federal Administration website.

Monday Jan 20, 2014

Configurator Build is Available!

Configurator Build has been released! 

You can download the latest version via Patch 17242618.  Please review the Patch Readme for a listing of what this latest release contains. 

Please remember Oracle Configurator patches are cumulative, so you only need to apply the latest patch for a specific release to receive the latest product enhancements and bug fixes. Before upgrading to a new release or applying a patch, be sure to review the patch readme file.

Please also note that Configurator Build has been obsoleted.  The details regarding all Configurator Patches can be found in Doc ID 131088.1.  Due to the fact that old releases are obsoleted, customers are encouraged to upgrade to the latest patch.

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!


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 »